Tag: datatable

SQL SERVER COLUMNLARI DATATABLEA DİNAMİK OLARAK AKTARMA

On By semt20In C SHARP, SqlLeave a comment 
        public static DataTable getReadingTableFromSchema()
        {
            string TARIH = DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString() + "-" + DateTime.Now.Year.ToString();
            using (SqlConnection conn = new SqlConnection(CS))
            {
                string sql = string.Format("EXEC[LG_118_ONAY] '','{0}'",  TARIH);
                conn.Open();
                SqlCommand cmd = new SqlCommand(sql, conn);
                DbDataAdapter da = new SqlDataAdapter(cmd);
                DataTable dtbl = new DataTable();
                da.FillSchema(dtbl, SchemaType.Source);
                return dtbl;
            }
        }

        private void INITIALIZEGV()
        {
            DataTable DTNEW = getReadingTableFromSchema();
            DataTable DT = _M.SELECT_LISTE();
            string TARIH = DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString() + "-" + DateTime.Now.Year.ToString();

            foreach (DataRow item in DT.Rows)
            {
                string STUDENTCODE = item[0].ToString(); 
                DataRow s = _M.SELECT_ONAY(CODE, TARIH).Rows[0];
                DTNEW.ImportRow(s);
            }

            gc_CONTROL1.DataSource = DTNEW;
        }

c# devexpress gridview selectedrow to datatable dataset

On By semt20In C SHARPLeave a comment 
            DataTable MyTable = new DataTable(); // 1
            DataTable MyTableByName = new DataTable("MyTableName"); // 2




            MyTable.Columns.Add("AMBAR", typeof(string));

            int[] SROWSdublicate = _gv_SARFFISI_.GetSelectedRows();
            for (int i = 0; i < SROWSdublicate.Length; i++)
            {
                MyTable.Rows.Add(_gv_SARFFISI_.GetRowCellValue(SROWSdublicate[i], "Ambar").ToString());
                //dr["AMBAR"] = _gv_SARFFISI_.GetRowCellValue(SROWSdublicate[i], "Ambar").ToString();
                //dt.Rows.Add(new object[] { "Ravi", 500 });
                // dt.Rows.Add(dr);

            }              

whole grid rows (without select)

for (int i = 0; i < gridView1.RowCount; i++) {

datatable to list convert

On By semt20In C SHARPLeave a comment 
   public class MOBILEUSER
    {
        public int LOGICALREF { get; set; }
        public int CAPIUSERREF { get; set; }
        public string NAME { get; set; } = string.Empty;
        public string KEY_ { get; set; } = string.Empty;
        public string DEFINITION_ { get; set; }
        public int SLSMANREF { get; set; }
        public string SLSMANCODE { get; set; } = string.Empty;
        public string FCMREGID { get; set; } = string.Empty;
        public int CONFTYPE { get; set; }
        public double CONF_SAMOUNT { get; set; }
        public double CONF_FAMOUNT { get; set; }
        public double CONF_SPERCENT { get; set; }
        public double CONF_FPERCENT { get; set; }
        public short ACTIVE { get; set; }
        public string NTF_ORFICHEREF { get; set; } = string.Empty;
        public string NTF_ORFICHENO { get; set; } = string.Empty;
    }   




   private List GET_MOBILEUSER_LIST()
        {
            List MUL = new List();
            try
            {
                DataTable DT = sqlLGDB.ExecuteDataSet(new SqlCommand(string.Format("SELECT * FROM BM_MOBILEUSER WHERE ACTIVE = 0"))).Tables[0];
                foreach (DataRow R in DT.Rows)
                {
                    MOBILEUSER U = new MOBILEUSER();
                    try { U.LOGICALREF = (int)R["LOGICALREF"]; } catch { }
                    try { U.CAPIUSERREF = (int)R["CAPIUSERREF"]; } catch { }
                    try { U.NAME = (string)R["NAME"]; } catch { }
                    try { U.KEY_ = (string)R["KEY_"]; } catch { }
                    try { U.DEFINITION_ = (string)R["DEFINITION_"]; } catch { }
                    try { U.SLSMANREF = (int)R["SLSMANREF"]; } catch { }
                    try { U.SLSMANCODE = (string)R["SLSMANCODE"]; } catch { }
                    try { U.FCMREGID = (string)R["FCMREGID"]; } catch { }
                    try { U.CONFTYPE = (int)R["CONFTYPE"]; } catch { }
                    try { U.CONF_SAMOUNT = (double)R["CONF_SAMOUNT"]; } catch { }
                    try { U.CONF_FAMOUNT = (double)R["CONF_FAMOUNT"]; } catch { }
                    try { U.CONF_SPERCENT = (double)R["CONF_SPERCENT"]; } catch { }
                    try { U.CONF_FPERCENT = (double)R["CONF_FPERCENT"]; } catch { }
                    try { U.ACTIVE = (short)R["ACTIVE"]; } catch { }
                    MUL.Add(U);
                }

            }
            catch (Exception E)
            {
                WRITELOG("GET_MOBILEUSER_LIST", E, false);
            }
            return MUL;
        }