Hi,

I'm using ASP.net c#, visual studio 2005, and access 2003. I'm trying to add a record to a database with the info of a textbox when that textbox changes. so I wrote this code in the Textchanged method

 protected void  _TextChanged(object sender, EventArgs e)
{
    OleDbConnection cn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data      Source=C:\AccessDB\db1.mdb;User Id=admin;Password=;");
    OleDbCommand cmd = new OleDbCommand();
    cmd.CommandText = "insert into comments (comment) VALUES (?)";
    cmd.Parameters.AddWithValue("comment", COMMENT_BOX.Text.ToString());
    cmd.Connection = cn;
    cmd.Connection.Open();
    cmd.ExecuteNonQuery();
    cmd.Connection.Close();
    cmd.Dispose();
    cn.Dispose();
    COMMENT_BOX.Text = String.Empty;
}

The text box look like this:

 <asp:TextBox ID="COMMENT_BOX" Name="COMMENT_BOX" runat="server" Enabled="true" OnTextChanged="_TextChanged" Height="24px" Width="344px" /> Comments

But this doesn't work, I even tryed to refresh the page after the text changes but no luck.. 

Anything i'm missing here?

 what do you mean by doesn't work? like in does not fire?

use this AutoPostBack="true"  in here  :

<asp:TextBox ID="COMMENT_BOX" Name="COMMENT_BOX" runat="server" Enabled="true" OnTextChanged="_TextChanged" Height="24px" Width="344px" AutoPostBack="true"/>

also, you should keep you database code in the changed event under atry-catch block so that any database errors, if at all, will be reported

try{}
catch(Exception ex)
{
    Response.Write(ex.Message);
}

Hi,

I the text box set AutoPostBack="true"

Thanks

Ratheesh

 AutoPostback = True is missing from your textbox.

here:

<asp:TextBox ID="COMMENT_BOX" Name="COMMENT_BOX" runat="server" Enabled="true" OnTextChanged="_TextChanged" AutoPostBack="true" Height="24px" Width="344px" />

Still no results and i received a syntax error when I added AutoPostBack="true"

 <asp:TextBox ID="COMMENT_BOX" Name="COMMENT_BOX" runat="server" Enabled="true" OnTextChanged="_TextChanged" Height="24px" Width="344px" AutoPostBack="true"/>

 type in some text and 'tab' away from the textbox or click, say, another button...

Hi,

Please post here the error you are getting..

Thanks

....if all you're doing is saving text into the database then you would rather simply keep a button there and fire its click event and save...so that most of your code is already working.

...textchanged works for me though.....remember textchanged might cause multiple postbacks every time the text changes and normally one would try to avoid re-loading a complete page all the time or saving information into the database repeatedly like this.

 Well.. I don't have a choice here.. My boss wants me to save the information when it is written, without hitting an add button.. so I gotta do this

set  AutoPostBack="True" for your textbox. and try to clear your textbox in post back

page_load()

if  not ispostback then

else

better clear textbox  here

endif

Could u post your .aspx and CS code here..?

Thanks

Ratheesh

 this is fine just copy and past this:

<asp:TextBox ID="COMMENT_BOX" Name="COMMENT_BOX" runat="server" Enabled="true" OnTextChanged="_TextChanged" Height="24px" Width="344px" AutoPostBack="true" /> 

Also the textchange event will work only when you tab out, so say you are writing something in your textbox and your press tab then your textchanged event would hit

So in your case you should look at some async saving methods to save into your db

 I tried that already and it didn't work and i also recieved a syntax error...

I tested that line and it does not throws any syntax errors. please check may be there are some other errors on your page