System.Data.SqlClient.SqlException: 第 1 行: '' 附近有语法错误。

[liuwaiqiang1981]

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

If Not IsPostBack Then
Dim tbname As String = Session("dtname")
conn = New SqlConnection("server=localhost;database=cjglxt;uid='sa';pwd='lwqyll1353'")
sqldap = New SqlDataAdapter("select * from '" + tbname + "'", conn)
ds = New DataSet
sqldap.Fill(ds, "dtchengji")
Session("MyData") = ds.Tables("dtchengji")
Else
dtchengji = Session("mydata")
End If
End Sub

运行时提示：System.Data.SqlClient.SqlException: 第 1 行: '' 附近有语法错误。错误。

另外：我想实现：运行时创建一个datatable ，往里面添加数据。然后点击保存按钮时，把datatable里面的所有数据存在数据库里面。请问我这样做行不行：
Private Sub Btnext_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Btnext.Click －－－－－往数据表里面添加数据

dtchengji = CType(Session("mydata"), DataTable)
rows = dtchengji.NewRow
rows.Item("banji") = ddlnianji.SelectedItem.Value.ToString & "." & ddlbanji.SelectedItem.Value.ToString
rows.Item("xuehao") = CLng(Txuehao.Text)
rows.Item("xingming") = Txingming.Text
rows.Item("chengji") = CDec(Tchengji.Text)
dtchengji.Rows.Add(rows)
dtchengji.AcceptChanges()

Session("mydata") = dtchengji
Txuehao.Text = CStr(CLng(Txuehao.Text) + 1)
End Sub

Private Sub btsave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btsave.Click －－－－－－往数据库里面倒的数据

Dim commandstr As New SqlCommandBuilder(sqldap)
sqldap.insertCommand = commandstr.insertCommand
sqldap.Update(ds, "dtchengji")
End Sub

[brightheroes]

("server=localhost;database=cjglxt;uid='sa';pwd='lwqyll1353'")
－－－》

("server=localhost;database=cjglxt;uid=sa;pwd=lwqyll1353")

[liuwaiqiang1981]

楼主，不是那的错误！
照你的改还是不好使。我把sqldap = New SqlDataAdapter("select * from '" + tbname + "'", conn)
中的tbname变量变成具体数据表名好使

[Overriding]

sqldap = New SqlDataAdapter("select * from '" + tbname + "'", ---->
sqldap = New SqlDataAdapter("select * from " + tbname ", cnn)

[Overriding]

sorry !

sqldap = New SqlDataAdapter("select * from '" + tbname + "'", ---->
sqldap = New SqlDataAdapter("select * from " + tbname , cnn)

[Overriding]

你的数据库连接字符串确实有问题！应该改！

[liuwaiqiang1981]

不好使啊

[liuwaiqiang1981]

我改了，不好使！郁闷我一天了！完全按照楼主们的说法改的

[liuwaiqiang1981]

已经解决。谢谢各位！我数据库的名字是中文。
sql可能不支持中文。所以出错

[jin_xiaolu2000]

这个。。。。。。

[coldpanth]

昏