22,209
社区成员
发帖
与我相关
我的任务
分享
public SqlDataReader GetStudentInfoByName(string sName)
{
string strConn = "";//自己补
string sql = @"select * from Student as A,Grade as B
where a.StudentName like '%'+@name+'%'
and a.GradeId=b.GradeId
";
SqlDataReader sdr = null;
try
{
SqlConnection conn = new SqlConnection(strConn);
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@name", sName);
sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (Exception ex)
{
//注意:在这里看具体的异常信息
Console.WriteLine(ex.Message);
}
return sdr;
}