web课堂代码文档格式.docx
- 文档编号:6799546
- 上传时间:2023-05-07
- 格式:DOCX
- 页数:70
- 大小:144.25KB
web课堂代码文档格式.docx
《web课堂代码文档格式.docx》由会员分享,可在线阅读,更多相关《web课堂代码文档格式.docx(70页珍藏版)》请在冰点文库上搜索。
///<
///insertdeleteupdate
paramname="
sql"
>
<
/param>
returns>
/returns>
publicstaticintExecuteNonQuery(stringsql)
{
SqlConnectionconn=newSqlConnection(connstr);
SqlCommandcomm=newSqlCommand(sql,conn);
conn.Open();
intret=comm.ExecuteNonQuery();
conn.Close();
returnret;
///select,表
publicstaticDataTableExecuteQuery(stringsql)
SqlDataAdapterda=newSqlDataAdapter(sql,conn);
DataSetds=newDataSet();
da.Fill(ds);
returnds.Tables[0];
///SELECT,只取结果中的第一行,第一列的值
publicstaticObjectExecuteScalar(stringsql)
objectret=comm.ExecuteScalar();
//null
}
JavaScript举例
!
DOCTYPEhtmlPUBLIC"
-//W3C//DTDXHTML1.0Transitional//EN"
"
http:
//www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"
htmlxmlns="
//www.w3.org/1999/xhtml"
head>
<
title>
/title>
scripttype="
text/javascript"
functioncloseme()
if(window.confirm("
你真的关闭吗?
"
))
window.close();
else{
window.location.hreg="
functionopenme()
window.open("
);
varleft=50;
vartop=50;
functionmove()
vardiv=window.document.getElementById("
smallwindows"
left+=1;
top+=1;
div.style.left=left;
div.style.top=top;
vart=setInterval(move,1000);
functionstop()
clearInterval(t);
/script>
/head>
body>
p>
inputid="
Button1"
type="
button"
value="
关闭"
onclick="
closeme()"
/>
input
id="
Button2"
打开"
openme()"
Button3"
停止"
stop()"
/p>
divid="
style="
position:
absolute;
left:
198px"
imgalt="
src="
images/logo.png"
/div>
/body>
/html>
新闻提交页面
div>
<
asp:
LabelID="
lbltitle"
runat="
server"
Text="
标题"
/asp:
Label>
TextBoxID="
txttitle"
Width="
426px"
TextBox>
br/>
content"
内容"
txtContent"
Height="
284px"
TextMode="
MultiLine"
429px"
ButtonID="
btnSave"
btnSave_Click"
提交"
protectedvoidbtnSave_Click(objectsender,EventArgse)
SqlConnectionconn=newSqlConnection("
database=webdb;
IntegratedSecurity=sspi"
stringsql="
insertintonews(newtitle,newcontent)values('
{0}'
'
{1}'
)"
sql=string.Format(sql,txttitle.Text,txtContent.Text);
SqlCommandcomm=newSqlCommand(sql,conn);
if(ret==1)
ScriptManager.RegisterClientScriptBlock(this,GetType(),"
aaa"
"
alert('
插入成功'
true);
else{}
显示新闻
protectedvoidPage_Load(objectsender,EventArgse)
select*fromnews"
SqlDataAdapterda=newSqlDataAdapter(sql,conn);
for(inti=0;
i<
ds.Tables[0].Rows.Count;
i++)
lblMsg.Text+="
ahref='
'
target='
_blank'
+ds.Tables[0].Rows[i]["
newstitle"
].ToString()+"
/a>
br/>
另一种写法
%@PageLanguage="
C#"
%>
%@ImportNamespace="
System.Data.SqlClient"
System.Data"
scriptrunat="
protectedvoidPage_Load(objectsender,EventArgse)
headrunat="
formid="
form1"
lblMsg"
/form>
TreeView导航
AutoEventWireup="
true"
CodeFile="
Default1026.aspx.cs"
Inherits="
Default1026"
%@RegisterSrc="
~/footer.ascx"
TagName="
footer"
TagPrefix="
myfooter"
~/header.ascx"
header"
myheader"
TreeView导航及自定控件<
myheader:
headerID="
header1"
/>
TreeViewID="
TreeView1"
TreeView>
MenuID="
Menu1"
Orientation="
Horizontal"
Menu>
myfooter:
footerID="
footer1"
footer2"
Menu控件
if(!
IsPostBack)
selectdepartmentnamefromdepartment"
DataTabledt=SqlHelper.ExecuteQuery(sql);
dt.Rows.Count;
MenuItemx=newMenuItem(dt.Rows[i][0].ToString(),dt.Rows[i][0].ToString());
stringsql2="
selectmajorNamefrommajorwheredepartmentName='
sql2=string.Format(sql2,dt.Rows[i][0].ToString());
DataTabledt2=SqlHelper.ExecuteQuery(sql2);
for(intj=0;
j<
dt2.Rows.Count;
j++)
MenuItemy=newMenuItem(dt2.Rows[j][0].ToString(),dt2.Rows[j][0].ToString());
stringsql3="
selectclasscodefromStudentClasswheremajorid=(selectmajoridfrommajorwheremajorname='
sql3=string.Format(sql3,dt2.Rows[j][0].ToString());
DataTabledt3=SqlHelper.ExecuteQuery(sql3);
for(intk=0;
k<
dt3.Rows.Count;
k++)
MenuItemz=newMenuItem(dt3.Rows[k][0].ToString(),dt3.Rows[k][0].ToString());
y.ChildItems.Add(z);
x.ChildItems.Add(y);
Menu1.Items.Add(x);
验证控件的使用
Default1030.aspx.cs"
Default1030"
验证控件的使用<
styletype="
text/css"
.style1{
height:
25px;
/style>
tablewidth="
100%"
tr>
tdcolspan="
2"
class="
tdtop"
填写登陆信息
/td>
/tr>
tdclass="
tdlef"
用户名:
tdrigh"
tbname"
RequiredFieldValidatorID="
RequiredFieldValidator1"
ErrorMessage="
请输入用户名"
ControlToValidate="
ForeColor="
#FF3300"
RequiredFieldValidator>
密码:
tbpwd"
&
nbsp;
确认密码:
tbpwd2"
RequiredFieldValidator
ID="
RequiredFieldValidator2"
*"
Red"
CompareValidator
CompareValidator1"
ControlToCompare="
两次输入的密码不一样"
CompareValidator>
td>
年龄:
TextBox2"
CompareValidatorID="
CompareValidator3"
未满18禁止注册"
Operator="
GreaterThanEqual"
Type="
Double"
ValueToCompare="
18"
出生日期
TextBox1"
CompareValidator4"
填写正确的出生日期,建议xxxx-xx-xx"
DataTypeCheck"
Date"
&
TextBox3"
RequiredFieldValidator3"
RangeValidatorID="
RangeValidator1"
没在这个范围"
MaximumValue="
1.4"
MinimumValue="
1.2"
RangeValidator>
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- web 课堂 代码