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_ID,Name,Age,Contact

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()); } } } }

Sql

Answers (3)