using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
String connectionString =@"Data Source=kk;Initial Catalog=DB;Integrated Security=True;Pooling=False";
String strSqlSelect = "select ID,MIMA from 身份 WHERE ID=TextBox.Text and MIMA=TextBox2.Text";
DataSet myDataSet = new DataSet();
myDataSet .Tables .Add("身份");
adoConnection myConnection=new adoConnection(connectionString );
adoDataSetCommand myDataSetCmd =new adoDataSetCommand();
myConnection .Open();
try
{
myDataSetCmd .FillDataSet(myDataSet ,"身份");//从数据库中获取数据 }
finally
{
myDataSetCmd .Close();
}
DataRow [] dra=myDataSet .Tables ["身份"].Rows.All;
if (dra[0].ToString ().Trim ()==this .textBox1 .Text .ToString ().Trim ()&&dra[1].ToString ().Trim ()==this .textBox2 .Text .ToString ().Trim ())
{
denglu j = new denglu ();
j.Show();
return;
}
else
{
MessageBox.Show("您输入的用户号或密码不正确!");
return ;
}
String connectionString =@"Data Source=kk;Initial Catalog=DB;Integrated Security=True;Pooling=False";
String strSqlSelect = "select ID,MIMA from 身份 WHERE ID=TextBox.Text and MIMA=TextBox2.Text";
DataSet myDataSet = new DataSet();
myDataSet .Tables .Add("身份");
adoConnection myConnection=new adoConnection(connectionString );
adoDataSetCommand myDataSetCmd =new adoDataSetCommand();
myConnection .Open();
try
{
myDataSetCmd .FillDataSet(myDataSet ,"身份");//从数据库中获取数据 }
finally
{
myDataSetCmd .Close();
}
DataRow [] dra=myDataSet .Tables ["身份"].Rows.All;
if (dra[0].ToString ().Trim ()==this .textBox1 .Text .ToString ().Trim ()&&dra[1].ToString ().Trim ()==this .textBox2 .Text .ToString ().Trim ())
{
denglu j = new denglu ();
j.Show();
return;
}
else
{
MessageBox.Show("您输入的用户号或密码不正确!");
return ;
}
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
String connectionString =@"Data Source=kk;Initial Catalog=DB;Integrated Security=True;Pooling=False";
String strSqlSelect = "select ID,MIMA from 身份 WHERE ID=TextBox.Text and MIMA=TextBox2.Text";
DataSet myDataSet = new DataSet();
myDataSet .Tables .Add("身份");
adoConnection myConnection=new adoConnection(connectionString );
adoDataSetCommand myDataSetCmd =new adoDataSetCommand();
myConnection .Open();
try
{
myDataSetCmd .FillDataSet(myDataSet ,"身份");//从数据库中获取数据 }
finally
{
myDataSetCmd .Close();
}
DataRow [] dra=myDataSet .Tables ["身份"].Rows.All;
if (dra[0].ToString ().Trim ()==this .textBox1 .Text .ToString ().Trim ()&&dra[1].ToString ().Trim ()==this .textBox2 .Text .ToString ().Trim ())
{
denglu j = new denglu ();
j.Show();
return;
}
else
{
MessageBox.Show("您输入的用户号或密码不正确!");
return ;
}
String connectionString =@"Data Source=kk;Initial Catalog=DB;Integrated Security=True;Pooling=False";
String strSqlSelect = "select ID,MIMA from 身份 WHERE ID=TextBox.Text and MIMA=TextBox2.Text";
DataSet myDataSet = new DataSet();
myDataSet .Tables .Add("身份");
adoConnection myConnection=new adoConnection(connectionString );
adoDataSetCommand myDataSetCmd =new adoDataSetCommand();
myConnection .Open();
try
{
myDataSetCmd .FillDataSet(myDataSet ,"身份");//从数据库中获取数据 }
finally
{
myDataSetCmd .Close();
}
DataRow [] dra=myDataSet .Tables ["身份"].Rows.All;
if (dra[0].ToString ().Trim ()==this .textBox1 .Text .ToString ().Trim ()&&dra[1].ToString ().Trim ()==this .textBox2 .Text .ToString ().Trim ())
{
denglu j = new denglu ();
j.Show();
return;
}
else
{
MessageBox.Show("您输入的用户号或密码不正确!");
return ;
}
"select ID,MIMA from 身份 WHERE ID=TextBox.Text and MIMA=TextBox2.Text";
错了。
你不会组织sql语句吗?vs.net调试就明显的知道是什么错了。
不好意思我是初学者。还希望您能说仔细些。另外在调试的时候涉及ADOCONNECTION的时候提示是不是缺少类库或类库引用错误。不清楚怎么回事儿。
string id=TextBox1.Text.Trim();
string mima=TextBox2.Text.Trim();
select语句写成如下形式:
select ID,MIMA from 身份 where ID='"+id+"' and MIMA='"+mima+"'"
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb; namespace Denglu
{
public class Test
{
public OledbConnection myConnection;
public String connectionString;
private void Dengluing()//登陆代码
{
if(Textbox.Text !="" && TextBox2.Text !="")
{
try
{
connectionString=@"DataSource=kk;InitialCatalog=DB;IntegratedSecurity=True;
Pooling=False"; //连接语句直接到网上查
String strSqlSelect = "select ID,MIMA from 身份 WHERE ID=TextBox.Text and
MIMA=TextBox2.Text";
DataSet myDataSet = new DataSet();
myConnection=new OledbConnection(connectionString );
myConnection .Open();
OledbCommand myCmd = myConnection.CreateCommand();
myCmd.CommadnText="select ID,MIMA from 身份 WHERE ID=TextBox.Text and
MIMA=TextBox2.Text";
//OledbDataApdater da=new OledbDataApdater(myCmd);
//da.fill(myDataSet,"身份");
//DataRow [] dra=myDataSet .Tables ["身份"].Rows.All; OledbDataReader myReader=myCmd.ExecuteReader()
/*if (dra[0].ToString ().Trim ()==this .textBox1 .Text .ToString ().Trim ()
&&dra[1].ToString ().Trim ()==this .textBox2 .Text .ToString ().Trim ())
*/
if(myReader.read())//如果有这个用户
{
denglu j = new denglu ();
j.Show();
}
else
{
MessageBox.Show("您输入的用户号或密码不正确!");
}
myConnection.close();
myCmd.dispose();
myReader.dispose();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
/*finally
{
....
}
*/
}
}
public void Button1_Click(....
{
Dengluing();
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Drawing.Drawing2D;
using System.Collections ;
using System.Globalization; namespace Denglu
{
public class Test
{
public OledbConnection myConnection;
public String connectionString;
private void Dengluing()//登陆代码
{
if (Textbox.Text != "" && TextBox2.Text != "")
{
try
{
connectionString = @"DataSource=kk;InitialCatalog=DB;IntegratedSecurity=True;
Pooling=False"; //连接语句直接到网上查
// System.String strSqlSelect = "select ID,MIMA from 身份 WHERE ID=TextBox.Text and MIMA=TextBox2.Text";
// DataSet myDataSet = new DataSet();
myConnection = new OledbConnection(connectionString);
myConnection.Open();//打开连接
OledbCommand myCmd = myConnection.CreateCommand();//创建新的Command
myCmd.CommadnText = "select ID,MIMA from 身份 WHERE ID=TextBox.Text and MIMA=TextBox2.Text";//确定Command查询语句
//OledbDataApdater da=new OledbDataApdater(myCmd);
//da.fill(myDataSet,"身份");
//DataRow [] dra=myDataSet .Tables ["身份"].Rows.All; OledbDataReader myReader = myCmd.ExecuteReader();//读取数据
/*if (dra[0].ToString ().Trim ()==this .textBox1 .Text .ToString ().Trim ()
&&dra[1].ToString ().Trim ()==this .textBox2 .Text .ToString ().Trim ())
*/
if (myReader.read())//如果有这个用户,用户ID都是唯一的。所以只要判断是否有这个用户
{
denglu j = new denglu();
j.Show();
}
else
{
MessageBox.Show("您输入的用户号或密码不正确!");
}
myConnection.close();
myCmd.dispose();
myReader.dispose();
}
catch (Exception ex)//获取错误
{
MessageBox.Show(ex.Message);
}
}
} public void Button1_Click(。。)//调用验证代码
{
Dengluing();
}
}
}修改下
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Drawing.Drawing2D;
using System.Collections ;
using System.Globalization; namespace Denglu
{
public class Test
{
public OledbConnection myConnection;
public String connectionString;
private void Dengluing()//登陆代码
{
if (Textbox.Text != "" && TextBox2.Text != "")
{
try
{
connectionString = @"DataSource=kk;InitialCatalog=DB;IntegratedSecurity=True;
Pooling=False"; //连接语句直接到网上查
// System.String strSqlSelect = "select ID,MIMA from 身份 WHERE ID=TextBox.Text and MIMA=TextBox2.Text";
// DataSet myDataSet = new DataSet();
myConnection = new OledbConnection(connectionString);
myConnection.Open();//打开连接
OledbCommand myCmd = myConnection.CreateCommand();//创建新的Command
myCmd.CommadnText = "select ID,MIMA from 身份 WHERE ID='"+TextBox.Text+"' and MIMA='"+TextBox2.Text+"'";//确定Command查询语句,修改后的语句
//OledbDataApdater da=new OledbDataApdater(myCmd);
//da.fill(myDataSet,"身份");
//DataRow [] dra=myDataSet .Tables ["身份"].Rows.All; OledbDataReader myReader = myCmd.ExecuteReader();//读取数据
/*if (dra[0].ToString ().Trim ()==this .textBox1 .Text .ToString ().Trim ()
&&dra[1].ToString ().Trim ()==this .textBox2 .Text .ToString ().Trim ())
*/
if (myReader.read())//如果有这个用户,用户ID都是唯一的。所以只要判断是否有这个用户
{
denglu j = new denglu();
j.Show();
}
else
{
MessageBox.Show("您输入的用户号或密码不正确!");
}
myConnection.close();
myCmd.dispose();
myReader.dispose();
}
catch (Exception ex)//获取错误
{
MessageBox.Show(ex.Message);
}
}
} public void Button1_Click(。。)//调用验证代码
{
Dengluing();
}
}
}
把方法的修饰符改成PUBLIC后仍出现此错误。
好好看看代码把