string uname, pword, server;
if (textBox1.Text.Trim() != "" && textBox2.Text.Trim() != "" && comboBox1.Text.Trim() != "")
{
uname = textBox1.Text.Trim();
pword = textBox2.Text.Trim();
server = comboBox1.Text.Trim();
OracleConnection conn = new OracleConnection();
conn.ConnectionString = "Data Source='server';User ID='uname';Password='pword'";
conn.Open();
DataSet ds = new DataSet();
string str = "select 姓名 from 检验标本记录 ";
OracleCommand com = new OracleCommand();
OracleDataAdapter da = new OracleDataAdapter(str, conn);
da.Fill(ds, "检验标本记录");
if (ds.Tables[0].Rows.Count > 0)
{
MessageBox.Show("登录成功!");
this.Hide();
Form2 form = new Form2();
form.Show();
}
else
{
MessageBox.Show("用户名或密码错误!");
}
}
else
{
MessageBox.Show("用户名或者密码为空,请正确输入!", "提示");
}
上面是我的代码,为一个小程序做的登陆界面,界面类似pl/sql。
但是上面代码运行会出错。感觉是连接字符串问题,各位给看看,谢谢了