6、删除“08040004”的用户的记录
<%
@
Page Language="C#" Debug="true" %>
<%
@
Import Namespace="System.Data" %>
<%
@
Import Namespace="System.Data.SqlClient"%>
<
html
xmlns="http://www.w3.org/1999/xhtml" >
<
script
language="C#" runat=server>
//
查询表student
void page_load(object serder, EventArgs e)
{
SqlConnection sqlcon = new SqlConnection("Data Source=localhost;uid=sa;pwd=123456;Initial Catalog=master");
SqlCommand sqlcomm=new SqlCommand();
DataSet ds=new DataSet();
sqlcon.Open();
sqlcomm.Connection=sqlcon;
sqlcomm.CommandText="delete from users where userid=08040004";
sqlcomm.ExecuteNonQuery();
sqlcomm=null;
labcontent.Text="
成功删除<br>"
;
SqlDataAdapter sqla=new SqlDataAdapter("select * from users",sqlcon );
sqla.Fill(ds, "tabre");
dg.DataSource=ds.Tables["tabre"].DefaultView;
dg.DataBind();
sqlcomm=null;
sqlcon.Close();
}
</script>
<head runat="server">
<title>
学生表查询</title>
</
head
>
<
body
>
<form id="form1" runat="server">
<asp:Label ID=labcontent runat=server></asp:Label>
<asp:Label ID=labcontent1 runat=server></asp:Label>
<asp:DataGrid ID=dg runat=server></asp:DataGrid><br />
</form>
</
body
>
</
html
>