Hello all... I'm having trouble with updating a text area. I want to call the original value of the text area into a textbox, and have the user able to change text in the textbox, and submit the changes. I can update the database with no problem, but I can't call the previous value into the text box. Here's my code... if anyone could fix it or tell me another way to do it I'd really appreciate it. Thanks a lot!<BR>---<BR><%@ Page Language="VB" Debug="true" %><BR><%@ Import Namespace="System.Data" %><BR><%@ Import Namespace="System.Data.OLEDB" %><BR><%@ Import Namespace="System.Web.UI.HtmlControls" %><BR><script language="vb" runat="server"><BR><BR><BR>Sub Page_Load(Src As Object, E As EventArgs)<BR><BR>==connection junk here==<BR> Dim Conn as New OLEDBConnection<BR> Conn = New OleDbConnection(ss)<BR><BR> Dim strSQL as string ="select * from bios where id=" & Request.QueryString("i")<BR><BR> Dim Cmd as New OLEDBCommand(strSQL,Conn)<BR> Conn.Open()<BR> myDataGrid.DataSource = Cmd.ExecuteReader(system.data.CommandBehavior.Clos eConnection)<BR> myDataGrid.DataBind()<BR> <BR>End Sub<BR><BR><BR>Sub btnInsertRecord_Click(sender As Object, e As EventArgs)<BR><BR>===connection junk here==<BR><BR> Dim DetailsText As HtmlInputText<BR> DetailsText = E.Item.FindControl("txtDetailStuff")<BR><BR> Dim sql = "Update bios Set Details='" & DetailsText.Text<BR> sql = sql & "' WHERE ID=" & Request.QueryString("i")<BR><BR> Dim myConnection As New OleDbConnection(ss)<BR> Dim myCommand As New OleDbCommand(sql, myConnection)<BR> <BR> myCommand.Connection.Open()<BR> myCommand.ExecuteNonQuery()<BR> myCommand.Connection.Close()<BR><BR> Response.Redirect("ebios.aspx")<BR><BR><BR>End Sub <BR><BR></script><BR><BR><BR><HTML><BR><HEAD><BR><title>Free Ride Admin - Bios</title><BR><LINK href=http://aspmessageboard.com/archive/index.php/"../css/style.css" type="text/css" rel=stylesheet><BR></HEAD><BR><body><BR><BR><ASP:Repeater id="myDataGrid" runat="server"><BR><BR> <headertemplate><BR> <CENTER><BR><TABLE BORDER=0 WIDTH=75% CELLPADDING=0 CELLSPACING=0><BR> </headertemplate><BR><BR><BR> <itemtemplate><BR> <TR><BR> <TD ALIGN="center" valign="middle"><BR><BR> <%# Container.DataItem("Details")%><BR><BR> <BR><BR> <BR><BR><form id="Inserting" method="post" runat="server"><BR><BR>Message Text:<BR><asp:TextBox id="txtDetailStuff" runat="server" TextMode="MultiLine"/><BR></P><BR><P><BR><asp:Button class="button" id="btnInsertRecord" runat="server" Text="Insert Record" OnClick="btnInsertRecord_Click"></asp:button><BR></P><BR></form><BR><BR> </TD><BR> </TR><BR> </itemtemplate><BR><BR> <footertemplate><BR> </TABLE><BR> </footertemplate><BR> <BR></ASP:Repeater><BR>In your Page_Load event handler, put that databinding jazz in an If statement so that it only occurs on the Page's first load. I.e.:<BR><BR>If Not Page.IsPostBack Then<BR> 'Do all your Databinding, Databse connection stuff<BR>End If<BR><BR>Does that do the trick? If it does, can you explain why?
Updating a Text Area
- Thread starter test
- Start date