datagirdviewºÍlistview,ɾ¸Ä²ésqlserverÊý¾Ý¿âµÄС½á
//´´½¨DBhelperÊý¾Ý¿âÁ´½ÓÎļþ
private static string sqlcon = "server=.;database=myschool;uid=sa;pwd=sa";
public static SqlConnection connection = new SqlConnection(sqlcon);
============================================================
//Ê×ÏÈÊÇlv¿Ø¼þµÄÁбíÏÔʾ ,(listview)
// Çå¿Õµ±Ç°lv±íÖÐÄÚÈÝ
listview.Items.Clear();
string sql = "select * from question";
//ÒýÓÃDBhelperÖеÄÊý¾Ý¿âÁ´½Ó
SqlCommand command = new SqlCommand(sql,DBhelper.connection);
//´ò¿ªÊý¾Ý¿â,²¢ÓÃdr¶ÁÈ¡¼Ç¼
DBhelper.connection.Open();
SqlDataReader dr = command.ExecuteReader();
while (dr.Read())
{
ListViewItem lvi = new ListViewItem(dr["Question"].ToString());
lvi.SubItems.AddRange(new string[] { dr["Answer"].ToString(), dr["Difficulty"].ToString(), dr["SubjectId"].ToString(), dr["OptionA"].ToString(), dr["OptionB"].ToString(), dr["OptionC"].ToString(), dr["OptionD"].ToString() });
Ïà¹ØÎĵµ£º
Ò»¡¢Ö÷¼üÓë¾Û¼¯Ë÷Òý²¢²»ÊÇÒ»¶ÔһƥÅäµÄ
Ò»°ãÇé¿öÏÂÎÒÃǶ¼ÈÏΪ,¾Û¼¯Ë÷ÒýºÍÖ÷¼üÊÇÏ໥ƥÅäµÄ,ÒòΪֻҪÄãÔÚSQLServer±íÖж¨ÒåÁËÒ»¸öÖ÷¼ü,ÄÇôSQLServer»áΪÕâ¸öÖ÷¼ü×Ô¶¯Ìí¼Ó¾Û¼¯Ë÷Òý.µ«ÊÇ,Èç¹ûÄãÏÈÔÚ±íÖлùÓÚÈÎÒâÒ»Áн¨Á¢¾Û¼¯Ë÷Òý,È»ºóÔÙÑ¡ÔñÁíÒ»ÁÐ×÷ΪÖ÷¼ü,Õâʱ,Õâ¸öSQLServer½«»á»ùÓÚÕâ¸öÖ÷¼ü½¨Á¢Ò»¸öΨһ·Ç¾Û¼¯Ë÷Òý.
¶þ¡¢ ......
ÿ´Î´ò¿ªSQLServer²éѯ·ÖÎöÆ÷ºó£¬ÔÚÁ¬½Ó´°¿ÚÀïµÄSQLServer·þÎñÆ÷Ñ¡ÔñÏÂÀ¿òºÍµÇ¼Óû§ÃûÊäÈë¿òÀï¶¼»áÁôÓÐÀúÊ·µÇ¼µÄ¼Ç¼£¬ÓÐʱºòÎÒÃÇÊDz»Ï£ÍûÕâÑùµÄ£¬±ÈÈçÔÚÒ»¸ö·Ç˽ÓÐÁìµØ×öÁËÔÝʱµÄ¿ª·¢ºó£¬²»ÏëÁôÏÂÈκÎÁ¬½ÓÔ¶³ÌÊý¾Ý¿âµÄ¼Ç¼£¬ÈçºÎɾ³ýÄØ£¿»¹ÊÇ×¢²á±í£¬ÕÒµ½ÒÔÏ·¾¶£º
HKEY_CURRENT_USER\Software\Microsoft\Microsoft&n ......
SQLServerʱ¼äÈÕÆÚº¯ÊýÏê½â,SQLServer,ʱ¼äÈÕÆÚ,
1. µ±Ç°ÏµÍ³ÈÕÆÚ¡¢Ê±¼ä
select getdate()
2. dateadd ÔÚÏòÖ¸¶¨ÈÕÆÚ¼ÓÉÏÒ»¶Îʱ¼äµÄ»ù´¡ÉÏ£¬·µ»ØÐ嵀 datetime Öµ
À ......
×òÌìÏÂÎç¿ìϰàµÄʱºò£¬ÎÞÒâÖÐÌýµ½¹«Ë¾Á½Î»Í¬ÊÂÔÚ̽ÌÖÅúÁ¿ÏòÊý¾Ý¿â²åÈëÊý¾ÝµÄÐÔÄÜÓÅ»¯ÎÊÌ⣬¶ÙʱÀ´ÁËÐËȤ£¬°Ñ×Ô¼ºµÄÏë·¨ÏòÁ½Î»Í¬ÊÂ˵ÁËһϣ¬ÓÚÊÇÓÐÁ˱¾ÎÄ¡£
¹«Ë¾¼¼Êõ±³¾°£ºÊý¾Ý¿â·ÃÎÊÀࣨxxx.DataBase.Dll£©µ÷Óô洢¹ý³ÌʵÏÖÊý¾Ý¿âµÄ·ÃÎÊ¡£
¼¼Êõ·½°¸Ò»£º
ѹËõʱ¼äϳÌÐòԱд³öµÄµÚÒ»¸ö°æ±¾£¬½ö½öΪÁËÍê³ÉÈÎÎñ£¬Ã»ÓÐ´Ó³Ì ......
ÔÚ¼ÆËã»úÖÐÊý¾ÝÓÐÁ½ÖÖÌØÕ÷£ºÀàÐͺͳ¤¶È¡£ËùνÊý¾ÝÀàÐ;ÍÊÇÒÔÊý¾ÝµÄ±íÏÖ·½Ê½ºÍ´æ´¢·½Ê½À´»®·ÖµÄÊý¾ÝµÄÖÖÀà¡£
ÔÚSQL Server ÖÐÿ¸ö±äÁ¿¡¢²ÎÊý¡¢±í´ïʽµÈ¶¼ÓÐÊý¾ÝÀàÐÍ¡£ÏµÍ³ÌṩµÄÊý¾ÝÀàÐÍ·ÖΪ¼¸´óÀ࣬Èç±í4-2 Ëùʾ¡£
ÆäÖУ¬BIGINT¡¢ SQL_VARIANT ºÍTABLE ÊÇSQL Server 2 ......