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(sSQLobjConn); 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(sSQLobjConn); 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(sSQLobjConn); SqldataReader dr=objCmd.ExcuteReader(); } } Hope this will help you. Thanks.