private void buttonInfoMessage_Click(object sender, EventArgs e)
{
/**** Create this Store Procedure in the tempdb database first ****
Create Proc TestInfoMessage
as
Print 'Using a Print Statement'
RaisError('RaisError in Stored Procedures', 9, 1)
****************************************************/
//1. Make a Connection
System.Data.OleDb.OleDbConnection objOleCon = new System.Data.OleDb.OleDbConnection();
objOleCon.ConnectionString = strConnection;
objOleCon.Open();
objOleCon.InfoMessage += new System.Data.OleDb.OleDbInfoMessageEventHandler(objOleCon_InfoMessage);
//2. Issue a Command
System.Data.OleDb.OleDbCommand objCmd;
objCmd = new System.Data.OleDb.OleDbCommand("Raiserror('Typical Message Goes Here', 9, 1)", objOleCon);
objCmd.ExecuteNonQuery();
objCmd = new System.Data.OleDb.OleDbCommand("Exec TestInfoMessage", objOleCon); //This executes the stored procedure.
objCmd.ExecuteNonQuery();
//3. Process the Results
/** No Results at this time **/
//4. Clean up code
objOleCon.Close();
}
protected void btnGo_Click(object sender, EventArgs e)
{
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();
string sql = "";
System.Data.DataSet ds = new System.Data.DataSet();
System.Data.OleDb.OleDbDataReader dr;
System.Data.OleDb.OleDbCommand comm = new System.Data.OleDb.OleDbCommand();
//http://www.c-sharpcorner.com/UploadFile/dchoksi/transaction02132007020042AM/transaction.aspx
//get this from connectionstrings.com/access
conn.ConnectionString = txtConnString.Text;
conn.Open();
//here I can talk to my db...
System.Data.OleDb.OleDbTransaction Trans;
Trans = conn.BeginTransaction(System.Data.IsolationLevel.Chaos);
try
{
comm.Connection = conn;
comm.Transaction = Trans;
// Trans.Begin();
//Console.WriteLine(conn.State);
sql = txtSQL.Text;
comm.CommandText = sql;
if (sql.ToLower().IndexOf("select") == 0)
{
dr = comm.ExecuteReader();
while (dr.Read())
{
txtresults.Text = dr.GetValue(0).ToString();
}
}
else
{
txtresults.Text = comm.ExecuteNonQuery().ToString();
}
Trans.Commit();
}
catch (Exception ex)
{
txtresults.Text = ex.Message;
Trans.Rollback();
}
finally
{
comm.Dispose();
conn.Close();
conn = null;
}
}
public DataTable SelectToDataTable(string sql)
{
//set connection
System.Data.OleDb.OleDbConnection con = new System.Data.OleDb.OleDbConnection();
con.ConnectionString = connectString;
//set commandtext
System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand();
command.CommandText = sql;
command.Connection = con;
//set adapter
System.Data.OleDb.OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter();
adapter.SelectCommand = command;
//creat a datatable
DataTable dt = new DataTable();
try
{
//open this connection
con.Open();
adapter.Fill(dt);
}
catch (Exception ex)
{
//throw new Exception
con.Close();
}
finally
{
//close this connection
con.Close();
}
//return a datatable
return dt;
}
/// <summary>
/// M�todo necesario para admitir el Dise�ador, no se puede modificar
/// el contenido del m�todo con el editor de c�digo.
/// </summary>
private void InitializeComponent()
{
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.dsFicha1 = new ficha_antecedentes_personales.dsFicha();
((System.ComponentModel.ISupportInitialize)(this.dsFicha1)).BeginInit();
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = "Provider=SQLOLEDB;server=edoras;OLE DB Services = -2;uid=protic;pwd=,.protic;init" +
"ial catalog=protic2";
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = @"select '' as nombre, '' as rut, '' as pasaporte, '' as fecha_nac, '' as fono, '' as nacionalidad, '' as Estado_civil, '' as Direccion, '' as comuna, '' as ciudad, '' as region, '' as colegio_egreso, '' as ano_egreso, '' as proced_educ, '' as inst_educ_sup, '' as Carrera, '' as ano_ingr, '' as FinanciaEst, '' as ultimo_post_ncorr, '' as nombre_sost_ec, '' as RUT_sost_ec, '' as fnac_sost_ec, '' as edad_sost, '' as fono_sost_ec, '' as pare_sost_ec, '' as dire_tdesc_sost_ec, '' as comu_sost_ec, '' as ciud_sost_ec, '' as regi_sost_ec";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
//
// dsFicha1
//
this.dsFicha1.DataSetName = "dsFicha";
this.dsFicha1.Locale = new System.Globalization.CultureInfo("es-CL");
this.dsFicha1.Namespace = "http://www.tempuri.org/dsFicha.xsd";
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.dsFicha1)).EndInit();
}
public System.Collections.Generic.List<string> GetColumnNames(string file, string table)
{
System.Data.DataTable dataSet = new System.Data.DataTable();
string connString = "";
if (Global.filepassword != "")
{
if (Path.GetExtension(file).ToString().ToUpper() != ".ACCDB")
connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file + ";Jet OLEDB:Database Password="******"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + file + ";Jet OLEDB:Database Password="******".ACCDB")
connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file;
else
connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + file + ";Persist Security Info=False;";
}
using (System.Data.OleDb.OleDbConnection connection = new System.Data.OleDb.OleDbConnection(connString))
{
connection.Open();
System.Data.OleDb.OleDbCommand Command = new System.Data.OleDb.OleDbCommand("SELECT * FROM " + table, connection);
using (System.Data.OleDb.OleDbDataAdapter dataAdapter = new System.Data.OleDb.OleDbDataAdapter(Command))
{
dataAdapter.Fill(dataSet);
}
}
System.Collections.Generic.List<string> columns = new System.Collections.Generic.List<string>();
for (int i = 0; i < dataSet.Columns.Count; i++)
{
columns.Add(dataSet.Columns[i].ColumnName);
}
return columns;
}
protected void btnInsert_Click(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/products.mdb");
Conn.Open();
//Response.Write(Conn.State);
string strSQL = "insert into [users] ([username], firstname, lastname, email, [password]) values (?,?,?,?,?)";
object returnVal;
System.Data.OleDb.OleDbCommand Comm = new System.Data.OleDb.OleDbCommand();
Comm.Connection = Conn;
Comm.CommandText = "select [username] from [users] where [username] = ?";
Comm.Parameters.AddWithValue("[username]", txtUserName.Text);
returnVal = Comm.ExecuteScalar();
if (returnVal == null)
{
Comm.Parameters.Clear();
Comm.CommandText = strSQL;
Comm.Parameters.AddWithValue("username", txtUserName.Text);
Comm.Parameters.AddWithValue("firstname", txtFName.Text);
Comm.Parameters.AddWithValue("lastname", txtLName.Text);
Comm.Parameters.AddWithValue("email", txtEmail.Text);
Comm.Parameters.AddWithValue("password", txtPassword.Text);
Comm.ExecuteNonQuery();
}
else {
Response.Write("Username already exists.");
}
Conn.Close();
Conn = null;
}
public void insertImage(string wkImg)
{
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
cmd.CommandText = "Insert into [" + TableName + "] (imageName) values('" + wkImg + "') ";
cmd.Connection = conn;
cmd.ExecuteNonQuery();
}
public static IDbCommand CreateCommand(EnumProviders provider)
{
IDbCommand cmd;
switch (provider)
{
case EnumProviders.SqlServer:
cmd = new System.Data.SqlClient.SqlCommand();
break;
case EnumProviders.OleDb:
cmd = new System.Data.OleDb.OleDbCommand();
break;
case EnumProviders.Odbc:
cmd = new System.Data.Odbc.OdbcCommand();
break;
case EnumProviders.Oracle:
throw new NotImplementedException("Provider not implemented");
break;
default:
cmd = new System.Data.SqlClient.SqlCommand();
break;
}
return cmd;
}
/// <summary>
/// M�todo necesario para admitir el Dise�ador, no se puede modificar
/// el contenido del m�todo con el editor de c�digo.
/// </summary>
private void InitializeComponent()
{
System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.datosInforme1 = new informe_1.datosInforme();
((System.ComponentModel.ISupportInitialize)(this.datosInforme1)).BeginInit();
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Table", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE")})});
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT \'\' AS NOMBRE FROM DUAL";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
//
// datosInforme1
//
this.datosInforme1.DataSetName = "datosInforme";
this.datosInforme1.Locale = new System.Globalization.CultureInfo("es-ES");
this.datosInforme1.Namespace = "http://www.tempuri.org/datosInforme.xsd";
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.datosInforme1)).EndInit();
}
public static void makeAll(System.String baseDirectory, System.String version)
{
//make base directory
if (!(baseDirectory.EndsWith("\\") || baseDirectory.EndsWith("/")))
{
baseDirectory = baseDirectory + "/";
}
System.IO.FileInfo targetDir = SourceGenerator.makeDirectory(baseDirectory + PackageManager.GetVersionPackagePath(version) + "EventMapping");
//get list of data types
System.Data.OleDb.OleDbConnection conn = NormativeDatabase.Instance.Connection;
System.String sql = "SELECT * from HL7EventMessageTypes inner join HL7Versions on HL7EventMessageTypes.version_id = HL7Versions.version_id where HL7Versions.hl7_version = '" + version + "'";
System.Data.OleDb.OleDbCommand temp_OleDbCommand = new System.Data.OleDb.OleDbCommand();
temp_OleDbCommand.Connection = conn;
temp_OleDbCommand.CommandText = sql;
System.Data.OleDb.OleDbDataReader rs = temp_OleDbCommand.ExecuteReader();
using (StreamWriter sw = new StreamWriter(targetDir.FullName + @"\EventMap.properties", false))
{
sw.WriteLine("#event -> structure map for " + version);
while (rs.Read())
{
string messageType = string.Format("{0}_{1}", rs["message_typ_snd"], rs["event_code"]);
string structure = (string) rs["message_structure_snd"];
sw.WriteLine(string.Format("{0} {1}", messageType, structure));
}
}
}
public void DBSetup()
{
// +++++++++++++++++++++++++++ DBSetup function +++++++++++++++++++++++++++
// This DBSetup() method instantiates all the DB objects needed to access a DB,
// including OleDbDataAdapter, which contains 4 other objects(OlsDbSelectCommand,
// oleDbInsertCommand, oleDbUpdateCommand, oleDbDeleteCommand.) And each
// Command object contains a Connection object and an SQL string object.
OleDbDataAdapter2 = new System.Data.OleDb.OleDbDataAdapter();
OleDbSelectCommand2 = new System.Data.OleDb.OleDbCommand();
OleDbInsertCommand2 = new System.Data.OleDb.OleDbCommand();
OleDbUpdateCommand2 = new System.Data.OleDb.OleDbCommand();
OleDbDeleteCommand2 = new System.Data.OleDb.OleDbCommand();
OleDbConnection2 = new System.Data.OleDb.OleDbConnection();
OleDbDataAdapter2.DeleteCommand = OleDbDeleteCommand2;
OleDbDataAdapter2.InsertCommand = OleDbInsertCommand2;
OleDbDataAdapter2.SelectCommand = OleDbSelectCommand2;
OleDbDataAdapter2.UpdateCommand = OleDbUpdateCommand2;
// The highlighted text below should be changed to the location of your own database
OleDbConnection2.ConnectionString = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Reg" + "istry Path =; Jet OLEDB:Database L" +
"ocking Mode=1;Data Source= C:\\Users\\Trenton MCleod\\Desktop\\RegistrationDB.mdb;J" +
"et OLEDB:Engine Type=5;Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:System datab" +
"ase=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Mode=S" +
"hare Deny None;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet " +
"OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repai" +
"r=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1";
} //end DBSetup()
public int AddEvent(String eventName, String eventRoom,
String eventAttendees, String eventDate)
{
System.Data.OleDb.OleDbConnection oleDbConnection1;
System.Data.OleDb.OleDbDataAdapter daEvents;
DataSet ds;
oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
oleDbConnection1.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=C:\\Inetpub\\wwwroot\\PCSWebApp3\\PCSWebApp3.mdb";
String oleDbCommand = "INSERT INTO Events (Name, Room, AttendeeList," +
" EventDate) VALUES ('" + eventName + "', '" +
eventRoom + "', '" + eventAttendees + "', '" +
eventDate + "')";
System.Data.OleDb.OleDbCommand insertCommand =
new System.Data.OleDb.OleDbCommand(oleDbCommand,
oleDbConnection1);
oleDbConnection1.Open();
int queryResult = insertCommand.ExecuteNonQuery();
if (queryResult == 1)
{
daEvents = new System.Data.OleDb.OleDbDataAdapter(
"SELECT * FROM Events", oleDbConnection1);
ds = (DataSet)Application["ds"];
ds.Tables["Events"].Clear();
daEvents.Fill(ds, "Events");
Application.Lock();
Application["ds"] = ds;
Application.UnLock();
oleDbConnection1.Close();
}
return queryResult;
}
public virtual int FillByWhereClause(AccountDataset.AccountsDataTable dataTable, string whereClause, System.Data.OleDb.OleDbParameter[] parameters)
{
System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand();
command.Connection = this.Connection;
command.CommandText = @"select * from
(Select ""C-"" & CustomerID as ID, ""Customer"" AS CustomerSupplierFlag,
CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax, '' as HomePage, CreateID, CreateUser, ModifyID, ModifyUser
from Customers
Union
Select ""S-"" & SupplierID as ID, ""Supplier"" AS CustomerSupplierFlag,
CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax, HomePage, CreateID, CreateUser, ModifyID, ModifyUser
FROM Suppliers) as a "
+ whereClause + ";";
command.CommandType = System.Data.CommandType.Text;
if (null != parameters)
command.Parameters.AddRange(parameters);
this.Adapter.SelectCommand = command;
if ((this.ClearBeforeFill == true))
{
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
/// <summary>
/// Create access database file
/// </summary>
public static void create_mdb_file(DataSet ds, string destination, string template)
{
if(SqlConvert.ToString(template) == "")
throw new Err("You must specify the location of a template mdb file inherit from.");
if(!System.IO.File.Exists(template))
throw new Err("The specified template file \"" + template + "\" could not be found.");
if(SqlConvert.ToString(destination) == "")
throw new Err("You must specify the destination location and filename of the mdb file to create.");
//COPY THE TEMPLATE AND CREATE DESTINATION FILE
System.IO.File.Copy(template,destination,true);
//CONNECT TO THE DESTINATION FILE
string sconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + destination + ";";
System.Data.OleDb.OleDbConnection oconn = new System.Data.OleDb.OleDbConnection(sconn);
oconn.Open();
System.Data.OleDb.OleDbCommand ocmd = new System.Data.OleDb.OleDbCommand();
ocmd.Connection = oconn;
//WRITE TO THE DESTINATION FILE
try
{
oledb.insert_dataset(ds,ocmd);
}
catch(Exception ex)
{
//System.Web.HttpContext.Current.Response.Write(ex.ToString());
General.Debugging.Report.SendError("Error exporting to MS Access", ex.ToString() + "\r\n\r\n\r\n" + ocmd.CommandText);
}
finally
{
// Close the connection.
oconn.Close();
}
}
private void button3_Click(object sender, EventArgs e)
{ // Botão btnResultados
try
{
string id1 = txtIdade1.Text;
string id2 = txtIdade2.Text;
string strSsexo = "";
if (rbMasculino.Checked) strSsexo = " sexo = 'M' AND ";
else if (rbFeminino.Checked) strSsexo = " sexo = 'F' AND ";
else strSsexo = "";
sql = "select * from alunos WHERE " + strSsexo
+ " idade>=" + id1 + " AND idade<=" + id2
+ " ORDER BY nome";
stm = new System.Data.OleDb.OleDbCommand(sql, conexao);
rs = stm.ExecuteReader();
string strSaida = "";
while (rs.Read())
{
string dados = "RGM: " + rs.GetString(0)
+ ", " + rs.GetString(1) + ", idade: " + rs.GetInt32(3)
+ ", sexo: " + rs.GetString(4)
+ ", curso: " + rs.GetString(2);
strSaida += dados + "\r\n";
}
txtResultados.Text = strSaida;
}
catch (Exception exsql) { MessageBox.Show("Erro na consulta"); }
if(stm!=null)stm.Dispose();
if(rs!=null)rs.Close();
}
public static bool AnalyzeExcel(ExcelXMLLayout layout)
{
System.Data.OleDb.OleDbConnection conn = null;
try
{
conn = new System.Data.OleDb.OleDbConnection(MakeConnectionString(layout.solution.path));
conn.Open();
System.Data.DataTable table = conn.GetOleDbSchemaTable(
System.Data.OleDb.OleDbSchemaGuid.Columns,
new object[] { null, null, layout.sheet + "$", null });
layout.Clear();
System.Diagnostics.Debug.WriteLine("Start Analyze [" + table.Rows.Count + "]");
foreach (System.Data.DataRow row in table.Rows)
{
string name = row["Column_Name"].ToString();
System.Diagnostics.Debug.WriteLine(name);
// 测试数据类型
ExcelXMLLayout.KeyType testType = ExcelXMLLayout.KeyType.Unknown;
{
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(
string.Format("select [{0}] from [{1}$]", name, layout.sheet), conn
);
System.Data.OleDb.OleDbDataReader r = cmd.ExecuteReader();
while (r.Read())
{
System.Diagnostics.Debug.WriteLine(r[0].GetType());
if (r[0].GetType() == typeof(System.Double))
{
testType = ExcelXMLLayout.KeyType.Integer;
break;
}
if (testType == ExcelXMLLayout.KeyType.String)
{
break;
}
testType = ExcelXMLLayout.KeyType.String;
}
r.Close();
cmd.Dispose();
}
layout.Add(name, testType);
}
table.Dispose();
conn.Close();
return true;
}
catch (Exception outErr)
{
lastError = string.Format("无法分析，Excel 无法打开\r\n{0}", outErr.Message);
}
return false;
}
public string getRowCount()
{
string query = "select * from [" + TableName + "]";
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(query, conn);
System.Data.OleDb.OleDbDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dataTable.Load(dr);
dr.Close();
return dataTable.Rows.Count.ToString();
}
public static System.Data.OleDb.OleDbCommand Comando(string sql, params object[] args)
{
System.Data.OleDb.OleDbCommand com = new System.Data.OleDb.OleDbCommand(sql, cnx);
for (System.Int32 i = 0; i < args.Length; i++)
{
System.Data.OleDb.OleDbParameter par = new System.Data.OleDb.OleDbParameter("DPeriodo_" + i, args[i]);
com.Parameters.Add(par);
}
return com;
}
private void m_select()
{
this.oDS = new DataSet();
this.rq_sql = "SELECT * FROM TB_PERSONNE;"; //Requête SELECT Paramétrée
this.oCMD = new System.Data.OleDb.OleDbCommand(this.rq_sql, this.oCNX); //Création d'un objet commande qui prend en paramètre la requête SQL et la l'objet de Connexion a la BDD.
this.oDA = new System.Data.OleDb.OleDbDataAdapter(this.oCMD); //Création d'un objet DataAdapter qui prend en paramètre l'objet commande. (DataAdapter et l'interface réel entre l'application et la BDD.
this.oDA.Fill(this.oDS, "personne"); //Execution de la requête SQL, si retournes des enregistrements, elle sont placé dans l'objet DataSet, dans la DataTable "Personne".
this.dataGridView1.DataSource = this.oDS; //On attribue le modèle de mon DataSet au gridview pour afficher mes enregistrement.
this.dataGridView1.DataMember = "personne"; //Mais bien définir la table a afficher, car le DataSet peut en contenir plusieur.
}
//##########################################################
//# Changer l'emplacement de la BDD #
//##########################################################
private void Form1_Load()
{
this.rq_sql = null;
//Changer l'emplacement ou ce trouve votre BDD
this.cnx = @"Provider = Microsoft.Jet.OLEDB.4.0; Data Source = C:\Users\Orage\Documents\Visual Studio 2015\Projects\AppBaseDeDonnee\AppBaseDeDonnee\MyBDD.mdb";
this.oCNX = new System.Data.OleDb.OleDbConnection(this.cnx);
this.oCMD = null;
this.oDA = null;
this.oDS = new DataSet();
this.m_select();
}
public DataSet Method1()
{
string s = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("Northwind1.mdb") + ";Persist Security Info=False";
string z = "select * from Клиенты";
System.Data.OleDb.OleDbConnection olcon = new System.Data.OleDb.OleDbConnection(s);
System.Data.OleDb.OleDbCommand olcom = new System.Data.OleDb.OleDbCommand(z, olcon);
System.Data.OleDb.OleDbDataAdapter DA = new System.Data.OleDb.OleDbDataAdapter(olcom);
System.Data.DataSet DS = new System.Data.DataSet();
DA.Fill(DS);
return DS;
}
public System.Data.DataTable Read(string filename)
{
var excelDataAdapter = new System.Data.OleDb.OleDbDataAdapter();
_connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + filename + "; Extended Properties = Excel 8.0;";
var excelConn = new System.Data.OleDb.OleDbConnection(_connectionString);
excelConn.Open();
var dtProtocol = new System.Data.DataTable { TableName = "Protocol" };
var excelCommand = new System.Data.OleDb.OleDbCommand("SELECT * FROM [протокол плавки$]", excelConn);
excelDataAdapter.SelectCommand = excelCommand;
excelDataAdapter.Fill(dtProtocol);
excelConn.Close();
return dtProtocol;
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.dgNotes = new System.Windows.Forms.DataGrid();
this.daJoin = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
((System.ComponentModel.ISupportInitialize)(this.dgNotes)).BeginInit();
this.SuspendLayout();
//
// dgNotes
//
this.dgNotes.DataMember = "";
this.dgNotes.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dgNotes.Location = new System.Drawing.Point(16, 16);
this.dgNotes.Name = "dgNotes";
this.dgNotes.Size = new System.Drawing.Size(744, 336);
this.dgNotes.TabIndex = 0;
//
// daJoin
//
this.daJoin.SelectCommand = this.oleDbSelectCommand1;
this.daJoin.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "Notes", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("primulatext", "primulatext"),
new System.Data.Common.DataColumnMapping("visitnote", "visitnote"),
new System.Data.Common.DataColumnMapping("noteid", "noteid"),
new System.Data.Common.DataColumnMapping("primula", "primula")})});
this.daJoin.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter1_RowUpdated);
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source=""C:\Documents and Settings\Anders Ruberg\Mina dokument\Visual Studio Projects\RehabLight\bin\Debug\rehab.mdb"";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False";
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT Charges.primulatext, Notes.visitnote, Notes.noteid, Notes.primula FROM (No" +
"tes INNER JOIN Charges ON Charges.chargeid = Notes.chargeid) WHERE (Notes.primul" +
"a = FALSE) AND (Notes.visitnote = TRUE) AND (MID([Notes.visitdatetime], 1, 4) = " +
"\'2007\')";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// FilteredNotes
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(768, 390);
this.Controls.Add(this.dgNotes);
this.Name = "FilteredNotes";
this.Text = "FilteredNotes";
((System.ComponentModel.ISupportInitialize)(this.dgNotes)).EndInit();
this.ResumeLayout(false);
}
public void UpdateDateTime(string skey, DateTime StartDatetime, DateTime updatetime)
{
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
string Query = "Update [" + TableName + "] set submittedOn = '" + StartDatetime.ToString("dd/MM/yyyy hh:mm:ss") + "' ";
if (updatetime.Year > 1900)
{
Query += ", lastEdited = '" + updatetime.ToString("dd/MM/yyyy hh:mm:ss") + "'";
}
Query += " Where imagePath = '" + skey + "'";
cmd.CommandText = Query;
cmd.Connection = conn;
int x = cmd.ExecuteNonQuery();
}
/// <summary>
/// M�todo necesario para admitir el Dise�ador, no se puede modificar
/// el contenido del m�todo con el editor de c�digo.
/// </summary>
private void InitializeComponent()
{
System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.contrato1 = new reporte_contrato.contrato();
((System.ComponentModel.ISupportInitialize)(this.contrato1)).BeginInit();
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "contrato", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("NOMBRE_INSTITUCION", "NOMBRE_INSTITUCION"),
new System.Data.Common.DataColumnMapping("RUT_INSTITUCION", "RUT_INSTITUCION"),
new System.Data.Common.DataColumnMapping("RUT_POSTULANTE", "RUT_POSTULANTE"),
new System.Data.Common.DataColumnMapping("EDAD", "EDAD"),
new System.Data.Common.DataColumnMapping("NOMBRE_ALUMNO", "NOMBRE_ALUMNO"),
new System.Data.Common.DataColumnMapping("CARRERA", "CARRERA"),
new System.Data.Common.DataColumnMapping("RUT_CODEUDOR", "RUT_CODEUDOR"),
new System.Data.Common.DataColumnMapping("NOMBRE_CODEUDOR", "NOMBRE_CODEUDOR"),
new System.Data.Common.DataColumnMapping("DIRECCION", "DIRECCION"),
new System.Data.Common.DataColumnMapping("CIUDAD", "CIUDAD"),
new System.Data.Common.DataColumnMapping("COMUNA", "COMUNA"),
new System.Data.Common.DataColumnMapping("TIPO_DOCUMENTO", "TIPO_DOCUMENTO"),
new System.Data.Common.DataColumnMapping("DOCUMENTO", "DOCUMENTO"),
new System.Data.Common.DataColumnMapping("NOMBRE_BANCO", "NOMBRE_BANCO"),
new System.Data.Common.DataColumnMapping("VALOR_DOCTO", "VALOR_DOCTO"),
new System.Data.Common.DataColumnMapping("FECHA_VENCIMIENTO", "FECHA_VENCIMIENTO"),
new System.Data.Common.DataColumnMapping("TOTAL_M", "TOTAL_M"),
new System.Data.Common.DataColumnMapping("TOTAL_A", "TOTAL_A")})});
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = @"SELECT '' AS NOMBRE_INSTITUCION, '' AS RUT_INSTITUCION, '' AS RUT_POSTULANTE, '' AS EDAD, '' AS NOMBRE_ALUMNO, '' AS CARRERA, '' AS RUT_CODEUDOR, '' AS NOMBRE_CODEUDOR, '' AS DIRECCION, '' AS CIUDAD, '' AS COMUNA, '' AS TIPO_DOCUMENTO, '' AS DOCUMENTO, '' AS NOMBRE_BANCO, '' AS VALOR_DOCTO, '' AS FECHA_VENCIMIENTO, '' AS TOTAL_M, '' AS TOTAL_A FROM DUAL";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
//
// contrato1
//
this.contrato1.DataSetName = "contrato";
this.contrato1.Locale = new System.Globalization.CultureInfo("es-ES");
this.contrato1.Namespace = "http://www.tempuri.org/contrato.xsd";
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.contrato1)).EndInit();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.oleDbCommand1 = new System.Data.OleDb.OleDbCommand();
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=C:\Inetpub\wwwroot\CSharpBook\nwind.mdb;Mode=Share Deny None;Extended Properties="""";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="""";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False";
//
// oleDbCommand1
//
this.oleDbCommand1.Connection = this.oleDbConnection1;
this.Load += new System.EventHandler(this.Page_Load);
}
public void AttemptReadingDBFWithOLEDB()
{
//FeatureLayer target = new MapPolygonLayer();
string filename = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "TestFiles", "soils.shp");
string dBaseFile = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "TestFiles");
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source = " + dBaseFile + ";Extended Properties =dBase IV;";
System.Data.OleDb.OleDbConnection dBaseConnection;
dBaseConnection = new System.Data.OleDb.OleDbConnection(connectionString);
dBaseConnection.Open();
System.Data.OleDb.OleDbCommand dBaseCommand;
dBaseCommand = new System.Data.OleDb.OleDbCommand("SELECT * FROM [soils]", dBaseConnection);
System.Data.OleDb.OleDbDataReader dBaseDataReader;
dBaseDataReader = dBaseCommand.ExecuteReader(CommandBehavior.SequentialAccess);
}
private void btnGo_Click(object sender, EventArgs e)
{
lblError.Text = "";
//open connection to database
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();
conn.ConnectionString = txtConnString.Text;
conn.Open();
// MessageBox.Show(conn.State.ToString());
//create my command
System.Data.OleDb.OleDbCommand comm = new System.Data.OleDb.OleDbCommand();
comm.Connection = conn;
//send the sql through the command
comm.CommandText = txtSQL.Text;
//receive the result into a data container.
System.Data.OleDb.OleDbDataReader dr;
try
{
if (txtSQL.Text.ToUpper().StartsWith("SELECT"))
{
dr = comm.ExecuteReader();
System.Data.DataTable dt = new DataTable();
dt.Load(dr);
Grid1.AutoGenerateColumns = true;
//bind the result to the grid
Grid1.DataSource = dt;
}
else
{
MessageBox.Show(comm.ExecuteNonQuery().ToString());
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
finally
{
conn.Close();
}
}
private void toolStripButton2_Click(object sender, EventArgs e)
{
try
{
if (grvKQ.RowCount > 0)
{
if (kt(MtbNTDG.Text, cbtenphongb.Text) == "")
{
for (int i = 0; i < grvKQ.RowCount; i++)
{
sql = "insert into theodoisk (ngaydanhgia,mahocsinh,sothangtuoi,cannang,chieucao,danhgia) values (@ngaydanhgia,@mahocsinh,@sothangtuoi,@cannang,@chieucao,@danhgia)";
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
cmd.CommandText = sql;
cmd.Parameters.Add("@ngaydanhgia", System.Data.OleDb.OleDbType.Date).Value = Convert.ToDateTime(MtbNTDG.Text);
cmd.Parameters.Add("@mahocsinh", System.Data.OleDb.OleDbType.VarChar).Value = grvKQ.GetRowCellValue(i, colmshs);
cmd.Parameters.Add("@sothangtuoi", System.Data.OleDb.OleDbType.Double).Value = Connect.GetDou(grvKQ.GetRowCellValue(i, colsothangtuoi));
cmd.Parameters.Add("@cannang", System.Data.OleDb.OleDbType.Double).Value = Connect.GetDou(grvKQ.GetRowCellValue(i, colcannang).ToString());
cmd.Parameters.Add("@chieucao", System.Data.OleDb.OleDbType.Double).Value = Connect.GetDou(grvKQ.GetRowCellValue(i, colchieucao).ToString());
cmd.Parameters.Add("@danhgia", System.Data.OleDb.OleDbType.VarChar).Value = Connect.GetStr(grvKQ.GetRowCellValue(i, coldanhgia));
KPBT.Modules.Connect.LuuDL(cmd);
}
}
else
{
for (int i = 0; i < grvKQ.RowCount; i++)
{
sql = "update theodoisk set ngaydanhgia=@ngaydanhgia,mahocsinh=@mahocsinh,sothangtuoi=@sothangtuoi,cannang=@cannang,chieucao=@chieucao,danhgia=@danhgia" +
" where idtheodoisk =" + Convert.ToInt64(grvKQ.GetRowCellValue(i, colid).ToString());
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
cmd.CommandText = sql;
cmd.Parameters.Add("@ngaydanhgia", System.Data.OleDb.OleDbType.Date).Value = Convert.ToDateTime(MtbNTDG.Text);
cmd.Parameters.Add("@mahocsinh", System.Data.OleDb.OleDbType.VarChar).Value = grvKQ.GetRowCellValue(i, colmshs);
cmd.Parameters.Add("@sothangtuoi", System.Data.OleDb.OleDbType.Double).Value = Connect.GetDou(grvKQ.GetRowCellValue(i, colsothangtuoi));
cmd.Parameters.Add("@cannang", System.Data.OleDb.OleDbType.Double).Value = Connect.GetDou(grvKQ.GetRowCellValue(i, colcannang).ToString());
cmd.Parameters.Add("@chieucao", System.Data.OleDb.OleDbType.Double).Value = Connect.GetDou(grvKQ.GetRowCellValue(i, colchieucao).ToString());
cmd.Parameters.Add("@danhgia", System.Data.OleDb.OleDbType.VarChar).Value = Connect.GetStr(grvKQ.GetRowCellValue(i, coldanhgia));
KPBT.Modules.Connect.LuuDL(cmd);
}
}
}
MessageBox.Show("Bạn đã lưu dữ liệu thành công!", "Thông báo");
}
catch
{
MessageBox.Show("Có lỗi trong quá trình lưu. Bạn hãy kiểm tra lại!", "Thông báo!");
}
}
static void Main(string[] args)
{
string connstring =
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\DropBox\My Dropbox\Devry\CIS407\SU10B\day5\NorthWind.mdb;";
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();
string sql = "";
System.Data.DataSet ds = new System.Data.DataSet();
System.Data.OleDb.OleDbDataReader dr;
System.Data.OleDb.OleDbCommand comm = new System.Data.OleDb.OleDbCommand();
try
{
//get this from connectionstrings.com/access
conn.ConnectionString = connstring;
conn.Open();
//here I can talk to my db...
comm.Connection = conn;
//Console.WriteLine(conn.State);
sql = Console.ReadLine();
comm.CommandText = sql;
if (sql.ToLower().IndexOf("select") == 0)
{
dr = comm.ExecuteReader();
while (dr.Read())
{
Console.WriteLine(dr.GetString(0));
}
}
else
{
Console.WriteLine(comm.ExecuteNonQuery().ToString());
}
}
catch ( Exception ex)
{
Console.WriteLine(ex.Message);
Console.Read();
}
finally
{
Console.ReadLine();
comm.Dispose();
conn.Close();
conn = null;
}
}
public void ReceivePayment()
{
System.Data.OleDb.OleDbConnection con = new System.Data.OleDb.OleDbConnection();
con.ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;"
+ "Data Source=acct.mdb;";
con.Open();
System.Data.OleDb.OleDbCommand com = new System.Data.OleDb.OleDbCommand();
com.Connection = con;
com.CommandText = "INSERT INTO Income(accountid, company, firstName, lastName, [date], amount, invoiceNo, incomeNote, paymentMethod, checkNo, bankAccountNo, routingNo, theirbankAccountNo, theirroutingNo)VALUES(" + this.accountid + ", '" + companytb.Text.Replace("'", "''") + "','" + firstNametb.Text.Replace("'", "''") + "','" + lastnametb.Text.Replace("'", "''") + "','" + datetb.Text + "'," + amounttb.Text + ",'" + invoiceNotb.Text.Replace("'", "''") + "', '" + incomeNotetb.Text.Replace("'", "''") + "', '" + paymentMethodcb.Text.Replace("'", "''") + "', '" + checkNotb.Text.Replace("'", "''") + "', '" + mybankacctnotb.Text.Replace("'", "''") + "', '" + myroutingnotb.Text.Replace("'", "''") + "', '" + theirbankacctnotb.Text.Replace("'", "''") + "', '" + theirroutingnotb.Text.Replace("'", "''") + "')";
com.ExecuteNonQuery();
com.CommandText = "Delete From AcctAR Where id=" + this.arId + " and accountid=" + this.accountid;
com.ExecuteNonQuery();
MessageBox.Show("Done");
con.Close();
}
public override System.Data.DataColumn[] ObtenerColumnas(FuenteInformacion fuenteInformacion, string rutaArchivo)
{
try
{
DataSet dsMsExcel = new DataSet();
using (System.Data.OleDb.OleDbConnection objOleConnection = new System.Data.OleDb.OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + rutaArchivo + ";Extended Properties='Excel 8.0;HDR=NO;IMEX=1'"))
{
System.Data.OleDb.OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter();
objOleConnection.Open();
DataTable worksheets = objOleConnection.GetSchema("Tables");
string hoja = worksheets.Rows[0][2].ToString();
System.Data.OleDb.OleDbCommand select = new System.Data.OleDb.OleDbCommand("SELECT * FROM [" + hoja + "]", objOleConnection);
select.CommandType = CommandType.Text;
adapter.SelectCommand = select;
dsMsExcel.Tables.Clear();
adapter.Fill(dsMsExcel);
if (dsMsExcel.Tables.Count > 0)
{
DataRow col = dsMsExcel.Tables[0].Rows[0];
DataColumn[] columnas = new DataColumn[col.ItemArray.Length];
int index = 0;
string nombre;
foreach (object campo in col.ItemArray)
{
if (!string.IsNullOrEmpty(campo.ToString()))
{
nombre = campo.ToString().Trim();
}
else
{
nombre = "NULL" + index.ToString();
}
columnas[index] = new DataColumn(nombre);
index++;
}
return(columnas);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(null);
}
public System.Data.DataSet ReadExcelFile(String filename)
{
// Create connection string variable.
String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + Server.MapPath("~/Images/" + filename) + ";" +
"Extended Properties=Excel 8.0;";
// Create connection object
System.Data.OleDb.OleDbConnection objConn = new System.Data.OleDb.OleDbConnection(sConnectionString);
// Open connection with the database.
objConn.Open();
// The code to follow uses a SQL SELECT command to display the data from the worksheet.
// Create new OleDbCommand to return data from worksheet.
System.Data.OleDb.OleDbCommand objCmdSelect = new System.Data.OleDb.OleDbCommand("SELECT * FROM [Products$]", objConn);
// Create new OleDbDataAdapter that is used to build a DataSet
// based on the preceding SQL SELECT statement.
System.Data.OleDb.OleDbDataAdapter objAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
// Pass the Select command to the adapter.
objAdapter1.SelectCommand = objCmdSelect;
// Create new DataSet to hold information from the worksheet.
System.Data.DataSet objDataset1 = new System.Data.DataSet();
try
{
// Fill the DataSet with the information from the worksheet.
objAdapter1.Fill(objDataset1, "Products");
}
catch (Exception exp)
{
objConn.ResetState();
objConn.Dispose();
objConn.Close();
}
//objConn.Dispose();
// Clean up objects.
objConn.Close();
return(objDataset1);
}
private static List <List <string> > File_Selected_New(FileInfo _file)
{
DataSet ds = new DataSet();
string connectionString = GetConnectionString(_file);
using (System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(connectionString))
{
conn.Open();
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
cmd.Connection = conn;
// Get all Sheets in Excel File
DataTable dtSheet = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);
// Loop through all Sheets to get data
foreach (DataRow dr in dtSheet.Rows)
{
string sheetName = dr["TABLE_NAME"].ToString();
// Get all rows from the Sheet
cmd.CommandText = "SELECT * FROM [" + sheetName + "]";
DataTable dt = new DataTable();
dt.TableName = sheetName;
System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(cmd);
da.Fill(dt);
ds.Tables.Add(dt);
}
// В list_table хранится информация по строкам, начиная с [0]
List <List <string> > list_table = new List <List <string> >();
for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
{
List <string> list_row = new List <string>();
for (int i = 1; i < ds.Tables[0].Rows.Count; i++)
{
list_row.Add(ds.Tables[0].Rows[i].ItemArray[j].ToString());
}
list_table.Add(list_row);
}
return(list_table);
}
}
/// <summary>
/// method when the search button is clicked
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
string searchstring = search.Text;
System.Data.OleDb.OleDbConnection connection = new System.Data.OleDb.OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:\ASD\ase 2\user Database.accdb");
connection.Open(); //opens connection
string query = "Select [code ID], [user], [class], [method], [line], [solution], [time added] FROM fixed_code WHERE [code ID] LIKE '%" + searchstring + "%'"; //query that searches the fixed code where the code id is like the search string
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(query, connection);
cmd.CommandType = CommandType.Text;
System.Data.OleDb.OleDbDataAdapter myDataAdapter = new System.Data.OleDb.OleDbDataAdapter(cmd);
DataTable fixed_code = new DataTable();
myDataAdapter.Fill(fixed_code); //fills datagrid with search results
dataGridView1.DataSource = fixed_code; //assigns the data source
}
private void button3_Click(object sender, EventArgs e)
{ // Botão btnResultados
try
{
string id1 = txtIdade1.Text;
string id2 = txtIdade2.Text;
string strSsexo = "";
if (rbMasculino.Checked)
{
strSsexo = " sexo = 'M' AND ";
}
else if (rbFeminino.Checked)
{
strSsexo = " sexo = 'F' AND ";
}
else
{
strSsexo = "";
}
sql = "select * from alunos WHERE " + strSsexo
+ " idade>=" + id1 + " AND idade<=" + id2
+ " ORDER BY nome";
stm = new System.Data.OleDb.OleDbCommand(sql, conexao);
rs = stm.ExecuteReader();
string strSaida = "";
while (rs.Read())
{
string dados = "RGM: " + rs.GetString(0)
+ ", " + rs.GetString(1) + ", idade: " + rs.GetInt32(3)
+ ", sexo: " + rs.GetString(4)
+ ", curso: " + rs.GetString(2);
strSaida += dados + "\r\n";
}
txtResultados.Text = strSaida;
}
catch (Exception exsql) { MessageBox.Show("Erro na consulta"); }
if (stm != null)
{
stm.Dispose();
}
if (rs != null)
{
rs.Close();
}
}
/// <summary>
/// Método necesario para admitir el Diseñador, no se puede modificar
/// el contenido del método con el editor de código.
/// </summary>
private void InitializeComponent()
{
System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.dataSet11 = new procedencia.DataSet1();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "T_Datos", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ANO", "ANO"),
new System.Data.Common.DataColumnMapping("SEDE_TDESC", "SEDE_TDESC"),
new System.Data.Common.DataColumnMapping("CARR_TDESC", "CARR_TDESC"),
new System.Data.Common.DataColumnMapping("JORN_TDESC", "JORN_TDESC"),
new System.Data.Common.DataColumnMapping("COLEGIO_EGRESO", "COLEGIO_EGRESO"),
new System.Data.Common.DataColumnMapping("CIUD_TDESC", "CIUD_TDESC"),
new System.Data.Common.DataColumnMapping("TCOL_TDESC", "TCOL_TDESC"),
new System.Data.Common.DataColumnMapping("ALUMNOS", "ALUMNOS"),
new System.Data.Common.DataColumnMapping("PSU", "PSU")
})
});
this.oleDbDataAdapter1.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.oleDbDataAdapter1_RowUpdated);
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT \'\' AS ANO, \'\' AS SEDE_TDESC, \'\' AS CARR_TDESC, \'\' AS JORN_TDESC, \'\' AS COL" +
"EGIO_EGRESO, \'\' AS CIUD_TDESC, \'\' AS TCOL_TDESC, \'\' AS ALUMNOS, \'\' AS PSU FROM D" +
"UAL";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.Locale = new System.Globalization.CultureInfo("es-CL");
this.dataSet11.Namespace = "http://www.tempuri.org/DataSet1.xsd";
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
}
public bool DeleteQry(string strCommand)
{
try
{
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(dbConnection);
conn.Open();
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(strCommand, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception)
{
return(true);
}
return(false);
}
private void m_axCalendar_DoCreateRPattern(object sender, AxXtremeCalendarControl._DCalendarControlEvents_DoCreateRPatternEvent e)
{
e.bResult = false;
if (!IsOpen())
{
return;
}
try
{
String strSQL = "SELECT * FROM CalendarRecurrencePatterns WHERE RecurrencePatternID = 0 ";
System.Data.OleDb.OleDbDataAdapter oleDbDataAdapter = new System.Data.OleDb.OleDbDataAdapter(strSQL, m_oleDbConnection);
System.Data.OleDb.OleDbCommandBuilder custCB = new System.Data.OleDb.OleDbCommandBuilder(oleDbDataAdapter);
custCB.QuotePrefix = "[";
custCB.QuoteSuffix = "]";
System.Data.DataSet objPatternDSet = new System.Data.DataSet();
oleDbDataAdapter.Fill(objPatternDSet);
//code to modify data in dataset here
System.Data.DataRow objDRow = objPatternDSet.Tables[0].NewRow();
objPatternDSet.Tables[0].Rows.Add(objDRow);
m_DataHelper.PutRPatternToData(e.pPattern, objDRow);
oleDbDataAdapter.Update(objPatternDSet);
//'-- update Auto EventID
System.Data.OleDb.OleDbCommand objCommand = m_oleDbConnection.CreateCommand();
objCommand.CommandText = "SELECT MAX(RecurrencePatternID) AS NewNewPatternID FROM CalendarRecurrencePatterns";
System.Data.OleDb.OleDbDataReader objReader = objCommand.ExecuteReader();
objReader.Read();
e.newPatternID = objReader.GetInt32(0);
objReader.Close();
e.bResult = true;
}
catch (System.Exception ex)
{
System.Diagnostics.Debug.WriteLine("EXCEPTION! providerSQLServer.m_axCalendar_DoCreateRPattern: " + ex.Message);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Do you want to Update all the records", "TareEntry", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
DataTable resultData = (DataTable)dgRakeView.DataSource;
string query = string.Format("Select ID,Slno,RakeNo,WagonNo,WagonType,Tare,Gross,dateout,timeout,spd,PCC,[From],[Product],[To],Net,UL,OL,CC from Temp where RakeNo={0} order by val(Slno)", txtRakeNo.Text);
var db = new DBEngine();
btnUpdate.Visible = false;
var dt = new System.Data.DataTable();
System.Data.OleDb.OleDbConnection cn = new System.Data.OleDb.OleDbConnection(db.ConnectionString);
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(query, cn);
System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(cmd);
System.Data.OleDb.OleDbCommandBuilder ocb = new System.Data.OleDb.OleDbCommandBuilder(da);
//cn.Open();
da.Fill(dt);
ocb.QuoteSuffix = "]";
ocb.QuotePrefix = "[";
// var insertBuilder = new StringBuilder();
for (int i = 0; i < resultData.Rows.Count; i++)
{
//DataRow dr = dt.NewRow();
//dr["Slno"] = dttemp.Rows[i][0];
//dr["RakeNo"] = txtRakeNo.Text;
//dr["WagonType"] = txtWagonType.Text;
dt.Rows[i]["WagonNo"] = resultData.Rows[i][1];
dt.Rows[i]["Tare"] = resultData.Rows[i]["tare"];
dt.Rows[i]["Net"] = resultData.Rows[i]["net"];
//dt.Rows[i]["datein"] = resultData.Rows[i]["datein"];
//dt.Rows[i]["timein"] = resultData.Rows[i]["timein"];
dt.Rows[i]["UL"] = resultData.Rows[i]["UL"];
dt.Rows[i]["OL"] = resultData.Rows[i]["OL"];
dt.Rows[i]["CC"] = resultData.Rows[i]["CC"];
dt.Rows[i]["PCC"] = resultData.Rows[i]["PCC"];
}
da.Update(dt);
MessageBox.Show("Successfully Updated");
dgRakeView.DataSource = null;
txtRakeNo.Clear();
txtSlno.Clear();
}
}
/// <summary>
/// 查询通讯协议
/// </summary>
/// <param name="sql">查询语句</param>
/// <param name="AccessPath">Access数据库路径</param>
/// <param name="Ip">服务器数据库Ip地址</param>
/// <param name="UserName">服务器登录名</param>
/// <param name="pwd">密码</param>
/// <returns></returns>
private DgnProtocolInfo GetProtocolInfo(string sql, string AccessPath, string Ip, string UserName, string pwd)
{
DgnProtocolInfo Items = new DgnProtocolInfo();
bool flag = false;
if (Ip != "")
{
flag = ConnectDataBase("", Ip, UserName, pwd);
}
else if (AccessPath != "")
{
flag = ConnectDataBase(AccessPath, "", "", "");
}
else
{
flag = ConnectDataBase("", "", "", "");
}
try
{
if (!flag)
{
return(Items);
}
System.Data.OleDb.OleDbCommand Cmd = new System.Data.OleDb.OleDbCommand(sql, _Data.Con);
System.Data.OleDb.OleDbDataReader Reader = Cmd.ExecuteReader();
while (Reader.Read())
{
Items.Pro_ProtocolID = Convert.ToInt32(Reader["ProtocolID"].ToString()); //协议编号
Items.Pro_proNameNo = Convert.ToInt32(Reader["proNameNo"].ToString()); //通讯协议归属
Items.Pro_chrPname = Reader["chrPname"].ToString(); //协议名称
Items.Pro_intInfoNo = Convert.ToInt32(Reader["intInfoNo"].ToString()); //信息序号
Items.Pro_chrValue = Reader["chrValue"].ToString(); //对应值
}
Reader.Close();
}
catch (Exception e)
{
System.Windows.Forms.MessageBox.Show(e.Message, "数据库操作错误", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
}
finally
{
_Data.CloseDB();
}
return(Items);
}
public override DataTable GetSchemaTable(string sql)
{
try
{
using (var conn = new System.Data.OleDb.OleDbConnection(ProviderString))
{
conn.Open();
var cmd = new System.Data.OleDb.OleDbCommand(sql, conn);
var rdr = cmd.ExecuteReader(CommandBehavior.SchemaOnly);
return(rdr.GetSchemaTable());
}
}
catch
{
return(null);
}
}
/// <summary>
/// method when the submit solution button is clicked
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
System.Data.OleDb.OleDbConnection connection = new System.Data.OleDb.OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:\ASD\ase 2\user Database.accdb");
connection.Open(); //opens connection
if (codeID != null && src_class != null && solution != null) //if statement that makes sure certain fields are filled in
{
String query = "INSERT INTO fixed_code ([code ID], [user], [class], [method], [line], [solution], [time added]) VALUES(" + codeID.Text + ",'" + label3.Text + "','" + src_class.Text + "','" + method.Text + "'," + line.Text + ",'" + solution.Text + "','" + label4.Text + "')";
//query that adds the values of the text boxes and rich text boxes to the database
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(query, connection);
cmd.ExecuteNonQuery(); //executes query
MessageBox.Show("Your solution has been added to the database"); // message box to confirm that the database has been updated
}
else
{
MessageBox.Show("Code id class and solution must be filled in");
}
}
private DataSet GetMeSomeDataIntoDataSet(string sql)
{
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Jason\Dropbox\Devry\CIS336\SimpleQueryAnalyzer\SimpleQueryAnalyzer\northwind.mdb;";
conn.Open();
System.Data.OleDb.OleDbCommand comm = new System.Data.OleDb.OleDbCommand();
comm.Connection = conn;
comm.CommandText = sql;
System.Data.DataSet ds = new DataSet();
System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter();
da.SelectCommand = comm;
da.Fill(ds);
return(ds);
}
/// <summary>
/// Método necesario para admitir el Diseñador, no se puede modificar
/// el contenido del método con el editor de código.
/// </summary>
private void InitializeComponent()
{
System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.datosPagare1 = new envios_notaria_pagare.datosPagare();
((System.ComponentModel.ISupportInitialize)(this.datosPagare1)).BeginInit();
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "envioPagare", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("FOLIO", "FOLIO"),
new System.Data.Common.DataColumnMapping("EMPRESA", "EMPRESA"),
new System.Data.Common.DataColumnMapping("FECHA_EN", "FECHA_EN"),
new System.Data.Common.DataColumnMapping("FECHA_ENVIO", "FECHA_ENVIO"),
new System.Data.Common.DataColumnMapping("VALOR_PAGAR", "VALOR_PAGAR"),
new System.Data.Common.DataColumnMapping("ESTADO_PAGARE", "ESTADO_PAGARE"),
new System.Data.Common.DataColumnMapping("RUT_ALUMNO", "RUT_ALUMNO"),
new System.Data.Common.DataColumnMapping("RUT_APODERADO", "RUT_APODERADO"),
new System.Data.Common.DataColumnMapping("NOMBRE_APODERADO", "NOMBRE_APODERADO")
})
});
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT \'\' AS FOLIO, \'\' AS EMPRESA, \'\' AS FECHA_EN, \'\' AS FECHA_ENVIO, \'\' AS VALOR" +
"_PAGAR, \'\' AS ESTADO_PAGARE, \'\' AS RUT_ALUMNO, \'\' AS RUT_APODERADO, \'\' AS NOMBRE" +
"_APODERADO, \'\' AS PAGA_NCORR FROM DUAL";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
//
// datosPagare1
//
this.datosPagare1.DataSetName = "datosPagare";
this.datosPagare1.Locale = new System.Globalization.CultureInfo("es-ES");
this.datosPagare1.Namespace = "http://www.tempuri.org/datosPagare.xsd";
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.datosPagare1)).EndInit();
}
/// <summary>
/// xls文件转数据表
/// </summary>
/// <param name="fileName">文件名</param>
/// <returns></returns>
public static System.Data.DataTable XlsToData(string fileName)
{
string fileExtenSion;
fileExtenSion = System.IO.Path.GetExtension(fileName);
if (fileExtenSion.ToLower() != ".xls" && fileExtenSion.ToLower() != ".xlsx")
{
return null;
}
System.Data.OleDb.OleDbConnection conn = null;
try
{
//HDR=Yes，这代表第一行是标题，不做为数据使用 ，如果用HDR=NO，则表示第一行不是标题，做为数据来使用。系统默认的是YES
string connstr2003 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1;'";
string connstr2007 = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties=\"Excel 12.0;HDR=YES\"";
if (fileExtenSion.ToLower() == ".xls")
{
conn = new System.Data.OleDb.OleDbConnection(connstr2003);
}
else
{
conn = new System.Data.OleDb.OleDbConnection(connstr2007);
}
conn.Open();
string sql = "select * from [Sheet1$]";
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(sql, conn);
System.Data.DataTable dt = new System.Data.DataTable();
System.Data.OleDb.OleDbDataReader sdr = cmd.ExecuteReader();
dt.Load(sdr);
sdr.Close();
conn.Close();
return dt;
}
catch
{
return null;
}
finally
{
if (conn != null)
conn.Close();
}
}
/// <summary>
/// Método necesario para admitir el Diseñador, no se puede modificar
/// el contenido del método con el editor de código.
/// </summary>
private void InitializeComponent()
{
System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.datosAlumno1 = new ficha_alumno.datosAlumno();
((System.ComponentModel.ISupportInitialize)(this.datosAlumno1)).BeginInit();
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "alumno", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ANO_INGRESO", "ANO_INGRESO"),
new System.Data.Common.DataColumnMapping("NOMBRE_SEDE", "NOMBRE_SEDE"),
new System.Data.Common.DataColumnMapping("NOMBRE_ALUMNO", "NOMBRE_ALUMNO"),
new System.Data.Common.DataColumnMapping("RUT_POST", "RUT_POST"),
new System.Data.Common.DataColumnMapping("CARRERA", "CARRERA"),
new System.Data.Common.DataColumnMapping("DIRECCION", "DIRECCION"),
new System.Data.Common.DataColumnMapping("FONO", "FONO"),
new System.Data.Common.DataColumnMapping("CIUDAD", "CIUDAD"),
new System.Data.Common.DataColumnMapping("COMUNA", "COMUNA")
})
});
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT \'\' AS ANO_INGRESO, \'\' AS NOMBRE_SEDE, \'\' AS NOMBRE_ALUMNO, \'\' AS RUT_POST," +
" \'\' AS CARRERA, \'\' AS DIRECCION, \'\' AS FONO, \'\' AS CIUDAD, \'\' AS COMUNA FROM DUA" +
"L";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
//
// datosAlumno1
//
this.datosAlumno1.DataSetName = "datosAlumno";
this.datosAlumno1.Locale = new System.Globalization.CultureInfo("es-ES");
this.datosAlumno1.Namespace = "http://www.tempuri.org/datosAlumno.xsd";
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.datosAlumno1)).EndInit();
}
public void UpdateByProcedure(string procedureName, System.Data.OleDb.OleDbParameter[] sqlParameter)
{
try
{
System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand(procedureName, managerDB.OpenApp());
command.CommandType = System.Data.CommandType.StoredProcedure;
for (int i = 0; i < sqlParameter.Length; i++)
{
command.Parameters.Add(sqlParameter[i]);
}
command.ExecuteNonQuery();
}
catch (Exception exception)
{
IAppLog log = (IAppLog)AppLogFactory.LogProduct();
log.writeLog(this.GetType().Name, "执行存储过程出错!" + exception.ToString());
}
}
internal static System.Data.DataSet getXldata(System.Data.OleDb.OleDbConnection xlConn, string sheetName, string excelPath, string excelExten)
{
System.Data.DataSet ds = new System.Data.DataSet();
SPSecurity.RunWithElevatedPrivileges(delegate()
{
xlConn = new global::System.Data.OleDb.OleDbConnection(Utilities.ConnUtilities.CreateXlConnectionString(excelPath, excelExten));
string cmd = string.Format("select * from [{0}]", sheetName);
System.Data.OleDb.OleDbCommand Comm = new System.Data.OleDb.OleDbCommand(cmd, xlConn);
Comm.Connection = xlConn;
System.Data.OleDb.OleDbDataAdapter adapter = new System.Data.OleDb.OleDbDataAdapter();
xlConn.Open();
Comm.CommandType = System.Data.CommandType.Text;
adapter.SelectCommand = Comm;
adapter.Fill(ds);
xlConn.Close();
});
return(ds);
}
public System.Data.DataTable get_data_from_excell()
{
System.Data.DataTable bang = new System.Data.DataTable();
try
{
con = new System.Data.OleDb.OleDbConnection(sConnectionString);
con.Open();
System.Data.OleDb.OleDbCommand lenh = new System.Data.OleDb.OleDbCommand("SELECT * FROM [Sheet1$]", con);
System.Data.OleDb.OleDbDataAdapter thich_ung = new System.Data.OleDb.OleDbDataAdapter();
thich_ung.SelectCommand = lenh;
thich_ung.Fill(bang);
con.Close();
}
catch
{
}
return(bang);
}
public int ModifyDatabase(string queryString)
{
configureConnection();
using (conn){
System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand(queryString);
command.Connection = conn;
try{
conn.Open();
command.ExecuteNonQuery();
return(0);
}
catch (Exception ex) {
Console.WriteLine(ex.Message);
return(1);
}
}
}
public static System.Data.OleDb.OleDbDataReader GetWDSResults(IList <WDSField> fields, string scope, string extention, System.Data.OleDb.OleDbConnection wds_connection)
{
var fieldnames = System.String.Join(",", fields.Select(f => f.Name));
var sb = new System.Text.StringBuilder();
sb.AppendFormat(@"SELECT {0} ", fieldnames);
sb.AppendFormat(@"FROM SYSTEMINDEX ");
var clauses = new List <string>();
if (scope != null)
{
clauses.Add(string.Format(@"SCOPE='{0}' ", scope));
}
if (extention != null)
{
clauses.Add(string.Format(@"System.ItemType='{0}' ", extention));
}
if (clauses.Count > 0)
{
sb.AppendFormat(@"WHERE ");
int n = 0;
foreach (string clause in clauses)
{
if (n > 0)
{
sb.Append(" AND ");
}
sb.Append(clause);
n++;
}
}
string wds_query = sb.ToString();
var x = System.String.Format(
@"SELECT {0} FROM SYSTEMINDEX WHERE SCOPE='{1}' AND System.ItemType = '.mp3'", fieldnames, scope);
var wds_command = new System.Data.OleDb.OleDbCommand(wds_query, wds_connection);
return(wds_command.ExecuteReader());
}
private void btnGo_Click(object sender, EventArgs e)
{
lblError.Text = "";
//open connection to database
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();
conn.ConnectionString = txtConnString.Text;
conn.Open();
// MessageBox.Show(conn.State.ToString());
//create my command
System.Data.OleDb.OleDbCommand comm = new System.Data.OleDb.OleDbCommand();
comm.Connection = conn;
//send the sql through the command
comm.CommandText = txtSQL.Text;
//receive the result into a data container.
System.Data.OleDb.OleDbDataReader dr;
try
{
if (txtSQL.Text.ToUpper().StartsWith("SELECT"))
{
dr = comm.ExecuteReader();
System.Data.DataTable dt = new DataTable();
dt.Load(dr);
Grid1.AutoGenerateColumns = true;
//bind the result to the grid
Grid1.DataSource = dt;
}
else
{
MessageBox.Show(comm.ExecuteNonQuery().ToString());
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
finally
{
conn.Close();
}
}
/// <summary>
/// Método necesario para admitir el Diseñador, no se puede modificar
/// el contenido del método con el editor de código.
/// </summary>
private void InitializeComponent()
{
System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.datos1 = new Pres_Ingreso_Real.Datos();
((System.ComponentModel.ISupportInitialize)(this.datos1)).BeginInit();
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "ProsupuestadoReal", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("CARR_TDESC", "CARR_TDESC"),
new System.Data.Common.DataColumnMapping("CARR_CCOD", "CARR_CCOD"),
new System.Data.Common.DataColumnMapping("TOTAL_MATR_COMPROMETIDA", "TOTAL_MATR_COMPROMETIDA"),
new System.Data.Common.DataColumnMapping("TOTAL_COL_COMPROMETIDA", "TOTAL_COL_COMPROMETIDA"),
new System.Data.Common.DataColumnMapping("TOTAL_MATR_REAL", "TOTAL_MATR_REAL"),
new System.Data.Common.DataColumnMapping("TOTAL_COL_REAL", "TOTAL_COL_REAL"),
new System.Data.Common.DataColumnMapping("SALDO", "SALDO")
})
});
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT \'\' AS SEDE_TDESC, \'\' AS CARR_TDESC, \'\' AS CARR_CCOD, \'\' AS TOTAL_MATR_COMP" +
"ROMETIDA, \'\' AS TOTAL_COL_COMPROMETIDA, \'\' AS TOTAL_MATR_REAL, \'\' AS TOTAL_COL_R" +
"EAL, \'\' AS SALDO, \'\' AS PERIODO, \'\' AS FECHA_INICIO, \'\' AS FECHA_TERMINO FROM DU" +
"AL";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
//
// datos1
//
this.datos1.DataSetName = "Datos";
this.datos1.Locale = new System.Globalization.CultureInfo("es-ES");
this.datos1.Namespace = "http://www.tempuri.org/Datos.xsd";
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.datos1)).EndInit();
}
/// <summary>
/// Método necesario para admitir el Diseñador, no se puede modificar
/// el contenido del método con el editor de código.
/// </summary>
private void InitializeComponent()
{
System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();
this.datosReporte1 = new rep_det_cob.datosReporte();
((System.ComponentModel.ISupportInitialize)(this.datosReporte1)).BeginInit();
//
// oleDbDataAdapter1
//
this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "reporte", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("TIPO", "TIPO"),
new System.Data.Common.DataColumnMapping("FECHA_EMISION", "FECHA_EMISION"),
new System.Data.Common.DataColumnMapping("NRO_NDOCTO", "NRO_NDOCTO"),
new System.Data.Common.DataColumnMapping("MONTO", "MONTO"),
new System.Data.Common.DataColumnMapping("FECHA_VEN", "FECHA_VEN"),
new System.Data.Common.DataColumnMapping("ESTADO", "ESTADO"),
new System.Data.Common.DataColumnMapping("RUT_ALUMNO", "RUT_ALUMNO"),
new System.Data.Common.DataColumnMapping("RUT_APODERADO", "RUT_APODERADO")
})
});
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT \'\' AS TIPO, \'\' AS FECHA_EMISION, \'\' AS NRO_NDOCTO, \'\' AS MONTO, \'\' AS FECH" +
"A_VEN, \'\' AS ESTADO, \'\' AS RUT_ALUMNO, \'\' AS RUT_APODERADO, \'\' AS C_CORRIENTE FR" +
"OM DUAL";
this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
//
// oleDbConnection1
//
this.oleDbConnection1.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
//
// datosReporte1
//
this.datosReporte1.DataSetName = "datosReporte";
this.datosReporte1.Locale = new System.Globalization.CultureInfo("es-ES");
this.datosReporte1.Namespace = "http://www.tempuri.org/datosReporte.xsd";
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.datosReporte1)).EndInit();
}
/// <summary>
/// Método necesario para admitir el Diseñador, no se puede modificar
/// el contenido del método con el editor de código.
/// </summary>
private void InitializeComponent()
{
System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
this.DbConnection = new System.Data.OleDb.OleDbConnection();
this.DbDataAdapter = new System.Data.OleDb.OleDbDataAdapter();
this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
this.dataSetMorosidad1 = new MorosidadFinanzas.DataSetMorosidad();
((System.ComponentModel.ISupportInitialize)(this.dataSetMorosidad1)).BeginInit();
//
// DbConnection
//
this.DbConnection.ConnectionString = ((string)(configurationAppSettings.GetValue("cadenaConexion", typeof(string))));
//
// DbDataAdapter
//
this.DbDataAdapter.SelectCommand = this.oleDbSelectCommand1;
this.DbDataAdapter.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "T_Morosidad", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("FECHA_CORTE", "FECHA_CORTE"),
new System.Data.Common.DataColumnMapping("SEDE_TDESC", "SEDE_TDESC"),
new System.Data.Common.DataColumnMapping("CARRERA", "CARRERA"),
new System.Data.Common.DataColumnMapping("RUT", "RUT"),
new System.Data.Common.DataColumnMapping("NOMBRE", "NOMBRE"),
new System.Data.Common.DataColumnMapping("COMPROMETIDO", "COMPROMETIDO"),
new System.Data.Common.DataColumnMapping("LETRAS", "LETRAS"),
new System.Data.Common.DataColumnMapping("CHEQUES", "CHEQUES"),
new System.Data.Common.DataColumnMapping("PAGARE", "PAGARE")
})
});
//
// oleDbSelectCommand1
//
this.oleDbSelectCommand1.CommandText = "SELECT \'\' AS FECHA_CORTE, \'\' AS SEDE_TDESC, \'\' AS CARRERA, \'\' AS RUT, \'\' AS NOMBR" +
"E, \'\' AS COMPROMETIDO, \'\' AS LETRAS, \'\' AS CHEQUES, \'\' AS PAGARE FROM DUAL";
this.oleDbSelectCommand1.Connection = this.DbConnection;
//
// dataSetMorosidad1
//
this.dataSetMorosidad1.DataSetName = "DataSetMorosidad";
this.dataSetMorosidad1.Locale = new System.Globalization.CultureInfo("es-CL");
this.dataSetMorosidad1.Namespace = "http://www.tempuri.org/DataSetMorosidad.xsd";
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.dataSetMorosidad1)).EndInit();
}
public DataSet updtedata(string sortfield)
{
System.Data.OleDb.OleDbConnection conn = GetConnection();
DataSet ds = new DataSet();
try
{
string sqlupdate = default(string);
sqlupdate = "UPDATE Table1 set STUDENTID=@STUDENTID, data1=@data1, data2=@data2, data3=@data3, data4=@data4," + "data5=@data5, data6=@data6, data7=@data7, data8=@data8, data9=@data9, data10=@data10," + "data11=@data11, data12=@data12, data13=@data13, data14=@data14, data15=@data15, data16=@data16," + "data17=@data17, data18=@data18, data19=@data19 where STUDENTID=\'" + Form1.Default.STUDID.Text + "\'";
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand(sqlupdate, conn);
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@STUDENTID", Form1.Default.STUDID.Text));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA1", Form1.Default.TextBox1.Text));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA2", Form1.Default.TextBox2.Text));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA3", Form1.Default.TextBox3.Text));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA4", Form1.Default.TextBox4.Text));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA5", Form1.Default.TextBox5.Text));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA6", Form1.Default.TextBox6.Text));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA7", Form1.Default.TextBox7.Text));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA8", Form1.Default.TextBox8.Text));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA9", Form1.Default.TextBox9.Text));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA10", Form1.Default.TextBox10.Text));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA11", Form1.Default.TextBox11.Text));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA12", Form1.Default.TextBox12.Text));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA13", Form1.Default.TextBox13.Text));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA14", Form1.Default.TextBox14.Text));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA15", Form1.Default.TextBox15.Text));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA16", Form1.Default.TextBox16.Text));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA17", Form1.Default.TextBox17.Text));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA18", Form1.Default.TextBox18.Text));
cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@DATA19", Form1.Default.TextBox19.Text));
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("Data Updated in the Database");
RefreshDGV();
}
finally
{
}
return(ds);
}
// Return the adjective's exception singular to plurial group
public static string groupS2POf(string adjective, string gender, string number)
{
string res = "";
// we transform the adjective to male singular if it is not
if (number == "P")
{
adjective = plurialToSingular(adjective);
}
if (gender == "F")
{
adjective = femaleToMale(adjective);
}
// if the IA knows the adjective, we only have to make a research on the data base
if (existe(adjective))
{
con.Open();
res = new CMD("SELECT GroupS2P FROM Adjectifs WHERE Adjective = '" + adjective + "'", con).ExecuteScalar().ToString();
con.Close();
}
// else, we had to estimate it
else
{
int length = adjective.Length;
string ending = "";
object resEnding;
con.Open();
for (int i = length; res == "" && i >= 1; i--)
{
ending = adjective.Substring(length - i);
resEnding = new CMD("SELECT GroupS2P FROM ExceptionsAdjectifsS2P WHERE Singular = '" + ending + "' ORDER BY GroupS2P ", con).ExecuteScalar();
if (resEnding != null)
{
res = resEnding.ToString();
}
}
}
con.Close();
if (res == "")
{
res = "10";
}
return(res);
}
private void save(Report r, System.Data.OleDb.OleDbConnection con)
{
string cmd;
TextManager mng = new TextManager();
string[] text = new string[r.Items.Count];
cmd = "Insert into Diagn (FIO, Dat, Name) Values (";
cmd += "\"" + r.FIO + "\", ";
cmd += "\"" + r.Date.ToShortDateString() + "\", ";
cmd += "\"" + (string)r.Tag + "\");";
con.Open();
System.Data.OleDb.OleDbCommand c =
new System.Data.OleDb.OleDbCommand(cmd, con);
c.ExecuteNonQuery();
cmd = "Select max(ID) From Diagn;";
c = new System.Data.OleDb.OleDbCommand(cmd, con);
mng.Save(r, c.ExecuteScalar());
con.Close();
}
private void button1_Click(object sender, EventArgs e)
{
//Mostrar na listBox2 os alunos do curso selecionado no listBox1:
try
{
listBox2.Items.Clear(); //limpamos a segunda lista
string cursoSelec = (string)((DataRowView)listBox1.SelectedItem)[0];
string sql = "SELECT * FROM Alunos WHERE abrevcurso = '" + cursoSelec + "'";
//suponhamos o BD em C:\tempo
System.Data.OleDb.OleDbConnection conexao =
new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/temp/Universidade3.mdb");
conexao.Open();
System.Data.OleDb.OleDbCommand comando =
new System.Data.OleDb.OleDbCommand(sql, conexao);
System.Data.OleDb.OleDbDataReader dr = comando.ExecuteReader();
while (dr.Read())
{
string dadosAluno = dr.GetString(0)
+ ", " + dr.GetString(1) + ", " + dr.GetString(2)
+ ", " + dr.GetInt32(3) + ", " + dr.GetString(4);
listBox2.Items.Add(dadosAluno);
}
dr.Close();
comando.Dispose();
conexao.Close();
}
catch (Exception exc) { MessageBox.Show(exc.Message); }
}
