mehrshadms
شنبه 05 آذر 1390, 19:00 عصر
من از این طریق به کنترل datagridview رو به بانک متصل کردم حالا می خوام یه رکورد بهش اضافه کنم از جه دستوری استفاده کنم ؟
SqlConnection connection = new SqlConnection();
connection.ConnectionString = global::_1.Properties.Settings.Default.connections tring;
connection.Open();
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "select * from T1";
/* SqlDataReader reader = command.ExecuteReader();
reader.Read();
textBox1.Text= reader.GetString(1);*/
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable dataset = new DataTable();
adapter.Fill(dataset);
dataGridView1.DataSource = dataset;
SqlConnection connection = new SqlConnection();
connection.ConnectionString = global::_1.Properties.Settings.Default.connections tring;
connection.Open();
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "select * from T1";
/* SqlDataReader reader = command.ExecuteReader();
reader.Read();
textBox1.Text= reader.GetString(1);*/
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable dataset = new DataTable();
adapter.Fill(dataset);
dataGridView1.DataSource = dataset;