string sqlstr="select userid,pass from auth where userid="+userid.Text.Trim()+" and pass="+pass.Text.Trim()+"";
------------->
string sqlstr="select userid,pass from auth where userid='"+userid.Text.Trim()+"' and pass='"+pass.Text.Trim()+"'";单引号不要忘了!!!!!!!!!!!!!!!!!!!!
------------->
string sqlstr="select userid,pass from auth where userid='"+userid.Text.Trim()+"' and pass='"+pass.Text.Trim()+"'";单引号不要忘了!!!!!!!!!!!!!!!!!!!!
我加了'还是不行啊
同样的问题
试试:
DataSet my=new DataSet();
this.mydata.Fill(my,"Table");//在这里中断或者: DataSet my=new DataSet("auth")
this.mydata.Fill(my,"auth")还不行检查下连接字符串。
myCommand.CommandText=sqlstr;
myCommand.Connection=myconn;
SqlDataAdapter mydata=new SqlDataAdapter(myCommand);
这样试一下
还是不行
{
string cnnstr=@"Data Source=(Local);Integrated Security=SSPI;Initial Catalog=testfair2";
SqlConnection myconn=new SqlConnection(cnnstr);
myconn.Open();
//MessageBox.Show(this.sqlConnection1.ConnectionString.ToString());
string sqlstr="select userid,pass from auth where userid='"+userid.Text.Trim()+" 'and pass='"+pass.Text.Trim()+"'";
DataSet my=new DataSet("auth");
SqlDataAdapter mydata=new SqlDataAdapter(sqlstr,myconn);
mydata.Fill(my,"auth");//在
dataGrid1.SetDataBinding(my,"auth");
dataGrid1.Refresh();
}测试你的代码。改动后,成功。
是不是加内存可以该改善这样的情况
哦这样啊,谢谢
DataSet采用断线连接
this.mydata.Dispose()也会自动施放资源;
this.mydata.Fill(my,"auth");//在这里中断
this.mydata.Dispose();this.mydata.Dispose()也会自动施放资源;可是这是最后一句啊,释放应该没问题的。在前一句被中断的