大家帮忙看看这个SqlDataAdapter怎么会出现这个问题
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 Sub