本文整理汇总了C#中System.Data.DataSet类的典型用法代码示例。如果您正苦于以下问题:C# DataSet类的具体用法?C# DataSet怎么用?C# DataSet使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
DataSet类属于System.Data命名空间,在下文中一共展示了DataSet类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。
示例1: GetHandoverLogByHandoverLogId
public static DataTable GetHandoverLogByHandoverLogId(int handoverLogId)
{
string connectionString = ConnectionStringFactory.GetNXJCConnectionString();
DataSet ds = new DataSet();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = connection.CreateCommand();
command.CommandText = @"SELECT WorkingTeamShiftLog.*,
StaffInfo.Name AS ChargeManName, ProductLine.Name AS ProductLineName,
WorkingTeam.Name AS WorkingTeamName
FROM WorkingTeam INNER JOIN
StaffInfo INNER JOIN
WorkingTeamShiftLog ON StaffInfo.ID = WorkingTeamShiftLog.ChargeManID INNER JOIN
ProductLine ON WorkingTeamShiftLog.ProductLineID = ProductLine.ID ON
WorkingTeam.ID = WorkingTeamShiftLog.WorkingTeamID
WHERE (WorkingTeamShiftLog.ID = @workingTeamShiftLogID)";
command.Parameters.Add(new SqlParameter("workingTeamShiftLogID", handoverLogId));
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(ds);
}
return ds.Tables[0];
}
开发者ID:nxjcproject,项目名称:nxjcslim,代码行数:25,代码来源:HandoverLogService.cs
示例2: LerUsuarios_Desconectado
public static void LerUsuarios_Desconectado()
{
DataSet ds = new DataSet();
using (var con = ObterConexao())
{
var cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Usuario";
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
}
foreach (DataTable table in ds.Tables)
{
foreach (DataColumn column in table.Columns)
{
foreach (DataRow row in table.Rows)
{
Console.WriteLine("{0}: {1}", column.ColumnName, row[column.ColumnName]);
}
}
}
Console.Read();
}
开发者ID:TiagoSoczek,项目名称:MOC,代码行数:28,代码来源:Program.cs
示例3: runDocno
public static string runDocno(string tablename, string fieldname, string doctype)
{
SqlConnection con = new SqlConnection(SysApp.DatabaseConfig.ServerConStr);
string sql = " select ";
sql += " case when max(substring(" + fieldname + ",4,6)) <> convert(varchar,getdate(),12) then ";
sql += " '" + doctype + "' + convert(varchar,getdate(),12) + '-0001' ";
sql += " when max(substring(" + fieldname + ",4,6)) = convert(varchar,getdate(),12) then ";
sql += " case ";
sql += " when (select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%') <10 then '" + doctype + "' + convert(varchar,getdate(),12) + '-000' + convert(varchar,(select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%')) ";
sql += " when (select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%') <100 then '" + doctype + "' + convert(varchar,getdate(),12) + '-00' + convert(varchar,(select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%')) ";
sql += " when (select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%') <1000 then '" + doctype + "' + convert(varchar,getdate(),12) + '-0' + convert(varchar,(select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%')) ";
sql += " else ";
sql += " '" + doctype + "' + convert(varchar,getdate(),12) + '-' + convert(varchar,(select max(substring(" + fieldname + ",11,4))+1 from " + tablename + " where substring(" + fieldname + ",4,6) = convert(varchar,getdate(),12) and " + fieldname + " like '" + doctype + "%')) ";
sql += " end ";
sql += " else ";
sql += " '" + doctype + "' + convert(varchar,getdate(),12) + '-0001' ";
sql += " end ";
sql += " as " + fieldname;
sql += " from " + tablename;
sql += " where " + fieldname + " like '" + doctype + "%' ";
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
da.Fill(ds, "runDocno");
string docno = ds.Tables["runDocno"].Rows[0][fieldname].ToString();
da = null;
return docno;
}
开发者ID:SUPCDEV,项目名称:HROS,代码行数:30,代码来源:ClassDocId.cs
示例4: InsertUpdateDelete
public bool InsertUpdateDelete(DataSet ds)
{
Database db = DatabaseFactory.CreateDatabase(Constants.HBMCONNECTIONSTRING);
DbCommand commandInsert = db.GetStoredProcCommand("usp_TaxTypeInsert");
db.AddInParameter(commandInsert, "@CompanyId", DbType.Int32, "CompanyId", DataRowVersion.Current);
db.AddInParameter(commandInsert, "@TaxTypeName", DbType.String, "TaxTypeName", DataRowVersion.Current);
db.AddInParameter(commandInsert, "@Note", DbType.String, "Note", DataRowVersion.Current);
db.AddInParameter(commandInsert, "@TaxPercentage", DbType.Decimal, "TaxPercentage", DataRowVersion.Current);
db.AddInParameter(commandInsert, "@CreatedUser", DbType.Int32, "CreatedUser", DataRowVersion.Current);
db.AddInParameter(commandInsert, "@StatusId", DbType.Int32, "StatusId", DataRowVersion.Current);
DbCommand commandUpdate = db.GetStoredProcCommand("usp_TaxTypeUpdate");
db.AddInParameter(commandUpdate, "@TaxTypeId", DbType.Int32, "TaxTypeId", DataRowVersion.Current);
db.AddInParameter(commandUpdate, "@TaxTypeName", DbType.String, "TaxTypeName", DataRowVersion.Current);
db.AddInParameter(commandUpdate, "@Note", DbType.String, "Note", DataRowVersion.Current);
db.AddInParameter(commandUpdate, "@TaxPercentage", DbType.Decimal, "TaxPercentage", DataRowVersion.Current);
db.AddInParameter(commandUpdate, "@UpdatedUser", DbType.Int32, "UpdatedUser", DataRowVersion.Current);
db.AddInParameter(commandUpdate, "@StatusId", DbType.Int32, "StatusId", DataRowVersion.Current);
DbCommand commandDelete = db.GetStoredProcCommand("usp_TaxTypeDelete");
db.AddInParameter(commandDelete, "@TaxTypeId", DbType.Int32, "TaxTypeId", DataRowVersion.Current);
db.UpdateDataSet(ds, ds.Tables[0].TableName, commandInsert, commandUpdate, commandDelete, UpdateBehavior.Transactional);
return true;
}
开发者ID:nirshandileep,项目名称:HotelManagement,代码行数:29,代码来源:TaxTypeDAO.cs
示例5: HandleData
/// <summary>
/// 处理数据
/// </summary>
/// <param name="ds"></param>
public void HandleData(DataSet ds)
{
int count = ds.Tables[0].Rows.Count;
int current = AspNetPager.PageSize * (AspNetPager.CurrentPageIndex - 1) + 1;
dsPosts.Tables.Add("table");
dsPosts.Tables[0].Columns.AddRange(new DataColumn[] {
new DataColumn("ID"),
new DataColumn("PostTitle"),
new DataColumn("PosterID"),
new DataColumn("PostContent"),
new DataColumn("PostRecordTime"),
new DataColumn("PostReplyCount"),
new DataColumn("PosterType"),
new DataColumn("PostPlateID"),
new DataColumn("ViewTimes")
});
DataRow row;
for (int i = current - 1; (i < current + AspNetPager.PageSize - 1) && (i < count); i++)
{
row = ds.Tables[0].Rows[i];
dsPosts.Tables[0].Rows.Add(row["ID"], row["PostTitle"], row["PosterID"], row["PostContent"], row["PostRecordTime"],
row["PostReplyCount"], row["PosterType"], row["PostPlateID"], row["ViewTimes"]);
}
}
开发者ID:dalinhuang,项目名称:labms,代码行数:31,代码来源:Plate.aspx.cs
示例6: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
DataSet ds1 = new DataSet();
ds.ReadXml(@"D:\Books.xml");
bookgrd.DataSource = ds.Tables[0];
bookgrd.DataBind();
IEnumerable<DataRow> tbl1row = ds.Tables[0].AsEnumerable();
ds1.ReadXml(@"D:\Books2.xml");
IEnumerable<DataRow> tbl2row = ds1.Tables[0].AsEnumerable();
GridView1.DataSource = ds1.Tables[0];
GridView1.DataBind();
var items = tbl2row.AsEnumerable().Select(r => r.Field<string>("id"))
.Except(tbl1row.AsEnumerable().Select(r => r.Field<string>("id")));
DataTable TableC = (from row in tbl2row.AsEnumerable()
join id in items
on row.Field<string>("id") equals id
select row).CopyToDataTable();
GridView2.DataSource = TableC;
GridView2.DataBind();
}
开发者ID:MurugesanSP,项目名称:DataTable-Comparision-through-Linq,代码行数:27,代码来源:WebForm1.aspx.cs
示例7: QueryAccessFomList
public static List<string> QueryAccessFomList(int userID, string conn)
{
try
{
List<string> list = new List<string>();
DataSet ds = new DataSet();
ds.Tables.Add();
ds.Tables[0].Columns.Add("mode");
ds.Tables[0].Columns.Add("id");
ds.Tables[0].Rows.Add("2", userID);
DataTable dt = DbUserRes.QueryFormAuth(ds, conn);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string formName = dt.Rows[i]["NAME"].ToString();
if (!list.Contains(formName))
{
list.Add(formName);
}
}
}
return list;
}
catch (Exception ex)
{
throw ex;
}
}
开发者ID:sunpander,项目名称:VSDT,代码行数:29,代码来源:DbUserRes.cs
示例8: FilterData
public DataSet FilterData(ArsonFilterModel filterData)
{
var connectionString = ConfigurationManager.ConnectionStrings["UCR_DataEntities"];
DataSet dsResult = new DataSet();
using (SqlConnection conn = new SqlConnection(connectionString.ConnectionString))
{
try
{
SqlCommand command = new SqlCommand();
command.Connection = conn;
command.CommandText = GenerateArsonORQuery(filterData);
command.CommandType = System.Data.CommandType.Text;
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = command;
conn.Open();
adapter.Fill(dsResult);
conn.Close();
adapter.Dispose();
command.Dispose();
}
catch (Exception ex)
{
StorageClient.LogError(ex);
}
}
return dsResult;
}
开发者ID:yogsgit,项目名称:FBIUCRDashboard,代码行数:28,代码来源:DataAccess.cs
示例9: dataGridView1_CellContentClick
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
SqlConnection con = new SqlConnection(constring);
con.Open();
int curRow = int.Parse(e.RowIndex.ToString());
string currentrow;
currentrow = dataGridView1.Rows[curRow].Cells[1].Value.ToString();
SqlDataAdapter adp1 = new SqlDataAdapter("Select * from ResManagerToAdmin where ResID='" + currentrow + "'", con);
DataSet ds1 = new DataSet();
adp1.Fill(ds1);
SqlCommand cmd = new SqlCommand("Update ResManagerToAdmin set RView='" + p2 + "' where ResID='" + currentrow + "'", con);
cmd.ExecuteNonQuery();
SqlCommand cmd1 = new SqlCommand("Update ResManagerToAdmin set RFinalView='" + p2 + "' where ResID='" + currentrow + "'", con);
cmd1.ExecuteNonQuery();
status = ds1.Tables[0].Rows[0]["RStatus"].ToString();
if (status == "Success")
{
ViewAdminResponses var = new ViewAdminResponses();
var.ShowDialog();
}
else
{
RecordNotFound rnf = new RecordNotFound();
rnf.ShowDialog();
}
}
开发者ID:balajivit1,项目名称:Sourcecode,代码行数:32,代码来源:User.cs
示例10: button1_Click_1
private void button1_Click_1(object sender, EventArgs e)
{
SqlConnection con1 = new SqlConnection(constring);
con1.Open();
SqlDataAdapter adp = new SqlDataAdapter("Select whoislogin from Registration", con1);
DataSet ds = new DataSet();
adp.Fill(ds);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
SqlCommand cmd = new SqlCommand("Update Registration set whoislogin='" + whoislog + "'", con1);
cmd.ExecuteNonQuery();
}
SqlDataAdapter adp2 = new SqlDataAdapter("Select * from ResManagerToAdmin", con1);
DataSet ds2 = new DataSet();
adp2.Fill(ds2);
for (int j = 0; j < ds2.Tables[0].Rows.Count; j++)
{
//adminview = ds.Tables[0].Rows[j]["RView"].ToString();
SqlCommand cmd = new SqlCommand("Update ResManagerToAdmin set RView='" + adminviewempty + "'", con1);
cmd.ExecuteNonQuery();
}
con1.Close();
this.Close();
}
开发者ID:balajivit1,项目名称:Sourcecode,代码行数:26,代码来源:User.cs
示例11: ArrayBinding_Load
private void ArrayBinding_Load(object sender, System.EventArgs e)
{
// Access database
System.Windows.Forms.DataVisualization.Charting.Utilities.SampleMain.MainForm mainForm = (System.Windows.Forms.DataVisualization.Charting.Utilities.SampleMain.MainForm)this.ParentForm;
// The XML document
string fileNameString = mainForm.applicationPath + "\\data\\data.xml";
string fileNameSchema = mainForm.applicationPath + "\\data\\data.xsd";
// Initializes a new instance of the DataSet class
DataSet custDS = new DataSet();
// Reads an XML schema into the DataSet.
custDS.ReadXmlSchema( fileNameSchema );
// Reads XML schema and data into the DataSet.
custDS.ReadXml( fileNameString );
// Initializes a new instance of the DataView class
DataView firstView = new DataView(custDS.Tables[0]);
Chart1.Series.Clear();
// Since the DataView implements and IEnumerable, pass the reader directly into
// the DataBindTable method with the name of the column used for the X value.
Chart1.DataBindTable(firstView, "Name");
// Set series appearance
Chart1.Series[0].ChartType = SeriesChartType.Bar;
Chart1.Series[0].Font = new Font("Trebuchet MS", 8);
Chart1.Series[0].Color = System.Drawing.Color.FromArgb(220, 224,64,10);
Chart1.Series[0].BorderWidth = 0;
}
开发者ID:zhaohengyi,项目名称:WinChartControlerSamples,代码行数:32,代码来源:XMLData.cs
示例12: ExecuteDataSet
public static DataSet ExecuteDataSet(CommandType cmdType, string strProcedureName, SqlParameter[] objParameters)
{
DataSet dset = new DataSet();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["db1ConnectionString"].ToString());
con.Open();
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = cmdType;
cmd.CommandText = strProcedureName;
AttachParameters(cmd, objParameters);
SqlDataAdapter ad = new SqlDataAdapter(cmd);
ad.Fill(dset);
return dset;
}
catch (Exception ex)
{
return dset;
}
finally
{
con.Close();
}
}
开发者ID:hbb20,项目名称:gtu_pde,代码行数:29,代码来源:DataAccess.cs
示例13: load_price
protected void load_price()
{
string price_name = null;
string article = null;
price_name = Request.QueryString["price_name"];
article = Request.QueryString["article"];
if (article != null)
{
if (price_name != null)
{
SqlConnection con = new SqlConnection(str);
string sql = "SELECT id, article, ROUND([price]*(SELECT course FROM Course_USD WHERE id = 1),2) AS [price] FROM " + price_name + " WHERE article=" + article + ";";
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
da.Fill(ds, price_name);
DataRow dr;
dr = ds.Tables[price_name].Rows[0];
//Заполняем стоимость товара:
lblprice.Text = dr["price"].ToString();
}
else {Response.Redirect("Error.aspx");}
}
else {Response.Redirect("Error.aspx"); }
}
开发者ID:sgkMoscow,项目名称:vorsinstrument,代码行数:28,代码来源:Zubilo_po_betonu_ploskoe_40x250mm_SDS_plus_Optim.aspx.cs
示例14: SaveRecord
public static int SaveRecord(string sql)
{
const int rv = 0;
try
{
string connectionString = ConfigurationManager.ConnectionStrings["LA3Access"].ConnectionString;
using (var conn = new OleDbConnection(connectionString))
{
conn.Open();
var cmGetID = new OleDbCommand("SELECT @@IDENTITY", conn);
var comm = new OleDbCommand(sql, conn) { CommandType = CommandType.Text };
comm.ExecuteNonQuery();
var ds = new DataSet();
var adapt = new OleDbDataAdapter(cmGetID);
adapt.Fill(ds);
adapt.Dispose();
cmGetID.Dispose();
return int.Parse(ds.Tables[0].Rows[0][0].ToString());
}
}
catch (Exception)
{
}
return rv;
}
开发者ID:FuriousLogic,项目名称:LA3_DataTransfer,代码行数:28,代码来源:CoreFunctions.cs
示例15: GetAllAutos
public IList<Models.Auto> GetAllAutos()
{
DataSet ds = new DataSet();
myCommand = new SqlDataAdapter("Select * from Auto", myConnection);
ds = new DataSet();
myCommand.Fill(ds);
IList<Models.Auto> AutoList = new List<Models.Auto>();
foreach (DataRow item in ds.Tables[0].Rows)
{
AutoList.Add(new Auto
{
AutoNumber = item["AutoNumber"].ToString(),
AutoName = item["AutoName"].ToString()
});
}
ds.Dispose();
ds = null;
return AutoList;
}
开发者ID:dfwdino,项目名称:Closed-MVC-GasTracker,代码行数:26,代码来源:ASQLFunctions.cs
示例16: SquadForm
public SquadForm(DbConnect postgreConnect, DataSet globalDS, int squadID = -1)
{
InitializeComponent();
cbColumn = new DataGridViewCheckBoxColumn();
cbColumn.HeaderText = "Является сотрудником отряда";
cbColumn.DataPropertyName = "is_in_squad";
cbColumn.FillWeight = 40;
cbColumn.ReadOnly = false;
dataSet1 = globalDS;
postgreConnection = postgreConnect;
squadSelectBS.DataSource = dataSet1.Tables["squad"];
listBox1.DataSource = dataSet1.Tables["squad"];
listBox1.DisplayMember = "name";
listBox1.ValueMember = "id";
initEnd = true;
if (listBox1.SelectedValue != null)
ChangeSelectedSquad(int.Parse(listBox1.SelectedValue.ToString()));
else
DeactivateAllButtons();
SetButtonPermissions();
if (squadID != -1)
listBox1.SelectedValue = squadID;
bindingNavigator2.BindingSource = selectionsDataBS;
bindingNavigator1.BindingSource = employeesAddBS;
dataGridView1.DataSource = selectionsDataBS;
}
开发者ID:demty,项目名称:bd_company,代码行数:26,代码来源:SquadForm.cs
示例17: GetAll
public DataSet GetAll(string empresaid, tb_co_tabla01_mediopago BE)
{
using (SqlConnection cnx = new SqlConnection(conex.empConexion(empresaid)))
{
using (SqlCommand cmd = new SqlCommand("gspTbCoTabla01Mediopago_SEARCH", cnx))
{
DataSet ds = new DataSet();
{
cmd.CommandTimeout = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@codigoid", SqlDbType.Char, 3).Value = BE.codigoid;
cmd.Parameters.Add("@descripcion", SqlDbType.VarChar, 100).Value = BE.descripcion;
cmd.Parameters.Add("@sigla", SqlDbType.Char, 3).Value = BE.sigla;
cmd.Parameters.Add("@usuar", SqlDbType.Char, 15).Value = BE.usuar;
}
try
{
cnx.Open();
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(ds);
}
return ds;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
}
}
开发者ID:njmube,项目名称:ErpBapSoftNet_Producion,代码行数:31,代码来源:tb_co_tabla01_mediopagoDA.cs
示例18: BindData
public void BindData()
{
DataSet searchList = new DataSet();
StringBuilder builder = new StringBuilder();
if (this.txtKeyword.Text.Trim() != "")
{
builder.Append(" NickName like '%" + this.txtKeyword.Text + "%' ");
}
if (!string.IsNullOrEmpty(this.txtBeginTime.Text.Trim()))
{
if (builder.Length > 0)
{
builder.Append(" and ");
}
builder.Append(" convert(date,User_dateCreate)>='" + this.txtBeginTime.Text.Trim() + "' ");
}
if (Globals.SafeInt(this.dropType.SelectedValue, -1) > -1)
{
if (builder.Length > 0)
{
builder.Append(" and ");
}
builder.Append(" Activity=" + this.dropType.SelectedValue + " ");
}
if (!string.IsNullOrEmpty(this.txtEndTime.Text.Trim()))
{
if (builder.Length > 0)
{
builder.Append(" and ");
}
builder.Append(" convert(date,User_dateCreate)<='" + this.txtEndTime.Text.Trim() + "' ");
}
searchList = this.user.GetSearchList("UU", builder.ToString());
this.gridView.DataSetSource = searchList;
}
开发者ID:huaminglee,项目名称:myyyyshop,代码行数:35,代码来源:List.cs
示例19: process
public void process(ServiceRequest request, ServiceResponse response)
{
List<Category> list = new List<Category>();
string sqlStr = "select * from category";
MySqlConnection conn = ConnectionManager.getInstance().getConnection();
conn.Open();
MySqlDataAdapter mda = new MySqlDataAdapter(sqlStr, conn);
DataSet ds = new DataSet();
mda.Fill(ds,"table1");
conn.Close();
int count = ds.Tables["table1"].Rows.Count;
for (int i = 0; i < count; i++)
{
Category c = new Category();
c.categoryId = (int)ds.Tables["table1"].Rows[i][0];
c.categoryName = (string)ds.Tables["table1"].Rows[i][1];
list.Add(c);
}
GetCategoryResponse serviceResponse = new GetCategoryResponse();
serviceResponse.categories = list;
response.responseObj = serviceResponse;
response.returnCode = 0;
}
开发者ID:CtripHackthon,项目名称:TravelOnline,代码行数:30,代码来源:GetCategory.cs
示例20: BindData
private void BindData()
{
SqlDataSource1.DataBind();
//string sqlquery = "SELECT * FROM [ISBEPI_DEV].[dbo].[HomeVisitorSiteVisitSurvey] WHERE Schd_ID = 16";
DataTable dt = new DataTable();
DataSourceSelectArguments args = new DataSourceSelectArguments();
DataView view = (DataView)SqlDataSource1.Select(args);
dt = view.ToTable();
DataSet ds = new DataSet();
ds.Tables.Add(dt);
DataSet new_ds = FlipDataSet(ds); // Flip the DataSet
DataView my_DataView = new_ds.Tables[0].DefaultView;
this.DataGrid1.DataSource = my_DataView;
this.DataGrid1.DataBind();
DataTable dt2 = new DataTable();
DataSourceSelectArguments args2 = new DataSourceSelectArguments();
DataView view2 = (DataView)SqlDataSource2.Select(args2);
dt2 = view2.ToTable();
DataSet ds2 = new DataSet();
ds2.Tables.Add(dt2);
DataSet new_ds2 = FlipDataSet(ds2); // Flip the DataSet
DataView my_DataView2 = new_ds2.Tables[0].DefaultView;
this.DataGrid2.DataSource = my_DataView2;
this.DataGrid2.DataBind();
}
开发者ID:saltmktg,项目名称:isbepi.erikson.edu,代码行数:26,代码来源:PDtoExcel.aspx.cs
注:本文中的System.Data.DataSet类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论