SqlConnection conn = new SqlConnection("server=172.31.9.9;uid=sa;pwd=sa;database=ufdata_101_2020");
conn.Open();
string sql;
cinvcode = '100%'
sql = $@"select top 1000 * from inventory where cinvcode like {cinvcode}";
SqlCommand command = new SqlCommand(sql,conn);
//int result = command.ExecuteNonQuery();//这里是update delete等引起的行号变化
//以下使用reader取得,然后送给grid
SqlDataReader reader = command.ExecuteReader();
BindingSource source = new BindingSource();
source.DataSource = reader;
dataGridView1.DataSource = source;
conn.Close();
//以下为reader使用table传递到datagrid
DataTable data = new DataTable();
SqlDataReader reader = command.ExecuteReader();
data.Load(reader);
dataGridView1.DataSource = data;
conn.Close();
//以下为使用dataadapter送到table里面
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sql, conn);
DataTable data = new DataTable();
sqlDataAdapter.Fill(data);
dataGridView1.DataSource = data;
conn.Close();
//以上连接方面,以最下面一个为主,其他reader效率我估计会慢!