task12_04(1).cs

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;

namespace data
{
    class Class6
    {
       public static void Main()
        {

            // SqlConnection con = new SqlConnection("Data source =DESKTOP-7MGGRB4; database =Anand; user id = sa;password = P@ssword");
            //  string sqlqry = "create table enroll(sno int,Fname varchar(20),Lname varchar(20),Gender varchar(20));
            //  SqlCommand cmd = new SqlCommand(sqlqry, con);
            //  con.Open();
            //  cmd.ExecuteNonQuery();
            //  con.Close();
            //  Console.WriteLine("created successfully");



            //  SqlConnection con = new SqlConnection("Data source =DESKTOP-7MGGRB4; database =Anand; user id = sa;password = P@ssword");
            //  string sqlqry = "insert enroll values(1001,'Anand','kumar','M')";
            // SqlCommand cmd = new SqlCommand(sqlqry, con);
            // con.Open();
            //cmd.ExecuteNonQuery();
            //  con.Close();
            // Console.WriteLine("Row Inserted");




            // SqlConnection con = new SqlConnection("Data source =DESKTOP-7MGGRB4; database =Anand; user id = sa;password = P@ssword");
            //  string sqlqry = "delete from enroll where  Fname='Anand'";
            //  SqlCommand cmd = new SqlCommand(sqlqry, con);
            //  con.Open();
            //  cmd.ExecuteNonQuery();
            //  con.Close();
            //  Console.WriteLine("Deleted is done");



            // SqlConnection con = new SqlConnection("Data source =DESKTOP-7MGGRB4; database =Anand; user id = sa;password = P@ssword");
            //string sqlqry = "update enroll Set Fname='Thangam' Lname='Kar' where Gender='F'";
            // SqlCommand cmd= new SqlCommand("update tbl_enrollment Set Fname='Thangam' Lname='Kar' where Gender='F'", con);
            // con.Open();
           // cmd.ExecuteNonQuery();
            // con.Close();
            //Console.WriteLine("Updated is done");



        }

    }
}