dim myConnection2 as new sqlConnection("data source=.;Initial catalog=Email;Uid=sa;PWD=")
dim myCommand2 as sqlCommand
dim qry2 as string
myConnection2.openqry2="insert into email(s_email,d_email,subject,content,email_flag,sendtime,att_flag)"& _
"values('"&session("username") & _
"','"& receive.text & _
"','"& subject.text & _
"','"& content.text & _
"','"& "1" & _
"','"& now() & _
"','"& "0"&"')"
myCommand2=new sqlClient.sqlCommand(qry2,myConnection2)
myCommand2.executeNonQuery()为什么报错异常详细信息: System.Data.SqlClient.SqlException: 第 1 行: 'jjj' 附近有语法错误。源错误:
行 151:"','"& "0"&"')"
行 152:myCommand2=new sqlClient.sqlCommand(qry2,myConnection2)
行 153:myCommand2.executeNonQuery()
行 154:response.Redirect("sendmail_success.aspx?receive=" &receive.text)
行 155:end sub
dim myCommand2 as sqlCommand
dim qry2 as string
myConnection2.openqry2="insert into email(s_email,d_email,subject,content,email_flag,sendtime,att_flag)"& _
"values('"&session("username") & _
"','"& receive.text & _
"','"& subject.text & _
"','"& content.text & _
"','"& "1" & _
"','"& now() & _
"','"& "0"&"')"
myCommand2=new sqlClient.sqlCommand(qry2,myConnection2)
myCommand2.executeNonQuery()为什么报错异常详细信息: System.Data.SqlClient.SqlException: 第 1 行: 'jjj' 附近有语法错误。源错误:
行 151:"','"& "0"&"')"
行 152:myCommand2=new sqlClient.sqlCommand(qry2,myConnection2)
行 153:myCommand2.executeNonQuery()
行 154:response.Redirect("sendmail_success.aspx?receive=" &receive.text)
行 155:end sub
解决方案 »
- 空间命名与不命名的区别或好处
- GridView 导出EXCEL 问题
- 怪现象,找了几个小时,愣是找不出原因....
- 我想实现用javascript来判断服务器端一个文本控件输入的值长度是否大于10个字,怎么写?????
- 关于用detailview插入!!!
- 怎样理解票据(FormsAuthenticationTicket)?到底是怎么一回事?
- 利用XML取web.config中的值问题
- 论坛开发的问题:是直接做前台开发还是先做后台管理程序?
- 【笨笨问题集锦四:一个绑定数据的问题】
- 有用OpenFlashChart开发过折线图的朋友吗
- 前两天好好的,突然断点调试速度变得好慢???
- 怎样做到像CSDN的短消息的效果呢?
1.数据库连接错误,看看这个有没有误data source=.
2.仔细检查一下你的SQL语句,可能有误,若你实在检查不出来的话,可以用
try语句来检查异常处理,可能是你你的SQL语句错误了。
Catch{}来检查一下异常啊,也可用输出语句把SQL语句输出啊
Dim myConnection2 As New sqlConnection("data source=.;Initial catalog=Email;Uid=sa;PWD=")
Dim myCommand2 As sqlCommand
Dim qry2 As String
myConnection2.open()
qry2 = "insert into email(s_email,d_email,subject,content,email_flag,sendtime,att_flag)" & _
"values('" & Session("username") & _
"','" & receive.text & _
"','" & subject.text & _
"','" & content.text & _
"','" & "1" & _
"','" & Now() & _
"','" & "0" & "')"
myCommand2 = New SqlClient.SqlCommand(qry2, myConnection2)
catch
myCommand2.executeNonQuery(System.Exception.ee)
End Try End Sub
要不用断点调试下也可以,慢慢来吧!再见!