SQLiteConnection conn = new SQLiteConnection();//连接数据库
SQLiteCommand cmd =new SQLiteCommand();
try
{
cmd.Connection = conn;
conn.ConnectionString = "Data Source=accounting.s3db";
cmd.CommandText = "SELECT count(*) FROM usertable WHERE username = @username AND password = @password";
conn.Open();
cmd.Parameters["@username"].Value = this.txtName.Text;
cmd.Parameters["@password"].Value = this.txtPwd.Text;
int i = int.Parse(cmd.ExecuteScalar().ToString());//查询并返回查询结果集中第一行的第一列忽略其他列
if (i>0)
{
MainFm mform = new MainFm();
this.Hide();
mform.Show();
}
else
{
MessageBox.Show("用户名或密码错误");
}
错误为:用c#连接sqlite数据库中索引超出范围.必须为非负值并小于集合大小.参数名为index;不知道解决办法,求好心人。C#SQLite数据库
SQLiteCommand cmd =new SQLiteCommand();
try
{
cmd.Connection = conn;
conn.ConnectionString = "Data Source=accounting.s3db";
cmd.CommandText = "SELECT count(*) FROM usertable WHERE username = @username AND password = @password";
conn.Open();
cmd.Parameters["@username"].Value = this.txtName.Text;
cmd.Parameters["@password"].Value = this.txtPwd.Text;
int i = int.Parse(cmd.ExecuteScalar().ToString());//查询并返回查询结果集中第一行的第一列忽略其他列
if (i>0)
{
MainFm mform = new MainFm();
this.Hide();
mform.Show();
}
else
{
MessageBox.Show("用户名或密码错误");
}
错误为:用c#连接sqlite数据库中索引超出范围.必须为非负值并小于集合大小.参数名为index;不知道解决办法,求好心人。C#SQLite数据库
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货