ADO.NET Connection using C#

Question

Source code for database connection using ado.net Insert the data Delete the data Retrieve the data

Priya Linge · Answer

Hi, using System; using System.Data; using System.Data.SqlClient; //Sqlconnection Public class example() { string sConnectionString = "User ID= ;Initial Catalog=pubs;Data Source=(local)"; SqlConnection objConn = new SqlConnection(sConnectionString); Public void InsertData() { objConn.Open(); string sSQL = "INSERT INTO Employee " + "(emp_id, fname, hire_date) " + "VALUES ('MSD12923F', 'Duncan','2001-01-01')"; SqlCommand objCmd = new SqlCommand(sSQL,objConn); try { objCmd.ExecuteNonQuery(); } catch (System.Exception e) { Console.WriteLine(e.Message); } Console.WriteLine("Record Added"); } Public void Deleterecord() { objConn.Open(); string sSQL = "DELETE FROM Employee WHERE emp_id = @emp_id"; SqlCommand objCmd = new SqlCommand(sSQL,objConn); objCmd.Parameters.Add("@emp_id", SqlDbType.Char, 9); objCmd.Parameters["@emp_id"].Value = "MSD12923F"; try { objCmd.ExecuteNonQuery(); } catch (System.Exception e) { Console.WriteLine(e.Message); } Console.WriteLine("Record Deleted"); } Public void RetriveData() { objConn.Open(); string sSQL = Select Ename FROM Employee "; SqlCommand objCmd = new SqlCommand(sSQL,objConn); SqldataReader dr=objCmd.ExcuteReader(); } } Hope this will help you. Thanks.

ADO.NET Connection using C#

Answers (1)