DataTable dan Datatable. Kita sering menggunakan tipe data dalam C# tanpa menyadarinya. Bagaimana untuk memuat data dari DataTable ..???. Di sini akan memberi contoh mengambil nilai dari DataTable dan DataRows, berikut ini adalah potongan source codenya, jangan terlalu dipikirkan masing masing fungsi dari tiap baris source code ini, karena fokus kita tidak pada source code ini melainkan pada dataGridnya, source code dibawah ini adalah source code yang digunakan untuk melakukan load data dari file excel ke sebuah variabel bertype dataTable, perhatikan seksama
public DataTable GetWorksheet(string worksheet){
DataTable ws;
OleDbConnection connection = new
OleDbConnection(strConnection);
OleDbDataAdapter adaptor = new
OleDbDataAdapter(String.Format("SELECT * FROM [{0}$]",
worksheet), connection);
ws = new DataTable(worksheet);adaptor.FillSchema(ws,
SchemaType.Source);
adaptor.Fill(ws);
adaptor.Dispose();
connection.Close();
return ws;
}
adaptor.Dispose();
connection.Close();
return ws;
}
Misalkan kita sudah memiliki tipe tabel data. Asumsikan DT nama variabel id. Berikut adalah data sumber kode dari tabel toload data variabel, sehingga untuk meload data satu persatu dari dataTabel adalah seperti berikut ini
dr = readDataTable(DT);
dataPixelGreen = new int[cek.Rows.Count, cek.Columns.Count];
for (int i = 0; i < cek.Rows.Count; i++)
{
for (int j = 0; j < cek.Columns.Count; j++)
{
IsiData[i, j] = Convert.ToInt16(dr[i][j]);
}
}
dataPixelGreen = new int[cek.Rows.Count, cek.Columns.Count];
for (int i = 0; i < cek.Rows.Count; i++)
{
for (int j = 0; j < cek.Columns.Count; j++)
{
IsiData[i, j] = Convert.ToInt16(dr[i][j]);
}
}
IsiData variabel di atas adalah jenis dataArray untuk menampung nilai data dari tabel data variabel isiData. Dapat disimpulkan tipe dari data DataTable hampir mirip dengan tipe data array, hanya cara pengumpulan data yang memiliki sintax yang berbeda Variabel isiData diatas adalah jenis dataArray UNTUK menampung Nilai Data Dari data tabel variabel IsiData. Bisa disimpulkan bahwa tipe data hampir mirip DENGAN DataTable tipe data Array, Hanya cara pengambilan data yang Mempunyai sintak nya Yang berbeda
for more information contact on informasi@csharp-indonesia.com
Artiel yang terkait
for more information contact on informasi@csharp-indonesia.com
Artiel yang terkait
- mengambil data dari MYSQL ke datagridview menggunakan dataset ...
- koneksi C# dengan SQL SERVER dan mengambil data dari SQL ...
- Mengambil data dari DataTable di C# (C Sharp)
- Convert a Image file in byte pointer data in C# (C Sharp)
- Load data dari MYSQL setelah proses INSERT data ke MYSQL di ...
- Mendapatkan Type data double dari pembagian dua data integer
- Load Data dari Excel ke DataGridView di C#
- Konvert berbagai type data di C# (C Sharp)
ninest123 12.15
BalasHapusoakley sunglasses, louboutin shoes, michael kors outlet online, prada outlet, louis vuitton outlet online, oakley sunglasses, nike free, oakley sunglasses, replica watches, burberry outlet, christian louboutin, nike air max, tiffany jewelry, tiffany jewelry, ralph lauren outlet, ray ban sunglasses, burberry factory outlet, cheap jordans, longchamp outlet, michael kors, ralph lauren polo, michael kors outlet online, replica watches, gucci handbags, michael kors outlet, ray ban sunglasses, uggs on sale, michael kors handbags, nike outlet, nike air max, uggs on sale, uggs outlet, christian louboutin, prada handbags, uggs outlet, tory burch outlet, louis vuitton outlet, louboutin uk, longchamp bags, longchamp outlet, ray ban sunglasses, cheap oakley sunglasses, louis vuitton handbags, oakley sunglasses, louis vuitton, uggs on sale, michael kors outlet online, louis vuitton outlet
louboutin pas cher, timberland pas cher, nike trainers uk, true religion jeans, nike roshe run pas cher, nike air max pas cher, nike blazer pas cher, lunette ray ban pas cher, abercrombie and fitch, lululemon outlet, michael kors outlet online, michael kors, coach outlet store online, coach purses, new balance, nike air max, hollister uk, michael kors, lunette oakley pas cher, true religion outlet, nike tn pas cher, replica handbags, nike air max uk, longchamp soldes, nike free, longchamp pas cher, north face uk, ralph lauren pas cher, michael kors uk, north face pas cher, vanessa bruno pas cher, true religion outlet, polo ralph lauren uk, nike air force, converse, vans pas cher, nike roshe uk, burberry pas cher, sac guess pas cher, true religion outlet, nike air max uk, ray ban uk, hogan sito ufficiale, jordan pas cher, hermes pas cher, mulberry uk, polo lacoste pas cher, nike free pas cher, abercrombie and fitch UK
BalasHapuschi flat iron, iphone cases, wedding dresses, hollister clothing, reebok outlet, herve leger, converse, mac cosmetics, iphone 6 plus cases, vans outlet, jimmy choo outlet, giuseppe zanotti, timberland boots, ray ban, celine handbags, polo ralph lauren, vans scarpe, iphone 6 cases, ghd hair, beats by dre, oakley, mont blanc, p90x workout, iphone 6s cases, instyler ionic styler, valentino shoes, north face outlet, mcm handbags, abercrombie and fitch, insanity workout, iphone 5s cases, bottega veneta, gucci, nike air max, hollister, iphone 6s plus cases, nike air max, new balance shoes, lululemon outlet, babyliss pro, soccer shoes, north face outlet, ipad cases, asics running shoes, nfl jerseys, s6 cases, nike roshe run, softball bats, soccer jerseys, salvatore ferragamo, hermes handbags, louboutin
BalasHapussac louis vuitton, ugg,uggs,uggs canada, supra shoes, coach outlet, canada goose outlet, doke & gabbana, hollister, montre pas cher, pandora jewelry, swarovski uk, ugg pas cher, canada goose, juicy couture outlet, links of london uk, moncler uk, moncler, louis vuitton, canada goose jackets, louis vuitton uk, thomas sabo uk, barbour, moncler, moncler jackets, lancel, canada goose outlet, ugg,ugg australia,ugg italia, barbour jackets uk, canada goose, replica watches, karen millen uk, moncler, pandora jewelry, juicy couture outlet, swarovski jewelry, canada goose jackets, toms shoes, louis vuitton, marc jacobs, pandora charms, ugg uk, canada goose uk, canada goose pas cher, moncler outlet, bottes ugg pas cher, pandora uk, wedding dresses uk, moncler, moncler pas cher, sac louis vuitton, converse shoes outlet
BalasHapusninest123 12.15
cheap ray ban sunglasses
BalasHapusray ban outlet
fitflop sale
fitflop outlet
Ray Ban Outlet
michael kors outlet
ray ban sunglasses outlet
Ray Ban Sale
fitflop shoes
Ray Ban Sunglassses Sale
cheap mbt shoes
fitflops
mbt Shoes
Ray Ban Sunglassses
ray ban sunglasses
fitflop sandals
michael kors outlet online
mbt shoes for men
michael kors sale
mbt shoes sale
michael kors
michael kors outlet online sale
fitflops on sale
fitflops sandals
michael kors outlet
mbt
fitflop sandals
fitflops sale
ray ban outlet
michael kors outlet
instyler max
BalasHapusreplica watches
chiefs jersey
cheap nike shoes sale
supra shoes sale
armani exchange outlet
michael kors handbags
armani exchange
san diego chargers jerseys
michael kors outlet store
golden state warriors
BalasHapuslos angeles lakers jerseys
jordan shoes
new york knicks
cheap nike shoes sale
michael kors outlet
jordan shoes
michael kors outlet
kansas city chiefs jerseys
michael kors handbags
adidas nmd runner
BalasHapustennessee titans jersey
coach outlet
ray ban sunglasses
cheap jordan shoes
instyler max
nike huarache
fitflops
jaguars jersey
oakley sunglasses
now present in your city
BalasHapus1. manfaat kurma untuk persalinan
2. manfaat buah nanas
3. aktivitas penyebab keguguran
4. apakah usg berbahaya
5. penyebab telat haid
6. cara melancarkan haid
7. cara mengatasi keputihan
8. tanda tanda menopause
stephen curry shoes
BalasHapusgolden goose sneakers
kd13
hermes belt
supreme clothing
supreme t shirt
supreme hoodie
yeezys
jordan 12
supreme hoodie