本文整理汇总了C#中System.Data.DataTable.Load方法的典型用法代码示例。如果您正苦于以下问题:C# DataTable.Load方法的具体用法?C# DataTable.Load怎么用?C# DataTable.Load使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.DataTable
的用法示例。
在下文中一共展示了DataTable.Load方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: lc
private void lc(object sender, MouseEventArgs e)
{
c.Open();
DataSet ds = new DataSet();
string query = "select ID,pname,bill,pbill from pdetails where [email protected] ";
OleDbCommand cmd = new OleDbCommand(query, c);
cmd.Parameters.Add("@bc", OleDbType.Date).Value = dateTimePicker1.Value.Date;
OleDbDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(dr);
/*ds.Tables.Add(dt);
OleDbDataAdapter da = new OleDbDataAdapter();
da.Fill(dt);*/
dataGridView1.DataSource = dt.DefaultView;
c.Close();
try
{
c.Open();
String str = @"SELECT SUM(pbill) FROM pdetails WHERE [email protected];";
OleDbCommand comm2 = new OleDbCommand(str, c);
comm2.Parameters.Add("@bb", OleDbType.Date).Value = dateTimePicker1.Value.Date;
bill = Convert.ToDouble(comm2.ExecuteScalar());
label3.Text = bill.ToString() + "/-";
}
catch(Exception ex)
{
MessageBox.Show("selected date miss match");
c.Close();
}
c.Close();
}
示例2: GetLastIDInserted
public String GetLastIDInserted(String pStrDBTable)
{
String mStrSQL = "SELECT IDENT_CURRENT('" + pStrDBTable + "')";
String mStrLastIDInserted = "";
try
{
oCommand = new SqlCommand(mStrSQL,oConnection);
oReader = oCommand.ExecuteReader();
oTable = new DataTable();
oTable.Load(oReader);
foreach (DataRow oDataRow in oTable.Rows)
{
foreach (DataColumn oDataColumn in oTable.Columns)
{
mStrLastIDInserted = oDataRow[oDataColumn.ColumnName].ToString();
}
}
}
catch (DataException Ex)
{
mStrLastIDInserted = "";
}
oCommand = null;
oReader = null;
oTable = null;
return mStrLastIDInserted;
}
示例3: HashSum
public HashSum(SqlDataReader reader, String secret = "PZS")
{
DataTable dt = new DataTable();
dt.Load(reader);
dt.TableName = secret;
this.dt = dt;
}
示例4: btnAdminCalEdit_Click
protected void btnAdminCalEdit_Click(object sender, EventArgs e)
{
lblAdminCalBlockDate.Visible = true;
txtAdminCalBlockDate.Visible = true;
grdviewAdminCalendar.Visible = true;
conn = new SqlConnection(connstr);
cmd = new SqlCommand("select * from AdminCalendar", conn);
System.Data.DataTable dt = new System.Data.DataTable();
conn.Open();
rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
dt.Load(rdr);
grdviewAdminCalendar.DataSource = dt;
grdviewAdminCalendar.DataBind();
clear();
}
else
{
dt.Load(rdr);
grdviewAdminCalendar.DataSource = dt;
grdviewAdminCalendar.EmptyDataText = "No Record Found";
grdviewAdminCalendar.DataBind();
}
FillHolidayDataset();
conn.Close();
clear();
}
示例5: RetrieveQuery
/// <summary>
/// Selects and retrieves values from the database
/// </summary>
/// <param name="query">The selection statement</param>
/// <returns>A DataTable with the retrieved values></returns>
public static DataTable RetrieveQuery(string query)
{
if (Regex.IsMatch(query, @"-{2,}"))
{
throw new SQLInjectionException();
}
using (OracleConnection c = new OracleConnection(@connectionstring))
{
try
{
c.Open();
OracleCommand cmd = new OracleCommand(@query);
cmd.Connection = c;
try
{
OracleDataReader r = cmd.ExecuteReader();
DataTable result = new DataTable();
result.Load(r);
c.Close();
return result;
}
catch (OracleException e)
{
Console.Write(e.Message);
throw;
}
}
catch (OracleException e)
{
Console.Write(e.Message);
return new DataTable();
}
}
}
示例6: ExecuteSqlQuery
public static DataTable ExecuteSqlQuery(string query, params SqlCeParameter[] sqlParams)
{
var dt = new DataTable();
using (var conn = new SqlCeConnection(connStr))
using (var cmd = new SqlCeCommand(query, conn))
{
try
{
SqlCeEngine engine = new SqlCeEngine(conn.ConnectionString);
engine.Upgrade(conn.ConnectionString);
}
catch
{
}
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddRange(sqlParams);
conn.Open();
dt.Load(cmd.ExecuteReader());
}
return dt;
}
示例7: ExecuteSelectCommand
// executes a command and returns the results as a DataTable object
public static DataTable ExecuteSelectCommand(DbCommand command)
{
// The DataTable to be returned
DataTable table;
// Execute the command making sure the connection gets closed in the end
try
{
// Open the data connection
command.Connection.Open();
// Execute the command and save the results in a DataTable
DbDataReader reader = command.ExecuteReader();
table = new DataTable();
table.Load(reader);
// Close the reader
reader.Close();
}
catch (Exception ex)
{
Utilities.LogError(ex);
throw;
}
finally
{
// Close the connection
command.Connection.Close();
}
return table;
}
示例8: query
public DataTable query(String sql)
{
lock (syncQuery)
{
SqlConnection sqlConn = getConnection();
if (sqlConn.State != ConnectionState.Open)
{
sqlConn.Open();
}
DataTable dt = new DataTable();
SqlCommand sqlcmd = new SqlCommand(sql, sqlConn);
try
{
SqlDataReader dr = sqlcmd.ExecuteReader();
dt.Load(dr);
}
catch (SqlException ae)
{
log.Info(ae.Message.ToString());
log.Info(sql);
}
finally
{
sqlcmd.Dispose();
sqlConn.Close();
}
return dt;
}
}
示例9: GetDataTable
public static DataTable GetDataTable(string sql)
{
DataTable dt = new DataTable();
try
{
SQLiteConnection cnn = new SQLiteConnection(@"Data Source=C:\Projects\showdownsharp\db\showdown.db");
cnn.Open();
SQLiteCommand mycommand = new SQLiteCommand(cnn);
mycommand.CommandText = sql;
SQLiteDataReader reader = mycommand.ExecuteReader();
dt.Load(reader);
reader.Close();
cnn.Close();
} catch {
// Catching exceptions is for communists
}
return dt;
}
示例10: getOrderByID
public DataTable getOrderByID(String pStrID)
{
DataTable dt = new DataTable();
SqlConnection conn = Program.CreateConnection();
SqlCommand cmd = new SqlCommand();
try
{
using (conn)
{
conn.Open();
cmd.Connection = conn;
cmd.CommandText = "SELECT OrderID, UserName, ProdName, PaymentTypeName, ShipperName, CustEmail, DeliveryNotes, OrderAmount FROM Orders WHERE OrderID='" + pStrID + "' " +
"UNION " +
"SELECT OrderID, UserName, ProdName, PaymentTypeName, ShipperName, CustEmail, DeliveryNotes, OrderAmount FROM RejectedOrders WHERE OrderID='" + pStrID + "' " +
"UNION " +
"SELECT OrderID, UserName, ProdName, PaymentTypeName, ShipperName, CustEmail, DeliveryNotes, OrderAmount FROM ApprovedOrders WHERE OrderID='" + pStrID + "'";
dt.Load(cmd.ExecuteReader());
}
}
catch (SqlException)
{
conn.Close();
}
return dt;
}
示例11: PopulateLocation
private void PopulateLocation()
{
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Con"].ConnectionString))
{
string query = "Select * from Locations";
SqlCommand cmd = new SqlCommand(query, con);
if (con.State != ConnectionState.Open)
{
con.Open();
}
dt.Load(cmd.ExecuteReader());
}
direcFrom.DataSource = dt;
direcFrom.DataTextField = "LocName";
direcFrom.DataValueField = "LocID";
direcFrom.DataBind();
direcTo.DataSource = dt;
direcTo.DataTextField = "LocName";
direcTo.DataValueField = "LocID";
direcTo.DataBind();
}
示例12: Get_CtaCteNumeracion
//Get_CtaCteNumeracion
public DataTable Get_CtaCteNumeracion(BE_ReqCtaCteNumeracion Request)
{
DataTable dt = new DataTable();
try
{
clsConection Obj = new clsConection();
string Cadena = Obj.GetConexionString("Naylamp");
using (SqlConnection cn = new SqlConnection(Cadena))
{
cn.Open();
using (SqlCommand cm = new SqlCommand())
{
cm.CommandText = "usp_Get_CtaCteNumeracion";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo);
cm.Connection = cn;
using (SqlDataReader dr = cm.ExecuteReader())
dt.Load(dr);
}
}
}
catch (Exception)
{
throw;
}
return dt;
}
示例13: GeraDataTable
/// <summary>Carrega um <see cref="DataTable" /> a partir de um <see cref="SqlCommand" />.</summary>
/// <param name="comando">Objeto a partir do qual o <see cref="DataTable" /> é carregado.</param>
/// <returns>Retorna o novo <see cref="DataTable" />.</returns>
public static DataTable GeraDataTable(SqlCommand comando)
{
var dataTable = new DataTable();
SqlDataReader reader = comando.ExecuteReader();
dataTable.Load(reader);
return dataTable;
}
示例14: ShowAllBookBank
private void ShowAllBookBank()
{
string sqlUnit;
sqlUnit = "SELECT * FROM BANKDOC ORDER BY BankDocId";
SqlDataReader dr; // สร้าง data reader ชื่อ dr
com = new SqlCommand();
com.CommandType = CommandType.Text;
com.CommandText = sqlUnit; // ดึง sqlunit
com.Connection = Conn; // เชื่อมกะ db
dr = com.ExecuteReader(); // รันชุดคำสั่ง
if (dr.HasRows)
{
DataTable dt = new DataTable(); // สร้าง object datatable มาชื่อ dt
dt.Load(dr); // ให้ dt โหลดข้อมูลออกมา
//CheckResult = dt.Rows.Count;
dgvSelectBookBank.DataSource = dt; // แสดงรายชื่อ ลงไปยัง dgv unit ( Datagrid view)
FormatdgvHead();// FormatHeadDgv
}
else
{
//CheckResult = 0;
dgvSelectBookBank.DataSource = null; // ล้างข้อมูลออก
}
dr.Close(); // ปิด object dr
}
示例15: GetName
public static string GetName(int id)
{
string _out;
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["PrimaryDatabase"].ConnectionString);
con.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT name FROM States WHERE id =" + Convert.ToString(id);
using (SqlDataReader sdr = cmd.ExecuteReader())
{
if (sdr != null && sdr.HasRows)
{
DataTable dt = new DataTable();
dt.Load(sdr);
_out = dt.Rows[0]["name"].ToString();
return _out;
}
}
}
return null;
}