137 строки
3.5 KiB
C#
137 строки
3.5 KiB
C#
#region Copyright Syncfusion Inc. 2001-2022.
|
|
// Copyright Syncfusion Inc. 2001-2022. All rights reserved.
|
|
// Use of this code is subject to the terms of our license.
|
|
// A copy of the current license can be obtained at any time by e-mailing
|
|
// licensing@syncfusion.com. Any infringement will be prosecuted under
|
|
// applicable laws.
|
|
#endregion
|
|
using System;
|
|
using System.Data;
|
|
using System.Data.Sql;
|
|
using System.Configuration;
|
|
using System.Web;
|
|
using System.Web.Hosting;
|
|
using System.Web.UI;
|
|
using System.Web.UI.WebControls;
|
|
using System.Web.UI.WebControls.WebParts;
|
|
using System.Web.UI.HtmlControls;
|
|
using System.Data.SqlClient;
|
|
|
|
|
|
public class EmployeeList
|
|
{
|
|
private SqlConnection odc;
|
|
protected Exception Ex=null;
|
|
public EmployeeList()
|
|
{
|
|
|
|
odc = new SqlConnection("Network Address=66.135.59.108,49489;initial catalog=SampleDB;password=Sync_samples;persist security info=True;user id=sa;packet size=4096;Pooling=true");
|
|
}
|
|
|
|
/// <summary>
|
|
/// Return DataView from DB Table
|
|
/// </summary>
|
|
public DataSet GetRecords()
|
|
{
|
|
|
|
DataSet ds = new DataSet();
|
|
|
|
try
|
|
{
|
|
SqlDataAdapter odda = new SqlDataAdapter("SELECT top 10 [FirstName], [LastName],[Address], [City] FROM [Customers]", odc);
|
|
odda.Fill(ds, "Customers");
|
|
}
|
|
catch (Exception e)
|
|
{
|
|
throw new Exception(e.Message);
|
|
|
|
}
|
|
|
|
//DataColumn[] key = new DataColumn[1] ;
|
|
//key[0] = ds.Tables[0].Columns[0];
|
|
//ds.Tables[0].PrimaryKey = key;
|
|
//DataView dv = new DataView(ds.Tables[0]);
|
|
return ds;
|
|
}
|
|
|
|
|
|
}
|
|
|
|
public class EmployeeList1
|
|
{
|
|
private SqlConnection odc;
|
|
protected Exception Ex = null;
|
|
public EmployeeList1()
|
|
{
|
|
|
|
odc = new SqlConnection("Network Address=66.135.59.108,49489;initial catalog=Data;password=Sync_samples;persist security info=True;user id=sa;packet size=4096;Pooling=true");
|
|
}
|
|
|
|
/// <summary>
|
|
/// Return DataView from DB Table
|
|
/// </summary>
|
|
public DataSet GetRecords()
|
|
{
|
|
|
|
DataSet ds = new DataSet();
|
|
|
|
try
|
|
{
|
|
SqlDataAdapter odda = new SqlDataAdapter("SELECT top 10 [id], [parentId],[Text] FROM [Links]", odc);
|
|
odda.Fill(ds, "Customers");
|
|
}
|
|
catch (Exception e)
|
|
{
|
|
throw new Exception(e.Message);
|
|
|
|
}
|
|
|
|
//DataColumn[] key = new DataColumn[1] ;
|
|
//key[0] = ds.Tables[0].Columns[0];
|
|
//ds.Tables[0].PrimaryKey = key;
|
|
//DataView dv = new DataView(ds.Tables[0]);
|
|
return ds;
|
|
}
|
|
|
|
|
|
}
|
|
public class EmployeeList3
|
|
{
|
|
private SqlConnection odc;
|
|
protected Exception Ex = null;
|
|
public EmployeeList3()
|
|
{
|
|
|
|
odc = new SqlConnection("Network Address=66.135.59.108,49489;initial catalog=DataBind;password=Sync_samples;persist security info=True;user id=sa;packet size=4096;Pooling=true");
|
|
}
|
|
|
|
/// <summary>
|
|
/// Return DataView from DB Table
|
|
/// </summary>
|
|
public DataSet GetRecords()
|
|
{
|
|
|
|
DataSet ds = new DataSet();
|
|
|
|
try
|
|
{
|
|
SqlDataAdapter odda = new SqlDataAdapter("SELECT top 16 [id], [parentId],[Text] FROM [Links]", odc);
|
|
odda.Fill(ds, "Customers");
|
|
}
|
|
catch (Exception e)
|
|
{
|
|
throw new Exception(e.Message);
|
|
|
|
}
|
|
|
|
//DataColumn[] key = new DataColumn[1] ;
|
|
//key[0] = ds.Tables[0].Columns[0];
|
|
//ds.Tables[0].PrimaryKey = key;
|
|
//DataView dv = new DataView(ds.Tables[0]);
|
|
return ds;
|
|
}
|
|
|
|
|
|
}
|
|
|