textbox换行问题 我在MultiLine模式的textbox里面添加文本,是换行的,但在sql server中读出数据的时候,系统将换行符转换为空格,请问怎么处理?数据库中保存的数据类型为ntext. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 在vb中dim text1 as string=text1.texttext1=text1.replace("'","''")text1=text1.replace(" "," ")text1=text1.replace(chr(10) & chr(13),"<br>")在c#中String text1=text1.Text;text1=text1.Replace("'","''");text1=text1.Replace(" "," ");text1=text1.Replace(\r\n,"<br>"); Dim MyConnection As SqlConnection Dim MyCommand As SqlCommand Dim sCmd As String Dim sText As String = txtDemo.Text sText = sText.Replace("'", "''") sText = sText.Replace(" ", " ") sText = sText.Replace(Chr(10) & Chr(13), "<br>") Dim sUser As String = txtUser.Text Dim sTitle As String = txtTitle.Text Dim sTime As DateTime = labTime.Text sCmd = "insert into LessonTab(UserId,LessonTime,LessonTitle,LessonDemo)values(@iUser," sCmd = sCmd + "@iTime,@iTitle,@iText)" MyConnection = New SqlConnection MyConnection.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings("dsn") MyConnection.Open() MyCommand = New SqlCommand(sCmd, MyConnection) MyCommand.Parameters.Add(New SqlClient.SqlParameter("@iUser", sUser)) MyCommand.Parameters.Add(New SqlClient.SqlParameter("@iTitle", sTitle)) MyCommand.Parameters.Add(New SqlClient.SqlParameter("@iTime", sTime)) MyCommand.Parameters.Add(New SqlClient.SqlParameter("@IText", sText)) MyCommand.ExecuteScalar()我按照你的方法,还是不行 在vb中dim text1 as string=text1.texttext1=text1.replace("'","''")text1=text1.replace(" "," ")text1=text1.replace(chr(10) & chr(13),"<br>")在c#中String text1=text1.Text;text1=text1.Replace("'","''");text1=text1.Replace(" "," ");text1=text1.Replace(\r\n,"<br>"); 谢谢代码工人,我看了一下,保存在数据库中数据是正确的。估计是我在datalist中的显示问题。 直接写成属性就可以,写成类就不可以 ASP.NET2.0 ReportViewer会话已过期。 int?到底是个什么类型??跟int类型又有什么区别呢? 搞不明白的怪异脚本问题? 动网论坛谁装过 有关WebService安装部署的问题,请高手进来,谢谢! asp.net 验证表单 服务器控件 sp业务的几个不懂之处 DataList自动增长,覆盖下面控件,应该如何解决 请指教 谢谢 上传文件的时候,弹出要求登陆密码的对话框? DataGrid显示问题,研究一夜未果。 asp.net 字体问题
dim text1 as string=text1.text
text1=text1.replace("'","''")
text1=text1.replace(" "," ")
text1=text1.replace(chr(10) & chr(13),"<br>")
在c#中
String text1=text1.Text;
text1=text1.Replace("'","''");
text1=text1.Replace(" "," ");
text1=text1.Replace(\r\n,"<br>");
Dim MyCommand As SqlCommand
Dim sCmd As String
Dim sText As String = txtDemo.Text
sText = sText.Replace("'", "''")
sText = sText.Replace(" ", " ")
sText = sText.Replace(Chr(10) & Chr(13), "<br>")
Dim sUser As String = txtUser.Text
Dim sTitle As String = txtTitle.Text
Dim sTime As DateTime = labTime.Text sCmd = "insert into LessonTab(UserId,LessonTime,LessonTitle,LessonDemo)values(@iUser,"
sCmd = sCmd + "@iTime,@iTitle,@iText)"
MyConnection = New SqlConnection
MyConnection.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings("dsn")
MyConnection.Open()
MyCommand = New SqlCommand(sCmd, MyConnection)
MyCommand.Parameters.Add(New SqlClient.SqlParameter("@iUser", sUser))
MyCommand.Parameters.Add(New SqlClient.SqlParameter("@iTitle", sTitle))
MyCommand.Parameters.Add(New SqlClient.SqlParameter("@iTime", sTime))
MyCommand.Parameters.Add(New SqlClient.SqlParameter("@IText", sText)) MyCommand.ExecuteScalar()我按照你的方法,还是不行
dim text1 as string=text1.text
text1=text1.replace("'","''")
text1=text1.replace(" "," ")
text1=text1.replace(chr(10) & chr(13),"<br>")
在c#中
String text1=text1.Text;
text1=text1.Replace("'","''");
text1=text1.Replace(" "," ");
text1=text1.Replace(\r\n,"<br>");