Click here to Skip to main content
15,923,689 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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.....
Posted

C#
 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();
 
Share this answer
 
It's saying Inserting data, not displaying data in a grid.

This is totally useless.
 
Share this answer
 
C#
 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();
 
Share this answer
 
Comments
tusharkaushik 9-Jun-12 17:36pm    
thanks

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900