سلام بر تمامی برنامه نویسان #C 😉 در این مطلب از وب سایت پروگرم 98 کد پرکردن DataSet با SqlDataAdapter در سی شارپ را آماده کردم. انشاالله که این کد براتون مفید باشه.
کد پرکردن DataSet با SqlDataAdapter در سی شارپ :
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
class Program
{
static void Main(string[] args)
{
string cnStr = "Integrated Security = SSPI;Initial Catalog=YourDB;Data Source=(local)\\SQLEXPRESS";
DataSet ds = new DataSet("YourDB");
SqlDataAdapter dAdapt = new SqlDataAdapter("Select * From Inventory", cnStr);
DataTableMapping custMap = dAdapt.TableMappings.Add("Inventory", "Current Inventory");
custMap.ColumnMappings.Add("CarID", "Car ID");
custMap.ColumnMappings.Add("PetName", "Name of Car");
dAdapt.Fill(ds, "Inventory");
PrintDataSet(ds);
}
static void PrintDataSet(DataSet ds)
{
Console.WriteLine(ds.DataSetName);
foreach (System.Collections.DictionaryEntry de in ds.ExtendedProperties)
{
Console.WriteLine("Key = {0}, Value = {1}", de.Key, de.Value);
}
foreach (DataTable dt in ds.Tables)
{
Console.WriteLine(dt.TableName);
for (int curCol = 0; curCol < dt.Columns.Count; curCol++)
{
Console.Write(dt.Columns[curCol].ColumnName.Trim() + "\t");
}
PrintTable(dt);
}
}
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
class Program
{
static void Main(string[] args)
{
string cnStr = "Integrated Security = SSPI;Initial Catalog=YourDB;Data Source=(local)\\SQLEXPRESS";
DataSet ds = new DataSet("YourDB");
SqlDataAdapter dAdapt = new SqlDataAdapter("Select * From Inventory", cnStr);
DataTableMapping custMap = dAdapt.TableMappings.Add("Inventory", "Current Inventory");
custMap.ColumnMappings.Add("CarID", "Car ID");
custMap.ColumnMappings.Add("PetName", "Name of Car");
dAdapt.Fill(ds, "Inventory");
PrintDataSet(ds);
}
static void PrintDataSet(DataSet ds)
{
Console.WriteLine(ds.DataSetName);
foreach (System.Collections.DictionaryEntry de in ds.ExtendedProperties)
{
Console.WriteLine("Key = {0}, Value = {1}", de.Key, de.Value);
}
foreach (DataTable dt in ds.Tables)
{
Console.WriteLine(dt.TableName);
for (int curCol = 0; curCol < dt.Columns.Count; curCol++)
{
Console.Write(dt.Columns[curCol].ColumnName.Trim() + "\t");
}
PrintTable(dt);
}
}