ASP.NET·ÀSQL×¢Èë½Å±¾³ÌÐò
public class SqlCheck
{
public SqlCheck()
{
//
// TODO: ÔÚ´Ë´¦Ìí¼Ó¹¹Ô캯ÊýÂß¼
//
}
public SqlConnection oconn()
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["StudyConnectionString"].ToString();
//µÚ1ÖÖµ÷Óõķ½·¨ JK1986_CheckSql();
JK1986_CheckSql();
if ( conn.State == ConnectionState.Closed )
{
conn.Open();
}
return conn;
}
public DataTable getsource(string getds)
{
SqlConnection conn = oconn();
SqlDataAdapter da = new SqlDataAdapter(getds, conn);
DataSet ds = new DataSet();
da.Fill(ds,"news" );
return ds.Tables["news"];
 
Ïà¹ØÎĵµ£º
µÚÒ»ÖÖ·½·¨£ºÊ¹ÓÃNVLº¯Êý´¦ÀíNULLÖµ¡£
ÆäÓï·¨¸ñʽÊÇNVL(exp1,exp2)¡£ÆäÖвÎÊýexp1ºÍexp2¿ÉÒÔʹÈÎÒâÊý¾ÝµÄÀàÐÍ£¬µ«Á½ÕßÊý¾ÝÀàÐͱØÐëÆ¥Å䡣ʾÀý£ºselect ename,sal,comm,sal+nvl(comm,0) as salary from emp;
µÚ¶þÖÖ·½·¨£ºÊ¹ÓÃNVL2º¯Êý´¦ÀíNULLÖµ¡£
ÆäÓï·¨¸ñʽÊÇNVL2(exp1,exp2,exp3)¡£ÕâÊÇoracle9iÐÂÔö¼ÓµÄº¯Êý¡£Èç¹ûexp1 ......
1¡¢INSTR4(string1,string2[,a][,b]) ·µ»Østring1Öаüº¬string2µÄλÖÃaºÍbÊÇÒÔUCS4´úÂëµãΪµ¥Î»¡£
ÒÔÉϺ¯Êý·µ»Østring1Öаüº¬string2µÄλÖᣴÓ×ó±ß¿ªÊ¼É¨Ãèstring1,ÆðʼλÖÃÊÇA¡£Èç¹ûAΪ¸ºÊýÄÇô´ÓÓұ߿ªÊ¼É¨Ãè¡£µÚB´Î³öÏÖµÄλÖý«±»·µ»Ø¡£AºÍBȱʡ¶¼Îª1£¬¼´·µ»ØÔÚ
string1ÖеÚÒ»´Î³öÏÖstring2µÄλÖá£Èç¹ûstring2ÔÚAº ......
ÎÊÌâÃèÊö£º
Express°æÓÃsaÕÊ»§µÇ¼ʱʧ°Ü
½â¾ö·½°¸£º
µÚÒ»²½£ºÓÃWindowsÉí·ÝµÇ¼Management Studio£¬ÓÒ»÷·þÎñÆ÷Ñ¡ÔñÊôÐÔ£¬½«°²È«ÐÔÑ¡Ïî ¸ü¸ÄΪ:SQL Server ºÍ Windows
Éí·ÝÑéÖ¤
& ......
asp.net¸öÈËѧϰÀú³Ì³õѧµ½¾«Í¨ ÊÕ²Ø
Èç¹ûÄãÊÇÒ»¸ö²ËÄñ»òÕß×ÔÈÏΪ³õѧÕßÄÇô±¾Îķdz£ÊʺÏÄ㣻
²»ÄÜ˵Õâ30±¾Êé¾ÍÊÇ×î¼Ñ×éºÏ£¬µ«ÊÇ¿ÉÒÔ˵Õâ¸ö×éºÏ²»²î£»
±¾ÈËÔø²©ÀÀȺÊ飬ºÜ¶àÊéÖظ´£¬ºÜ¶àÊé½²µÄ²»ÊÊÓã¬ÕâЩÊ鶼ÊÇÄ¿Ç°Êéµê¿ÉÒÔÂòµ½µÄ£»
´ïµ½Öм¶³ÌÐòÔ±ÒÔºóÔõô³ÉΪ¸ß¼¶³ÌÐòÔ±¾Í¿¿Äã×Ô¼ºÁË£¬¶ø´ËʱÄãÒѾ ......
·µ»ØÉÏÒ»Ò³µÄÕâ¸ö¶«¶«ÔÚÎÒÃÇ×öÏîÄ¿µÄʱºòÒ»°ãÊÇÓÃÓÚÌîдÍê±íµ¥ºóÈ·ÈϵÄʱºò£¬ÓжÔÔÀ´ÊäÈëµÄÊý¾Ý½øÐÐÐÞ¸Äʱ
Óõģ¬»òÕßÊÇÒòΪÍøվΪÁË·½±ãä¯ÀÀÕ߶øÓÐÐÄÌí¼ÓµÄÒ»¸ö¶«¶«£¬Ò»°ãÕâÖÖ¹¦ÄܵÄʵÏÖÔÚASP.netÖж¼ÊÇÓÃÒ»¸öbuttonµÄ¿Ø¼þÀ´ÊµÏֵģ¬ÊµÏֵķ½·¨ÓкÜ
¶à£¬½ñÌìÇ¡ºÃÔÚ×öÏîĿʱÅöµ½ÒªÓÃÕâ¸ö¶«¶«£¬ÎҾͰÑÄÜʵÏÖ" · ......