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>