我希望在包含文本框的asp.net页面中检索访问数据库值,按钮单击文本框上的按钮应该从访问文件获取数据,我得到输出... [英] i want access database values to be retrieved in asp.net page containing textbox and button on button click textbox should get the data from access file and i am getting the output...
问题描述
使用System;
使用System.Configuration;
使用System.Data;
使用System.Data.OleDb;
使用System.Linq;
使用System.Web;
使用System.Web.Security;
使用System.Web .UI;
使用System.Web.UI.HtmlControls;
使用System.Web.UI.WebControls;
使用System.Web。 UI.WebControls.WebParts;
使用System.Xml.Linq;
public partial class _Default:System.Web.UI.Page
{
OleDbConnection conn = new OleDbConnection(Provider = Microsoft.Jet.OLEDB.4.0; Data Source = C:/ Documents and Settings / abby1 / My Documents / Visual Studio 2008 / WebSites / WebSite3 / App_Data / TEST.mdb);
OleDbDataReader rdr = null;
protected void Page_Load(object sender,EventArgs e)
{
}
protected void TextBox1_TextChanged(object sender,EventArgs e)
{
}
protected void Button1_Click(object sender,EventArgs e)
{
try
{
conn.Open();
OleDbCommand str = new OleDbCommand(select appno from final,conn);
OleDbDataReader rdr = str .ExecuteReader();
DataSet ds = new DataSet();
if(rdr.HasRows)
{
while(rdr.Read())
{
TextBox1.Text = Convert.ToString(str);
}
}
}
catch
{
conn .Close();
}
}
私有字符串ToString(string p)
{
抛出新的NotImplementedException();
}
}
using System;
using System.Configuration;
using System.Data;
using System.Data.OleDb;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
public partial class _Default : System.Web.UI.Page
{
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Documents and Settings/abby1/My Documents/Visual Studio 2008/WebSites/WebSite3/App_Data/TEST.mdb");
OleDbDataReader rdr = null;
protected void Page_Load(object sender, EventArgs e)
{
}
protected void TextBox1_TextChanged(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
conn.Open();
OleDbCommand str = new OleDbCommand("select appno from final", conn);
OleDbDataReader rdr = str.ExecuteReader();
DataSet ds = new DataSet();
if (rdr.HasRows)
{
while (rdr.Read())
{
TextBox1.Text = Convert.ToString(str);
}
}
}
catch
{
conn.Close();
}
}
private string ToString(string p)
{
throw new NotImplementedException();
}
}
推荐答案
如果有帮助,请尝试以下代码并标记答案。
TextBox1.Text = rdr(appno)。ToString()
Try the following code & mark it answer if it helps .
TextBox1.Text = rdr("appno").ToString()
这篇关于我希望在包含文本框的asp.net页面中检索访问数据库值,按钮单击文本框上的按钮应该从访问文件获取数据,我得到输出...的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!