本文整理汇总了C#中System.Data.OleDb.OleDbCommand类的典型用法代码示例。如果您正苦于以下问题:C# OleDbCommand类的具体用法?C# OleDbCommand怎么用?C# OleDbCommand使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
OleDbCommand类属于System.Data.OleDb命名空间,在下文中一共展示了OleDbCommand类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的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();
}
开发者ID:sankeerthsaan18,项目名称:Dignostic,代码行数:33,代码来源:Form5.cs
示例2: 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
示例3: FillCombo
public void FillCombo()
{
try
{
con = new OleDbConnection(cs);
con.Open();
string ct = "select RTRIM(CategoryName) from Category order by CategoryName";
cmd = new OleDbCommand(ct);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
cmbCategory.Items.Add(rdr[0]);
}
con.Close();
con = new OleDbConnection(cs);
con.Open();
string ct1 = "select RTRIM(CompanyName) from Company order by CompanyName";
cmd = new OleDbCommand(ct1);
cmd.Connection = con;
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
cmbCompany.Items.Add(rdr[0]);
}
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
开发者ID:balavigneshs,项目名称:iMgmt,代码行数:35,代码来源:frmProduct.cs
示例4: EnterToSite
public int EnterToSite(UserDetails userDetails)//בודק על פי האימייל והסיסמא האם המשתשמש שמנסה להיכנס לאתר קיים או לא
{
OleDbCommand myCmd = new OleDbCommand("CheckIfUserExist", myConnection);
myCmd.CommandType = CommandType.StoredProcedure;
OleDbParameter objParam;
objParam = myCmd.Parameters.Add("@Email", OleDbType.BSTR);
objParam.Direction = ParameterDirection.Input;
objParam.Value = userDetails.email;
objParam = myCmd.Parameters.Add("@Password", OleDbType.BSTR);
objParam.Direction = ParameterDirection.Input;
objParam.Value = userDetails.password;
int x = 0;
try
{
myConnection.Open();
x = (int)myCmd.ExecuteScalar();
}
catch (Exception ex)
{
throw ex;
}
finally
{
myConnection.Close();
}
return x;
}
开发者ID:yanoovoni,项目名称:Rdroid,代码行数:32,代码来源:UserService.cs
示例5: datefilterPlanMeal_DayRender
protected void datefilterPlanMeal_DayRender(object sender, DayRenderEventArgs e)
{
OleDbCommand command = new OleDbCommand("SELECT * FROM PlannedMeal WHERE UserDataID = " + userID + " ORDER BY CreatedDate DESC", myConnection);
OleDbDataReader dr = command.ExecuteReader();
// Read DataReader till it reaches the end
while (dr.Read() == true)
{
// Assign the Calendar control dates
// already contained in the database
//datefilterPlanMeal.SelectedDates.Add((DateTime)dr["CreatedDate"]);
if (e.Day.Date == (DateTime)dr["CreatedDate"])
{
e.Cell.BackColor = System.Drawing.Color.Silver;
}
}
if (e.Day.IsSelected)
{
e.Cell.BackColor = System.Drawing.ColorTranslator.FromHtml("#4db6ac");
e.Cell.ForeColor = System.Drawing.Color.White;
}
// Close DataReader
dr.Close();
}
开发者ID:trinhphandinhhuy,项目名称:FoodApp,代码行数:25,代码来源:PlannedMealHistory.aspx.cs
示例6: fill_form
private void fill_form(string p_id)
{
String strQuery = String.Empty;
OleDbConnection sqlConn = new OleDbConnection();
OleDbCommand sqlComm = new OleDbCommand();
OleDbDataReader sqlRead;// = new OleDbDataReader();
DateTime strReturn = DateTime.Now;
//
sqlConn.ConnectionString = PCPUB.m_oledb_connection.ToString();
sqlConn.Open();
//
strQuery = String.Empty;
strQuery += " SELECT";
strQuery += " [yarn_count_id],";
strQuery += " [yarn_count_name]";
strQuery += " FROM [tis_yarn_count]";
strQuery += " WHERE [yarn_count_id] = '" + p_id + "'";
//
sqlComm.Connection = sqlConn;
sqlComm.CommandText = strQuery.ToString();
sqlRead = sqlComm.ExecuteReader();
//
if (sqlRead.Read())
{
txt_yarn_count_id.Text = sqlRead["yarn_count_id"].ToString();
txt_yarn_count_name.Text = sqlRead["yarn_count_name"].ToString();
}
//
sqlRead.Close();
sqlConn.Close();
sqlRead.Dispose();
sqlComm.Dispose();
sqlConn.Dispose();
}
开发者ID:balasmani,项目名称:texpro,代码行数:34,代码来源:FMAD104.cs
示例7: LoadContain
public string LoadContain()
{
if (Request.QueryString["CourseId"] == null)
{
return string.Empty;
}
string ThePath = string.Empty;
string RetData = string.Empty;
using (OleDbConnection Con = new OleDbConnection(constr))
{
OleDbCommand cmd = new OleDbCommand(String.Format("SELECT TOP 1 DataPath FROM CoursenotimeDataPath WHERE CourseId = {0}", Request.QueryString["CourseId"]), Con);
try
{
Con.Open();
ThePath = cmd.ExecuteScalar().ToString();
//if (ThePath != string.Empty)
// ThePath = MapPath(DB.CourseNoTimeFileDir + ThePath);
ThePath = DB.CourseNoTimeFileDir + ThePath;
TextReader TR = new StreamReader(ThePath);
RetData = TR.ReadToEnd();
TR.Close();
TR.Dispose();
}
catch (Exception ex)
{
RetData = ex.Message;
}
Con.Close();
}
return HttpUtility.HtmlDecode(RetData);
}
开发者ID:EgyFalseX,项目名称:WebSites,代码行数:35,代码来源:ViewCourseNoTimeDetailsViewer.ascx.cs
示例8: btnAddBag_Click
protected void btnAddBag_Click(object sender, EventArgs e)
{
try
{
OleDbConnectionStringBuilder sb = new OleDbConnectionStringBuilder();
sb.Provider = "Microsoft.ACE.OLEDB.12.0";
sb.DataSource = Server.MapPath("/vedb01/uploads/db1.accdb");
OleDbConnection conn = new OleDbConnection(sb.ConnectionString);
conn.Open();
string insertQuery = "insert into Bag ( [BagName], [Supplier], [Color], [Category], [Price], [Description]) values (@name ,@supplier ,@color ,@category ,@price ,@description)";
OleDbCommand com = new OleDbCommand(insertQuery, conn);
com.Parameters.AddWithValue("@name", txtBagName.Text);
com.Parameters.AddWithValue("@supplier", txtSupplier.Text);
com.Parameters.AddWithValue("@color", txtColor.Text);
com.Parameters.AddWithValue("@category", txtCategory.Text);
com.Parameters.AddWithValue("@price", txtPrice.Text);
com.Parameters.AddWithValue("@description", txtDescription.Text);
com.ExecuteNonQuery();
lblMessage.Text = "The bag was added successfully " + txtBagName.Text + " !";
conn.Close();
}
catch (Exception ex)
{
Response.Write("Error: " + ex.ToString());
lblMessage.Text = "Error" + txtBagName.Text + " !";
}
}
开发者ID:bhrushank,项目名称:quality-bags-asp.net-application,代码行数:31,代码来源:AddBags.aspx.cs
示例9: ExecuteSqlTran
/// <summary>
/// 执行多条SQL语句,实现数据库事务。
/// </summary>
/// <param name="SQLStringList">多条SQL语句</param>
public static void ExecuteSqlTran(ArrayList SQLStringList)
{
using (OleDbConnection conn = new OleDbConnection(connectionString))
{
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
OleDbTransaction tx = conn.BeginTransaction();
cmd.Transaction = tx;
try
{
for (int n = 0; n < SQLStringList.Count; n++)
{
string strsql = SQLStringList[n].ToString();
if (strsql.Trim().Length > 1)
{
cmd.CommandText = strsql;
cmd.ExecuteNonQuery();
}
}
tx.Commit();
}
catch (System.Data.OleDb.OleDbException E)
{
tx.Rollback();
throw new Exception(E.Message);
}
}
}
开发者ID:tianyaalone,项目名称:Water125,代码行数:33,代码来源:DbHelperOleDb.cs
示例10: Page_Load
protected void Page_Load(object sender, System.EventArgs e)
{
// resolve the address to the Access database
string fileNameString = this.MapPath(".");
fileNameString += "..\\..\\..\\..\\data\\chartdata.mdb";
// initialize a connection string
string myConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileNameString;
// define the database query
string mySelectQuery="SELECT GrossSales FROM SALES WHERE QuarterEnding < #01/01/2002#;";
// create a database connection object using the connection string
OleDbConnection myConnection = new OleDbConnection(myConnectionString);
// create a database command on the connection using query
OleDbCommand myCommand = new OleDbCommand(mySelectQuery, myConnection);
// open the connection
myCommand.Connection.Open();
// create a database reader
OleDbDataReader myReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
// since the reader implements and IEnumerable, pass the reader directly into
// the DataBind method with the name of the Column selected in the query
Chart1.Series["Default"].Points.DataBindY(myReader, "GrossSales");
// close the reader and the connection
myReader.Close();
myConnection.Close();
}
开发者ID:samuellin124,项目名称:cms,代码行数:32,代码来源:DataBindingY.aspx.cs
示例11: ReadExcelSheet
public void ReadExcelSheet(string fileName, string sheetName, Action<DataTableReader> actionForEachRow)
{
var connectionString = string.Format(ExcelSettings.Default.ExcelConnectionString, fileName);
using (var excelConnection = new OleDbConnection(connectionString))
{
excelConnection.Open();
if (sheetName == null)
{
var excelSchema = excelConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if (excelSchema != null)
{
sheetName = excelSchema.Rows[0]["TABLE_NAME"].ToString();
}
}
var excelDbCommand = new OleDbCommand(@"SELECT * FROM [" + sheetName + "]", excelConnection);
using (var oleDbDataAdapter = new OleDbDataAdapter(excelDbCommand))
{
var dataSet = new DataSet();
oleDbDataAdapter.Fill(dataSet);
using (var reader = dataSet.CreateDataReader())
{
while (reader.Read())
{
actionForEachRow(reader);
}
}
}
}
}
开发者ID:Team-Tower-Databases-Online,项目名称:Databases-Teamwork-2015,代码行数:34,代码来源:ExcelXlsHandler.cs
示例12: Button1_Click
protected void Button1_Click(object sender, EventArgs e)
{
int lgflg = 0;
OleDbConnection conn = new OleDbConnection(ConfigurationSettings.AppSettings["classDB"]);
OleDbCommand cmd = new OleDbCommand("SELECT * FROM student WHERE studentpassword = '" + password.Text + "' AND email = '" + userName.Text + "'", conn);
conn.Open();
OleDbDataReader myReader = cmd.ExecuteReader();
while (myReader.Read())
{
lgflg = 1;
Session.Add("fname", myReader["Contact_name"]);
Session.Add("address", myReader["address"]);
Session.Add("city", myReader["city"]);
Session.Add("state", myReader["state"]);
Session.Add("zipcode", myReader["zipcode"]);
}
myReader.Close();
conn.Close();
if (lgflg == 1)
{
Response.Write(Session["fname"]);
}
else
{
error.Visible = true;
}
}
开发者ID:KungfuCreatives,项目名称:P3WebApp,代码行数:31,代码来源:Login.aspx.cs
示例13: ExecuteDataReader
public IDataReader ExecuteDataReader(string connectionString, string query)
{
_connection = new OleDbConnection(connectionString);
_connection.Open();
var command = new OleDbCommand(query, _connection);
return command.ExecuteReader();
}
开发者ID:Dimweed,项目名称:temporary-viewwwsearcher,代码行数:7,代码来源:OleDbAdapter.cs
示例14: Autocomplete
private void Autocomplete()
{
try
{
con = new OleDbConnection(cs);
con.Open();
OleDbCommand cmd = new OleDbCommand("SELECT distinct ProductName FROM product", con);
DataSet ds = new DataSet();
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
da.Fill(ds, "Product");
AutoCompleteStringCollection col = new AutoCompleteStringCollection();
int i = 0;
for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
col.Add(ds.Tables[0].Rows[i]["productname"].ToString());
}
txtProductName.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtProductName.AutoCompleteCustomSource = col;
txtProductName.AutoCompleteMode = AutoCompleteMode.Suggest;
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
开发者ID:balavigneshs,项目名称:iMgmt,代码行数:28,代码来源:frmProduct.cs
示例15: addToDatabase
private void addToDatabase(string sql)
{
OleDbConnection db = null;
try
{
db = new OleDbConnection();
db.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + mFileName;
db.Open();
OleDbCommand command = new OleDbCommand(sql, db);
command.ExecuteNonQuery();
}
catch (Exception ex)
{
showErrorMessage(ex.Message);
}
finally
{
if (db != null)
{
db.Close();
}
}
}
开发者ID:jocull,项目名称:ContactManagement,代码行数:25,代码来源:UpdateContact.cs
示例16: Button1_Click
protected void Button1_Click(object sender, EventArgs e)
{
try
{
OleDbConnectionStringBuilder sb = new OleDbConnectionStringBuilder();
sb.Provider = "Microsoft.ACE.OLEDB.12.0";
sb.DataSource = Server.MapPath("/vedb01/uploads/db1.accdb");
OleDbConnection conn = new OleDbConnection(sb.ConnectionString);
conn.Open();
string updateQuery = "UPDATE Bag SET [email protected], [email protected], [email protected], [email protected], [email protected], [email protected] WHERE BagID= @ID";
OleDbCommand com = new OleDbCommand(updateQuery, conn);
com.Parameters.AddWithValue("@ID", txtBagId.Text);
com.Parameters.AddWithValue("@name", txtBagName.Text);
com.Parameters.AddWithValue("@supplier", txtSupplier.Text);
com.Parameters.AddWithValue("@color", txtColor.Text);
com.Parameters.AddWithValue("@category", txtCategory.Text);
com.Parameters.AddWithValue("@price", txtPrice.Text);
com.Parameters.AddWithValue("@description", txtDescription.Text);
com.ExecuteNonQuery();
lblMessage.Text = "The bag No " + txtBagId.Text +" was updated successfully " + txtBagName.Text + " !";
conn.Close();
}
catch (Exception ex)
{
Response.Write("Error: " + ex.ToString());
lblMessage.Text = "Error !";
}
}
开发者ID:bhrushank,项目名称:quality-bags-asp.net-application,代码行数:33,代码来源:AddBags.aspx.cs
示例17: ExecuteDataSet
/// <summary>
/// 执行查询语句,返回DataSet
/// </summary>
/// <param name="SQLString">查询语句</param>
/// <returns>DataSet</returns>
public override DataSet ExecuteDataSet(string SQLString, params IDataParameter[] cmdParms)
{
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
OleDbCommand cmd = new OleDbCommand();
PrepareCommand(cmd, connection, null, SQLString, cmdParms);
using (OleDbDataAdapter da = new OleDbDataAdapter(cmd))
{
DataSet ds = new DataSet();
try
{
da.Fill(ds, "ds");
cmd.Parameters.Clear();
}
catch (OleDbException e)
{
//LogManage.OutputErrLog(e, new Object[] { SQLString, cmdParms });
throw;
}
finally
{
cmd.Dispose();
connection.Close();
}
return ds;
}
}
}
开发者ID:qq5013,项目名称:JXNG,代码行数:33,代码来源:OLEDataBaseProvider.cs
示例18: btn_Browser_Click
private void btn_Browser_Click(object sender, EventArgs e)
{
OpenFileDialog P_open = new OpenFileDialog();//创建打开文件对话框对象
P_open.Filter = "文本文件|*.txt|所有文件|*.*";//设置筛选字符串
if (P_open.ShowDialog() == DialogResult.OK)
{
txt_Path.Text = P_open.FileName;//显示文件路径
string conn = string.Format(//创建连接字符串
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=text",
P_open.FileName.Substring(0,P_open.FileName.LastIndexOf(@"\")));
OleDbConnection P_OleDbConnection = new OleDbConnection(conn);//创建连接对象
try
{
P_OleDbConnection.Open();//打开连接
OleDbCommand cmd = new OleDbCommand(//创建命令对象
string.Format("select * from {0}",
P_open.FileName.Substring(P_open.FileName.LastIndexOf(@"\"),
P_open.FileName.Length - P_open.FileName.LastIndexOf(@"\"))),
P_OleDbConnection);
OleDbDataReader oda = cmd.ExecuteReader();//得到数据读取器对象
while (oda.Read())
{
txt_Message.Text += oda[0].ToString();//得到文本文件中的字符串
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);//弹出消息对话框
}
finally
{
P_OleDbConnection.Close();//关闭连接
}
}
}
开发者ID:mahuidong,项目名称:c-1200-II,代码行数:35,代码来源:Frm_Main.cs
示例19: MSAccessDataUtility
public MSAccessDataUtility()
{
command = new OleDbCommand();
command.Connection = GetConnection();
}
开发者ID:NRPS,项目名称:NRT,代码行数:7,代码来源:MSAccessDataUtility.cs
示例20: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
System.Data.OleDb.OleDbConnection Conn = new System.Data.OleDb.OleDbConnection();
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("app_data/productsdb.mdb");
Conn.Open();
//Response.Write(Conn.State);
System.Data.OleDb.OleDbCommand Comm = new System.Data.OleDb.OleDbCommand();
System.Data.OleDb.OleDbDataReader dr;
Comm.Connection = Conn;
Comm.CommandText = "select productid, productname, productiondescription, price, qoh, imagelocation from products";
if (Request.Params["categoryid"] != null && Request.Params["categoryid"].Length >0)
{
Comm.CommandText += " where categoryid = ?" ;
Comm.Parameters.AddWithValue("anything", Request.Params["categoryid"].ToString());
}
dr = Comm.ExecuteReader();
bool firstone = true;
Response.Write("{\"product\":[");
while (dr.Read())
{
if (!firstone)
{
Response.Write(",");
}
Response.Write(dr[0].ToString());
firstone = false;
}
Response.Write("]}");
}
开发者ID:jasonhuber,项目名称:2010FallB_CIS407,代码行数:35,代码来源:getProducts.aspx.cs
注:本文中的System.Data.OleDb.OleDbCommand类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论