static void Main(string[] args)
{
//int d = GetInt("4.5");
int d = (int)Math.Round(2.5,MidpointRounding.AwayFromZero);
decimal kk = Convert.ToDecimal("3.2");
//int dd = int.Parse(d);
int result;
int.TryParse("2.3", out result);
int kkd = result;
int dp = (int)Math.Round(4.5);
//double ll =Math.Floor(2.5);
}
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1">
<Columns>
<asp:TemplateField HeaderText="StudentNumber">
<ItemTemplate>
<asp:CheckBox ID="snc" runat="server" Text='<% #DataBinder.Eval(Container.DataItem,"snumber") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="sname" HeaderText="sname" SortExpression="sname" />
</Columns>
</asp:GridView>
The templatefield class is used to display custom content for each record displayed.
The DataBinder.Eval method is used to evaluate data-binding expressions at run time.
<body >
<form id="form1" runat="server">
<div>
<object id="MP" classid="clsid:22D6F312-B0F6-11D0-94AB-0080C74C7E95" width="620" height="460" VIEWASTEXT>
<param name="filename" value="msft101006vxpm.wmv">
<param name="AutoStart" value="1">
<param name="Enabled" value="-1">
<param name="ShowControls" value="-1">
<param name="ShowGotoBar" value="0">
<param name="ShowStatusBar" value="-1">
<param name="EnableFullScreenControls" value="0">
<param name="EnablePositionControls" value="0">
<param name="Volume" value="0">
<param name="DisplaySize" value="4">
<param name="SendErrorEvents" value="0">
<param name="enableContextMenu" value="0">
<param name="EnableTracker" value="-1">
<param name="AudioStream" value="-1">
<param name="AutoSize" value="0">
<param name="AnimationAtStart" value="-1">
<param name="AllowScan" value="-1">
<param name="AllowChangeDisplaySize" value="-1">
<param name="AutoRewind" value="0">
<param name="Balance" value="0">
<param name="BaseURL" value="">
<param name="BufferingTime" value="5">
<param name="CaptioningID" value="">
<param name="ClickToPlay" value="-1">
<param name="CursorType" value="0">
<param name="CurrentPosition" value="-1">
<param name="CurrentMarker" value="0">
<param name="DefaultFrame" value="">
<param name="DisplayBackColor" value="0">
<param name="DisplayForeColor" value="16777215">
<param name="DisplayMode" value="0">
<param name="InvokeURLs" value="-1">
<param name="Language" value="-1">
<param name="Mute" value="0">
<param name="PlayCount" value="1">
<param name="PreviewMode" value="0">
<param name="Rate" value="1">
<param name="SAMILang" value="">
<param name="SAMIStyle" value="">
<param name="SAMIFileName" value="">
<param name="SelectionStart" value="-1">
<param name="SelectionEnd" value="-1">
<param name="SendOpenStateChangeEvents" value="-1">
<param name="SendWarningEvents" value="-1">
<param name="SendKeyboardEvents" value="0">
<param name="SendMouseClickEvents" value="0">
<param name="SendMouseMoveEvents" value="0">
<param name="SendPlayStateChangeEvents" value="-1">
<param name="ShowCaptioning" value="0">
<param name="ShowAudioControls" value="-1">
<param name="ShowDisplay" value="0">
<param name="ShowPositionControls" value="-1">
<param name="ShowTracker" value="-1">
<param name="TransparentAtStart" value="0">
<param name="VideoBorderWidth" value="0">
<param name="VideoBorderColor" value="0">
<param name="VideoBorder3D" value="0">
<param name="WindowlessVideo" value="0">
</object>
</div>
</form>
</body>
using System.Diagnostics;
namespace WebApplication1
{
public partial class WebForm3 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Process pro = new Process();
pro.StartInfo.UseShellExecute = false;
pro.StartInfo.FileName = "cmd";
pro.StartInfo.Arguments = "/c dir > d:\\2.txt";
pro.StartInfo.RedirectStandardOutput = false;
pro.Start();
}
}
}
CREATE TABLE tbl_students
(
snumber char,
sname varchar(10)
)
CREATE TABLE tbl_curriculums
(
cnumber char,
cname varchar(15),
cteacher varchar(10)
)
CREATE TABLE tbl_relationships
(
snumber char,
cnumber char,
score varchar(3)
)
--Method 1 Good
SELECT S.sname
FROM
tbl_students S,
tbl_curriculums C,
tbl_relationships R
WHERE
S.snumber = R.snumber AND
R.cnumber = C.cnumber AND
C.cteacher = 'XU'
--Method 2 Better
SELECT S.sname
FROM
tbl_students S
WHERE
S.snumber in
(
SELECT R.snumber
From
tbl_curriculums C,
tbl_relationships R
WHERE
R.cnumber = C.cnumber AND
C.cteacher = 'XU'
)
-- Method 3 Best
SELECT S.sname
FROM
tbl_students S
INNER JOIN tbl_relationships R ON S.snumber = R.snumber
INNER JOIN tbl_curriculums C ON R.cnumber = C.cnumber
AND C.cteacher ='XU'