private void cmd_save_Click(object sender, System.EventArgs e)
{
    DataSet ds=(DataSet)Session["ds1"];
System.Data.DataRow dr=ds.Tables["Customers"].NewRow();//
dr.ItemArray[Convert.ToInt32("Customerid")]=this.txt_Customerid.Text;//
dr.ItemArray[Convert.ToInt32("Companyname")]=this.txt_Companyname.Text;
dr.ItemArray[Convert.ToInt32("Address")]=this.txt_Address.Text;
dr.ItemArray[Convert.ToInt32("Phone")]=this.txt_Phone.Text;
dr.ItemArray[Convert.ToInt32("Fax")]=this.txt_Fax.Text;
dr.ItemArray[Convert.ToInt32("Country")]=this.txt_Country.Text;
ds.Tables["Customers"].Rows.Add(dr);//
 SqlCommandBuilder builder=new SqlCommandBuilder(Session["ad1"]);
Session["ad1"].update(ds,"Customers");
}
C:\Inetpub\wwwroot\WebApplication1\WebForm2.aspx.cs(100): 参数“1” : 无法从“object”转换为“System.Data.SqlClient.SqlDataAdapter”
C:\Inetpub\wwwroot\WebApplication1\WebForm2.aspx.cs(100): 与“System.Data.SqlClient.SqlCommandBuilder.SqlCommandBuilder(System.Data.SqlClient.SqlDataAdapter)”最匹配的重载方法具有一些无效参数
C:\Inetpub\wwwroot\WebApplication1\WebForm2.aspx.cs(101): “object”并不包含对“update”的定义
 SqlCommandBuilder builder=new SqlCommandBuilder(Session["ad1"]);
Session["ad1"].update(ds,"Customers");

解决方案 »

  1.   

    这二句有问题: SqlCommandBuilder builder=new SqlCommandBuilder(Session["ad1"]);
    Session["ad1"].update(ds,"Customers");
      

  2.   

    SqlCommandBuilder builder=new SqlCommandBuilder(Session["ad1"]);
    Session["ad1"].update(ds,"Customers");改为SqlDataAdapter ad1=(SqlDataAdapter)Session["ad1"];
    SqlCommandBuilder builder=new SqlCommandBuilder(ad1);
    ad1.update(ds,"Customers");