Dim LeiBie As Boolean=True
Dim sql As String=Insert Into [books] (leibie) values ('" & Leibie & "') 数据库中[leibie]字段为boolean
上面的Sql语句有什么错误呢?
解决方案 »
- 紧急呼救, 大家来帮帮忙吧
- 在后台cs文件中定义的变量怎么在前台的aspx代码中不能由<%%>取到呢
- 如何控制在repeater中的button
- ------简繁体同时共存的问题(系统是繁体的),请高手指导,谢谢!
- 问一个简单的字符串的问题~~~~~~~~~~`
- 一个datatable里有10个字段,绑到datagrid时,让它只显示其中5个(其余的另有别的用处),应该怎么处理啊,不要在datagrid里加隐藏列
- 页面变为空白?
- asp.net2.0的问题
- 判断用户名重复的问题??
- Access数据库只能读,不能写,为何?>:(
- 有没有办法可以实现控制台程序和asp.net Web应用程序的交互呢?
- javascript在aspx文件中奇怪的问题?
在数据库中是:是/否,请帮助我
存入0代表否,存入1代表是.
不就是布尔型的了.
Dim ConnStr As String = ConfigurationSettings.AppSettings("ConnectionString")
Dim Conn As New OleDb.OleDbConnection(ConnStr)
Conn.Open() Dim LB As Boolean
If RadioButtonList2.SelectedItem.Value <= 3 Then
LB = True
Else
LB = False
End If Dim Sql As String = "INSERT INTO [STUDENTS] (xjId,stuNAME,SEX,BIRTH,ADDRESS,rxDate,byDate,zhuanye,nianjiduan,lb) VALUES ('" & 200701290001 & "','" & TextBox1.Text & "','" & RadioButtonList1.SelectedItem.Text & "','" & birth.Text & "','" & TextBox2.Text & "','" & rxday.Text & "','" & byday.Text & "','" & DropDownList1.SelectedItem.Text & "','" & RadioButtonList2.SelectedItem.Value & "',lb)"
Dim Cmd As New OleDb.OleDbCommand(Sql, Conn) Try
Cmd.ExecuteNonQuery()
Conn.Close()
Response.Write("成功")
Catch ex As Exception
Conn.Close()
Response.Write("失败")
End Try