专注收集记录技术开发学习笔记、技术难点、解决方案
网站信息搜索 >> 请输入关键词:
您当前的位置: 首页 > DotNet Exception

vb.net连接SQL出错:索引从0处开始

发布时间:2011-06-26 20:28:48 文章来源:www.iduyao.cn 采编人员:星星草

vb.net连接SQL出错

源程序如下:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
  Dim selectclause As String = "select *"
  dim fromclause As String = "from 站点信息"  '用于构成from子句
  Dim whereclause As String = ""
  If Not TextBox1.Text = "" Then
  whereclause += "and 站点名= " + "'" + TextBox1.Text + "'"
  End If
  If Not TextBox2.Text = "" Then
  whereclause += "and 地址= " + "'" + TextBox2.Text + "'"
  End If
  If Not TextBox3.Text = "" Then
  whereclause += "and 站点类型= " + "'" + TextBox3.Text + "'"
  End If

  Dim querystring As String = selectclause + fromclause + whereclause 
  Dim connectionstring As String = "user id="";initial catalog= 站点信息表;data source=localhost"
 
  Dim connection As New SqlConnection(connectionstring)”运行时这句总出错,说是'从索引0初开始,初始化字符串处理异常'“[/color]
  Dim dataadapter As New SqlDataAdapter
  dataadapter.SelectCommand = New SqlCommand(querystring, connection)

  Dim dataset As New DataSet

  Try
  connection.Open()
  dataadapter.Fill(dataset, "站点信息")
  DataGridView1.DataSource = dataset.Tables("站点信息")
  DataGridView1.Focus()

  Catch ex As Exception
  MsgBox(ex.Message)

  End Try

  connection.Close()


  End Sub


------解决方法--------------------------------------------------------
Dim querystring As String = selectclause + fromclause + whereclause

querystring 拼起来后里面确少必要的空格吧 你有没有DEBUG进去看下这个SQL啊?

比如  Dim selectclause As String = "select *"
  dim fromclause As String = "from 站点信息"
    

友情提示:
信息收集于互联网,如果您发现错误或造成侵权,请及时通知本站更正或删除,具体联系方式见页面底部联系我们,谢谢。

其他相似内容:

热门推荐: