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);
}
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);
}
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);
}