Sql

Question

Q.I want to save and retrive details to backend(Sql sever) by console C# programm please send me the code if possible thanks in advance....

Rajat Uppal · Answer

thanx nikhil for help me

Rajat Uppal · Answer

Nikhil The table name is emp and coloums names are Employee_IDNameAgeContact

Roei Bar · Answer

the insert command is: using (SqlConnection cn = new SqlConnection(connectionString)) { commandString =  INSERT INTO table (Column1 Column2)  +  Values ('string' 1) ); using (SqlCommand cm = new SqlCommand(commandString cn)) { cn.Open(); cm.ExecuteNonQuery(); } } the select is : using (SqlConnection cn = new SqlConnection(connectionString)) { cn.Open(); commandString =  select * from table ; using (SqlCommand cm = new SqlCommand(commandString cn)) { using ( SqlDataReader myReader = new SqlDataReader()) { myReader = cm .ExecuteReader(); while (myReader.Read()) { Console.WriteLine(myReader[  Column1 ].ToString()); Console.WriteLine(myReader[  Column2 ].ToString()); } } } }