现在提示我这句错误:SqlConnection conns = new SqlConnection(conn_conn.conn_str);错误1:与“System.Data.SqlClient.SqlConnection.SqlConnection(string)”
最匹配的重载方法具有一些无效参数C:\test\conn_test\conn_test\Form1.cs错误2:参数“1”: 无法从“方法组”转换为“string”
C:\test\conn_test\conn_test\Form1.cs 24大家帮看看什么地方错了呢?怎么改?.mdb表内数据库连接和内容我测试过可以连接上的。我在program中定义的类和方法
public class conn
{
public string conn_str(string server, string database, string uid, string pwd)
{
string strpath = "C:/cj_sys/cj_db/ms_ex.mdb";
string ole_str = "select top 1 * from db_conn order by db_id desc";
string ole_conn = "Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=" + strpath + ";User Id=admin;Password=;";
OleDbConnection conn = new OleDbConnection(ole_conn);
OleDbCommand cmd = new OleDbCommand(ole_str, conn);
conn.Open();
OleDbDataReader rs = cmd.ExecuteReader();
if (rs.Read())
{
server = rs[1].ToString();
database = rs[2].ToString();
uid = rs[3].ToString();
pwd = rs[4].ToString();
}
rs.Close();
conn.Close();
return (string)("server=" + server + ";" +
"database=" + database + ";" + "uid=" + uid + ";" + "pwd=" + pwd);
}
}
我在form1.cs中的调用private void button1_Click(object sender, EventArgs e)
{
string sql ="select * from cj_main_sd";
conn conn_conn = new conn();
SqlConnection conns = new SqlConnection(conn_conn.conn_str);
SqlCommand command = new SqlCommand(sql,conns);
conns.Open();
}
最匹配的重载方法具有一些无效参数C:\test\conn_test\conn_test\Form1.cs错误2:参数“1”: 无法从“方法组”转换为“string”
C:\test\conn_test\conn_test\Form1.cs 24大家帮看看什么地方错了呢?怎么改?.mdb表内数据库连接和内容我测试过可以连接上的。我在program中定义的类和方法
public class conn
{
public string conn_str(string server, string database, string uid, string pwd)
{
string strpath = "C:/cj_sys/cj_db/ms_ex.mdb";
string ole_str = "select top 1 * from db_conn order by db_id desc";
string ole_conn = "Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=" + strpath + ";User Id=admin;Password=;";
OleDbConnection conn = new OleDbConnection(ole_conn);
OleDbCommand cmd = new OleDbCommand(ole_str, conn);
conn.Open();
OleDbDataReader rs = cmd.ExecuteReader();
if (rs.Read())
{
server = rs[1].ToString();
database = rs[2].ToString();
uid = rs[3].ToString();
pwd = rs[4].ToString();
}
rs.Close();
conn.Close();
return (string)("server=" + server + ";" +
"database=" + database + ";" + "uid=" + uid + ";" + "pwd=" + pwd);
}
}
我在form1.cs中的调用private void button1_Click(object sender, EventArgs e)
{
string sql ="select * from cj_main_sd";
conn conn_conn = new conn();
SqlConnection conns = new SqlConnection(conn_conn.conn_str);
SqlCommand command = new SqlCommand(sql,conns);
conns.Open();
}
你至少也得给conn_str传递参数,然后返回字符串啊
是个方法?
方法有参数的啊?string server, string database, string uid, string pwd
"database=" + database + ";" + "uid=" + uid + ";" + "pwd=" + pwd);值没有被传入吗?