使用C＃.net将数据插入数据集 [英] Inserting a data into dataset by using C#.net

问题描述

我想通过使用变量使用c #Windows应用程序将数据插入数据集。

假设我想使用sql命令将员工数据插入表单！

我怎么能这样做！

提前使用Thanx .....

I want to insert a data to dataset by using c# Windows application by using a variable.
suppose I want to insert data of employees to the form by using sql command!
how can i do that!
Thanx in advance.....

推荐答案

 SqlConnection conn = null;
 SqlDataReader rdr = null;

 // create and open a connection object
 conn = new
     SqlConnection(@"Server=MDT765\MDT765;DataBase=TST;user=user;password=user@123;Integrated Security=SSPI");
 conn.Open();

string myConnection = conn.ConnectionString.ToString();//"Data Source=MDT765;Initial Catalog=TST;User Id=user;Password=user@123;";
 SqlDataAdapter sqlcom0 = new SqlDataAdapter("SELECT * FROM Employee", myConnection);
 DataSet ds0 = new DataSet();
 sqlcom0.Fill(ds0);
 dataGridView1.DataSource = ds0.Tables[0].DefaultView;
 dataGridView1.Refresh();

这就是说插入数据，而不是在网格中显示数据。



这完全没用。

It's saying Inserting data, not displaying data in a grid.

This is totally useless.

 SqlConnection conn = null;
 SqlDataReader rdr = null;

 // create and open a connection object
 conn = new
     SqlConnection(@"Server=MDT765\MDT765;DataBase=TST;user=user;password=user@123;Integrated Security=SSPI");
 conn.Open();

string myConnection = conn.ConnectionString.ToString();//"Data Source=MDT765;Initial Catalog=TST;User Id=user;Password=user@123;";
 SqlDataAdapter sqlcom0 = new SqlDataAdapter("SELECT * FROM Employee", myConnection);
 DataSet ds0 = new DataSet();
 sqlcom0.Fill(ds0);
 dataGridView1.DataSource = ds0.Tables[0].DefaultView;
 dataGridView1.Databind()
 dataGridView1.Refresh();

这篇关于使用C＃.net将数据插入数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！