コード例 #1
0
        private void get_nhomkho(int i_userid)
        {
            string  sql = "select nhomkho from " + d.user + ".d_dlogin where id='" + i_userid + "'";
            DataSet lds = d.get_data(sql);

            lds.WriteXml("..\\..\\..\\xml\\d_nhomkholog.xml", XmlWriteMode.WriteSchema);
        }
コード例 #2
0
ファイル: rptCongno.cs プロジェクト: tayduivn/TTBRuBy
        private void rptCongno_Load(object sender, EventArgs e)
        {
            cbKieu.SelectedIndex = 0;
            string sql = "select * from " + user + ".d_dmkho where khott=1 and nhom=" + iNhom;

            if (sMakho != "")
            {
                sql += " and id in (" + sMakho.Substring(0, sMakho.Length - 1) + ")";
            }
            sql              += " order by stt";
            dtDmkho           = lib.get_data(sql).Tables[0];
            kho.DisplayMember = "TEN";
            kho.ValueMember   = "ID";
            kho.DataSource    = dtDmkho;
            AddGridTableStyle();
            load_dmmaubaocao(this.Name);
        }