Looks like you are mixing between sending direct SQL commands and calling a stored procedure. Try to decide which one you want to use.
public DataSet FindRecord(int RollNumber)
{
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spfindtblstudent";
cmd.Parameters.AddWithValue("@RollNumber", RollNumber);
con.Open();
SqlDataAdapter da = new SqlDataAdapter()
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
}
As you don't specify your exact exception message, I can only guess that this is the problem.