大家帮忙看看这个SqlDataAdapter怎么会出现这个问题
- VB.NET code
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim myDS As New DataSet Dim TitleTable As DataTable Dim TitleRow As DataRow Dim connStr As String connStr = "server=(local);uid=sa;pwd=123456;database=pubs" Dim SQLSelect As String SQLSelect = "select * from titles" Dim mySQLconn As New SqlConnection(connStr) mySQLconn.Open() Dim mysqlda As New SqlDataAdapter(SQLSelect, connStr) Dim mysqlcb As New SqlCommandBuilder(mysqlda) myDS.ReadXmlSchema(Server.MapPath("AddTitle.xsd")) Try If IsPostBack Then TitleTable = myDS.Tables(0) TitleRow = TitleTable.NewRow() TitleRow("Title_id") = TextBox1.Text TitleRow("title") = TextBox2.Text TitleRow("type") = TextBox3.Text TitleRow("pub_id") = TextBox4.Text TitleRow("price") = CDbl(TextBox5.Text) TitleRow("advance") = CDbl(TextBox6.Text) TitleRow("royalty") = CInt(TextBox7.Text) TitleRow("ytd_sales") = CInt(TextBox8.Text) TitleRow("notes") = TextBox9.Text TitleRow("pubdate") = CDate(TextBox10.Text) TitleTable.Rows.Add(TitleRow) mysqlda.Update(myDS) mySQLconn.Close() DataGrid1.DataSource = myDS.Tables(0).DefaultView DataGrid1.DataBind() Response.Write("添加成功") End If Catch ex As Exception Response.Write(ex.ToString) End Try End SubUpdate unable to find TableMapping['Table'] or DataTable 'Table'. at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable) at System.Data.Common.DbDataAdapter.Update(DataSet dataSet) at WebfirstVB.WebForm3.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\WebfirstVB\WebForm3.aspx.vb:line 71
这个是什么错误 有没有人知道
[解决办法]
告诉我们你的目的是干嘛的.或许可以换种方法去解决!
[解决办法]
能详细说一下,在哪一句出的错?
[解决办法]
sql语句的问题,你插入的目的表没有找到,断点检查sql语句
[解决办法]
都是很好的建议! 值得学习