表1:student 截图如下:表2:course 截图如下:(此时这样建表只是为了演示连接SQL语句,当然实际开发中我们不会这样建表,实际开发中这两个表会有自己不同的主键。)一、外连接外连接可分为:左连接、右连接、完全外连接。1、左连接 left join 或 left outer joinSQL语句…
错误页 <script language="javascript" type="text/javascript"> var i = 5; var intervalid; intervalid = setInterval("fun()", 1000); function fun() { ...
发送邮件Xiaobin.Utility.Tool.SendMail("邮件标题", "邮件内容", "收件人", "发件人", "发件用户名", "发件密码", "smtp.qq.com");Utility.Tool.Alert("密码已经发送到您的邮箱中,请注意查收。…
上传文件 try{string proimg = Utility.Tool.Upload(fuimg, new string[] { ".jpg",".png",".gif",".bmp" }, 1, Server.MapPath("/upload/")); imgYL.ImageUrl = "/upload/" +...
递归绑定ddl private void BindDDLCA() //在Page_load中加上 { ddlca.Items.Clear(); ddlca.Items.Insert(0, new ListItem("请选择分类...", "0")); List<Model.Category&g...
Page_Load中获取CheckBoxList值ListItem li = radsex.Items.FindByValue(model.sex.ToString());if (li != null){li.Selected = true;}Page_Load中获取DropDownList值li = ddlprovince.Items.FindByValue(model.province);ddlprovince.ClearSelec...
1、导入jQuery.js代码<asp:TextBox ID="txtname" onblur="checkUsername(this.value);" class="txt" runat="server"></asp:TextBox><br /><span id="mes_username" s...
//判断用户名if (!Regex.IsMatch(name, @"^[a-zA-Z0-9]{6,20}$")){Utility.Tool.Alert("用户名长度必须大于6个字符小于20个字符", this.Page);return;}
<webdiyer:AspNetPager ID="anp" runat="server" CssClass="pages" CurrentPageButtonClass="cpb" CustomInfoHTML="总共%RecordCount%条记录,当前为%CurrentPageIndex%/%PageCount%页"...
alter table test_table add id int identity primary key