protected void Submit1_ServerClick(object sender, EventArgs e) { string constr = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"; SqlConnection con = new SqlConnection(constr); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd = new SqlCommand("SubmitRecord1", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ID", SqlDbType.NVarChar,10).Value = TextBox1.Text; cmd.Parameters.Add("@Password", SqlDbType.NVarChar, 50).Value = TextBox2.Text; cmd.Parameters.Add("@ConfirmPassword", SqlDbType.NVarChar, 50).Value = TextBox3.Text; cmd.Parameters.Add("@EmailID", SqlDbType.NVarChar, 200).Value = TextBox4.Text; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } stored procedure ALTER PROCEDURE dbo.SubmitRecord1 ( @ID varchar(10), @Password varchar(50), @ConfirmPassword varchar(50), @EmailID varchar(200) ) AS INSERT INTO login1(ID,Password,ConfirmPassword,EmailID)VALUES(@ID,@Password,@ConfirmPassword,@EmailID) RETURN this worked fine..... for reference u can see link Thanks any ways
