0
private void cmdSearch_Click(object sender, EventArgs e)
{
SqlConnection sqlNWConn = new SqlConnection();
SqlDataAdapter daCustomers;
DataSet dsCustomers;
String tableName = "Customers";
sqlNWConn = new SqlConnection(@"Data Source=DANS-MAC--WIN7\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True");
if (radioAll.Checked == true)
{
try
{
sqlNWConn.Open();
dsCustomers = new DataSet(); // Creates a new DataSet
daCustomers = new SqlDataAdapter("select * from Customers", sqlNWConn); // Creates a new SqlDataAdapter with select command and connection
SqlCommandBuilder cmdBldr = new SqlCommandBuilder(daCustomers); // Fills in insert, update, and delete commands
daCustomers.Fill(dsCustomers, tableName); // Fills the dataset
dataGridCustomers.DataSource = dsCustomers;
dataGridCustomers.DataMember = tableName;
}
catch
{
MessageBox.Show("there was an error and your code is crap"); // error will be changed when working
}
}
if (radioName.Checked == true)
{
// Searches value in txtSearch in table Customer ContactName
}
}
0