View Full Version : 取数据库数据然后登陆


Kylin
04-05-2007, 02:32 AM
string aa = "select LoginName from User";
string bb = "select Psw from User";
System.Data.SqlClient.SqlConnection conn =new
System.Data.SqlClient.SqlConnection(client.CDBAccess.ConnectStringDB);
System.Data.SqlClient.SqlCommand cmd1 = new
System.Data.SqlClient.SqlCommand(aa,conn);
System.Data.SqlClient.SqlCommand cmd2 = new
System.Data.SqlClient.SqlCommand(aa,conn);

conn.Open();
int cc = (int)cmd1.ExecuteNonQuery();
int dd = (int)cmd2.ExecuteNonQuery();
if ( textBox1.Text = cc&&textBox2.Text=dd )
{

Form er = new Form1();
er.Show();
}
提示&&无法应用于int和string类型 请指教并代码有没有问题

秦风意动
04-05-2007, 03:28 AM
textBox1.Text = cc&&textBox2.Text=dd

改成

textBox1.Text == cc&&textBox2.Text==dd

“Kylin”编写:

>
> string aa = "select LoginName from User";
> string bb = "select Psw from User";
> System.Data.SqlClient.SqlConnection conn =new
> System.Data.SqlClient.SqlConnection(client.CDBAccess.ConnectStringDB);
> System.Data.SqlClient.SqlCommand cmd1 = new
> System.Data.SqlClient.SqlCommand(aa,conn);
> System.Data.SqlClient.SqlCommand cmd2 = new
> System.Data.SqlClient.SqlCommand(aa,conn);
>
> conn.Open();
> int cc = (int)cmd1.ExecuteNonQuery();
> int dd = (int)cmd2.ExecuteNonQuery();
> if ( textBox1.Text = cc&&textBox2.Text=dd )
> {
>
> Form er = new Form1();
> er.Show();
> }
> 提示&&无法应用于int和string类型 请指教并代码有没有问题
>

Kylin
04-05-2007, 03:34 AM
不行啊
ExecuteNonQuery();是int 无法应用到string和int.是不是ExecuteNonQuery();

“秦风意动”编写:

> textBox1.Text = cc&&textBox2.Text=dd
>
> 改成
>
> textBox1.Text == cc&&textBox2.Text==dd
>
> “Kylin”编写:
>
> >
> > string aa = "select LoginName from User";
> > string bb = "select Psw from User";
> > System.Data.SqlClient.SqlConnection conn =new
> > System.Data.SqlClient.SqlConnection(client.CDBAccess.ConnectStringDB);
> > System.Data.SqlClient.SqlCommand cmd1 = new
> > System.Data.SqlClient.SqlCommand(aa,conn);
> > System.Data.SqlClient.SqlCommand cmd2 = new
> > System.Data.SqlClient.SqlCommand(aa,conn);
> >
> > conn.Open();
> > int cc = (int)cmd1.ExecuteNonQuery();
> > int dd = (int)cmd2.ExecuteNonQuery();
> > if ( textBox1.Text = cc&&textBox2.Text=dd )
> > {
> >
> > Form er = new Form1();
> > er.Show();
> > }
> > 提示&&无法应用于int和string类型 请指教并代码有没有问题
> >

秦风意动
04-05-2007, 09:14 AM
Convert.toInt32(textBox1.Text) == cc && Convert.toInt32(textBox2.Text) =dd

“Kylin”编写:

> 不行啊
> ExecuteNonQuery();是int 无法应用到string和int.是不是ExecuteNonQuery();
>
> “秦风意动”编写:
>
> > textBox1.Text = cc&&textBox2.Text=dd
> >
> > 改成
> >
> > textBox1.Text == cc&&textBox2.Text==dd
> >
> > “Kylin”编写:
> >
> > >
> > > string aa = "select LoginName from User";
> > > string bb = "select Psw from User";
> > > System.Data.SqlClient.SqlConnection conn =new
> > > System.Data.SqlClient.SqlConnection(client.CDBAccess.ConnectStringDB);
> > > System.Data.SqlClient.SqlCommand cmd1 = new
> > > System.Data.SqlClient.SqlCommand(aa,conn);
> > > System.Data.SqlClient.SqlCommand cmd2 = new
> > > System.Data.SqlClient.SqlCommand(aa,conn);
> > >
> > > conn.Open();
> > > int cc = (int)cmd1.ExecuteNonQuery();
> > > int dd = (int)cmd2.ExecuteNonQuery();
> > > if ( textBox1.Text = cc&&textBox2.Text=dd )
> > > {
> > >
> > > Form er = new Form1();
> > > er.Show();
> > > }
> > > 提示&&无法应用于int和string类型 请指教并代码有没有问题
> > >