aarav-program

ALTER PROCEDURE [dbo].[SP_Student]( @Action VARCHAR(50)=NULL, @Name VARCHAR(50)=NULL, @DOB DATE=NULL, @Email VARCHAR(120)=NULL, @ImagePath VARCHAR(500)=NULL, @Password VARCHAR(300)=NULL ) AS BEGIN     IF(@Action='insert')         BEGIN             IF NOT EXISTS(SELECT * FROM Student WHERE Email=@Email)                 BEGIN                     INSERT INTO Student(Name,DOB,Email,Password,ImagePath,IsActive,AddedOn) VALUES(@Name,@DOB,@Email,@Password,'/content/profilepic/user.png',1,GETDATE());                     SELECT 1 AS Flag;                 END             ELSE     ...

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data; using System.Data.SqlClient; using System.Configuration; /// <summary> /// Summary description for mydblayer /// </summary> public class mydblayer {     public SqlConnection con;     public SqlCommand cmd;     public SqlDataAdapter da;     public mydblayer()     {         con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);         cmd = new SqlCommand();         cmd.Connection = con;         cmd.CommandType = CommandType.StoredProcedure;         da = new SqlDataAdapter(cmd);     }     public bool MyInsertUpdateDelete(string procedureName)     ...

 Bussiness data layer class in asp.net c# you can use using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data; using System.Data.SqlClient; using System.Configuration; namespace screentestbrijesh.App_Code {     public class DataAdoLayer     {         public SqlConnection con;         public SqlCommand cmd;         public SqlDataAdapter da;         public DataAdoLayer()         {             con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConStr"].ConnectionString);             cmd = new SqlCommand();             cmd.Connection = c...