سلام بر تمامی برنامه نویسان سی شارپ 😉 در این مطلب آموزش تعریف کردن DataRelation در سی شارپ را آماده کردم. انشاالله که این آموزش برای شما مفید باشد.
کد تعریف کردن DataRelation در سی شارپ :
using System;
using System.Data;
using System.Data.SqlClient;
public class XmlRelations
{
private static string connectionString = "Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI";
private static string categorySQL = "SELECT CategoryID, CategoryName,Description FROM Categories";
private static string productSQL = "SELECT ProductID, ProductName, CategoryID FROM Products";
public static void Main()
{
SqlConnection con = new SqlConnection(connectionString);
SqlCommand com = new SqlCommand(categorySQL, con);
SqlDataAdapter adapter = new SqlDataAdapter(com);
DataSet ds = new DataSet("Nortwind");
con.Open();
adapter.FillSchema(ds, SchemaType.Mapped, "Categories");
adapter.Fill(ds, "Categories");
adapter.SelectCommand.CommandText = productSQL;
adapter.FillSchema(ds, SchemaType.Mapped, "Products");
adapter.Fill(ds, "Products");
using System.Data;
using System.Data.SqlClient;
public class XmlRelations
{
private static string connectionString = "Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI";
private static string categorySQL = "SELECT CategoryID, CategoryName,Description FROM Categories";
private static string productSQL = "SELECT ProductID, ProductName, CategoryID FROM Products";
public static void Main()
{
SqlConnection con = new SqlConnection(connectionString);
SqlCommand com = new SqlCommand(categorySQL, con);
SqlDataAdapter adapter = new SqlDataAdapter(com);
DataSet ds = new DataSet("Nortwind");
con.Open();
adapter.FillSchema(ds, SchemaType.Mapped, "Categories");
adapter.Fill(ds, "Categories");
adapter.SelectCommand.CommandText = productSQL;
adapter.FillSchema(ds, SchemaType.Mapped, "Products");
adapter.Fill(ds, "Products");