asp.netè°ç¨SQLSERVERè§å¾çè¿ç¨ï¼åæ¥è¯¢è¡¨çè¯æ³æ¯ä¸æ ·çãå 为å¨SQLä¸è§å¾çè¯ï¼åºæ¬å¯ä»¥ç解为ä¸ä¸ªèæ表ãå
¶ä½ç¨ä¸»è¦ä½ç°å¨å¦ä¸å ç¹ï¼
è§å¾çä½ç¨ï¼
ãã1 è§å¾å¯ä»¥ç®åç¨æ·çæä½
ããè¯å¾æºå¶ä½¿ç¨æ·å¯ä»¥å°æ³¨æåéä¸å¨æå
³å¿çæ°æ®ä¸
ãã2 è§å¾ä½¿ç¨æ·è½ä»¥å¤ç§è§åº¦çå¾
åä¸æ°æ®ï¼å½è®¸å¤ä¸åç§ç±»çç¨æ·å
±äº«åä¸æ°æ®åºæ¶ï¼è¿ç§çµæ´»æ§å¾éè¦
ãã3è§å¾å¯¹éææ°æ®åºæä¾äºä¸å®ç¨åº¦çé»è¾ç¬ç«æ§
ãã4 è§å¾è½å¤å¯¹æºå¯æ°æ®æä¾å®å
¨ä¿æ¤ï¼æäºè§å¾æºå¶ï¼å°±å¯ä»¥å¨è®¾è®¡æ°æ®å¯åºç¨ç³»ç»æ¶ï¼å¯¹ä¸åçç¨æ·å®ä¹ä¸åçè§å¾ï¼ä½¿æºå¯æ°æ®ä¸åºç°å¨ä¸åºçå°è¿äºæ°æ®çç¨æ·è§å¾ä¸
ãã5éå½çå©ç¨è§å¾å¯ä»¥æ´æ¸
æ°ç表达æ¥è¯¢
è§å¾æ¬èº«è¿æ¯å»ºç«å¨ç°æç表çåºç¡ä¸ï¼å
¶è°ç¨ä»£ç å¦ä¸ï¼
using (SqlConnection cn = new SqlConnection())
{
cn.ConnectionString = âserver=.;å®é
è¿æ¥å符串";
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
//è°ç¨è§å¾,å表çè¯æ³æ¯ä¸æ ·çã
cmd.CommandText = @"SELECT * from v_MyView where id=1";
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
return dt;
}
温馨提示:答案为网友推荐,仅供参考