本文整理汇总了C#中System.Data.DataSet类的典型用法代码示例。如果您正苦于以下问题:C# DataSet类的具体用法?C# DataSet怎么用?C# DataSet使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
DataSet类属于System.Data命名空间,在下文中一共展示了DataSet类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的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];
}
示例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();
}
示例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;
}
示例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;
}
示例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"]);
}
}
示例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();
}
示例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;
}
}
示例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;
}
示例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();
}
}
示例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();
}
示例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;
}
示例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();
}
}
示例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;
}
示例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;
}