form id="form1" runat="server">
<div></div>
姓名:<asp:TextBox ID="name" runat="server"></asp:TextBox><br /><br />
性别:<asp:RadioButton ID="male" runat="server" GroupName="group" OnCheckedChanged="male_CheckedChanged"/>男
<asp:RadioButton ID="female" runat="server" GroupName="group" OnCheckedChanged="female_CheckedChanged"/>女<br /><br />
班级:<asp:DropDownList ID="amd" runat="server" AutoPostBack="true" OnSelectedIndexChanged="amd_SelectedIndexChanged">
<asp:ListItem Value="001">001</asp:ListItem>
<asp:ListItem Value="002">002</asp:ListItem>
<asp:ListItem Value="003">003</asp:ListItem>
</asp:DropDownList><br />
<br />
<asp:DataGrid ID="mydatagrid1" Width="100" runat="server"></asp:DataGrid>
<br /><br />
出生日期:<asp:TextBox ID="uvw" runat="server" ></asp:TextBox>
<asp:TextBox ID="nmd" Text="1987-05-06" runat="server"></asp:TextBox>
<asp:CompareValidator ID="yz" runat="server" Type="Date" Operator="DataTypeCheck" ControlToValidate="uvw" ControlToCompare="nmd" ErrorMessage="错误信息">输入错误,请重新输入!</asp:CompareValidator> <br /><br />
课程:<asp:DropDownList ID="DropDownList1" AutoPostBack="true" runat="server" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
<asp:ListItem Text="A1">A1</asp:ListItem>
<asp:ListItem Text="A2">A2</asp:ListItem>
<asp:ListItem Text="A3">A3</asp:ListItem>
</asp:DropDownList>
<br /><br />
<asp:DataGrid ID="mydatagrid" runat="server" Width="150" BackColor="white" BorderColor="black" ShowFooter="false" CellPadding="3" CellSpacing="0">
</asp:DataGrid><br /><br />
学籍编号:<asp:TextBox ID="abc" runat="server"></asp:TextBox>
<asp:Label ID="lmn" runat="server"></asp:Label><br /><br />
<asp:Button ID="zyz" Text="添加" OnClick="btn_click" OnClientClick="msg()" runat="server" />
<asp:Button ID="opq" Text="修改" OnClick="opq_click" runat="server" />
<asp:Button ID="rst" Text="删除" OnClick="rst_click" runat="server" />
</form>
public partial class _Default : System.Web.UI.Page
{
protected void Page_load(object sender, EventArgs e)
{
}
protected void male_CheckedChanged(object sender, EventArgs e)
{
}
protected void female_CheckedChanged(object sender, EventArgs e)
{
}
protected void btn_click(object sender, EventArgs e)
{
SqlConnection wd = new SqlConnection("Server=(local)\\SQLEXPRESS;database=test;user id=sa;password=mao123456");
wd.Open();
if (male.Checked)
{
SqlDataAdapter myCommand = new SqlDataAdapter("insert into student( userid,username,studydate,sex,classid,lesson) values('" + abc.Text + "','" + name.Text + "','" + uvw.Text + "','1','" + amd.SelectedValue + "','" + DropDownList1.SelectedValue + "') ", wd);
DataSet ds = new DataSet();
myCommand.Fill(ds, "student");
}
if (female.Checked)
{
SqlDataAdapter myCommand = new SqlDataAdapter("insert into student( userid,username,studydate,sex,classid,lesson) values('" + abc.Text + "','" + name.Text + "','" + uvw.Text + "','0','" + amd.SelectedValue + "','" + DropDownList1.SelectedValue + "') ", wd);
DataSet ds = new DataSet();
myCommand.Fill(ds, "student");
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
string lesson = DropDownList1.SelectedValue;
SqlConnection myConnection=new SqlConnection("server=(local)\\SQLEXPRESS;database=test; user id=sa;password=mao123456;");
myConnection.Open();
SqlDataAdapter myCommand=new SqlDataAdapter("select lesson,subject from lesson where lesson='"+ lesson +"' ",myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds,"lesson");
mydatagrid.DataSource = ds.Tables["lesson"].DefaultView;
mydatagrid.DataBind();
}
protected void rst_click(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection("server=(local)\\SQLEXPRESS;database=test;user id=sa;password=mao123456");
cn.Open();
SqlDataAdapter myCommand = new SqlDataAdapter("delete from student where userid='" + abc.Text + "'", cn);
DataSet ds = new DataSet();
myCommand.Fill(ds, "student");
}
//protected void uvw_TextChanged(object sender, EventArgs e)
//{ //}
//protected void abc_TextChanged(object sender, EventArgs e)
//{ //}
protected void opq_click(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection("server=(local)\\SQLEXPRESS;database=test;user id=sa;password=mao123456;");
cn.Open();
if (male.Checked)
{
SqlDataAdapter myCommand = new SqlDataAdapter("update student set username='" + name.Text + "',studydate='" + uvw.Text + "',sex='1',classid='" + amd.SelectedValue + "' where userid='" + abc.Text + "'", cn);
DataSet ds = new DataSet();
myCommand.Fill(ds, "student");
}
if (female.Checked)
{
SqlDataAdapter myCommand = new SqlDataAdapter("update student set username='" + name.Text + "',studydate='" + uvw.Text + "',sex='0',classid='" + amd.SelectedValue + "' where userid='" + abc.Text + "'", cn);
DataSet ds=new DataSet();
myCommand.Fill(ds, "student");
}
}
protected void amd_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection myConnection =new SqlConnection("server=(local)\\SQLEXPRESS;database=test;user id=sa;password=mao123456;");
myConnection.Open();
SqlDataAdapter myCommand = new SqlDataAdapter("select classid,classname from class1 where classid='" + amd.SelectedValue + "'",myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "class1");
mydatagrid1.DataSource = ds.Tables["class1"].DefaultView;
mydatagrid1.DataBind();
}
}
要求是:
编写一个简单复合表的维护页面
数据库:test 请对表student 做增加,修改,删除的页面
表关联:class.classid=student.class
lesson.lesson=student.lesson
界面要求:
性别:单选框(男,女)
班级:下拉框
出生日期:文本框,I要效验日期,并能选择日期?
课程:下拉框,显示课程组合名,并在旁边显示此组合有哪些具体的课程
删除时要有提示:是否删除,如果选择否,则不删除,返回原界面。?
学籍:是关键字段,唯一性,修改时只显示,不能修改,增加时如果有相同的学籍,要提示有重复项,不能保存。
<div></div>
姓名:<asp:TextBox ID="name" runat="server"></asp:TextBox><br /><br />
性别:<asp:RadioButton ID="male" runat="server" GroupName="group" OnCheckedChanged="male_CheckedChanged"/>男
<asp:RadioButton ID="female" runat="server" GroupName="group" OnCheckedChanged="female_CheckedChanged"/>女<br /><br />
班级:<asp:DropDownList ID="amd" runat="server" AutoPostBack="true" OnSelectedIndexChanged="amd_SelectedIndexChanged">
<asp:ListItem Value="001">001</asp:ListItem>
<asp:ListItem Value="002">002</asp:ListItem>
<asp:ListItem Value="003">003</asp:ListItem>
</asp:DropDownList><br />
<br />
<asp:DataGrid ID="mydatagrid1" Width="100" runat="server"></asp:DataGrid>
<br /><br />
出生日期:<asp:TextBox ID="uvw" runat="server" ></asp:TextBox>
<asp:TextBox ID="nmd" Text="1987-05-06" runat="server"></asp:TextBox>
<asp:CompareValidator ID="yz" runat="server" Type="Date" Operator="DataTypeCheck" ControlToValidate="uvw" ControlToCompare="nmd" ErrorMessage="错误信息">输入错误,请重新输入!</asp:CompareValidator> <br /><br />
课程:<asp:DropDownList ID="DropDownList1" AutoPostBack="true" runat="server" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
<asp:ListItem Text="A1">A1</asp:ListItem>
<asp:ListItem Text="A2">A2</asp:ListItem>
<asp:ListItem Text="A3">A3</asp:ListItem>
</asp:DropDownList>
<br /><br />
<asp:DataGrid ID="mydatagrid" runat="server" Width="150" BackColor="white" BorderColor="black" ShowFooter="false" CellPadding="3" CellSpacing="0">
</asp:DataGrid><br /><br />
学籍编号:<asp:TextBox ID="abc" runat="server"></asp:TextBox>
<asp:Label ID="lmn" runat="server"></asp:Label><br /><br />
<asp:Button ID="zyz" Text="添加" OnClick="btn_click" OnClientClick="msg()" runat="server" />
<asp:Button ID="opq" Text="修改" OnClick="opq_click" runat="server" />
<asp:Button ID="rst" Text="删除" OnClick="rst_click" runat="server" />
</form>
public partial class _Default : System.Web.UI.Page
{
protected void Page_load(object sender, EventArgs e)
{
}
protected void male_CheckedChanged(object sender, EventArgs e)
{
}
protected void female_CheckedChanged(object sender, EventArgs e)
{
}
protected void btn_click(object sender, EventArgs e)
{
SqlConnection wd = new SqlConnection("Server=(local)\\SQLEXPRESS;database=test;user id=sa;password=mao123456");
wd.Open();
if (male.Checked)
{
SqlDataAdapter myCommand = new SqlDataAdapter("insert into student( userid,username,studydate,sex,classid,lesson) values('" + abc.Text + "','" + name.Text + "','" + uvw.Text + "','1','" + amd.SelectedValue + "','" + DropDownList1.SelectedValue + "') ", wd);
DataSet ds = new DataSet();
myCommand.Fill(ds, "student");
}
if (female.Checked)
{
SqlDataAdapter myCommand = new SqlDataAdapter("insert into student( userid,username,studydate,sex,classid,lesson) values('" + abc.Text + "','" + name.Text + "','" + uvw.Text + "','0','" + amd.SelectedValue + "','" + DropDownList1.SelectedValue + "') ", wd);
DataSet ds = new DataSet();
myCommand.Fill(ds, "student");
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
string lesson = DropDownList1.SelectedValue;
SqlConnection myConnection=new SqlConnection("server=(local)\\SQLEXPRESS;database=test; user id=sa;password=mao123456;");
myConnection.Open();
SqlDataAdapter myCommand=new SqlDataAdapter("select lesson,subject from lesson where lesson='"+ lesson +"' ",myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds,"lesson");
mydatagrid.DataSource = ds.Tables["lesson"].DefaultView;
mydatagrid.DataBind();
}
protected void rst_click(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection("server=(local)\\SQLEXPRESS;database=test;user id=sa;password=mao123456");
cn.Open();
SqlDataAdapter myCommand = new SqlDataAdapter("delete from student where userid='" + abc.Text + "'", cn);
DataSet ds = new DataSet();
myCommand.Fill(ds, "student");
}
//protected void uvw_TextChanged(object sender, EventArgs e)
//{ //}
//protected void abc_TextChanged(object sender, EventArgs e)
//{ //}
protected void opq_click(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection("server=(local)\\SQLEXPRESS;database=test;user id=sa;password=mao123456;");
cn.Open();
if (male.Checked)
{
SqlDataAdapter myCommand = new SqlDataAdapter("update student set username='" + name.Text + "',studydate='" + uvw.Text + "',sex='1',classid='" + amd.SelectedValue + "' where userid='" + abc.Text + "'", cn);
DataSet ds = new DataSet();
myCommand.Fill(ds, "student");
}
if (female.Checked)
{
SqlDataAdapter myCommand = new SqlDataAdapter("update student set username='" + name.Text + "',studydate='" + uvw.Text + "',sex='0',classid='" + amd.SelectedValue + "' where userid='" + abc.Text + "'", cn);
DataSet ds=new DataSet();
myCommand.Fill(ds, "student");
}
}
protected void amd_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection myConnection =new SqlConnection("server=(local)\\SQLEXPRESS;database=test;user id=sa;password=mao123456;");
myConnection.Open();
SqlDataAdapter myCommand = new SqlDataAdapter("select classid,classname from class1 where classid='" + amd.SelectedValue + "'",myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "class1");
mydatagrid1.DataSource = ds.Tables["class1"].DefaultView;
mydatagrid1.DataBind();
}
}
要求是:
编写一个简单复合表的维护页面
数据库:test 请对表student 做增加,修改,删除的页面
表关联:class.classid=student.class
lesson.lesson=student.lesson
界面要求:
性别:单选框(男,女)
班级:下拉框
出生日期:文本框,I要效验日期,并能选择日期?
课程:下拉框,显示课程组合名,并在旁边显示此组合有哪些具体的课程
删除时要有提示:是否删除,如果选择否,则不删除,返回原界面。?
学籍:是关键字段,唯一性,修改时只显示,不能修改,增加时如果有相同的学籍,要提示有重复项,不能保存。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货