C＃Web應(yīng)用程序入門經(jīng)典學(xué)習(xí)筆記之一
2020-01-18 01:55:39
供稿：網(wǎng)友
最近看了《Beginning C# Web Applications Wtith Visual Studio .Net 》。感覺這本書在一些細(xì)節(jié)方面寫的不錯，特做筆記，為后來者提供一些或許有用的東東。今天先寫出來一些，年前正確整理完。
當(dāng)前日期：
Lbll.Text = DateTime.Now.ToLongDataString();
This.controls.Add(lbl);
URL:
HyperLink reg = new HyperLink();
Reg.Text = “Register;
Reg.NavigateUrl = Context.Request.ApplicationPath + “Myfirst.aspx”;
判斷用戶授權(quán):
Context.User.Identity.IsAuthenticated;
表格相關(guān)：
1. 新建一圖片img
2. img添加到cell
3. cell添加到row
4. row添加到Table
5. Table添加到PlaceHolder
Table tb = new Table();
TableRow row = new TableRow();
Image img = new Image();
img.ImageUrl = "Images/winbook.gif";
img.ImageAlign = ImageAlign.Middle;
img.Width = new Unit(24, UnitType.Pixel);
img.Height = new Unit(24, UnitType.Pixel);
cell = new TableCell();
cell.Controls.Add(img);
row.Cells.Add(cell);
HyperLink lnk = new HyperLink();
lnk.Text = "News";
lnk.NavigateUrl = "News.aspx";
row.Cells.Add(cell);
tb.Rows.Add(row);
phNav.Controls.Add(tb);
將已驗(yàn)證身份的用戶重定向回最初請求的URL
public static void RedirectFromLoginPage(string userName,bool createPersistentCookie);
參數(shù)
userName
用于 Cookie 身份驗(yàn)證的用戶名稱。這不需要映射到帳戶名稱，并將由 URL 身份驗(yàn)證使用。
createPersistentCookie
指定是否應(yīng)當(dāng)發(fā)出持久性 Cookie（跨瀏覽器會話保存的 Cookie）。
標(biāo)準(zhǔn)數(shù)據(jù)庫操作1
String sql;
SqlCommand cmd;
SqlConnection conn;
Sql = “insert into …”;
conn = new SqlConnection (“data source = (local); initial catalog = caoxicao;userid = sa”);
cmd = new SqlCommand (sql,conn);
conn.open();
cmd.ExecuteNonQuery();
標(biāo)準(zhǔn)數(shù)據(jù)庫操作2
SqlConnection conn;
SqlCommand cmd;
SqlDataReader reader;
string sql;
sql = “select * from TableName”;
conn = new SqlConnection (“data source = (local); initial catalog = caoxicao;userid = sa”)
cmd = new SqlCommand(sql,conn);
conn.open();
reader = cmd.ExecuteReader();
可以用reader的Read()方法判斷是否真的返回了值
If (reader.Read())
...{
This.Email.Text = reader[“Email”].ToString();
}
DataSet 基本操作
DataSet dsCaoxicao;
String sql;
SqlConnection conn;
SqlDataAdapter adPlaces;
conn = new SqlConnection (“data source = (local); initial catalog = caoxicao;userid = sa”)
adPlaces = new SqlDataAdapter(sql,conn);
dsCaoxiCao = new DataSet();
conn.Open();
adPlaces.Fill(dsCaoxiCao,”Places”);
