amir-aa
سه شنبه 23 خرداد 1391, 16:52 عصر
string connectionstring = "provider=Microsoft.Jet.OLeDB.4.0;Data Source=" + Server.MapPath("Copy of dbsite.mdb");
OleDbConnection conn = new OleDbConnection(connectionstring);
string query = "select * from tbl_jayeze where [mojud]>=0";
OleDbCommand cm = new OleDbCommand(query, conn);
conn.Open();
OleDbDataReader dr = cm.ExecuteReader();
if (dr.Read())
{
conn.Close();
string query1 = "select top 1 id as [ran],[name],[cost] from tbl_jayeze where [pish]='False' order by newid()";
OleDbCommand cm1=new OleDbCommand(query1,conn);
conn.Open();
OleDbDataReader dr1 = cm.ExecuteReader();
if (dr1.Read())
{
string a1 = dr1["name"].ToString();
int a2 = Convert.ToInt32(dr1["cost"]);
Label1.Text = a1;
Label7.Text = a2.ToString();
}
}
سلام این کد روی conn.open() ارورر میده unspecified Erorr
OleDbConnection conn = new OleDbConnection(connectionstring);
string query = "select * from tbl_jayeze where [mojud]>=0";
OleDbCommand cm = new OleDbCommand(query, conn);
conn.Open();
OleDbDataReader dr = cm.ExecuteReader();
if (dr.Read())
{
conn.Close();
string query1 = "select top 1 id as [ran],[name],[cost] from tbl_jayeze where [pish]='False' order by newid()";
OleDbCommand cm1=new OleDbCommand(query1,conn);
conn.Open();
OleDbDataReader dr1 = cm.ExecuteReader();
if (dr1.Read())
{
string a1 = dr1["name"].ToString();
int a2 = Convert.ToInt32(dr1["cost"]);
Label1.Text = a1;
Label7.Text = a2.ToString();
}
}
سلام این کد روی conn.open() ارورر میده unspecified Erorr