private void FillGridView() { GridViewName.DataSource = broker.Fill(); GridViewName.DataBind(); }
private void DisplayContactDetails(string contactId) { string contactQueryString = "SELECT ContactId, LastName, FirstName, MiddleInitial FROM Contact WHERE ContactId = @ContactId"; string addressQueryString = "SELECT AddressId, Street, StreetLineTwo,City,State,ZipCode,PrimaryAddress, ContactId FROM Address " + "WHERE ContactId = @ContactId AND Country='USA'"; string eMailQueryString = "SELECT EmailId, UserName,Domain,PrimaryEmail, ContactId FROM Email WHERE ContactId = @ContactId"; string phoneQueryString = "SELECT PhoneId, Type, AreaCode, PhoneNumberPOne,PhoneNumberPTwo,Extension,PrimaryNumber, ContactId " + "FROM Phone WHERE ContactId = @ContactId AND CountryCode='1'"; string internationalPhone = "SELECT PhoneId, Type, CountryCode, PrimaryNumber, ContactId, International FROM Phone " + "WHERE ContactId=@ContactId AND CountryCode!='1'"; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); DataSet dataSet = new DataSet(); SqlDataAdapter contactAdapter = new SqlDataAdapter(); contactAdapter.TableMappings.Add("Table", "Contact"); SqlCommand cCommand = new SqlCommand(contactQueryString, connection); cCommand.Parameters.AddWithValue("ContactId", contactId); contactAdapter.SelectCommand = cCommand; contactAdapter.Fill(dataSet); SqlCommand aCommand = new SqlCommand(addressQueryString, connection); aCommand.Parameters.AddWithValue("ContactId", contactId); SqlDataAdapter addressAdapter = new SqlDataAdapter(); addressAdapter.TableMappings.Add("Table", "Address"); addressAdapter.SelectCommand = aCommand; addressAdapter.Fill(dataSet); SqlCommand eCommand = new SqlCommand(eMailQueryString, connection); eCommand.Parameters.AddWithValue("ContactId", contactId); SqlDataAdapter eMailAdapter = new SqlDataAdapter(); eMailAdapter.TableMappings.Add("Table", "Email"); eMailAdapter.SelectCommand = eCommand; eMailAdapter.Fill(dataSet); SqlCommand pCommand = new SqlCommand(phoneQueryString, connection); pCommand.Parameters.AddWithValue("ContactId", contactId); SqlDataAdapter phoneAdapter = new SqlDataAdapter(); phoneAdapter.TableMappings.Add("Table", "Phone"); phoneAdapter.SelectCommand = pCommand; phoneAdapter.Fill(dataSet); SqlCommand iPCommand = new SqlCommand(internationalPhone, connection); iPCommand.Parameters.AddWithValue("ContactId", contactId); SqlDataAdapter iPAdapter = new SqlDataAdapter(); iPAdapter.TableMappings.Add("Table", "InternationalPhone"); iPAdapter.SelectCommand = iPCommand; iPAdapter.Fill(dataSet); connection.Close(); GridViewName.DataSource = dataSet.Tables["Contact"]; GridViewName.DataBind(); AddressGridView.DataSource = dataSet.Tables["Address"]; AddressGridView.DataBind(); EmailGridView.DataSource = dataSet.Tables["Email"]; EmailGridView.DataBind(); PhoneGridView.DataSource = dataSet.Tables["Phone"]; PhoneGridView.DataBind(); InternationalPhoneGridView.DataSource = dataSet.Tables["InternationalPhone"]; InternationalPhoneGridView.DataBind(); } }