Пример #1
0
        private void Init()
        {
            SqlCommand cmm = new SqlCommand();

            cmm.Connection  = consql;
            cmm.CommandText = "select a.id, a.kod, a.aciklama, a.pasif  from parFirma a ";

            daMain = new SqlDataAdapter(cmm);
            CommandBuilderBase cb = new CommandBuilderBase();

            cb.AddField("id", SqlDbType.Int, 4, true);
            cb.AddField("kod", SqlDbType.VarChar, 50);
            cb.AddField("aciklama", SqlDbType.VarChar, 130);
            cb.AddField("pasif", SqlDbType.Bit, 0);
            cb.SqlTableName = "parFirma";
            cb.Con          = consql;
            cb.CreateCommands(daMain);
        }
Пример #2
0
        private void Init()
        {
            SqlCommand cmm = new SqlCommand();

            cmm.Connection  = con;
            cmm.CommandText = "select a.id, a.code, a.explanation, a.pasif  from parGiderTip a ";

            daMain = new SqlDataAdapter(cmm);
            CommandBuilderBase cb = new CommandBuilderBase();

            cb.AddField("id", SqlDbType.Int, 4, true);
            cb.AddField("code", SqlDbType.VarChar, 50);
            cb.AddField("explanation", SqlDbType.VarChar, 130);
            cb.AddField("pasif", SqlDbType.Bit, 0);
            cb.SqlTableName = "parGiderTip";
            cb.Con          = con;
            cb.CreateCommands(daMain);
        }
Пример #3
0
        private void Init()
        {
            SqlCommand cmm = new SqlCommand();

            cmm.Connection  = con;
            cmm.CommandText = "select a.id, a.code, a.explanation, a.gidertipi, a.vadetarih, a.pasif  from parGider a " +
                              " left outer join parGiderTip b on b.id = a.gidertipi ";

            daMain = new SqlDataAdapter(cmm);
            CommandBuilderBase cb = new CommandBuilderBase();

            cb.AddField("id", SqlDbType.Int, 4, true);
            cb.AddField("code", SqlDbType.VarChar, 50);
            cb.AddField("gidertipi", SqlDbType.Int, 4);
            cb.AddField("explanation", SqlDbType.VarChar, 130);
            cb.AddField("vadetarih", SqlDbType.DateTime, 4);
            cb.AddField("pasif", SqlDbType.Bit, 0);
            cb.SqlTableName = "parGider";
            cb.Con          = con;
            cb.CreateCommands(daMain);
        }