User1988952462 posted
Hi
I'm new to asp.net so please bear with me. I'm just trying to retrieve information
from an access database (Access 2010) and allow user to update it through a text control.
I was able to retrieve the information and display it throug a text control but when i
update the value on the text and click the save button, it does not update the information
on the database. I don't know what i'm doing wrong. Any help is greatly appreciated.
I'm using VS2010 Professional. Please see my code below:
Default.aspx.cs
public partial class _Default : System.Web.UI.Page
{
private DataSet ds = null;
private OleDbDataAdapter da = null;
private OleDbCommandBuilder comBuilder = null;
DataRow dr = null;
OleDbConnection con= null;
protected void Page_Load(object sender, EventArgs e)
{
OpenDB();
GetTextValue();
}
private void GetTextValue()
{
dr = ds.Tables[0].Rows[0];
txtFName.Text = dr["FName"].ToString();
}
private void OpenDB()
{
string strCon = ConfigurationManager.ConnectionStrings["OleDbCon"].ToString();
con = new OleDbConnection(strCon);
int iID = 1;
string strSQL = "SELECT ID, FName FROM Emptbl " +
" WHERE ID =" + iID ;
da = new OleDbDataAdapter(strSQL, con);
comBuilder = new OleDbCommandBuilder(da);
ds = new DataSet();
da.Fill(ds);
}
protected void btnSave_Click(object sender, EventArgs e)
{
dr = ds.Tables[0].Rows[0];
dr["FName"] = txtFName.Text.ToString();
da.Update(ds);
}
}
Default.aspx
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<table style="width:100%">
<tr>
<td>
<asp:Button ID="btnSave" runat="server" Text="Save" onclick="btnSave_Click" />
</td>
</tr>
</table>
<table style="width:100%">
<tr>
<td style="width:10%" >
First Name :
</td>
<td>
<asp:TextBox ID="txtFName" runat="server" AutoPostBack="True"></asp:TextBox>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
