what is trigger

Question

what is trigger and how to work it with example

Answer 1

1. imports namesapce in class

using System.Data.SqlClient;

2. create a function in that class which retrun sqlConnection

public static SqlConnection Connection()

         {

            string connectionString = "Data Source=sandeepss-PC;database=Development;user=sa;password=knowdev";

            SqlConnection con = new SqlConnection();

            con.ConnectionString = connectionString;

            return con;

        }

3 create a function which return all login names in a data Table

 public static DataTable getUserLogin()

         {

             DataTable dt = new DataTable();

             SqlConnection con = Connection();

             SqlCommand cmd = new SqlCommand();

             cmd.CommandText = "select userLogin from tbl_login";

             cmd.Connection = con;

             con.Open();

             SqlDataReader reader = cmd.ExecuteReader();

             dt.Load(reader);

             return dt;

         }