private void LoadData()
{
dtMain = new DataTable();
SqlConnection con = new SqlConnection("Server=KEYMM;Database=DbLibraryManagement;User Id=sa;Password=12355;Trusted_Connection=True;");
SqlCommand cmm = new SqlCommand();
cmm.Connection = con;
cmm.CommandText = "select a.id, a.aciklama, a.ad, a.adres, a.babaad, a.cinsiyet, " +
"a.dtarih, a.mail, a.okul, a.sinif, a.soyad, a.tc, a.tel, a.donem, a.anaad " +
"from tbl_customer a";
daMain = new SqlDataAdapter(cmm);
cCommandBuilder cb = new cCommandBuilder();
cb.AddField("id", SqlDbType.Int, 4, true);
cb.AddField("aciklama", SqlDbType.VarChar, 100);
cb.AddField("ad", SqlDbType.VarChar, 30);
cb.AddField("adres", SqlDbType.VarChar, 100);
cb.AddField("anaad", SqlDbType.VarChar, 30);
cb.AddField("babaad", SqlDbType.VarChar, 30);
cb.AddField("cinsiyet", SqlDbType.TinyInt, 4);
cb.AddField("dtarih", SqlDbType.SmallDateTime, 4);
cb.AddField("mail", SqlDbType.VarChar, 30);
cb.AddField("okul", SqlDbType.VarChar, 100);
cb.AddField("sinif", SqlDbType.VarChar, 30);
cb.AddField("soyad", SqlDbType.VarChar, 30);
cb.AddField("tc", SqlDbType.VarChar, 30);
cb.AddField("tel", SqlDbType.VarChar, 30);
cb.AddField("donem", SqlDbType.VarChar, 50);
cb.SqlTableName = "tbl_customer";
cb.Con = con;
cb.CreateCommands(daMain);
daMain.Fill(dtMain);
}
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);
cCommandBuilder cb = new cCommandBuilder();
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.kod, a.aciklama, a.pasif from parFirma a ";
daMain = new SqlDataAdapter(cmm);
cCommandBuilder cb = new cCommandBuilder();
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 = 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);
cCommandBuilder cb = new cCommandBuilder();
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);
}
