{"id":2530,"date":"2014-07-15T13:49:24","date_gmt":"2014-07-15T05:49:24","guid":{"rendered":"http:\/\/kuki.idv.tw\/?p=2530"},"modified":"2014-07-15T13:49:24","modified_gmt":"2014-07-15T05:49:24","slug":"%e8%bd%89asp-net-%e4%bd%bf%e7%94%a8%e7%ad%86%e8%a8%98","status":"publish","type":"post","link":"https:\/\/www.kuki.idv.tw\/?p=2530","title":{"rendered":"[\u8f49]ASP.NET \u4f7f\u7528\u7b46\u8a18"},"content":{"rendered":"

\u4f86\u6e90 http:\/\/catchtest.pixnet.net\/blog\/post\/28219055-asp.net-%E4%BD%BF%E7%94%A8%E7%AD%86%E8%A8%98<\/p>\n

\u672c\u7bc7\u6574\u7406\u4e86\u4e00\u4e9b\u6211\u4ee5\u524d\u5bebASP.NET\u9047\u5230\u7684\u554f\u984c
\n\u5e0c\u671b\u80fd\u5e6b\u52a9\u5f9eJava\u6216\u5176\u4ed6\u8a9e\u8a00\u8df3\u69fd\u5230ASP.NET\u7684\u4eba
\n\u6709\u65b0\u7684\u5167\u5bb9\u61c9\u8a72\u6703\u5728\u6b64\u7bc7\u7e7c\u7e8c\u66f4\u65b0\u5427<\/p>\n

\n

===========[ \u5feb\u901f\u958b\u767c ]===========<\/span><\/strong><\/p>\n

\u203b\u5584\u7528using<\/span><\/strong>
\nusing\u5b8c\u7684\u7269\u4ef6\u6703\u81ea\u52d5Close\u8207Dispose\uff0c\u6240\u4ee5\u5efa\u8b70\u9700\u8981Dispose\u7684\u7269\u4ef6\u90fd\u53ef\u4ee5\u4f7f\u7528using
\n\u50cf\u662fSqlConnection, SqlCommand, SqlDataReader…<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n<\/td>\n
\n
\n
using<\/code> (SqlConnection conn = <\/code>new<\/code> SqlConnection(<\/code>\"xxx\"<\/code>))<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>conn.Open();<\/code><\/div>\n
}\u00a0\u00a0 <\/code>\/\/ \u7d50\u675f\u6642\u4e0d\u9700\u8981Close\u8ddfDispose<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\n

\u203b\u8cc7\u6599\u5eab\u4ea4\u6613(Transaction)\u4e0d\u7528\u90a3\u9ebc\u9ebb\u7169<\/strong><\/span>
\n.NET 2.0\u5f8c\u65b0\u589e\u4e86TransactionScope\u7269\u4ef6<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
using<\/code> (TransactionScope scope = <\/code>new<\/code> TransactionScope())<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\/\/ TODO: SQL\u9023\u7dda<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>scope.Complete();\u00a0\u00a0 <\/code>\/\/ \u4ea4\u6613\u5b8c\u6210<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\u5982\u679c\u4e2d\u9014\u56e0\u610f\u5916\u800c\u8df3\u51fa\uff0c\u7121\u9808Rollback
\n\u53ea\u8981TransactionScope\u6c92\u6709\u57f7\u884cComplete()\uff0c\u7d50\u675f\u5f8c\u5c31\u6703\u81ea\u52d5Rollback
\n\u4f7f\u7528\u524d\u5fc5\u9808\u8981\u52a0\u5165\u53c3\u8003 System.Transactions \u624d\u80fd\u4f7f\u7528<\/span><\/p>\n

\n

\u203b\u4f7f\u7528string.Join \u7701\u53bb\u4e32\u63a5\u529f\u592b<\/strong><\/span>
\n\u5047\u8a2d\u6709\u500b\u9663\u5217\uff0c\u4f60\u60f3\u628a\u9663\u5217\u88e1\u7684\u8cc7\u6599\u4e32\u6210\u4e00\u884c\u4e14\u7528\u81ea\u8a02\u7b26\u865f\u9694\u958b\uff0c\u4f60\u6703\u600e\u9ebc\u505a\u5462\uff1f<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n<\/td>\n
\n
\n
\/\/ \u4e00\u822c\u5beb\u6cd5<\/code><\/div>\n
string<\/code>[] values = { <\/code>\"1\"<\/code>, <\/code>\"2\"<\/code>, <\/code>\"3\"<\/code> };<\/code><\/div>\n
StringBuilder sb = <\/code>new<\/code> StringBuilder();<\/code><\/div>\n
foreach<\/code> (<\/code>string<\/code> s <\/code>in<\/code> values)<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>if<\/code> (sb.length() > 0)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>sb.append(<\/code>','<\/code>);<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>sb.append(s);<\/code><\/div>\n
}<\/code><\/div>\n
sb.ToString();\u00a0\u00a0 <\/code>\/\/ 1,2,3<\/code><\/div>\n
\/\/ string.Join<\/code><\/div>\n
string<\/code>.Join(<\/code>\",\"<\/code>, values);\u00a0\u00a0 <\/code>\/\/ 1,2,3<\/code><\/div>\n
\/\/ Linq\u5beb\u6cd5<\/code><\/div>\n
values.Aggregate((i, j) => i + <\/code>\",\"<\/code> + j);\u00a0\u00a0 <\/code>\/\/ 1,2,3<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\n

\u203b\u7528out\u4f5c\u70ba\u8b8a\u6578\u56de\u50b3\u503c<\/strong><\/span>
\n\u5ba3\u544aout\u7684\u8b8a\u6578\uff0c\u5728\u65b9\u6cd5\u7d50\u675f\u524d\u4e00\u5b9a\u6703\u8ce6\u503c\uff0c\u6240\u4ee5\u53ef\u4ee5\u505a\u70ba\u56de\u50b3\u503c\u4f7f\u7528<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n<\/td>\n
\n
\n
private<\/code> void<\/code> Test()<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>string<\/code> a, b;\u00a0\u00a0 <\/code>\/\/ \u5ba3\u544a\u6642\u7121\u9808\u7d66\u521d\u59cb\u503c<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>GetValue(<\/code>out<\/code> a, <\/code>out<\/code> b);\u00a0\u00a0 <\/code>\/\/ \u7d50\u679ca=\"a\", b=\"b\"<\/code><\/div>\n
}<\/code><\/div>\n
<\/div>\n
private<\/code> void<\/code> GetValue(<\/code>out<\/code> string<\/code> a, <\/code>out<\/code> string<\/code> b)<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>a = <\/code>\"a\"<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>b = <\/code>\"b\"<\/code>;<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\n

\u203b\u7528@\u4f86\u8a2d\u5b9a\u591a\u884c\u7684SQL\u8a9e\u6cd5<\/strong><\/span>
\n\u96d6\u7136\u6211\u500b\u4eba\u6bd4\u8f03\u63a8\u85a6\u628aSQL\u8a9e\u6cd5\u90fd\u5beb\u5728\u67e5\u8a62\u7522\u751f\u5668\u4e2d(\u6e1b\u5c11\u7a0b\u5f0f\u78bc\u8907\u96dc\u5ea6\uff0c\u9084\u80fd\u9a57\u8b49)
\n\u4e0d\u904e\u67d0\u4e9b\u6642\u5019\u9084\u662f\u5fc5\u9808\u8981\u628aSQL\u5beb\u5728code\u4e2d
\n\u5f9eJava\u8f49\u904e\u4f86\u7684\u4eba\u53ef\u80fd\u6703\u9019\u6a23\u5beb<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n<\/td>\n
\n
\n
string<\/code> sql = <\/code>\"SELECT field1, field2\"<\/code> +<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>\"FROM table1\"<\/code> +<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>\"WHERE field3 = @Param1\"<\/code>;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\u5176\u5be6\u5728ASP.NET\u4e0d\u9700\u8981\u9019\u9ebc\u9ebb\u7169\u6bcf\u4e00\u884c\u8981\u4e32\u63a5\uff0c\u5728\u5b57\u4e32\u524d\u52a0\u4e0a@\u5c31\u80fd\u505a\u5230\u8de8\u884c<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n<\/td>\n
\n
\n
string<\/code> sql = <\/code>@\"SELECT field1, field2<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>FROM table1<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>WHERE field3 = @Param1\"<\/code>;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\n

\u203b\u7528TryParse\u8f49\u63db\u53ef\u80fd\u6703\u51fa\u932f\u7684\u5b57\u4e32<\/span><\/strong>
\n\u5e7e\u4e4e\u6240\u6709\u7684\u57fa\u672c\u578b\u614b\u90fd\u6709TryParse\u65b9\u6cd5
\nTryParse\u7684\u7279\u9ede\u662f\u5982\u679c\u5b57\u4e32\u8f49\u63db\u5931\u6557\uff0c\u4e0d\u6703\u62cb\u51faException
\n\u5982\u679c\u51fa\u932f\u5f8c\uff0c\u8b8a\u6578\u6703\u8b8a\u6210\u521d\u59cb\u503c0\uff0c\u5982\u679c\u5e0c\u671b\u540c\u6642\u7d66\u4e88\u4e0d\u540c\u503c\uff0c\u53ef\u4ee5\u9019\u6a23\u5beb<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
int<\/code> i;<\/code><\/div>\n
if<\/code> (!<\/code>int<\/code>.TryParse(<\/code>\"\"<\/code>, <\/code>out<\/code> i))<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>i = 100;<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\n

\u203b\u5982\u4f55\u8981\u6c42\u4f7f\u7528\u8005\u8981\u5728TextBox\u8f38\u5165\u7279\u5b9a\u683c\u5f0f\u7684\u8cc7\u6599\u624d\u80fd\u9001\u51fa?<\/strong><\/span>
\n\u53ef\u4ee5\u4f7f\u7528Validator\u9a57\u8b49\uff0c\u5982\u679c\u683c\u5f0f\u4e0d\u7b26\uff0c\u5c31\u7121\u6cd5Postback
\n(\u9664\u975e\u8a2d\u5b9a\u63a7\u5236\u9805\u5c6c\u6027CausesValidation = false\uff0c\u4f7f\u5176\u4e0d\u6aa2\u67e5)
\n\u53e6\u5916\u8981Validator\u9810\u8a2d\u6703\u4f54\u4f4f\u756b\u9762\uff0c\u5982\u679c\u8981\u8b93\u5176\u52d5\u614b\u986f\u793a
\n\u9700\u8a2d\u5b9aValidator\u5c6c\u6027Display = Dynamic<\/p>\n

\n

\u203b\u8981\u6e05\u6389\u63a7\u5236\u9805\u7684\u5167\u5bb9\u5f97\u5beb\u597d\u9577\u4e00\u4e32\uff0c\u6709\u6c92\u6709\u7c21\u55ae\u7684\u6e05\u7a7a\u65b9\u6cd5\u5462?<\/span><\/strong><\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n<\/td>\n
\n
\n
\/\/ \u4e00\u822c\u5beb\u6cd5<\/code><\/div>\n
this<\/code>.TextBox1.Text = <\/code>\"\"<\/code>;<\/code><\/div>\n
this<\/code>.TextBox2.Text = <\/code>\"\"<\/code>;<\/code><\/div>\n
this<\/code>.Label1.Text = <\/code>\"\"<\/code>;<\/code><\/div>\n
<\/div>\n
\/\/ \u500b\u4eba\u5beb\u6cd5: \u5beb\u500b\u65b9\u6cd5\u53bb\u547c\u53eb<\/code><\/div>\n
private<\/code> void<\/code> ClearControls(<\/code>params<\/code> Control[] controls)<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>foreach<\/code> (Control control <\/code>in<\/code> controls)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>if<\/code> (control <\/code>is<\/code> TextBox)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>(control <\/code>as<\/code> TextBox).Text = <\/code>\"\"<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>else<\/code> if<\/code> (control <\/code>is<\/code> Label)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>(control <\/code>as<\/code> Label).Text = <\/code>\"\"<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>else<\/code> if<\/code> (control <\/code>is<\/code> HiddenField)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>(control <\/code>as<\/code> HiddenField).Value = <\/code>\"\"<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
}<\/code><\/div>\n
\/\/ \u4f7f\u7528\u65b9\u6cd5<\/code><\/div>\n
ClearControls(TextBox1, TextBox2, Label1);<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\n

\u203b\u7528??\u4ee3\u66ff\u9ebb\u7169\u7684\u689d\u4ef6\u5224\u65b7<\/strong><\/span><\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n<\/td>\n
\n
\n
string<\/code> str;<\/code><\/div>\n
if<\/code> (WebConfigurationManager.AppSettings[<\/code>\"xx\"<\/code>] != <\/code>null<\/code>)<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>str = WebConfigurationManager.AppSettings[<\/code>\"xx\"<\/code>];<\/code><\/div>\n
}<\/code><\/div>\n
else<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>str = <\/code>\"defaultValue\"<\/code>;<\/code><\/div>\n
}<\/code><\/div>\n
<\/div>\n
string<\/code> str = WebConfigurationManager.AppSettings[<\/code>\"xx\"<\/code>] ?? <\/code>\"defaultValue\"<\/code>;\u00a0\u00a0 <\/code>\/\/ \u8207\u4e0a\u9762\u540c\u7fa9<\/code><\/div>\n
<\/div>\n
string<\/code> str = val1 ?? val2 ?? val3 ?? val4;\u00a0\u00a0 <\/code>\/\/ \u4f9d\u5e8f\u5224\u65b7val1, val2, val3, val4\u662f\u5426\u6709\u503c\uff0c\u6709\u503c\u5373\u8a2d\u5b9a\u503c<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\n

\u203b\u6709\u6c92\u6709\u8fa6\u6cd5\u7e2e\u6e1bSqlCommand.Parameters.AddWithValue\u7684\u7a0b\u5f0f\u78bc?<\/strong><\/span><\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n<\/td>\n
\n
\n
string<\/code> str = <\/code>null<\/code>;<\/code><\/div>\n
SqlCommand cmd = <\/code>new<\/code> SqlCommand(sql){<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>if<\/code> (str == <\/code>null<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>cmd.Parameters.AddWithValue(<\/code>\"@Param1\"<\/code>, DBNull.Value);<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>else<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>cmd.Parameters.AddWithValue(<\/code>\"@Param1\"<\/code>, str);<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
}<\/code><\/div>\n
\/\/ \u5982\u679c\u4f60\u5beb\u9019\u6a23\uff0c\u6703\u8df3\u51fa\u932f\u8aa4\u8a0a\u606f<\/code><\/div>\n
cmd.Parameters.AddWithValue(<\/code>\"@Param1\"<\/code>, str ?? DBNull.Value);<\/code><\/div>\n
\/\/ \u56e0\u70bastring\u8ddfobject\u4e0d\u662f\u540c\u4e00\u500b\u578b\u5225<\/code><\/div>\n
\/\/ \u6b63\u78ba\u65b9\u6cd5\u662f<\/code><\/div>\n
cmd.Parameters.AddWithValue(<\/code>\"@Param1\"<\/code>, (<\/code>object<\/code>)str ?? DBNull.Value);<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\n

\u203b\u4e0d\u6703\u7528\u5230\u7684\u63a7\u5236\u9805\u4e0d\u8981\u547d\u540d<\/span><\/strong>
\n\u6709\u4e9b\u4eba\u6703\u5f88\u71b1\u60c5\u7684\u628a\u4e00\u4e9b\u986f\u793a\u4e0a\u7684Label\u90fd\u53d6\u500b\u65b0\u7684ID
\n\u4f46\u9019\u4e9bLabel\u5176\u5be6\u4e26\u4e0d\u6703\u5728\u7a0b\u5f0f\u4e0a\u88ab\u6307\u5b9a\u5230
\n\u786c\u8981\u53d6\u540d\u4e0d\u4f46\u6703\u589e\u52a0\u9078\u53d6\u7a0b\u5f0f\u78bc\u81ea\u52d5\u5b8c\u6210<\/a>\u7684\u56f0\u96e3\u5ea6\uff0c\u9084\u53ef\u80fd\u6703\u649e\u540d
\n\u5efa\u8b70\u7d14\u986f\u793a\u7684Label\u5c31\u76f4\u63a5\u7528\u9810\u8a2d\u503c<\/p>\n

\n

\u203b\u4f7f\u7528Google Loader\u8f09\u5165jQuery\u8ddfjQuery UI<\/span><\/strong>
Google Loader\u662fGoogle\u63d0\u4f9b\u7684\u4e00\u7d44API\uff0c\u53ef\u4ee5\u8b93\u4f60\u52d5\u614b\u8f09\u5165\u6307\u5b9a\u7248\u672c\u7684jQuery JS
\n\u53ef\u4ee5\u6307\u5b9a\u7279\u5b9a\u7248\u672c\uff0c\u4e5f\u80fd\u6307\u5b9a\u6700\u65b0\u7248\u672c\u3002\u7531\u65bc\u6a94\u6848\u4e0d\u662f\u653e\u5728\u4e3b\u6a5f\u4e0a\uff0c\u66f4\u80fd\u6e1b\u5c11\u983b\u5bec\uff08\u53c3\u8003<\/a>\uff09
\n\u4f7f\u7528\u65b9\u6cd5\u5982\u4e0b\uff08\u5beb\u5728aspx\u4e2d\uff09<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
<<\/code>script<\/code> type<\/code>=<\/code>\"text\/javascript\"<\/code> src<\/code>=<\/code>\"https:\/\/www.google.com\/jsapi<\/a>\"<\/code>><\/<\/code>script<\/code>><\/code><\/div>\n
<<\/code>script<\/code> type<\/code>=<\/code>\"text\/javascript\"<\/code>><\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>google.load(\"jquery\", \"1.7\");<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>google.load(\"jqueryui\", \"1.8\");<\/code><\/div>\n
<\/<\/code>script<\/code>><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\n

===========[ \u529f\u80fd\u6559\u5b78 ]===========<\/span><\/strong><\/p>\n

\u203bGridView\u5728\u6c92\u6709\u8cc7\u6599\u7684\u6642\u5019\u6703\u8b8a\u6210\u7a7a\u767d\uff0c\u9023\u6a19\u984c\u5217(Header)\u90fd\u4e0d\u6703\u986f\u793a\uff0c\u8981\u5982\u4f55\u8b93\u5b83\u986f\u793a?<\/span><\/strong>
\n1. .NET 4.0\u65b0\u589e\u4e86ShowHeaderWhenEmpty\u5c6c\u6027
\n2. \u81ea\u5df1\u5beb\u7269\u4ef6\uff0c\u7e7c\u627fGridView\uff08\u53c3\u8003<\/a>\uff09
\n3. \u5728\u7121\u8cc7\u6599\u6642\u81ea\u5df1\u4e1f\u500b\u7a7a\u8cc7\u6599\u7d66GridView\uff0c\u4f46\u662f\u4e0d\u5efa\u8b70\uff0c\u56e0\u70ba\u9019\u6a23\u5c31\u7121\u6cd5\u7528GridView1.Rows.Count\u5224\u65b7\u662f\u5426\u70ba\u7a7a\uff08\u53c3\u8003<\/a>\uff09
\n4. \u5728EmptyDataTemplate\u81ea\u884c\u756b\u4e0aHeader\uff0c\u4f46\u66f4\u4e0d\u5efa\u8b70\uff0c\u56e0\u70ba\u6c92\u6cd5\u52d5\u614b\u4fee\u6539\uff08\u53c3\u8003<\/a>\uff09<\/p>\n

\n

\u203bGridView\u8981\u5982\u4f55\u505a\u5230\u6309\u4e0b\u4e00\u884c\u81ea\u52d5\u9078\u53d6\u8a72\u884c(select row)<\/strong><\/span>
\n\u5167\u5efa\u7adf\u7136\u6c92\u9019\u529f\u80fd\uff0c\u6709\u9ede\u8a87\u5f35
\n\u5728GridView\u7684RowDataBound\u8f38\u5165\u4ee5\u4e0bcode<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n<\/td>\n
\n
\n
protected<\/code> void<\/code> GridView1_RowDataBound(<\/code>object<\/code> sender, GridViewRowEventArgs e)<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>if<\/code> (e.Row.RowType == DataControlRowType.DataRow)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>e.Row.Attributes[<\/code>\"onclick\"<\/code>] = ClientScript.GetPostBackClientHyperlink(<\/code>this<\/code>.GridView1, <\/code>\"Select$\"<\/code> + e.Row.RowIndex);<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>e.Row.Style.Add(HtmlTextWriterStyle.Cursor, <\/code>\"pointer\"<\/code>);\u00a0\u00a0 <\/code>\/\/ \u6ed1\u9f20\u79fb\u4e0a\u53bb\u6642\uff0c\u8b8a\u6210\u9ede\u9078\u6a23\u5f0f<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\u4f46\u8f38\u5165\u5b8c\u5f8c\u6703\u51fa\u73fe\u4ee5\u4e0b\u8a0a\u606f<\/p>\n

\"gridview_row\"<\/p>\n

\u56e0\u70ba\u9019\u500b\u65b9\u6cd5\u7684PostBack\u8cc7\u6599\u4e0d\u662f\u539f\u59cb\u7684\u63a7\u5236\u9805\u767c\u51fa\u4f86\u7684\uff0c\u6703\u6709\u5b89\u5168\u6027\u4e0a\u7684\u554f\u984c
\n\u89e3\u6c7a\u6cd5
\n1. \u7167\u8457\u8aaa\u660e\uff0c\u8a2d\u5b9aEnableEventValidation = false
\n\u4e0d\u904e\u9019\u6a23\u6703\u6709\u88ab\u8de8\u7ad9\u653b\u64ca\u7684\u98a8\u96aa\uff0c\u4e0d\u5efa\u8b70\uff08\u53c3\u8003<\/a>\uff09
\n2. \u8986\u5beb\u8a72\u9801Render\uff0c\u8a3b\u518a\u5176\u4e8b\u4ef6\u9a57\u8b49\uff0c\u63a8\u85a6<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n<\/td>\n
\n
\n
protected<\/code> override<\/code> void<\/code> Render(HtmlTextWriter writer)<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>for<\/code> (<\/code>int<\/code> i = 0; i < <\/code>this<\/code>.GridView1.Rows.Count; i++)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Page.ClientScript.RegisterForEventValidation(<\/code>this<\/code>.GridView1.UniqueID, <\/code>\"Select$\"<\/code> + i.ToString());<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>base<\/code>.Render(writer);<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\n

\u203b\u5728\u522a\u9664\u6309\u9215\u9ede\u4e0b\u53bb\u524d\u5148\u8df3\u51fa\u4e00\u500b\u78ba\u8a8d\u8996\u7a97\uff0c\u9078\u64c7\u78ba\u5b9a\u624dPostBack<\/span><\/strong>
\nButton\u7684OnClientClick\u8f38\u5165
\nreturn confirm(“Are you sure?”);<\/span><\/p>\n

\n

\u203b\u4f7f\u7528ASP.NET\u7684\u6309\u9215\u63a7\u5236\u9805\uff0c\u4f7f\u5176\u6309\u4e0b\u53bb\u80fd\u547c\u53ebJavaScript\uff0c\u4f46\u662f\u4e0d\u8981PostBack<\/span><\/strong>
\nButton\u7684OnClientClick\u662f\u53ef\u4ee5\u8f38\u5165\u591a\u53e5JS\u8a9e\u6cd5\u7684
\n\u53ea\u8981\u6700\u5f8c\u52a0\u4e0areturn false;\u5c31\u80fd\u907f\u514dPostBack
\njavascript:xxx(); return false;<\/span><\/p>\n

\n

\u203b\u5982\u4f55\u986f\u793aMessageBox<\/span><\/strong>
\nASP.NET\u6c92\u9019\u6771\u897f\uff0c\u4f60\u53ea\u80fd\u52d5\u614b\u8a3b\u518aJS\u547c\u53ebalert<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
ScriptManager.RegisterStartupScript(<\/code>this<\/code>, <\/code>this<\/code>.GetType(), <\/code>\"alert\"<\/code>, <\/code>\"alert('\"<\/code> + Message + <\/code>\"');\"<\/code>, <\/code>true<\/code>);<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\n

\u203b\u5982\u4f55\u53eb\u51faConfirmBox\uff0c\u6309\u9215\u662f\u5bebYes\/No\/Cancel\u800c\u4e0d\u662f\u4e00\u822c\u7684OK\/Cancel?<\/strong><\/span>
\n\u4e0d\u4f46ASP.NET\u6c92\u9019\u6771\u897f\uff0c\u9023JS\u90fd\u6c92\u6709
\n\u4f60\u53ef\u4ee5\u7528jQuery+jQuery UI\u7684Modal confirmation<\/a>\uff0c\u81ea\u5df1\u5275\u7acb\u4e00\u500bDialog<\/p>\n

\n

\u203bJS\u7684Confirm\u8996\u7a97\u53ef\u4e0d\u53ef\u4ee5\u505a\u5230\u6309\u4e0b\u662f\u6216\u5426\u8df3\u5230\u4e0d\u540cPostBack\u7684\u6548\u679c<\/strong><\/span>
\n\u53ef\u4ee5\uff0c\u4f46\u8981\u7528JS\u53bb\u547c\u53ebPostBack\u65b9\u6cd5<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n<\/td>\n
\n
\n
function<\/code> check()<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>var<\/code> ret = confirm(<\/code>'Are you sure?'<\/code>);<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>if<\/code> (ret) {<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>__doPostBack(<\/code>'question'<\/code>, <\/code>'true'<\/code>);<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>} <\/code>else<\/code> {<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>__doPostBack(<\/code>'question'<\/code>, <\/code>'false'<\/code>);<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n
\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n<\/td>\n
\n
\n
protected<\/code> void<\/code> Page_Load(<\/code>object<\/code> sender, EventArgs e)<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>string<\/code> event_target = Request.Form.Get(<\/code>\"__EVENTTARGET\"<\/code>);<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>string<\/code> event_argu = Request.Form.Get(<\/code>\"__EVENTARGUMENT\"<\/code>);<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>if<\/code> (event_target == <\/code>\"question\"<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>if<\/code> (event_argu == <\/code>\"true\"<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>\/\/ TODO: true<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>else<\/code> if<\/code> (event_argu == <\/code>\"false\"<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>\/\/ TODO: false<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\n

\u203b\u8981\u600e\u9ebc\u505a\u5230\u6309\u4e0b\u6309\u9215\u5f8c\u8df3\u51fa\u65b0\u8996\u7a97(open new window)\uff0c\u5728\u65b0\u8996\u7a97\u8f38\u5165\u5167\u5bb9(Ex.\u5e33\u865f\u5bc6\u78bc)\u5f8c\u56de\u50b3(return value)\u7684\u6548\u679c<\/strong><\/span>
\n\u7d14ASP.NET\u7121\u6cd5\u505a\u5230\uff0c\u53ea\u80fd\u4f7f\u7528JS\uff0c\u8acb\u641c\u5c0b\u95dc\u9375\u5b57showModalDialog
\n\u4ee5\u4e0b\u65b9\u6cd5\u4e0d\u662f\u6700\u597d\u7684\u65b9\u6cd5…\u5982\u679c\u6709\u66f4\u597d\u7684\u4f5c\u6cd5\u8acb\u8ddf\u6211\u8aaa<\/p>\n

\u5047\u8a2d\u8981\u5f9eA\u9801\u9762\u547c\u53ebB\u9801\u9762\uff0c\u8f38\u5165\u5b8c\u8cc7\u6599\u518d\u56de\u50b3A\u9801\u9762
\n\u5728A.aspx\u5beb\u5165\u6b64JS (\u8981\u76f4\u63a5\u5beb\u6216\u7528\u52d5\u614b\u8a3b\u518a\u7686\u53ef)<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n<\/td>\n
\n
\n
var<\/code> returnValue = window.showModalDialog(url, <\/code>\"\"<\/code>, <\/code>\"dialogWidth:300px;dialogHeight:300px;\"<\/code>);\u00a0\u00a0 <\/code>\/\/ \u9084\u6709\u5f88\u591a\u53c3\u6578\u53ef\u7528<\/code><\/div>\n
if<\/code> (returnValue != undefined) {<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>__doPostBack(target, returnValue);\u00a0\u00a0 <\/code>\/\/ target\u81ea\u8a02<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\u5728B.aspx\u5beb\u5165\u6b64JS<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n<\/td>\n
\n
\n
function<\/code> selectBack(valueString) {<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>window.returnValue = valueString;<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>window.close();<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\n\u5728B.aspx\u7684\u63a7\u5236\u9805\u4e0a\u547c\u53eb\u6b64\u65b9\u6cd5
\njavascript:selectBack(‘” + encodeKeyString + “‘)<\/span>
\n\u6700\u5f8c\u5728A.aspx.cs\u63a5\u6536\u6b64PostBack\u53c3\u6578<\/p>\n

\n

\u203b\u7db2\u9801\u539f\u59cb\u6a94\u90e8\u4efd\u6709\u5167\u5efa\u7684\u6392\u7248(format)\u5de5\u5177\u55ce\uff1f<\/span><\/strong>
\n\u7db2\u9801\u5168\u9078\u5f8c\u6309\u53f3\u9375\uff0c\u9078\u64c7”\u683c\u5f0f\u5316\u9078\u53d6\u7bc4\u570d”<\/p>\n

\n

\u203b\u8981\u600e\u9ebc\u5efa\u7acb\u5168\u57df\u8b8a\u6578?<\/strong><\/span>
\n\u4e0d\u53ef\u4ee5\u7528\u4ee5\u4e0b\u5beb\u6cd5
\nprivate static int i;
\n\u56e0\u70ba\u5176\u4ed6\u4eba\u6253\u958b\u7db2\u9801\u6642\u6240\u6709\u4eba\u770b\u5230\u7684\u8b8a\u6578\u662f\u76f8\u540c\u7684
\n\u6bd4\u65b9\u8aaa\u6709\u500b\u7db2\u9801\u6709\u500b\u6309\u9215\uff0c\u9ede\u4e00\u4e0b\u6703\u57f7\u884ci++\uff0c\u756b\u9762\u4e0a\u6703\u986f\u793ai\u7684\u5167\u5bb9
\n\u7b2c\u4e00\u500b\u4eba\u9032\u4f86\u6642\u770b\u5230i=0\uff0c\u9ede\u4e86\u4e94\u6b21\uff0ci=5
\n\u7b2c\u4e8c\u500b\u4eba\u9032\u4f86\u6642\u6703\u770b\u5230i=5\u800c\u975ei=0
\n\u6bd4\u8f03\u597d\u7684\u65b9\u6cd5\u662f\u4f7f\u7528HiddenField\uff08\u4f46\u53ea\u80fd\u5132\u5b58string\uff09
\n\u6216\u7528ViewState[“key”]<\/span>\u7684\u65b9\u5f0f\u53bb\u5132\u5b58\/\u53d6\u5f97\u5167\u5bb9\uff08\u53ef\u4ee5\u5132\u5b58\u6240\u6709\u683c\u5f0f\uff09
\n\u5982\u679c\u5acc\u592a\u9ebb\u7169\u53ef\u4ee5\u9019\u6a23\u4f7f\u7528<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
private<\/code> int<\/code> value_name<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>get<\/code> { <\/code>return<\/code> (<\/code>int<\/code>)ViewState[<\/code>\"key\"<\/code>]; }<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>set<\/code> { ViewState.Add(<\/code>\"key\"<\/code>, value); }<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\u4f46\u662f\u5728Page_Load\u7684\u6642\u5019\u5c31\u5fc5\u9808\u7d66\u4ed6\u521d\u59cb\u503c\uff0c\u4e0d\u7136\u5728\u6c92\u6709\u521d\u59cb\u503c\u7684\u6642\u5019\u53d6\u503c\u6703\u51fa\u932f<\/p>\n

\n

\u203b\u5982\u4f55\u907f\u514dSQL\u885d\u7a81 (\u5169\u4eba\u4fee\u6539\u540c\u4e00\u7b46\u8cc7\u6599)<\/span><\/strong>
\n\u5047\u8a2d\u6709\u500b\u8cc7\u6599\u8868\u662f\u9019\u6a23(id\u662fPrimary Key)
\nid name
\n1\u00a0 \u5c0f\u660e
\n2\u00a0 \u5c0f\u83ef
\n\u5982\u679c\u8cc7\u6599\u5eab\u8981\u4fee\u6539\u6b04\u4f4d\u5167\u5bb9\uff0c\u4e00\u822cSQL\u6703\u5beb
\nUpdate name = @Name Where id = @id<\/span>
\n\u4f46\u5982\u679c\u540c\u6642\u6709\u5169\u500b\u4eba\u8981\u4fee\u6539\u5c0f\u660e\u7684name\uff0c\u5c31\u6703\u8b8a\u6210”\u5f8c\u9032\u5148\u5beb\u5165”
\n\u4e5f\u5c31\u662f\u5f8c\u9762\u5beb\u5165\u7684\u8cc7\u6599\u6703\u84cb\u904e\u524d\u9762\u5beb\u5165\u7684\u8cc7\u6599
\n\u89e3\u6c7a\u6cd5\u662f\u628aSQL\u6539\u5beb\u6210\u9019\u6a23
\nUpdate name = @Name Where id = @id and name = @origin_name<\/span>
\n\u9019\u6a23\u7576\u7b2c\u4e00\u500b\u4eba\u628a”\u5c0f\u660e”\u4fee\u6539\u6210”\u5c0f\u660e1″\u4e4b\u5f8c
\n\u7b2c\u4e8c\u500b\u4eba\u5c31\u7121\u6cd5\u627e\u5230name=\u5c0f\u660e\u7684\u8cc7\u6599\uff0c\u6240\u4ee5\u4e0d\u6703\u8986\u84cb\u5230\u7b2c\u4e00\u500b\u4eba\u7684\u4fee\u6539\u7d50\u679c<\/p>\n

\n

\u203bDropDownList\u8981\u600e\u9ebc\u6839\u64daText\u6216Value\u6539\u8b8a\u4ed6\u7684\u9078\u53d6\u503c<\/strong><\/span><\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n<\/td>\n
\n
\n
DropDownList1.SelectedIndex = DropDownList1.Items.IndexOf(DropDownList1.Items.FindByText(<\/code>\"text\"<\/code>));<\/code><\/div>\n
DropDownList1.SelectedValue = <\/code>\"XXX\"<\/code>;\u00a0\u00a0 <\/code>\/\/ \u5982\u679c\u53ea\u8981\u6839\u64daValue\u9078\u64c7\uff0c\u76f4\u63a5\u9019\u6a23\u5beb\u5c31\u597d<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\n

\u8981\u600e\u9ebc\u4f7f\u7528Ajax\u6280\u8853?<\/strong><\/span>
\n1. \u4f7f\u7528Ajax Control Toolkit\uff0c\u9019\u662f\u4e00\u500b\u7528\u7d14JavaScript\u5beb\u6210\u7684Ajax\u6280\u8853\uff0c\u90fd\u662f\u63a7\u5236\u9805\u5f62\u5f0f
\n2. \u4f7f\u7528jQuery \/ jQuery UI
\n3. \u4f7f\u7528Juice UI\uff0c\u9019\u662f\u4e00\u500b\u7528jQuery\u5beb\u6210\u7684Ajax\u6280\u8853\uff0c\u4e5f\u662f\u63a7\u5236\u9805\u5f62\u5f0f\uff0c\u4f46\u529f\u80fd\u4e0a\u6bd4jQuery UI\u5c11
\n\uff08\u53c3\u8003<\/a>\uff09<\/p>\n

\n

\u203b\u5982\u4f55\u628a\u63a7\u5236\u9805\u81ea\u52d5\u7522\u751f\u7684\u7de8\u865f\u6b78\u96f6\uff1f<\/span><\/strong>
\n\u6bcf\u62c9\u4e00\u500b\u63a7\u5236\u9805\uff0c\u6703\u5728\u5f8c\u9762\u81ea\u52d5\u589e\u52a0\u865f\u78bc\uff0c\u4f8b\u5982Label1, Label2
\n\u5176\u5be6\u90a3\u500b\u865f\u78bc\u662f\u53bb\u627e\u6700\u5927\u63a7\u5236\u9805\u7684\u865f\u78bc+1
\n\u6bd4\u65b9\u8aaa\u76ee\u524d\u7db2\u9801\u6709\u63a7\u5236\u9805Label1, Label99
\n\u4e0b\u4e00\u6b21\u62c9\u51fa\u7684\u63a7\u5236\u9805ID\u5c31\u6703\u81ea\u52d5\u547d\u540d\u70baLabel100
\n\u8981\u600e\u9ebc\u8b93\u4ed6\u6b78\u96f6\uff1f\u53ea\u8981\u628a\u524d\u9762\u865f\u78bc\u7684\u90fd\u522a\u6389\u5c31\u597d\u4e86
\n\u4e0a\u9762\u4f8b\u5b50\u4e2d\uff0c\u53ea\u8981\u628aLabel99\u522a\u6389\uff0c\u4e0b\u6b21\u81ea\u52d5\u547d\u540d\u5c31\u662fLabel2<\/p>\n

\n

\u203b\u7522\u751f\u672c\u6a5f\u8cc7\u6e90\u5f8c\u5f8c\u6094\u4e86\uff0c\u8981\u600e\u9ebc\u79fb\u9664\u6389\u8a72\u9801\u63a7\u5236\u9805\u7684meta:resourcekey=xxx<\/span><\/strong>
\n\u5c0b\u627e\u76ee\u6a19\u00a0meta\\:resourcekey=[^:b>]*”<\/span>
\n\u53d6\u4ee3\u6210 (\u4e0d\u8f38\u5165)
\n\u4e26\u4f7f\u7528\u898f\u5247\u904b\u7b97\u5f0f\u5373\u53ef<\/p>\n

\"replace_meta_resource\"<\/p>\n

\n

\u203bDateTime\u8981\u600e\u9ebc\u91cd\u65b0\u8a2d\u5b9a\u6642\u9593\uff0c\u4e14\u4e0d\u4f7f\u7528new<\/span><\/strong>
\n\u6c92\u6709\u8fa6\u6cd5\uff0c\u8acb\u76f4\u63a5\u7528new\u7d66\u4e88\u65b0\u503c<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n<\/td>\n
\n
\n
DateTime dt = <\/code>new<\/code> DateTime(2012, 12, 12);<\/code><\/div>\n
dt = <\/code>new<\/code> DateTime(2011, 11, 11);<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

DateTime\u662fstruct\uff0c\u6240\u4ee5\u76f4\u63a5\u53d6\u4ee3\u6389\u5c31\u597d\u4e86
\nstruct\u662fvalue type\uff0c\u6240\u4ee5\u4e26\u4e0d\u6703\u6d6a\u8cbb\u8a18\u61b6\u9ad4<\/p>\n

\n

\u203b\u5982\u4f55\u8b93DateTime\u6307\u5b9a\u70ba\u8a72\u6708\u6700\u5f8c\u4e00\u5929?<\/span><\/strong>
\n1.\u00a0DateTime.DaysInMonth(year, month);<\/span>
\n2.\u00a0new DateTime(year, month, 1).AddMonths(1).AddDays(-1);<\/span><\/p>\n

\n

\u203b\u5982\u4f55\u8df3\u51fa\u4e00\u500b\u6708\u66c6\u8b93\u4f7f\u7528\u8005\u9078\u53d6\u65e5\u671f?<\/span><\/strong>
\n1. \u7528Ajax Control Toolkit\u7684CalendarExtender
\n2. \u7528jQuery UI\u7684Datepicker
\n3. \u7528\u5c08\u9580\u986f\u793a\u6708\u66c6\u7684\u5957\u4ef6\uff0c\u5982JSCal2<\/a>\uff08\u9084\u80fd\u9078\u6642\u9593\uff09<\/p>\n

\n

\u203b\u8981\u600e\u9ebc\u7528SqlDataReader\u8b80\u53d6SqlDataSource\u7684Select?<\/span><\/strong><\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n<\/td>\n
\n
\n
\/\/ \u5c07SqlDataSource\u7684Select\u8f49\u6210SqlDataReader\u7269\u4ef6\u7684\u65b9\u6cd5<\/code><\/div>\n
\/\/ \u7279\u5225\u6ce8\u610f: \u5fc5\u9808\u5148\u5c07SqlDataSource\u7684DataSourceMode\u5c6c\u6027\u8a2d\u5b9a\u70ba\"DataReader\"\uff0c\u5426\u5247\u8f49\u578b\u6703\u5931\u6557<\/code><\/div>\n
using<\/code> (SqlDataReader reader = SqlDataSource1.Select(DataSourceSelectArguments.Empty) <\/code>as<\/code> SqlDataReader)<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>while<\/code> (reader != <\/code>null<\/code> && reader.Read())<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>reader[<\/code>\"xxx\"<\/code>].ToString();<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
}<\/code><\/div>\n
<\/div>\n
\/\/ \u5c07SqlDataSource\u7684Select\u8f49\u6210DataTable\u7269\u4ef6\u7684\u65b9\u6cd5<\/code><\/div>\n
\/\/ \u7279\u5225\u6ce8\u610f: SqlDataSource\u7684DataSourceMode\u5c6c\u6027\u5fc5\u9808\u70ba\"DataSet\" (\u9019\u662f\u9810\u8a2d\u503c)<\/code><\/div>\n
DataTable dt = (SqlDataSource1.Select(DataSourceSelectArguments.Empty) <\/code>as<\/code> DataView).ToTable();<\/code><\/div>\n
<\/div>\n
\/\/ \u9806\u4fbf\u4e00\u63d0\uff0cSqlDataReader\u6240\u5360\u7528\u7684\u8cc7\u6e90\u6bd4\u8d77DataTable\u5c0f\u5f88\u591a<\/code><\/div>\n
\/\/ \u82e5\u6c92\u6709\u8981\u5c0d\u8cc7\u6599\u8868\u4f5c\u8655\u7406\uff0c\u53ef\u76e1\u91cf\u4f7f\u7528SqlDataReader<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\n

\u203bSQL\u8981\u600e\u9ebc\u628a\u5f88\u591a\u7b46\u8cc7\u6599(multi row)\u8b8a\u6210\u55ae\u884c\u5b57\u4e32(single string)\uff1f<\/span><\/strong>
\u6bd4\u65b9\u8aaa\u4eca\u5929\u6709\u8cc7\u6599\u5982\u4e0b
\nID Name
\n1 Name1
\n1 Name2
\n2 Name1
\n2 Name3
\n2 Name5
\n\u5e0c\u671b\u8f49\u6210\u4ee5\u4e0b\u7684\u6b04\u4f4d
\nID Name
\n1 Name1,Name2
\n2 Name1,Name3,Name5<\/p>\n

\u5982\u679c\u662fMSSQL\u6709\u500b\u5077\u5403\u6b65\u7684\u65b9\u6cd5\uff0c\u5c31\u662f\u4f7f\u7528FOR XML PATH(”)<\/span>\u8a9e\u6cd5
\n\u5c07\u53d6\u5f97\u7684\u6b04\u4f4d\u8f49\u8b8a\u6210\u4e00\u500b\u7528\u7a7a\u767dtag\u5305\u8986\u7684XML\u5167\u5bb9<\/p>\n

SELECT A.ID,
\n(
\nSELECT B.Name + ‘,’
\nFROM [TableB] AS B
\nWHERE B.ID = A.ID
\nFOR XML PATH(”)
\n) AS Name
\nFROM [TableA] As A<\/p>\n

\n

===========[ \u932f\u8aa4\u4fee\u6b63 ]===========<\/span><\/strong><\/p>\n

\u203bDropDownList\u7576\u9805\u76ee\u6709\u76f8\u540c\u7684Value\u7684\u6642\u5019\uff0c\u9ede\u9078\u7684\u7d50\u679c\u4e0d\u6b63\u78ba<\/span><\/strong>
\n\u9019\u500b\u554f\u984c\u662fPostBack\u7684\u539f\u7f6a\uff0c\u76f8\u540cValue\u6642\u56de\u50b3\u7d66Server\u7684\u503c\u662f\u76f8\u540c\u7684\uff08\u53c3\u8003<\/a>\uff09
\n1. \u81ea\u5df1\u5bebDropDownList\u63a7\u5236\u9805\u89e3\u6c7a
\n2. \u5728\u7d81\u5b9a\u5f8c\u81ea\u5df1\u4fee\u6539item value\uff0c\u4f7f\u5176\u4e0d\u91cd\u8907<\/p>\n

\n

\u203b\u4f7f\u7528\u81ea\u8a02\u5143\u4ef6\u6642\u51fa\u73fe\u300c\u7121\u6cd5\u5728\u5c6c\u6027xxx \u8a2d\u5b9axxx\u300d<\/span><\/strong>
\n\u9019\u662fVisual Studio 2008\u7684\u56fa\u6709Bug\uff0c\u89e3\u6c7a\u6cd5\uff1a\u8acb\u4e0b\u8f09\u66f4\u65b0\u6a94
\n\uff08\u66f4\u65b0\u6a94<\/a>\uff09\uff08\u53c3\u8003<\/a>\uff09<\/p>\n

\n

\u203b\u4f7f\u7528\u52d5\u614b\u8a3b\u518aJS\u4e4b\u5f8c\uff0c\u67d0\u4e9bTextBox\u8f38\u5165\u7684\u6587\u5b57\u6703\u6d88\u5931<\/span><\/strong>
\n\u4e0d\u8981\u7528RegisterClientScriptBlock\u8ddfRegisterClientScriptInclude
\n\u4f7f\u7528RegisterStartupScript<\/span>\uff0c\u4ed6\u6703\u628aJS\u653e\u5230\u7db2\u9801\u6700\u4e0b\u9762\uff0c\u78ba\u4fdd\u524d\u9762\u7684JS\u6703\u88ab\u57f7\u884c\u5230\uff08\u53c3\u8003<\/a>\uff09<\/p>\n

\n

\u203bGridView\u67d0\u6b04\u4f4d\u5728\u8a2d\u5b9aVisible=false\u5f8c\uff0cPostBack\u4e4b\u5f8c\u7121\u6cd5\u53d6\u5f97\u8a72\u6b04\u4f4d\u7684\u503c<\/strong><\/span>
\n\u56e0\u70ba\u9019\u500b\u6b04\u4f4d\u5728\u4e00\u958b\u59cb\u7522\u751f\u7db2\u9801\u7684\u6642\u5019\u5c31\u4e0d\u6703\u5beb\u9032\u53bb\uff0c\u6240\u4ee5\u81ea\u7136\u7121\u6cd5\u53d6\u5f97\u4e0d\u5b58\u5728\u7684\u8cc7\u6599
\n\u89e3\u6c7a\u6cd5
\n1. HeaderStyle\u8ddfItemStyle\u8a2d\u5b9aCSS\uff0cCSS\u5167\u5bb9\u70badisplay:none;
\n\u9019\u6a23\u5c31\u6703Bind\u8cc7\u6599\uff0c\u4e14\u5728\u756b\u9762\u4e0a\u770b\u4e0d\u5230\u8a72\u6b04\u4f4d
\n2. \u5728RowDataBound\u7684\u6642\u5019\u6307\u5b9a\u8a72\u6b04\u4f4dVisible = false;
\n\u4f46\u6709\u58de\u8655\u5c31\u662f\u5982\u679c\u4f60\u7684GridView\u6c92\u6709\u8cc7\u6599\u4e14\u6c92\u8cc7\u6599\u6642\u53ef\u4ee5\u986f\u793a\u6a19\u984c\u6b04
\n\u56e0\u70ba\u6c92\u8cc7\u6599\u6642\u4e0d\u6703\u547c\u53ebRowDataBound\uff0c\u6240\u4ee5\u8a72\u6b04\u6a19\u984c\u6703\u986f\u793a
\n\u56e0\u6b64\u5efa\u8b70\u9084\u662f\u4f7f\u7528\u7b2c\u4e00\u7a2e\u65b9\u6cd5<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n<\/td>\n
\n
\n
protected<\/code> void<\/code> GridView1_RowDataBound(<\/code>object<\/code> sender, GridViewRowEventArgs e)<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>if<\/code> (e.Row.RowType == DataControlRowType.Header || e.Row.RowType == DataControlRowType.DataRow)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>e.Row.Cells[0].Visible = <\/code>false<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>}<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\n

\u203b\u8a2d\u5b9aGridView\u7684SelectIndex\u5f8c\uff0c\u4e0d\u6703\u89f8\u767cSelectedIndexChanged\u4e8b\u4ef6?<\/span><\/strong>
\n\u662f\u7684\uff0c\u6bcf\u6b21\u5beb\u4e86\u66f4\u63dbSelectIndex\u5f8c\u4f60\u8981\u81ea\u884c\u53bb\u547c\u53ebSelectedIndexChanged
\n.NET 4.0\u5f88\u597d\u5fc3\u7684\u52a0\u4e86SelectRow\u65b9\u6cd5\uff0c\u53ef\u4ee5\u8a2d\u5b9aIndex\u5f8c\u81ea\u52d5\u547c\u53ebSelectedIndexChanged\u4e8b\u4ef6<\/p>\n

\n

\u203bIE 9\u7684CSS Selector\u8ddf\u5176\u4ed6\u700f\u89bd\u5668\u4e0d\u540c\uff0c\u5c0e\u81f4\u5713\u89d2\u77e9\u5f62\u986f\u793a\u4e0a\u6709\u554f\u984c<\/strong><\/span>
\n\u9019\u60c5\u6cc1\u6211\u5efa\u8b70\u5f37\u8febIE 9\u4f7f\u7528IE 8\u7684\u7db2\u9801\u6392\u7248\u65b9\u5f0f\uff0c\u9019\u6a23\u5713\u89d2\u77e9\u5f62\u7684\u554f\u984c\u5c31\u4e0d\u7528\u9ebb\u7169\u4e86
\n\u65b9\u6cd5\u6709\u5169\u7a2e\uff0c\u4e00\u7a2e\u662f\u76f4\u63a5\u5728aspx\u4e2d<title>\u7684\u4e0b\u65b9\u52a0\u4e0a
\n<meta http-equiv=”X-UA-Compatible” content=”IE=8″ \/><\/span>
\n\u6216\u662f\u5728aspx.cs\u52d5\u614b\u52a0\u4e0a\u9019\u6bb5<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n<\/td>\n
\n
\n
protected<\/code> void<\/code> Page_Init(<\/code>object<\/code> sender, EventArgs e)<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>Context.Response.AddHeader(<\/code>\"X-UA-Compatible\"<\/code>, <\/code>\"IE=8\"<\/code>);<\/code><\/div>\n
}<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\n

===========[ \u89c0\u5ff5\u89e3\u6790 ]===========<\/span><\/strong><\/p>\n

\u203b\u5efa\u8b70\u7528WebConfigurationManager\u53d6\u4ee3ConfigurationManager<\/span><\/strong>
\n\uff08\u53c3\u8003<\/a>\uff09
\n\u4e00\u822c\u66f8\u4e0a\u90fd\u7528ConfigurationManager\u53d6\u5f97Web.config\u7684\u8a2d\u5b9a\u503c
\n\u5176\u5be6WebConfigurationManager\u624d\u662f\u6b63\u7d71\u7684\u4f5c\u6cd5
\n\u96d6\u7136\u5169\u8005\u76ee\u524d\u662f\u901a\u7528\u7684\uff0c\u4e0d\u904e\u7528\u6b63\u7d71\u65b9\u6cd5\u9084\u662f\u6bd4\u8f03\u4fdd\u96aa\u4e00\u9ede<\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n
2<\/div>\n<\/td>\n
\n
\n
WebConfigurationManager.ConnectionStrings[<\/code>\"xx\"<\/code>].ConnectionString;\u00a0\u00a0 <\/code>\/\/ \u6a19\u6e96\u5beb\u6cd5<\/code><\/div>\n
WebConfigurationManager.AppSettings[<\/code>\"xx\"<\/code>];\u00a0\u00a0 <\/code>\/\/ \u6a19\u6e96\u5beb\u6cd5<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\n

\u203b\u5b57\u4e32\u76f4\u63a5\u4e32\u63a5\u6bd4\u8f03\u597d\u9084\u662f\u7528string.Format\u4e32\u63a5\u6bd4\u8f03\u597d?<\/span><\/strong>
\n\u7528string.Format\u4e32\u63a5\u6bd4\u8f03\u5feb\uff0c\u56e0\u70ba\u5176\u5167\u90e8\u662f\u4f7f\u7528StringBuilder\u5be6\u4f5c<\/p>\n

\n

\u203b\u7528string.Empty\u597d\u9084\u662f””\u597d?<\/span><\/strong>
\n.NET 2.0\u4e4b\u524d\uff0c””\u6703\u7522\u751f\u4e00\u500b\u65b0\u7269\u4ef6\uff0c.NET 2.0\u5f8c\u5beb\u54ea\u500b\u90fd\u4e00\u6a23
\n\u500b\u4eba\u5efa\u8b70\u4f7f\u7528””\uff0c\u56e0\u70ba\u7a0b\u5f0f\u78bc\u8d8a\u77ed\u8d8a\u597d
\n\uff08\u53c3\u80031<\/a>\uff09\uff08\u53c3\u80032<\/a>\uff09<\/p>\n

\n

\u203bstring\u8ddfString\u6709\u4ec0\u9ebc\u4e0d\u540c?<\/span><\/strong>
\n\u5b8c\u5168\u4e00\u6a23\uff0cstring\u662fString\u7684\u5225\u540d
\n\u4f46\u5982\u679c\u662f\u8981\u5ba3\u544a\u8b8a\u6578\uff0c\u500b\u4eba\u5efa\u8b70\u7528string\u6bd4\u8f03\u7d71\u4e00\uff08\u53c3\u8003<\/a>\uff09<\/p>\n

\n

\u203bdecimal\u8ddfdouble\u7684\u5dee\u5225?<\/span><\/strong>
\nDecimal \u4e0d\u662f\u6d6e\u9ede\u6578\u8cc7\u6599\u578b\u5225\u3002Decimal \u7d50\u69cb\u6703\u4fdd\u5b58\u4e8c\u9032\u4f4d\u6574\u6578\u503c\uff0c\u52a0\u4e0a\u6b63\u8ca0\u865f\u4f4d\u5143\u548c\u6574\u6578\u7e2e\u653e\u6bd4\u4f8b\uff0c\u6307\u5b9a\u503c\u7684\u54ea\u4e00\u90e8\u5206\u662f\u5c0f\u6578\u90e8\u5206\u3002
\n\u7c21\u55ae\u7684\u8aaa\uff0cdouble\u56e0\u70ba\u662f\u7528byte\u53bb\u5132\u5b58\u5c0f\u6578\uff0c\u6240\u4ee5\u6bcf\u6b21\u90fd\u6703\u6709\u8aa4\u5dee\uff0c\u800cdecimal\u662f\u7528\u5341\u9032\u4f4d\u53bb\u5b58\u5c0f\u6578\uff0c\u6240\u4ee5\u4e0d\u6703\u6709\u8aa4\u5dee
\n\u5982\u679c\u8981\u5132\u5b58\u91d1\u984d\u7b49\u9019\u7a2e\u4e0d\u5141\u8a31\u8aa4\u5dee\u7684\u6578\u503c\uff0c\u5c31\u8981\u7528decimal\uff08\u53c3\u8003<\/a>\uff09<\/p>\n

\n

\u203bint, double\u662fclass\u55ce?<\/strong><\/span>
\n\u4e0d\u662f\uff0c\u5176\u5be6\u662fstruct\uff0c\u53ef\u80fd\u662f\u56e0\u70ba\u8655\u7406\u901f\u5ea6\u4e0a\u6bd4\u8f03\u5feb\u7684\u95dc\u4fc2<\/p>\n

\n

\u203b\u6240\u4ee5string\u4e5f\u662fstruct\u55ce?<\/span><\/strong>
\n\u4e0d\u662f\uff0cstring\u662fclass\uff0c\u53ef\u4ee5\u7576object\u4f86\u7528\uff0c\u4e0d\u50cfstruct\u50b3\u905e\u4e00\u6b21\u5c31\u8981copy\u4e00\u6b21
\n\u53e6\u5916\u5c31\u662fstring pool\u7684\u554f\u984c\uff0c\u7528struct\u61c9\u8a72\u6703\u6709\u56f0\u96e3<\/p>\n

\n

\u203b\u90a3\u70ba\u4ec0\u9ebcList\u53ef\u4ee5\u76f4\u63a5\u653e\u57fa\u672c\u578b\u5225?<\/span><\/strong><\/p>\n

\n
\n
?<\/a><\/div>\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
List<<\/code>int<\/code>> list = <\/code>new<\/code> List<<\/code>int<\/code>>();\u00a0\u00a0 <\/code>\/\/ \u50cf\u9019\u6a23<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

\u56e0\u70baC#\u6703\u81ea\u52d5\u5e6b\u4f60\u505a\u8f49\u63db\uff08\u53c3\u8003<\/a>\uff09<\/p>\n

\n

\u203bas\u8ddf\u5f37\u5236\u8f49\u578b\u6709\u4ec0\u9ebc\u5dee\u5225?<\/span><\/strong>
\n\u5982\u679c\u4e0d\u80fd\u8f49\u578b\u7684\u8a71\uff0cas\u6703\u56de\u50b3null\uff0c\u5f37\u5236\u8f49\u578b\u6703\u4e1f\u51faException<\/p>\n

\n

\u203bLabel\u8ddfLiteral\u6709\u4ec0\u9ebc\u5dee\u5225?<\/span><\/strong>
\nLabel\u5728\u7de8\u8b6f\u6210\u7db2\u9801\u6642\u6703\u7528span\u5305\u8d77\u4f86\uff0cLiteral\u5247\u6703\u76f4\u63a5\u8f49\u6210\u7db2\u9801\u6587\u5b57
\n\u53e6\u5916Label\u53ef\u4ee5\u8a2d\u5b9aCSS style\uff0cLiteral\u5247\u5426
\n\u5982\u679c\u5728\u7d14\u986f\u793a\u6587\u5b57\u7684\u60c5\u6cc1\uff0c\u5efa\u8b70\u76f4\u63a5\u7528Literal\uff0c\u9019\u6a23\u80fd\u7528CSS\u76f4\u63a5\u8abf\u6574\u6574\u500b\u9801\u9762\u7684\u5b57\u578b<\/p>\n

\n

\u203bint.Parse\u8ddfConvert.ToInt32\u6709\u4ec0\u9ebc\u5dee\u5225?<\/span><\/strong>
\n1. int.Parse\u53ea\u80fd\u50b3\u5165string\uff0cConvert.ToInt32\u53ef\u4ee5\u8b80\u53d6\u5404\u7a2e\u578b\u614b
\n2. \u7576\u50b3\u5165\u53c3\u6578\u70banull\u6642\uff0cint.Parse\u6703\u62cb\u51faexception\uff0cConvert.ToInt32\u6703\u56de\u50b30
\n\uff08\u53c3\u8003<\/a>\uff09<\/p>\n

\n

\u203bif\u8ddfswitch\u54ea\u500b\u6548\u7387\u8f03\u597d?<\/span><\/strong>
\n\u5224\u65b7int\u7684\u60c5\u6cc1\uff0cswitch\u5b8c\u52dd\uff0c\u5c31\u7b97\u5728\u7b2c\u4e00\u500b\u689d\u4ef6\u5c31\u7b26\u5408\u7684\u60c5\u6cc1\u4e0b\uff0c\u9084\u662fswitch\u8f03\u5feb
\n\u9019\u662f\u56e0\u70baswitch\u6703\u5efa\u7acbbinary decision tree\uff0c\u6240\u6709\u7684case\u90fd\u8017\u6642O(1)
\n\u6240\u4ee5\u9069\u5408\u7528switch\u7684\u60c5\u6cc1\u5c31\u76e1\u91cf\u4e0d\u8981\u7528if
\n\u7576\u7136if\u80fd\u7528\u8907\u5408\u689d\u4ef6\u5224\u65b7\uff0c\u5728\u4f7f\u7528\u4e0a\u6bd4\u8f03\u9748\u6d3b
\n\u4ee5\u4e0b\u70ba\u6e2c\u8a66\u7d50\u679c
\nif(1) = 00:00:00.0320018
\nif(2) = 00:00:00.0430024
\nif(3) = 00:00:00.0470027
\nif(4) = 00:00:00.0600034
\nif(5) = 00:00:00.0630036
\nif(6) = 00:00:00.0730041
\nif(7) = 00:00:00.0820047
\nif(8) = 00:00:00.0880050
\nswitch(1) = 00:00:00.0230013
\nswitch(2) = 00:00:00.0230013
\nswitch(3) = 00:00:00.0230013
\nswitch(4) = 00:00:00.0250014
\nswitch(5) = 00:00:00.0240014
\nswitch(6) = 00:00:00.0250014
\nswitch(7) = 00:00:00.0240014
\nswitch(8) = 00:00:00.0240014<\/p>\n

\u4e0d\u904e\u5224\u65b7string\u7684\u60c5\u6cc1\uff0c\u82e5\u524d\u9762\u689d\u4ef6\u5c31\u7b26\u5408\u7684\u8a71\uff0cif\u6703\u6bd4\u8f03\u5feb
\n\u4ee5\u4e0b\u70ba\u6e2c\u8a66\u7d50\u679c
\nif(1) = 00:00:00.1010058
\nif(2) = 00:00:00.1510086
\nif(3) = 00:00:00.2160124
\nif(4) = 00:00:00.2850163
\nif(5) = 00:00:00.3520201
\nif(6) = 00:00:00.4160238
\nif(7) = 00:00:00.4860278
\nif(8) = 00:00:00.5600321
\nswitch(1) = 00:00:00.3790217
\nswitch(2) = 00:00:00.3810218
\nswitch(3) = 00:00:00.4210241
\nswitch(4) = 00:00:00.3800217
\nswitch(5) = 00:00:00.3820219
\nswitch(6) = 00:00:00.3900223
\nswitch(7) = 00:00:00.3850220
\nswitch(8) = 00:00:00.3800217<\/p>\n

\n

===========[ \u5de5\u5177\u9023\u7d50 ]===========<\/span><\/strong><\/p>\n

\u203b\u4fee\u6b63\u820a\u7248IE\u4e0d\u80fd\u986f\u793aPng\u900f\u660e\u5ea6\u7684\u554f\u984c<\/span><\/strong>
\nIEPngFix<\/a><\/p>\n

\n

\u203bJS\u7dda\u4e0a\u6392\u7248\u5de5\u5177<\/span><\/strong>
\nOnline JavaScript beautifier<\/a><\/p>\n

\n

\u203bCSS\u6f38\u5c64\u7522\u751f\u5668<\/span><\/strong>
\nUltimate CSS Gradient Generator<\/a>
\n\u8ddf\u4e00\u822c\u7522\u751f\u5668\u4e0d\u540c\u7684\u662f\uff0c\u4ed6\u7684\u8a9e\u6cd5\u80fd\u652f\u63f4\u5230IE 6~9
\n\u6703\u4e00\u4f75\u7522\u751ffilter: progid:DXImageTransform.Microsoft.gradient<\/p>\n

\n

\u203bCSS3\u6309\u9215\u7522\u751f\u5668<\/span><\/strong>
\nCSS3 Button Generator<\/a>
\n\u9664\u4e86\u57fa\u672c\u7522\u751f\u6309\u9215\u7684\u529f\u80fd\u5916\uff0c\u9084\u80fd\u4f7f\u7528\u5225\u4eba\u5206\u4eab\u8abf\u6574\u597d\u7684\u6309\u9215\u6a23\u5f0f<\/p>\n

\n

\u203b\u52a0\u5f37Visual Studio\u7684\u5916\u639b\u7a0b\u5f0f<\/span><\/strong>
\nVisual Assist X<\/a>
\n\u80fd\u8b93Visual Studio\u591a\u4e86\u5f88\u591a\u5be6\u7528\u7684\u529f\u80fd\uff0c\u50cf\u662f\u7a0b\u5f0f\u78bc\u66f4\u591a\u984f\u8272
\n\u7a0b\u5f0f\u78bc\u81ea\u52d5\u5b8c\u6210\u5217\u51fa\u7684\u5167\u5bb9\u66f4\u52a0\u5207\u984c
\n\u9078\u64c7\u65b9\u6cd5\u5f8c\u6703\u81ea\u52d5\u52a0\u4e0a\u62ec\u5f27()
\n\u591a\u4e86\u4e00\u4e9b\u5feb\u901f\u9375\uff08\u5982\u6309\u4e0bShift+8\u53ef\u4ee5\u628a\u4e00\u6bb5\u7a0b\u5f0f\u78bc\u7528\/* *\/<\/span>\u5305\u8d77\u4f86\uff09
\n\u91cd\u69cb\u4e5f\u66f4\u52a0\u5feb\u901f\u65b9\u4fbf
\n\u800c\u4e14\u529f\u80fd\u90fd\u662f\u53ef\u4ee5\u81ea\u884c\u9078\u64c7\u662f\u5426\u8981\u555f\u7528
\n\u652f\u63f4\u7248\u672c\u5f88\u591a\uff0c\u5f9e\u65e9\u671f\u7684VS6\u5230\u6700\u65b0\u7684VS2012\u90fd\u53ef\u4ee5\u4f7f\u7528
\n\u53ef\u60dc\u7684\u662f\u9019\u662f\u5171\u4eab\u8edf\u9ad4\uff0c\u53ea\u670930\u5929\u8a66\u7528<\/p>\n","protected":false},"excerpt":{"rendered":"

\u4f86\u6e90 http:\/\/catchtest.pixnet.net\/blog\/post\/28219055-asp.n … \u95b1\u8b80\u5168\u6587\u3008[\u8f49]ASP.NET \u4f7f\u7528\u7b46\u8a18\u3009<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/2530"}],"collection":[{"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2530"}],"version-history":[{"count":1,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/2530\/revisions"}],"predecessor-version":[{"id":2531,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=\/wp\/v2\/posts\/2530\/revisions\/2531"}],"wp:attachment":[{"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2530"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2530"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kuki.idv.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2530"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}