IoveBC
发表于 2013-3-5 13:04:05
private void button1_Click(object sender, EventArgs e)
{
String name = this.textBox1.Text;
String password = this.textBox2.Text;
//获得数据库连接字符串Data Source=.;Initial Catalog=winformSQL;Integrated Security=True
String conn = "Data Source=.;Initial Catalog=tempdb;Integrated Security=True";
//创建SqlConnection
SqlConnection connect = new SqlConnection(conn);//Data Source=.;Initial Catalog=tempdb;Integrated Security=True
String Sql = String.Format("Select * form tempdb Londing where usemer ='{0}'and password='{1}'", name, password);
//创建SqlCommand对象
SqlCommand command = new SqlCommand(Sql, connect);
connect.Open();//注:打开数据库连接要在创建command对象之后执行
int num = Convert.ToInt32(command.ExecuteScalar());
try
{
if (num > 0)
{
MessageBox.Show("登陆成功!");
}
else
{
MessageBox.Show("账户或密码错误!");
}
}
catch(Exception ex)
{
MessageBox.Show("异常!"+ex);
}
finally
{
connect.Close();
}
}
ibcadmin
发表于 2013-3-5 16:59:59
老百姓 发表于 2013-3-5 08:43 static/image/common/back.gif
select 不是 selecr,8是不是字段?不是的换成字段或*
楼上的精辟,眼睛真好,我还真没注意到select写错了。。
qzuser
发表于 2013-3-9 15:32:08
是不是在按*号键的时候,没有按住shift键啊?
IoveBC
发表于 2013-3-9 18:18:59
qzuser 发表于 2013-3-9 15:32 static/image/common/back.gif
是不是在按*号键的时候,没有按住shift键啊?
难不成还是大写的不成!
qzuser
发表于 2013-3-9 19:13:03
IoveBC 发表于 2013-3-9 18:18 static/image/common/back.gif
难不成还是大写的不成!
按*键不是要按住shift+8么?
IoveBC
发表于 2013-3-9 19:46:54
qzuser 发表于 2013-3-9 19:13 static/image/common/back.gif
按*键不是要按住shift+8么?
我的帖子上面不是有吗?很明显的一个*号啊
IoveBC
发表于 2013-3-10 12:47:51
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
String name = this.textBox1.Text;
String password = this.textBox2.Text;
//获得数据库连接字符串Data Source=.;Initial Catalog=tempdb;Integrated Security=True
String conn = "Data Source=.;Initial Catalog=tempdb;Integrated Security=True";
//创建SqlConnection
SqlConnection connect = new SqlConnection(conn);
String Sql = String.Format("Select * form tempdb Londing where usemer ='{0}'and password='{1}'", name, password);
//创建SqlCommand对象
SqlCommand command = new SqlCommand(Sql, connect);
connect.Open();//注:打开数据库连接要在创建command对象之后执行
int num = Convert.ToInt32(command.ExecuteScalar());
try
{
if (num > 0)
{
MessageBox.Show("登陆成功!");
}
else
{
MessageBox.Show("账户或密码错误!");
}
}
catch(Exception ex)
{
MessageBox.Show("异常!"+ex);
}
finally
{
connect.Close();
}
还是错的啊!
qzuser
发表于 2013-3-12 11:51:14
IoveBC 发表于 2013-3-10 12:47 static/image/common/back.gif
public Form1()
{
InitializeComponent();
Form1没有继承Form
IoveBC
发表于 2013-3-12 21:09:11
谢谢大家的指教,我有点头绪了,这个问题解决了
chao2332601
发表于 2013-6-16 00:52:51
谢谢分享!!!