public partial class read : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//string objConnection;
string stringstrConnection = "server=Cityhr-Z;uid=sa;pwd=;database=CityHRCorp";
SqlConnediob objConnection = new SqlCOnnection(strConnection);
objConnection.Open();
//string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
//strConnection += Server.MapPath(strDb);
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbCommand objCommand = new OleDbCommand("select Employees where EmployeeID=3", objConnection);
objConnection.Open();
OleDbDataReader objDataReader = objCommand.ExecuteReader();
if (objDataReader.Read())
{
id.Text = Convert.ToString(objDataReader["EmployeeID"]);
name.Text = Convert.ToString(objDataReader["EmployeeName"]);
ip.SelectedItem.Text = Convert.ToString(objDataReader["IPAddress"]);
}
}
}
{
protected void Page_Load(object sender, EventArgs e)
{
//string objConnection;
string stringstrConnection = "server=Cityhr-Z;uid=sa;pwd=;database=CityHRCorp";
SqlConnediob objConnection = new SqlCOnnection(strConnection);
objConnection.Open();
//string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
//strConnection += Server.MapPath(strDb);
OleDbConnection objConnection = new OleDbConnection(strConnection);
OleDbCommand objCommand = new OleDbCommand("select Employees where EmployeeID=3", objConnection);
objConnection.Open();
OleDbDataReader objDataReader = objCommand.ExecuteReader();
if (objDataReader.Read())
{
id.Text = Convert.ToString(objDataReader["EmployeeID"]);
name.Text = Convert.ToString(objDataReader["EmployeeName"]);
ip.SelectedItem.Text = Convert.ToString(objDataReader["IPAddress"]);
}
}
}
具体提示错误是什么?看你的代码好像有多处错误。objConnection 还还定义了两次。strConnection 已注释了你还用。
你还用oledb干吗?
直接用sqlcommand 了
http://blog.96yy.com/threadview.asp?forumID=6&threadID=4