• 基于vs2012的C# winform抽奖小程序的总结


    哈希表的使用
    
    Hashtable hashtable = new Hashtable();
    
    hashtable.ContainsValue(tmp);//判断哈希表中有没有tmp
    hashtable.add(tmp,tmp);//加入哈希表
    DataSet的使用
    
    SqlDataAdapter sda = new SqlDataAdapter(sqlCount, myconn);
    DataSet ds = new DataSet();
    sda.Fill(ds);
    
    获取ds里的值
    
    ds.Tables[0].Rows[0]["字段"]  或者 ds.Tables[0].Rows[0][0]
    dataGridView的使用
    SqlConnection myconn = new SqlConnection(conn);
                myconn.Open();
                SqlDataAdapter sda = new SqlDataAdapter(sql, myconn);
                DataSet ds = new DataSet();
                sda.Fill(ds, "Ticket");
                dataGridView1.DataSource = ds;
                dataGridView1.DataMember = "Ticket";
    dataGridView1.Rows[i].Cells["字段"].Value.ToString();

    哈希表的遍历

     foreach (DictionaryEntry de in hashtable2)

    {

    de.key;

    de.value;

    }

    //将excel表导入到dataSet
     1 //将excel表导入到dataSet
     2         public DataSet getXSLData(string filepath)
     3         {
     4             string strCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties="Excel 12.0;HDR=YES;"";
     5             System.Data.OleDb.OleDbConnection Conn = new System.Data.OleDb.OleDbConnection(strCon);
     6             string strCom = "SELECT * FROM [Sheet1$]";
     7             Conn.Open();
     8             System.Data.OleDb.OleDbDataAdapter myCommand = new System.Data.OleDb.OleDbDataAdapter(strCom, Conn);
     9             DataSet ds = new DataSet();
    10             myCommand.Fill(ds, "[Sheet1$]");
    11             Conn.Close();
    12             return ds;
    13         }

    openFileDialog的使用

    OpenFileDialog ofd = new OpenFileDialog();
                ofd.Filter = "Microsoft Excel files(*.xls)|*.xls;*.xlsx";//过滤一下,只要表格格式的
                ofd.RestoreDirectory = true;
                ofd.FilterIndex = 1;
                ofd.AddExtension = true;
                ofd.CheckFileExists = true;
                ofd.CheckPathExists = true;
                ofd.ShowHelp = true;//是否显示帮助按钮
                if (ofd.ShowDialog() == DialogResult.OK)
                {
                    this.textBox1.Text = ofd.FileName;
                }   
  • 相关阅读:
    poj 3621(最优比率环)
    bzoj 1497(最大权闭合子图)
    Dinic(模板 再错是不可能的 这辈子都不可能了)
    BZOJ 2038
    zoj 3822(概率dp)
    poj 3683(2-sat+拓扑排序)
    poj 2186(tarjan+缩点)
    hdu 5782(kmp+hash)
    hdu 6035(树形dp)
    Python爬取房屋租售信息
  • 原文地址:https://www.cnblogs.com/xtflz/p/5123276.html
Copyright © 2020-2023  润新知