private void Button1_Click(System.Object sender, System.EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database1.mdf;Integrated Security=True;User Instance=True");
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT StudentIdID, StudentName FROM Students WHERE StudentName LIKE @studName";
cmd.Connection = con;
SqlParameter StudentNameParameter = new SqlParameter("@studName", "g%");
cmd.Parameters.Add(StudentNameParameter);
}
|