110,527
社区成员
发帖
与我相关
我的任务
分享
静态类中声明的两个方法
private static SqlCommand FormatSql(string Format_Sql, params SqlParameter[] Format_cmdParms)
{
SqlCommand cmd = new SqlCommand(Format_Sql, SqlConn);
if (Format_cmdParms != null)
{
foreach (SqlParameter parm in Format_cmdParms)
cmd.Parameters.Add(parm);
}
return cmd;
}
public static DataSet GetQuery(string s_SQL, params SqlParameter[] cmdParms)
{
SqlConn.Close();
SqlCommand MyCommand = FormatSql(s_SQL, cmdParms);
SqlDataAdapter MyAdp = new SqlDataAdapter(MyCommand);
DataSet MyDS = new DataSet();
MyAdp.Fill(MyDS, "MyDS");
MyCommand.Parameters.Clear();
SqlConn.Close();
return MyDS;
}
窗体下按钮事件下写的代码
MyDS= IniClass.GetQuery("SELECT * FROM t1 WHERE id LIKE @JM OR mc LIKE @JM",
new SqlParameter("JM","%" + t_jm.Text.Trim() + "%"), new SqlParameter("JM",
"%" +t_jm.Text.Trim() + "%"));
dataGridView1.DataSource = MyDS.Tables["MyDS"];
IniClass.GetQuery("SELECT * FROM t1 WHERE id LIKE @JM OR mc LIKE @JM",
new SqlParameter("JM","%" + t_jm.Text.Trim() + "%");
能不能这样写,因为查询语句里有两个@JM,传值的时候就传一个,他的值是一样的