25 Nisan 2009 Cumartesi

DataAdaptor

private void btnDoldur_Click(object sender, System.EventArgs e)
{
OleDbConnection conFriends=new OleDbConnection("Provider=SQLOLEDB;Data Source=localhost;initial catalog=Friends;integrated security=SSPI");
string sqlIfadesi="Select * From Makale";
OleDbDataAdapter daFriends=new OleDbDataAdapter(sqlIfadesi,conFriends);
DataSet ds=new DataSet();
daFriends.Fill(ds);
dgMakale.DataSource=ds;
}


>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><>>>


private void btnDoldur_Click(object sender, System.EventArgs e)
{
OleDbConnection conFriends=new OleDbConnection("Provider=SQLOLEDB;Data Source=localhost;initial catalog=Friends;integrated security=SSPI");

string sqlIfadesi1="Select * From Makale";
string sqlIfadesi2="Select * From Kitap";

OleDbDataAdapter daMakale=new OleDbDataAdapter(sqlIfadesi1,conFriends);
OleDbDataAdapter daKitap=new OleDbDataAdapter(sqlIfadesi2,conFriends);

DataSet ds=new DataSet();
daMakale.Fill(ds);
daKitap.Fill(ds);
dgMakale.DataSource=ds;
}


>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>



private void btnDoldur_Click(object sender, System.EventArgs e)
{
OleDbConnection conFriends=new OleDbConnection("Provider=SQLOLEDB;Data Source=localhost;initial catalog=Friends;integrated security=SSPI");
OleDbCommand cmd=new OleDbCommand("Makaleler",conFriends);
cmd.CommandType=CommandType.StoredProcedure;
OleDbDataAdapter da=new OleDbDataAdapter(cmd);
DataSet ds=new DataSet();
da.Fill(ds,"TumMakaleler");
dgMakale.DataSource=ds;
}


Hiç yorum yok: