62,046
社区成员
发帖
与我相关
我的任务
分享
switch (Type.SelectedValue)
{
case "id":
sql += "ErrorID=@ErrorID";
sda = new SqlDataAdapter(sql, conn);
sda.SelectCommand.Parameters.Add("@ErrorID", SqlDbType.Int).Value=searchcontent.Text;
break;
case "subject":
sql += "ErrorSub like @ErrorSub";
sda = new SqlDataAdapter(sql, conn);
sda.SelectCommand.Parameters.Add("@ErrorSub", SqlDbType.Char).Value = searchcontent.Text;
break;