public BasketForm() { InitializeComponent(); string LoginUsername = "******"; object[] meta = new object[1]; bool read = true; string connString; connString = @"Provider=Microsoft.JET.OLEDB.4.0;Data Source = L:\Comp-1632-System Development Project\TicketBookingSystem\TicketBookingSystem\TicketSysDB.mdb"; OleDbConnection myConnection = new OleDbConnection(connString); myConnection.Open(); OleDbCommand myCommand = new OleDbCommand("SELECT * FROM [Basket] WHERE [UserID] = @Username", myConnection); myCommand.Parameters.AddWithValue("@Username", LoginUsername); OleDbDataReader reader = myCommand.ExecuteReader(); if (reader.Read() == true) { do { int NumberOfColums = reader.GetValues(meta); int NumberOfRows = reader.GetValues(meta); string play = reader.GetString(2); int quantity = reader.GetInt32(6); string TicketType = reader.GetString(3); { for (int j = 0; j < NumberOfRows; j++) { if (TicketType == "<div>Standard</div>" || TicketType == "Standard") { numericUpDown1.Value += quantity; } else if (TicketType == "<div>Child</div>" || TicketType == "Child") { numericUpDown2.Value += quantity; } else if (TicketType == "<div>OAP</div>" || TicketType == "OAP") { numericUpDown3.Value += quantity; } } } Console.WriteLine(); read = reader.Read(); } while (read == true); } reader.Close(); }
public void updateScreen() { string LoginUsername = Account.LoginUsername; if (LoginUsername != null) { object[] meta = new object[1]; bool read = true; string connString; connString = @"Provider=Microsoft.JET.OLEDB.4.0;Data Source = F:\Year 2\Systems Development\Coursework\SystemsDevelopment-master\TicketBookingSystem\TicketBookingSystem\TicketSysDB.mdb"; OleDbConnection myConnection = new OleDbConnection(connString); myConnection.Open(); OleDbCommand myCommand = new OleDbCommand("SELECT * FROM [Basket] WHERE [UserID] = @Username", myConnection); myCommand.Parameters.AddWithValue("@Username", LoginUsername); OleDbDataReader reader = myCommand.ExecuteReader(); if (reader.Read() == true) { do { int NumberOfColums = reader.GetValues(meta); int NumberOfRows = reader.GetValues(meta); int orderID = reader.GetInt32(0); string play = reader.GetString(2); DateTime date = reader.GetDateTime(6); string datestring = date.ToShortDateString(); string time = reader.GetString(7); float price = reader.GetInt32(8); int quantity = reader.GetInt32(9); string TicketType = reader.GetString(3); { Orderlist.Add(orderID + ""); Listl.Text += orderID + " " + play + " " + datestring + " " + time + " £" + price + " " + "\n" + "\n" + "\n"; OrderBox.Items.Add(orderID); } Console.WriteLine(); read = reader.Read(); } while (read == true); } reader.Close(); } else { MessageBox.Show("Please Login to Continue"); } }
/// <summary> /// SqlDataReader转成DataTable实现方法 /// </summary> /// <param name="strSql"></param> /// <returns></returns> public DataTable DataReaderToDataTable(string strSql) { //string connstr = ConfigurationManager.ConnectionStrings["mycon"].ConnectionString; OleDbConnection OleDbConn = new OleDbConnection(connstr); OleDbCommand OleDbComm = new OleDbCommand(strSql, OleDbConn); OleDbDataReader dataReader = null; DataTable dtReturn = null; object[] value = null; try { OleDbComm.Connection.Open(); dataReader = OleDbComm.ExecuteReader(); if (dataReader.HasRows) { dtReturn = CreateTableBySchemaTable(dataReader.GetSchemaTable()); value = new object[dataReader.FieldCount]; while (dataReader.Read()) { dataReader.GetValues(value); dtReturn.LoadDataRow(value, true); } value = null; } } catch (Exception err) { } finally { dataReader.Close(); OleDbComm.Connection.Close(); OleDbComm.Dispose(); } return(dtReturn); }
public static List <object[]> ReadTable(string dbName, string tblName) { List <object[]> data = new List <object[]>(); if (!TableExist(dbName, tblName)) { return(data); } OleDbConnection conn = new OleDbConnection(Provider + @"Data Source=" + dbName + ";"); conn.Open(); string strSelect = "SELECT * FROM " + tblName; OleDbCommand cmd = new OleDbCommand(strSelect, conn); OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { object[] values = new object[reader.FieldCount]; reader.GetValues(values); data.Add(values); } reader.Close(); conn.Close(); return(data); }
protected DataTable ReadQueryResult(OleDbCommand command) { DataTable table = new DataTable(); using (OleDbDataReader reader = command.ExecuteReader()) { for (int i = 0; i < reader.FieldCount; i++) { table.Columns.Add(reader.GetName(i), reader.GetFieldType(i)); } object[] values = new object[reader.FieldCount]; while (reader.Read()) { reader.GetValues(values); table.Rows.Add(values); } } foreach (DataColumn col in table.Columns) { if (col.ColumnName.Contains(memberCaption)) { col.ColumnName = col.ColumnName.Remove(col.ColumnName.Length - memberCaption.Length); } } return(table); }
/// <summary> /// 执行查询存储过程返回结果集 /// </summary> /// <param name="TransID">连接字符串</param> /// <param name="StrConn">连接字符串</param> /// <param name="ProcedureName">存储过程名</param> /// <param name="Params">Sql 参数,参数值所在位置必须与参数名一致</param> /// <returns>返回数据集</returns> public DataTable QueryProcedureTable(string TransID, string StrConn, string ProcedureName, Dictionary <string, object> Params) { OleDbConnection oConn = GetOleDbConnection(TransID, StrConn); try { using (OleDbCommand oCmd = new OleDbCommand(ProcedureName, oConn)) { oCmd.CommandType = CommandType.StoredProcedure; CreateSqlProcedureParam(oCmd, Params); using (OleDbDataReader odr = oCmd.ExecuteReader(CommandBehavior.CloseConnection)) { using (DataTable dtSchema = odr.GetSchemaTable()) { DataTable dtResult = BuildDataTable(dtSchema); object[] aryValues = new object[odr.FieldCount]; dtResult.BeginLoadData(); while (odr.Read()) { odr.GetValues(aryValues); dtResult.LoadDataRow(aryValues, true); } dtResult.EndLoadData(); aryValues = null; return(dtResult); } } } } finally { CloseConnection(TransID, oConn); } }
/// <summary> /// 执行查询存储过程返回结果集 /// </summary> /// <param name="TransID">连接字符串</param> /// <param name="StrConn">连接字符串</param> /// <param name="ProcedureName">存储过程名</param> /// <param name="Params">Sql 参数,参数值所在位置必须与参数名一致</param> /// <returns>返回数据集</returns> public byte[] QueryProcedure(string TransID, string StrConn, string ProcedureName, Dictionary <string, object> Params) { OleDbConnection oConn = GetOleDbConnection(TransID, StrConn); try { using (OleDbCommand oCmd = new OleDbCommand(ProcedureName, oConn)) { oCmd.CommandType = CommandType.StoredProcedure; CreateSqlProcedureParam(oCmd, Params); using (OleDbDataReader odr = oCmd.ExecuteReader(CommandBehavior.CloseConnection)) { using (DataTable dtSchema = odr.GetSchemaTable()) { using (CJia.Net.Serialization.SerializationWriter sw = new Net.Serialization.SerializationWriter()) { SerializationSchema(sw, dtSchema); object[] aryValues = new object[odr.FieldCount]; while (odr.Read()) { odr.GetValues(aryValues); sw.WriteOptimized(aryValues); } aryValues = null; return(sw.ToArray()); } } } } } finally { CloseConnection(TransID, oConn); } }
/// <summary> /// 执行查询SQL语句 /// </summary> /// <param name="StrConn">连接字符串</param> /// <param name="StrConn">连接字符串</param> /// <param name="TransID">事务ID</param> /// <param name="SqlText">Sql 文本</param> /// <param name="SqlParams">Sql 参数,参数值所在位置必须与参数名一致</param> /// <returns>返回数据集</returns> public DataTable QueryTable(string TransID, string StrConn, string SqlText, object[] SqlParams) { OleDbConnection oConn = GetOleDbConnection(TransID, StrConn); try { using (OleDbCommand oCmd = new OleDbCommand(SqlText, oConn)) { oCmd.Transaction = GetTransaction(TransID); CreateSqlParam(oCmd, SqlParams); using (OleDbDataReader odr = oCmd.ExecuteReader(CommandBehavior.CloseConnection)) { using (DataTable dtSchema = odr.GetSchemaTable()) { DataTable dtResult = BuildDataTable(dtSchema); object[] aryValues = new object[odr.FieldCount]; dtResult.BeginLoadData(); while (odr.Read()) { odr.GetValues(aryValues); dtResult.LoadDataRow(aryValues, true); } dtResult.EndLoadData(); aryValues = null; return(dtResult); } } } } finally { CloseConnection(TransID, oConn); } }
protected static ArrayList execQuery(string sql) { ArrayList result = new ArrayList(); OleDbCommand cmd = new OleDbCommand(sql, conn); try { if (conn.State == ConnectionState.Closed) { conn.Open(); } // conn.Open(); OleDbDataReader dbReader = cmd.ExecuteReader(); while (dbReader.Read()) { object[] values = new object[dbReader.FieldCount]; // 对应一条记录 dbReader.GetValues(values); //将一行的数据读进values数组中 result.Add(values); } } catch (OleDbException ex) { string s = ex.ToString(); MessageBox.Show(s, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { conn.Close(); } return(result); }
//Method: Login User public static User Login(string username, string password) { string getUserQuery = "SELECT * FROM Users WHERE [Username] = @Username AND [Password] = @Password"; using (OleDbConnection oleConn = new OleDbConnection(oleConnectionString)) { oleConn.Open(); object[] user = new object[6]; using (OleDbCommand oleCmd = new OleDbCommand(getUserQuery, oleConn)) { oleCmd.Parameters.AddWithValue("@Username", username); oleCmd.Parameters.AddWithValue("@Password", password); using (OleDbDataReader dr = oleCmd.ExecuteReader()) { while (dr.Read()) { dr.GetValues(user); } } } if (user == null) { Exception ex = new Exception("User Not Found"); throw ex; } else { double userID = double.Parse(user[0].ToString()); List <double> friends = Database.GetFriends(userID); User userObj = new User(userID, user[1].ToString(), friends); return(userObj); } } }
private void EmployeesButton_Click(object sender, RoutedEventArgs e) { string query = "select * from Employees"; OleDbCommand cmd = new OleDbCommand(query, cn); cn.Open(); OleDbDataReader read = cmd.ExecuteReader(); //Hardcoded an arbitrary magic number here. Ideally would be more thoughtful. object[] data = new object[10]; string etext = ""; while (read.Read()) { read.GetValues(data); //And here. for (int i = 0; i < 10; i++) { etext += data[i] + " "; } etext += "\n"; } EmployeeText.Text = etext; cn.Close(); }
public ImportDelimitedEventArgs(OleDbDataReader reader, int number) { object[] columns = new object[reader.FieldCount]; reader.GetValues(columns); _content = new ReadOnlyCollection <object>(columns); _lineNr = number; }
public static void readFromDB(OleDbConnection conn) { string testSelect = " SELECT * FROM ImportAccess"; OleDbCommand comm = new OleDbCommand(testSelect, conn); OleDbDataReader dr = comm.ExecuteReader(); object[] buffer = { 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 }; StringBuilder sb = new StringBuilder(); while (dr.Read())// populate buffer with values from db { int value = dr.GetValues(buffer); for (int i = 0; i < buffer.Length; i++) { sb.Append(buffer[i] + ","); } sb.Remove(buffer.Length - 1, 1); } ConsoleKeyInfo cki = new ConsoleKeyInfo(); while (true) // keep console window open { Console.WriteLine("Returned values " + sb.ToString()); cki = Console.ReadKey(true); if (cki.Key == ConsoleKey.X) { break; } } dr.Close(); }
private void btnExport_Click(object sender, EventArgs e) { try { OleDbConnection Myconnection = null; OleDbDataReader dbReader = null; Myconnection = new OleDbConnection(connectionName); Myconnection.Open(); OleDbCommand cmd = Myconnection.CreateCommand(); cmd.CommandText = "SELECT * FROM AVR WHERE [Rapport nr] =" + aktuelRapportNR; dbReader = cmd.ExecuteReader(); object[] liste = new object[dbReader.FieldCount]; if (dbReader.Read() == true) { int NumberOfColums = dbReader.GetValues(liste); for (int i = 0; i < NumberOfColums; i++) { output += "|" + liste[i].ToString(); } } dbReader.Close(); Myconnection.Close(); txtStatus.Text = "Export Lykkes! Luk programmet!"; } catch (Exception) { txtStatus.Text = "Export Fejlet!"; } }
public override bool Update() { bool have_data = reader.Read(); if (!have_data) { return(false); } Index += 1; reader.GetValues(rowdata); var time = (DateTime)rowdata[0]; var detail = (string)rowdata[1]; var err = (string)rowdata[2]; var source = (string)rowdata[3]; // New batch: hla ips perf r01 // Run recipe: sonosep-LoopRecipe if (err == "Recipe started") // new recipe start event { var name = detail.Substring("Run recipe: ".Length); _record.SetNewRecipeData(name); } else { _record.SetRecipeStepData(Index.ToString(), time.ToString(), detail, source); } return(true); }
protected static List <Object[]> executeReader(string sql) { List <Object[]> result = new List <object[]>(); OleDbCommand cmd = new OleDbCommand(sql, conn); try { if (conn.State == ConnectionState.Closed) { conn.Open(); } OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Object[] values = new Object[reader.FieldCount]; reader.GetValues(values); result.Add(values); } } catch (OleDbException ex) { string s = ex.ToString(); MessageBox.Show(s, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { conn.Close(); } return(result); }
private string[] queryDB(string query, string dbPath) { string connectionString = string.Format("Provider={0}; Data Source={1}; Jet OLEDB:Engine Type={2}", "Microsoft.Jet.OLEDB.4.0", dbPath, 5); OleDbConnection connection = new OleDbConnection(connectionString); connection.Open(); OleDbCommand command = new OleDbCommand(query, connection); object[] row = null; try { using (OleDbDataReader reader = command.ExecuteReader()) { while (reader.Read()) { row = new object[reader.FieldCount]; reader.GetValues(row); } command.Dispose(); } connection.Close(); string result = (string)row[0];; return(new string[] { null, result }); } catch (Exception ex) { connection.Close(); return(new string[] { ex.Message, null });; } }
public static List <object[]> execQuery(string sql) { List <object[]> result = new List <object[]>(); OleDbCommand cmd = new OleDbCommand(sql, conn); try { conn.Open(); OleDbDataReader dbReader = cmd.ExecuteReader(); while (dbReader.Read()) { object[] values = new object[dbReader.FieldCount]; dbReader.GetValues(values);//将一行的数据读进values数组中 result.Add(values); } } catch (OleDbException ex) { string s = ex.ToString(); } finally { conn.Close(); } return(result); }
private void GetData(string tablename, string sSql, string sDisplayField) { dataGridView1.Rows.Clear(); dataGridView1.Columns.Clear(); try { using (OleDbConnection sqlconn = new OleDbConnection(CommonClass.sDBConnectionString)) { OleDbCommand sqlcom = new OleDbCommand("select " + sDisplayField + " from " + tablename + " where 线编号='" + CommonClass.listDIC[0].sLineCode + "' and 行别='" + CommonClass.listDIC[0].sDir + "' " + sSql, sqlconn); sqlconn.Open(); OleDbDataReader oddr = sqlcom.ExecuteReader(); for (int i = 0; i < oddr.VisibleFieldCount; i++) { dataGridView1.Columns.Add(oddr.GetName(i), oddr.GetName(i)); } while (oddr.Read()) { object[] o = new object[oddr.VisibleFieldCount]; oddr.GetValues(o); dataGridView1.Rows.Add(o); } sqlconn.Close(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } //CommonClass.listDIC[0].sLineCode }
public ArrayList getDataORA(String str) { try { using (OleDbConnection con_ora = new OleDbConnection(strConnection)) { con_ora.Open(); using (OleDbCommand command = new OleDbCommand(str, con_ora)) { using (OleDbDataReader reader = command.ExecuteReader()) { ArrayList list = new ArrayList(); while (reader.Read()) { object[] values = new object[reader.FieldCount]; reader.GetValues(values); list.Add(values); } return(list); } } } } catch (Exception e) { // strError = e.Message.ToString(); return(null); } }
public Good GetGood(int id) { Good result = new Good(); string query = "select * from [GoodsTable] where Id = " + id.ToString(); OleDbConnection cnn = new OleDbConnection(ConnString); OleDbCommand cmd = new OleDbCommand(query, cnn); cmd.CommandType = System.Data.CommandType.Text; cnn.Open(); OleDbDataReader reader = cmd.ExecuteReader(); object[] data; reader.Read(); data = new object[reader.FieldCount]; reader.GetValues(data); result.Id = Convert.ToInt32(data[0]); result.Name = data[1].ToString(); result.Amount = Convert.ToInt32(data[2]); result.BarCode = Convert.ToInt32(data[3]); reader.Close(); cnn.Close(); return(result); }
public static DataTable ConvertDataReaderToDataTable(OleDbDataReader reader) { var objDataTable = new DataTable("TmpDataTable"); try { var intFieldCount = reader.FieldCount; //获取当前行中的列数; for (var intCounter = 0; intCounter <= intFieldCount - 1; intCounter++) { objDataTable.Columns.Add(reader.GetName(intCounter), reader.GetFieldType(intCounter)); } //populate datatable objDataTable.BeginLoadData(); //object[] objValues = new object[intFieldCount -1]; var objValues = new object[intFieldCount]; while (reader.Read()) { reader.GetValues(objValues); objDataTable.LoadDataRow(objValues, true); } reader.Close(); objDataTable.EndLoadData(); return(objDataTable); } catch (Exception ex) { throw new Exception("转换出错出错!", ex); } }
private List <string> StartNetworkScan(CancellationToken ct) { List <string> localNetworks = new List <string>(); if (ct.IsCancellationRequested) { return(localNetworks); } using (OleDbDataReader reader = OleDbEnumerator.GetEnumerator(Type.GetTypeFromProgID("SQLOLEDB Enumerator"))) { while (reader.Read()) { if (ct.IsCancellationRequested) { return(localNetworks); } object[] row = new object[reader.FieldCount]; reader.GetValues(row); string networkHost = (string)row[0]; if (!localNetworks.Contains(networkHost)) { localNetworks.Add(networkHost); } } } return(localNetworks); }
public List <Good> GetAll() { List <Good> result = new List <Good>(); string query = "select * from [GoodsTable]"; OleDbConnection cnn = new OleDbConnection(ConnString); OleDbCommand cmd = new OleDbCommand(query, cnn); cmd.CommandType = System.Data.CommandType.Text; cnn.Open(); OleDbDataReader reader = cmd.ExecuteReader(); object[] data; while (reader.Read()) { data = new object[reader.FieldCount]; reader.GetValues(data); result.Add( new Good { Id = Convert.ToInt32(data[0]), Name = data[1].ToString(), Amount = Convert.ToInt32(data[2]), BarCode = Convert.ToInt32(data[3]) }); } reader.Close(); cnn.Close(); return(result); }
public static List <object[]> getSet(string query) { List <object[]> set = new List <object[]>(); string _path_to_db = HttpContext.Current.Server.MapPath(@"~/resultdb.accdb"); OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + _path_to_db); try { con.Open(); OleDbCommand cmd = con.CreateCommand(); cmd.CommandText = query; OleDbDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { object[] record = new object[rdr.FieldCount]; rdr.GetValues(record); set.Add(record); } } catch (Exception ex) { } con.Close(); return(set); }
public static void Main() { using (OleDbConnection connection = new OleDbConnection("Provider=SQLOLEDB;Data Source=(local);Integrated Security=SSPI;Initial Catalog=Northwind")) { object[] meta = new object[10]; bool read; OleDbCommand command = new OleDbCommand("select * from Region", connection); connection.Open(); OleDbDataReader reader = command.ExecuteReader(); if (reader.Read() == true) { do { int NumberOfColums = reader.GetValues(meta); for (int i = 0; i < NumberOfColums; i++) { Console.Write("{0} ", meta[i].ToString()); } Console.WriteLine(); read = reader.Read(); } while (read == true); } reader.Close(); } }
public static string AccessRecordData(string tbl) { string k = ""; object[] recs = new Object[100]; int numOfObjs = 0; char t = '\t'; string rec = ""; if (AccessReader.Read() == false) { return("END OF FILE"); } else { numOfObjs = AccessReader.GetValues(recs); for (int y = 0; y < numOfObjs; y++) { k = recs[y].ToString(); k = TestString(k); rec = rec + t.ToString() + k; } rec = rec.Substring(1); } return(rec); }
private void button1_Click(object sender, EventArgs e) { // determination de type de compte int type = listBox2.SelectedIndex; // récuperation des variable String nom = textBox1.Text; String prenom = textBox2.Text; String mail = textBox3.Text; String password = textBox4.Text; // Connexion au Data Base try { OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=../../../../database.accdb"); OleDbCommand cmd = con.CreateCommand(); con.Open(); cmd.Connection = con; // last inserted id cmd.CommandText = "Select n° from users "; int id = -1; Object[] meta = new object[10]; OleDbDataReader read = cmd.ExecuteReader(); while (read.Read()) { int x; int n = read.GetValues(meta); x = (int)meta[0]; if (x > id) { id = x; } } id++; read.Close(); // insertion de nouveau utilisateur cmd.CommandText = "insert into users values (" + id + ",'" + nom + "','" + prenom + "','" + mail + "','" + password + "'," + type + ") "; int insert = cmd.ExecuteNonQuery(); if (insert > 0) { MessageBox.Show(" Votre utilisateur est ajoutée "); } else { MessageBox.Show(" Une erreur se produite lors d'ajout de votre utilisateur "); } //close con con.Close(); } catch (System.Data.OleDb.OleDbException exp) { // cas de erreur lié a la conexion a DB MessageBox.Show("Erreur de Connexion : " + exp.ToString()); } // cacher ce interface Hide(); }
public static void fillListView(ListView lv, String sql, string[] ch) { lv.View = View.Details; //定义列表显示的方式 lv.MultiSelect = false; // 不可以多行选择 lv.HeaderStyle = ColumnHeaderStyle.Nonclickable; lv.Visible = true; lv.GridLines = true; //画表格线 lv.FullRowSelect = true; //点击时整行选中 lv.Columns.Clear(); //将原有的列清空 lv.Items.Clear(); // 将原有的行清空 if (ch != null) { for (int i = 0; i < ch.Length; i++) { // 设置表头信息 lv.Columns.Add(ch[i], 80, HorizontalAlignment.Center); } } OleDbCommand cmd = new OleDbCommand(sql, conn); try { conn.Open(); OleDbDataReader dbReader = cmd.ExecuteReader(); object[] values = new object[dbReader.FieldCount]; // 对应一条记录 if (ch == null) { for (int i = 0; i < dbReader.FieldCount; i++) { lv.Columns.Add(dbReader.GetName(i), 80, HorizontalAlignment.Center); } } while (dbReader.Read()) { dbReader.GetValues(values); //将一样的数据读进values数组中 ListViewItem li = new ListViewItem(); //形成一个表项 li.SubItems.Clear(); li.SubItems[0].Text = values[0].ToString().Trim(); //设置第一列 for (int i = 1; i < values.Length; i++) { li.SubItems.Add(values[i].ToString().Trim()); //其余的列 } lv.Items.Add(li); } } catch (OleDbException ex) { string s = ex.ToString(); MessageBox.Show(s); } finally { conn.Close(); } }
public int GetValues(object[] values) { if (SDR != null) { return(SDR.GetValues(values)); } else { return(ODR.GetValues(values)); } }