asp.net添加记录不成功，求达人指点

Question

Dim selectstr As String
        Dim cnn As SqlConnection
        Dim sqldataset As DataSet
        Dim sqlc As SqlCommand
        Dim sqla As SqlDataAdapter
        Dim sqlb As SqlCommandBuilder        cnn = New SqlConnection
        sqldataset = New DataSet
        cnn.ConnectionString = ConfigurationSettings.AppSettings("ConnectionString")        selectstr = "SELECT timetext FROM timetab"
        sqlc = New SqlCommand(selectstr, cnn)
        sqla = New SqlDataAdapter        sqla.SelectCommand = sqlc
        sqlb = New SqlCommandBuilder(sqla)
        sqla.Fill(sqldataset)        sqldataset.Tables(0).Rows(0).Delete()
        sqla.Update(sqldataset)

Answer 1

myDataRow["name"] = TextBox1.Text;
myDataRow["pwd"] = TextBox2.Text;
myDataRow["age"] = TextBox4.Text;
myDataRow["email"] = TextBox5.Text;后面你忘了把数据行加入到数据表中，可以这样加：myDataSet.Table["worker"].Rows.Add(myDataRow);

Answer 2

再恰当的位置加上这几句
Dim sb As SqlCommandBuilder
sb = New SqlCommandBuilder(sqla)sqla.FillSchema()

Answer 3

Dim sb as?换个名字，会有人误会的

Answer 4

SqlCommandBuilderNew=new SqlCommandBuilder(myDataAdapter)
myDataAdapter.Update(myDataSet,"worker");

Answer 5

DotSharp(青幽客) 
答对了！！！

Answer 6

public static SqlDataAdapter CreateCustomerAdapter(SqlConnection conn)
{
  SqlDataAdapter da = new SqlDataAdapter();
  SqlCommand cmd;
  SqlParameter parm;  // Create the SelectCommand.  cmd = new SqlCommand("SELECT * FROM Customers " +
                       "WHERE Country = @Country AND City = @City", conn);  cmd.Parameters.Add("@Country", SqlDbType.NVarChar, 15);
  cmd.Parameters.Add("@City", SqlDbType.NVarChar, 15);  da.SelectCommand = cmd;  // Create the UpdateCommand.  cmd = new SqlCommand("UPDATE Customers SET CustomerID = @CustomerID, CompanyName = @CompanyName " +
                       "WHERE CustomerID = @oldCustomerID", conn);  cmd.Parameters.Add("@CustomerID", SqlDbType.NChar, 5, "CustomerID");
  cmd.Parameters.Add("@CompanyName", SqlDbType.NVarChar, 40, "CompanyName");  parm = cmd.Parameters.Add("@oldCustomerID", SqlDbType.NChar, 5, "CustomerID");
  parm.SourceVersion = DataRowVersion.Original;  da.UpdateCommand = cmd;  return da;
}