DataSet插入数据

来源:互联网 发布:unity3d 5.6.2破解版 编辑:程序博客网 时间:2024/05/15 06:08

DataSet插入数据

SqlDataAdaptersda=new SqlDataAdapter(a,con);

sda.Fill(ds,"users");

  SqlCommandBuilderscb=  new SqlCommandBuilder(sda);

  DataRowdr=ds.Tables["users"].NewRow();

  dr["name"]="aa";

  dr["pass"]="aa";

  ds.Tables["users"].Rows.Add(dr);

  sda.Update(ds,"users");

Dataset在数据改变时候并不会产生sql语句,所以要使用SqlCommandBuilder ,当单个表的数据改变时自动产生sql语句

<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<FONT face="宋体">
<asp:Button id="Button1" style="Z-INDEX: 101; LEFT: 256px; POSITION: absolute; TOP: 96px" runat="server"
Text="Button" Width="104px" Height="40px"></asp:Button></FONT>
</form>
<%
 while(dr.Read())
 {
%>
<%=dr["name"]%>
<%=dr["pass"]%>
<br>
<%
 }
%>
</body>

nds.Tables["users"].Rows[1].Delete();
nsda.Update(ds,"users");





0 0
原创粉丝点击