ADO .Net – Dynamic Record Deletion in SQL Server

using System;
using System.Data.SqlClient;
namespace ADO1
{
            internal class Program
            {
                        static void Main(string[] args)
                        {
                                    SqlConnection con = null;
                                    try
                                    {
                                                con = new SqlConnection(“data source=.; database=fullstack; integrated security=SSPI”);
                                                con.Open();
                                                Console.WriteLine(“Connected to Database”);

                                                Console.WriteLine(“Enter student number to delete : “);
                                                int num = Convert.ToInt32(Console.ReadLine());

                                                String query = “delete from student where num=@num”;
                                                SqlCommand cm = new SqlCommand(query, con);

                                                cm.Parameters.AddWithValue(“@num”, num);
                                                cm.ExecuteNonQuery();
                                                Console.WriteLine(“Record deleted successfully”);
                                    }
                                    catch (Exception e)
                                    {
                                                Console.WriteLine(“Exception : ” + e.ToString());
                                    }
                                    finally
                                    {
                                                if(con != null)
                                                {
                                                            con.Close();
                                                            Console.WriteLine(“Closed”);
                                                }
                                    }
                        }
            }
}

Copyright © 2023 Ameerpet Technologies | Powered by Ameerpet Technologies