databinding propoerty of textbox control

Hi
It is not possible to represent your entire database column in one text box line. I always prefer unbound database connectivity as it provides greater flexibility and reduce load on the server computer. Still, if you insist upon using the bound control then I would suggest you to go for BindingNavigator or DataGridView. Explore the possibilities of using BindingNavigator it is quite interesting if you are new to database handling.

Bound controls provide you a control in the user interface which is directly connected to your database. As a result of this whenever you make any change to value of the controls(say, you change the Name of a person in a DataGridView control) the change is reflected in the main database itself. To make these changes happen you need not write any extra code. While unbound controls establishes connection to the database only when needed. So any change made at the front end does not reflect in the database. You need to write down separate code for that. The facility of unbound control is that your are not constantly connected to your database which reduces the pressure on the server. Further you can interact with the database any way you want every time.

Though bound controls are easier and quicker to create, unbound controls serve better.


Ritwesh.

try this code for binding to database and insert into it:

SqlConnection conn = new SqlConnection();
            conn.ConnectionString = ConfigurationManager.ConnectionStrings["Your ConnectionString name"].ConnectionString;
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            conn.Open();
            try
            {
                cmd.CommandText = "Insert into [Database Name] values([your Field Name that you want to insert from Textbox])";
                cmd.Parameters.Add("@Your FieldName", SqlDbType.VarChar).Value = textbox1.Text;
                cmd.ExecuteNonQuery();
            }
            catch (SqlException se)
            {
               Page.Title = "Exception :" + ex.Message;
            }
            finally
            {
                    conn.Close();
            }