I need help with text fields in SQL Server.....<BR><BR>First off, how do I insert them? I'm doing the following:<BR><BR>1. Create new row in dataTable<BR>2. Edit and add new row to dataTable<BR>3. Create commandBuilder<BR>4. Run dataAdapter to update SQL Server.<BR><BR>Is that okay? I'm worried that the long text in my text boxes don't actually "make it" to SQL Server because all I see in SQL Server is <Long Text>.<BR><BR>2. How do I display the text in my textBoxes when I want to retrieve them? I do the following:<BR><BR>1. Search for dataRow by doing:<BR>dataRow = dataTable.Rows.Find(object);<BR>2. Display the text by:<BR>this.txtBox.Text = dataRow["column"].ToString();<BR><BR>But then I see <Long Text> again. Can someone please help me? I have a client that needs the solution quick....thank you thank you.