Save the data entered in the multiline textbox as
VB.NET
..
cmd.Parameters.Add(new SqlParameter('@Notes' ,SqlDbType.NVarChar ))
cmd.Parameters ('@Notes').Value ='<pre>' + TextBox1.Text + '</pre>'
....
cn.Open()
cmd.ExecuteNonQuery()
C#
...
cmd.Parameters.Add(new SqlParameter('@Notes' ,SqlDbType.NVarChar ));
cmd.Parameters ['@Notes'].Value ='<pre>' + TextBox1.Text + '</pre>';
....
cn.Open();
cmd.ExecuteNonQuery();
To retrieve the Data
VB.NET
Response.Write (ds.Tables(0).Rows(0)('Notes').ToString ())
C#
Response.Write (ds.Tables[0].Rows[0]['Notes'].ToString ());
Share with