想知道结果,那你就执行该语句么。
string _Dsn = "...";//你的连接串
SqlConnection sqlConn = new SqlConnection(_Dsn);
string Sql = "select ...";
SqlCommand Cmd = new SqlCommand(Sql,sqlConn);
object o = Cmd.ExecuteScalar();//返回第一行的第一列
if ...
string _Dsn = "...";//你的连接串
SqlConnection sqlConn = new SqlConnection(_Dsn);
string Sql = "select ...";
SqlCommand Cmd = new SqlCommand(Sql,sqlConn);
object o = Cmd.ExecuteScalar();//返回第一行的第一列
if ...
比如:
string sql="select ...from ... where xxx=aaa";
SqlConnection conn=new SqlConnection(//连接字符串);
try{
conn.Open();
SqlCommand comm=new SqlCommand(sql,conn);
SqlDataReader dr=comm.ExecuteReader(); //或者返回值;
while(dr.Read()){ //如果返回值不为空,继续下一条记录
... //可以通过判断dr["字段名"]来判断具体内容
}
}
catch(Exception ee){
MessageBox.Show(ee.Message);
} wish u good luck
Greatsft
{
bool tmp_pass=false;
SqlParameter[] parm1 = new SqlParameter[]{
new SqlParameter("@sSort",SqlDbType.NVarChar,50),
new SqlParameter("@sMname",SqlDbType.NVarChar,50)
};
parm1[0].Value=bo.Sort;
parm1[1].Value=bo.Mname;
string sSelectSql="select distinct sort,mname from paxa_qb_flow_member where [sort]=@sSort and Mname=@sMname";
conn myConn=new conn();
SqlConnection myConnection=new SqlConnection(myConn.ConnStr());
SqlCommand myCommand= new SqlCommand(sSelectSql,myConnection);
for (int ii=0;ii<parm1.Length;ii++)
{
myCommand.Parameters.Add(parm1[ii]);
}
try
{
myConnection.Open();
SqlDataReader myReader=myCommand.ExecuteReader();
if (myReader.Read())
{
tmp_pass=true;
}
myConnection.Close();
return tmp_pass;
}
catch
{
return false;
}
}看到了吧?知道应该怎么写了吧?
if (ii>0)
{
tmp_pass=true;
}