Вы разрабатываете приложение, работающее с базой данных Microsoft SQL Server ClientsAndSales. Требуется вывести на форму две таблицы – Clients и ClientsInfo, связанных по ключевому полю ClientsID. Главной является таблица Clients. Строки connectionString, commandText и commandText2 были определены в классе формы. Выберите правильный фрагмент кода для формирования связи:
(Отметьте один правильный вариант ответа.)
Варианты ответа
SqlConnection cnClientsAndSales = new SqlConnection(connectionString);cnClientsAndSales.Open();SqlCommand cmdClients = new SqlCommand();cmdClients.Connection = cnClientsAndSales;cmdClients.CommandText = commandText;SqlDataAdapter daClients = new SqlDataAdapter();daClients.SelectCommand = cmdClients;DataSet dsClientsAndSales = new DataSet();daClients.TableMappings.Add("Table", "Clients");daClients.Fill(dsClientsAndSales);dataGrid1.DataSource = dsClientsAndSales.Tables["Clients"].DefaultView;SqlCommand cmdClientsInfo = new SqlCommand();cmdClientsInfo.Connection = cnClientsAndSales;cmdClientsInfo.CommandText = commandText;SqlDataAdapter daClientsInfo = new SqlDataAdapter();daClientsInfo.SelectCommand = cmdClientsInfo;daClientsInfo.TableMappings.Add("Table", "ClientsInfo");daClientsInfo.Fill(dsClientsAndSales);
SqlConnection cnClientsAndSales = new SqlConnection(connectionString);cnClientsAndSales.Open();SqlCommand cmdClients = new SqlCommand();cmdClients.Connection = cnClientsAndSales;cmdClients.CommandText = commandText;SqlDataAdapter daClients = new SqlDataAdapter();daClients.SelectCommand = cmdClients;DataSet dsClientsAndSales = new DataSet();daClients.TableMappings.Add("Table", "ClientsAndSales");daClients.Fill(dsClientsAndSales);dataGrid1.DataSource = dsClientsAndSales.Tables["Clients"].DefaultView;SqlCommand cmdClientsInfo = new SqlCommand();cmdClientsInfo.Connection = cnClientsAndSales;cmdClientsInfo.CommandText = commandText2;SqlDataAdapter daClientsInfo = new SqlDataAdapter();daClientsInfo.SelectCommand = cmdClientsInfo;daClientsInfo.TableMappings.Add("Table", "ClientsAndSales");daClientsInfo.Fill(dsClientsAndSales);
SqlConnection cnClientsAndSales = new SqlConnection(commandText);cnClientsAndSales.Open();SqlCommand cmdClients = new SqlCommand();cmdClients.Connection = cnClientsAndSales;cmdClients.CommandText = commandText;SqlDataAdapter daClients = new SqlDataAdapter();daClients.SelectCommand = cmdClients;DataSet dsClientsAndSales = new DataSet();daClients.TableMappings.Add("Table", "Clients");daClients.Fill(dsClientsAndSales);dataGrid1.DataSource = dsClientsAndSales.Tables["Clients"].DefaultView;SqlCommand cmdClientsInfo = new SqlCommand();cmdClientsInfo.Connection = cnClientsAndSales;cmdClientsInfo.CommandText = commandText2;SqlDataAdapter daClientsInfo = new SqlDataAdapter();daClientsInfo.SelectCommand = cmdClientsInfo;daClientsInfo.TableMappings.Add("Table", "Clients");daClientsInfo.Fill(dsClientsAndSales);
SqlConnection cnClientsAndSales = new SqlConnection(connectionString);cnClientsAndSales.Open();SqlCommand cmdClients = new SqlCommand();cmdClients.Connection = cnClientsAndSales;cmdClients.CommandText = commandText;SqlDataAdapter daClients = new SqlDataAdapter();daClients.SelectCommand = cmdClients;DataSet dsClientsAndSales = new DataSet();daClients.TableMappings.Add("Table", "Clients");daClients.Fill(dsClientsAndSales);dataGrid1.DataSource = dsClientsAndSales.Tables["Clients"].DefaultView;SqlCommand cmdClientsInfo = new SqlCommand();cmdClientsInfo.Connection = cnClientsAndSales;cmdClientsInfo.CommandText = commandText2;SqlDataAdapter daClientsInfo = new SqlDataAdapter();daClientsInfo.SelectCommand = cmdClientsInfo;daClientsInfo.TableMappings.Add("Table", "ClientsInfo");daClientsInfo.Fill(dsClientsAndSales);(Верный ответ)