Create a Parameterized Sql Procedure..

Show How To Create a Sql Parameterized Procedure...

private void Button1_Click(System.Object sender, System.EventArgs e) { SqlCommand cmd = new SqlCommand(); SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database1.mdf;Integrated Security=True;User Instance=True"); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "StudentResult"; }