日韩欧美人妻无码精品白浆,夜夜嗨AV免费入口,国产欧美官网在线看,高校回应聋哑女生因长相完美被质疑

        static void SQLDBcreate(string dbname)
        {
            //通過連接到本身存在的db  master連接到sqlserver
            string connStr = "Server = localhost;User Id=sa;Password=******; database = master";
            SqlConnection conn = new SqlConnection(connStr);
            conn.Open();
            //如果當(dāng)前數(shù)據(jù)庫是正在狀態(tài)是無法刪除的，所以把master設(shè)置為當(dāng)前狀態(tài)，若數(shù)據(jù)庫存在則刪除重建
            //此處出問題一般為數(shù)據(jù)安裝過程中為默認(rèn)實(shí)例，改為特定實(shí)例，然后啟動(dòng)服務(wù)中心，在ip3更改相關(guān)ip為本機(jī)，并把tcp端口改為1433
            //其他更改為是，同時(shí)在服務(wù)中restart即可以
            string sql= "use master;" +
            "IF DB_ID(N‘{0}‘) IS NOT NULL " +
            "drop DATABASE {0};" +
                "create DATABASE {0}";
            sql = string.Format(sql, dbname);
            try
            {
                SqlCommand cmd = new SqlCommand(sql, conn);
                cmd.executeNonQuery();
                Console.WriteLine("createdb_success");
            }
            catch (Exception ex)
            {
                Console.WriteLine("createdb_failed:"+ex.Message);
            }
            finally
            {
                conn.Close();
            }
        }

        static void Tablecreate(string dbname,string tablename)
        {
            string connStr = "Server = localhost;User Id=sa;Password=********; database = {0}";
            connStr = string.Format(connStr, dbname);
            string sql= "IF OBJECT_ID(N‘{1}..{0}‘, N‘U‘) IS NOT NULL " +
                 "drop TABLE {0};" +
                "create TABLE {0}" +
                "(ID [int] NOT NULL Primary Key," +
                "Name [char] (40) NULL ," +
                "Price [char] (40) NULL," +
            "dPrice [char] (40) NULL)";
            sql = string.Format(sql, tablename, dbname);
            SqlConnection conn = new SqlConnection(connStr);
            conn.Open();
            try
            {
                SqlCommand cmd = new SqlCommand(sql, conn);
                cmd.executeNonQuery();
                Console.WriteLine("createtable_success");
            }
            catch(Exception ex)
            {
                Console.WriteLine("createtable_failed:" + ex.Message);
            }
            finally
            {
                conn.Close();
            }
        }

        static void FillTable(string dbname,string tablename)
        {
            string connStr = "Server = localhost;User Id=sa;Password=********; database = {0}";
            connStr = string.Format(connStr, dbname);
            SqlConnection conn = new SqlConnection(connStr);
            conn.Open();
            string sql= "insert INTO {0}(ID,name,price,dPrice)" +
                "values(@d,@a,@b,@c)";
            sql = string.Format(sql, tablename);
            try
            {
                for(int i=0;i<100;i++)
                {
                    SqlCommand cmd = new SqlCommand(sql, conn);
                    cmd.Parameters.AddWithValue("@d", i);
                    cmd.Parameters.AddWithValue("@a", Guid.NewGuid());
                    cmd.Parameters.AddWithValue("@b", i.ToString());
                    cmd.Parameters.AddWithValue("@c", i.ToString());
                    cmd.executeNonQuery();                    
                }
                Console.WriteLine("filltable_success");
            }
            catch(Exception ex)
            {
                Console.WriteLine("filltable_failed:" + ex.Message);
            }
            finally
            {
                conn.Close();
            }
        }

        static void deleteTable(string dbname,string tablename)
        {
            string connStr = "Server = localhost;User Id=sa;Password=*********; database = {0}";
            connStr = string.Format(connStr, dbname);
            SqlConnection conn = new SqlConnection(connStr);
            conn.Open();
            string sql= "IF OBJECT_ID(N‘{0}..{1}‘, N‘U‘) IS NOT NULL " +
                 "drop TABLE {1};";
            sql = string.Format(sql, dbname, tablename);
            try
            {
                SqlCommand cmd = new SqlCommand(sql, conn);
                cmd.executeNonQuery();
                Console.WriteLine("deletetable_success");
            }
            catch(Exception ex)
            {
                Console.WriteLine("deletetable_failed:" + ex.Message);
            }
            finally
            {
                conn.Close();
            }
        }

        static void TransToDS(string dbname,string tablename)
        {
            string connStr = "Server =.;User Id=sa;Password=*******; database = {0}";
            connStr = string.Format(connStr, dbname);
            SqlConnection conn = new SqlConnection(connStr);
            conn.Open();
            string sql = "select *from {0}";
            sql = string.Format(sql, tablename);
            SqlCommand cmd = new SqlCommand(sql, conn);
            SqlDataAdapter apt = new SqlDataAdapter(cmd);
            SqlCommandBuilder sb = new SqlCommandBuilder(apt);
            DataSet ds = new DataSet();
            
            try
            {
                
                apt.Fill(ds);
                Console.WriteLine("transTods_success");
            }
            catch (Exception ex)
            {
                Console.WriteLine("transTods_failed:" + ex.Message);
            }
            finally
            {
                conn.Close();
            }
            DataTable dt = ds.Tables[0];
            //int i = 0;
            //foreach(DataRow dr in ds.Tables[0].Rows)
            //{
            //    if(i>50)
            //    {
            //        ds.Tables[0].Rows.RemoveAt(i);
            //    }
            //    i++;
            //}
            int count = dt.Rows.Count;
            for(int i=0;i<count;i++)
            {
                if(i>50)
                {
                    //dt.Rows.RemoveAt(51);
                    dt.Rows[i].delete();
                }
            }
            apt.update(ds);           
            int j = 0;
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                Console.WriteLine(dr["Price"]+" "+j+" "+dr.RowState);
                j++;
            }         
        }