Scribd
Upload
21 views13 pages

Download Phetsarath OT Font

The document contains ASP.NET web forms that allow users to search for students and manage mailing lists in a SQL Server database. It includes code for handling user input, displaying data in a grid, and performing CRUD operations on the database. The forms utilize various ASP.NET controls and validation mechanisms to ensure data integrity.

Uploaded by

valenthaiymany
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
21 views13 pages

Download Phetsarath OT Font

The document contains ASP.NET web forms that allow users to search for students and manage mailing lists in a SQL Server database. It includes code for handling user input, displaying data in a grid, and performing CRUD operations on the database. The forms utilize various ASP.NET controls and validation mechanisms to ensure data integrity.

Uploaded by

valenthaiymany
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

<%@ Import Namespace="System.

Data" %>

<%@ Import Namespace="[Link]" %>

<%@ Page language="C#" %>

<script runat="server">

private void ABCD_CLICK(Object s, EventArgs e){

SqlConnection con ;

SqlCommand cmd ;

SqlDataReader dtr;

String strConn="server=LITHAUG2012\\NUN;uid=sa;pwd=sa;database=db3cw1";

con = new SqlConnection (strConn);

[Link]();

String sql="Select name from student where name like '%'+@stdname+'%' ";

cmd=new SqlCommand(sql, con);

[Link]("@stdname", [Link]);

dtr = [Link]();

[Link] = "";

while ([Link]()){

[Link] += "<li>";

[Link] += dtr["name"];

[Link]();

[Link]();

</script>

<HTML>

<HEAD>

<TITLE> Search Stusent </TITLE>


</HEAD>

<BODY>

<form runat="server">

<asp:TextBox id="txtName" Runat="Server" />

<br>

<asp:Button id="Button" Text="Search" OnClick="ABCD_CLICK" Runat="Server" />

<p>

<asp:Label id="lblMessage" Runat="Server" />

</p>

</form>

</BODY>

</HTML>

=================================================

[Link]

==========================================

<html>

<head runat="server">

<meta charset="utf-8">

<title>Test ASP</title>

</head>

<body>

<style type="text/css">
*{

font-family: phetsarath OT;

</style>

<CENTER>

<h1 style="font-family: phetsarath OT">ກະລ


ຸ ນາປອ ້ ມ
້ ນຂ ູ ນຂອງທ
່ ານ</h1>
<form runat="server" id="form">

<table border="0">

<TR>

<div>

<TD align="right"> <label>ລະຫັດ:</label></TD>

<TD> <asp:textBox id="txtid" runat="server" />

<asp:RequiredFieldValidator ControlToValidate="txtid"

text="ກະລ
ຸ ນາປອ ້ າກອ
້ ນລະຫັດຂອງເຈ ່ ນ" runat="server"/></TD>
</div>

</TR>

<TR>

<div>
່ :</label></TD>
<TD align="right"> <label>ຊ

<TD> <asp:textBox id='fname' runat="server" /></TD>

</div>

</TR>

<TR> <div>

<TD align="right"> <label>ນາມສະກ


ຸ ນ:</label></TD>
<TD> <asp:textBox id='lname' runat="server" /></TD>

</div>

</TR>

<TR> <div>
<TD align="right"> <label>ເພດ:</label></TD>

<TD><asp:RadioButton id="female" groupName="gender"

Text="ຍ
ີ ງ" runat="server" />
<asp:RadioButton id="male" groupName="gender" Text="ຊາຍ"

runat="server" /></TD>

</div>

</TR>

<TR> <div>

<TD align="right"> <label>ອ


ີ ເມວ:</label></TD>
<TD> <asp:textBox id='txtemail' runat="server" />

<asp:RegularExpressionValidator ID="ret2"

runat="server" ControlToValidate="txtemail"

ErrorMessage="* Your entry is not a valid e-mail address."

ValidationExpression=".*@.*\..*"></asp:RegularExpressionValidator>

</TD>

</div>

</TR>

<TR> <div>

<TD align="right"> <label>ລະຫັດປະເທດ:</label></TD>

<TD> <asp:textBox id='txtcode' runat="server" />

<asp:RegularExpressionValidator

ControlToValidate="txtcode"

Text="Invalid country code."

ValidationExpression="[0-9]{3}"

Display="Dynamic"

Runat="Server" > </asp:RegularExpressionValidator></TD>

</div></TR>
<TR> <div>

<TD align="right"> <label>ສາຂາ:</label></TD>

<TD> <asp:DropDownList id="dropID" runat="server">

<asp:ListItem value="ວ
ິ ທະຍາສາດຄອມພ
ິ ວເຕ
ີ "
Text="ວ
ິ ທະຍາສາດຄອມພ
ິ ວເຕ
ີ " />
<asp:ListItem value="ໂປຣແກຣມ" Text="ໂປຣແກຣມ" />

<asp:ListItem value="ການພັດທະນາເວ
ັ ບໄຊ" Text="ການ
ພັດທະນາເວ
ັ ບໄຊ" />
</asp:DropDownList></TD>

</div>

</TR>

<TR>

<div>
່ີ ເຈ
<TD align="right"> <label>ພາສາໂປຣແກຣມທ ່ີ ສ
້ າມັກທ ຸ ດ:
</label></TD>

<TD> <asp:checkBoxList id='checkBoxList' runat="server">

<asp:ListItem Text="Java" />

<asp:ListItem Text="PHP" />

<asp:ListItem Text="VB" />

</asp:checkBoxList></TD>

</div>

</TR>

<TR> <div>

<TD colspan="2"><div align="center"> <asp:Button style="color:

blue;" id="btnOK" text="ບັນທກ" Onclick="mysubmit" runat="server" /></div>

</TD>

</div>

</TR>
</div>

</table>

<div>

<asp:label id="lbMessage" runat="server" />

</form>

</CENTER>

<script lang="vb" runat="server">

sub mysubmit(s as Object, e as EventArgs)

Dim gender

if [Link] then

gender = [Link]

else if [Link] then

gender = [Link]

end if

Dim itemI As ListItem

Dim Str As String

For Each itemI in [Link]

if [Link] then

Str &= [Link] & ", "

end if

Next

[Link] = "<div>ລະຫັດ: " & [Link] & "<br/> ່ ຊ ແລະ

ຸ ນ:" & [Link] & " " & [Link] & "<br/>ເພດ: " & gender & "<br/>ອ
ນາມສະກ ີ ເມວ:
"& [Link] &"<br/>ລະຫັດປະເທດ:"& [Link] &"<br/>ສາຂາຮຽນ:" &
່ີ ເຈ
[Link] & "<br/> ພາສາໂປແກມທ ້ າມັກ: " & Str & "</div>"
end sub

</script>

</body>

</html>

===================================

[Link]

=====================================

<%@ Page Language="c#" debug="true" %>

<%@Import Namespace="[Link]" %>

<%@Import Namespace="[Link]" %>

<script runat="server">

protected void Page_Load(Object s, EventArgs e){

if (![Link] ){

showData();

private void showData(){

string strCon= "server=LITHAUG2012\\NUN;uid=sa;pwd=sa;database=dbCW1";

//string strCon= "server=.;uid=sa;pwd=qwerty;database=db3CW1";

SqlConnection myconn = new SqlConnection(strCon);

if(myconn!=null){

string strSQL = "SELECT * FROM tbMailling";

DataSet ds = new DataSet();

SqlDataAdapter da = new SqlDataAdapter(strSQL, myconn);

[Link](ds, "mail");

[Link] = ds;

[Link]() ;
}

private void Item_Edit(Object s, DataGridCommandEventArgs e){

[Link]=[Link];

showData();

private void Item_Cancel(Object s, DataGridCommandEventArgs e){

[Link]=-1;

showData();

private void Item_Change(Object s, DataGridPageChangedEventArgs e){

[Link]=[Link];

showData();

private void Item_Update(Object s, DataGridCommandEventArgs e){

int id ;

TextBox txtname,txtsurname,txtemail ;

id=(int)[Link][[Link]];

txtname=(TextBox)[Link][2].Controls[0];

txtsurname=(TextBox)[Link][3].Controls[0];

txtemail=(TextBox)[Link][4].Controls[0];

string strconn ="server=LITHAUG2012\\NUN;uid=sa;pwd=sa;database=dbCW1";

SqlConnection conn = new SqlConnection(strconn);

[Link]();

string sqlUpdate="UPDATE tbMailling SET Name=@name ,Surname=@surname,

Email=@email WHERE Id=@id";

SqlCommand cmd= new SqlCommand(sqlUpdate,conn);


[Link]("name", [Link]);

[Link]("surname", [Link]);

[Link]("email", [Link]);

[Link]("id", id);

[Link]();

[Link]=-1;

[Link]();

showData();

private void saveData(Object s, EventArgs e ){

//string strconn ="server=.;uid=sa;pwd=qwerty;database=db3CW1";

string strconn ="server=LITHAUG2012\\NUN;uid=sa;pwd=sa;database=dbCW1";

SqlConnection conn = new SqlConnection(strconn);

[Link]();

string sqlAdd="INSERT INTO tbMailling(Id,Name,Surname,Email)";

sqlAdd +=" VALUES(@id,@name,@surname,@email)";

SqlCommand command= new SqlCommand(sqlAdd,conn);

[Link]("id", [Link]);

[Link]("name", [Link]);

[Link]("surname", [Link]);

[Link]("email", [Link]);

[Link]();

[Link]();

showData();
[Link]="";

[Link]="";

[Link]="";

[Link]="";

</script>

<HTML>

<HEAD>

<TITLE> New Document </TITLE>

<META NAME="Generator" CONTENT="EditPlus">

<META NAME="Author" CONTENT="">

<META NAME="Keywords" CONTENT="">

<META NAME="Description" CONTENT="">

</HEAD>

<BODY>

<center>

<form id="f1" runat="server">

<h2>Use the SQL Server Database </h2><br>

Fill Data Please<br>

<table>

<tr><td>

ID:</td><td><asp:Textbox id="myId" size ="10" runat="server"/></td></tr>

<tr><td>

Name:</td><td><asp:Textbox id="name" size ="20" runat="server"/></td></tr>

<tr><td>

Surname:</td><td><asp:Textbox id="surname" size ="20" runat="server"/></td></tr>


<tr><td>

Gender:</td><td><asp:RadioButton id="radM" Text="Male"

runat="server"/><asp:RadioButton id="radF" Text="Female"

runat="server"/></td></tr>

<tr><td>

E-mail:</td><td><asp:Textbox id="email" size ="20" runat="server"/></td></tr>

<tr><td>

Major:</td><td><asp:DropdownList id="major" runat="server"><asp:ListItem

Value="cpr" Text="Programing" />

<asp:ListItem Value="cs" Text="Computer Science" />

<asp:ListItem Value="cw" Text="Website" /></asp:DropdownList></td></tr>

<tr><td>

Your Favourite Subject:</td><td> <asp:CheckBoxList

id="chkFavouriteSub" Runat="Server">

<asp:ListItem Text="PHP" />

<asp:ListItem Text="Java" />

<asp:ListItem Text="ASP" />

<asp:ListItem Text="JSP" />

<asp:ListItem Text="HTML" />

</asp:CheckBoxList>

</td></tr>

<tr><td rowspan="2">

<asp:Button id="mybutton" text="Save Data" onClick="saveData" runat="server"

/></td></tr>

<tr><td rowspan="2">

<asp:RegularExpressionValidator ID="validemail" runat="server"

ControlToValidate="email"
ErrorMessage="Missing @ sign"

ValidationExpression=".*@.*\..*"></asp:RegularExpressionValidator></td></tr>

</table>

<hr>

<asp:DataGrid id="myGrid" Autogeneratecolumns="false"

DataKeyField="Id"

HeaderStyle-BackColor="#99cc66"

HeaderStyle-Font-Bold="true"

AlternatingItemStyle-BackColor="#AABBCC"

AllowPaging="true"

PageSize="15"

PagerStyle-Mode="NumericPages"

onEditCommand="Item_Edit"

onCancelCommand="Item_Cancel"

onUpdateCommand="Item_Update"

onPageIndexChanged="Item_Change"

runat="server" >

<Columns>
<asp:EditCommandColumn HeaderText="ແກ
້ ໄຂ" ButtonType="LinkButton"
CancelText="ຍກເລ
ີ ກ" EditText="ແກ
້ ໄຂ" UpdateText="ປັບປ
ຸ ງ" />

<asp:BoundColumn HeaderText="ລະຫັດ" DataField="Id" ReadOnly="True" />


່ " DataField="Name" ReadOnly="True" />
<asp:BoundColumn HeaderText="ຊ

<asp:BoundColumn HeaderText="ນາມສະກ
ຸ ນ" DataField="Surname" />
<asp:BoundColumn HeaderText="ອ
ີ ເມວ" DataField="Email" />

<asp:ButtonColumn HeaderText="ລ
ຶ ບ" Text="Delete" CommandName="Delete" />

</Columns>

</asp:DataGrid>

</form>

</center>

</BODY>

</HTML>

===================

Create database dbCW1

Use dbCW1

Create table tbMailling(

Id int,

Name nvarchar(50),

Surname nvarchar(80),

Email varchar(100)

==============================

You might also like