- Oubliette -

Procedimientos iniciales

Introduce la información de la cuenta

using System.Reflection;
using System.IO;

...

// Get current and updated assemblies
Assembly currentAssembly = Assembly.LoadFile(currentAssemblyPath);
Assembly updatedAssembly = Assembly.LoadFile(updatedAssemblyPath);

AssemblyName currentAssemblyName = currentAssembly.GetName();
AssemblyName updatedAssemblyName = updatedAssembly.GetName();

// Compare both versions
if (updatedAssemblyName.Version.CompareTo(currentAssemblyName.Version) <= 0)
{
    // There's nothing to update
    return;
}

// Update older version
File.Copy(updatedAssemblyPath, currentAssemblyPath, true);

using System.Reflection;
using System.IO;

...

// Get current and updated assemblies
AssemblyName currentAssemblyName = AssemblyName.GetAssemblyName(currentAssemblyPath);
AssemblyName updatedAssemblyName = AssemblyName.GetAssemblyName(updatedAssemblyPath);

// Compare both versions
if (updatedAssemblyName.Version.CompareTo(currentAssemblyName.Version) <= 0)
{
    // There's nothing to update
    return;
}

// Update older version
File.Copy(updatedAssemblyPath, currentAssemblyPath, true)

AssemblyName.GetAssemblyName won't load the assembly, so we can change the file afterwards.  

Fuente

Introduction

Using the code

var qry1 = datatable1.AsEnumerable().Select(a => new { MobileNo = a["ID"].ToString() });
var qry2 = datatable2.AsEnumerable().Select(b => new { MobileNo = b["ID"].ToString() });
var exceptAB = qry1.Except(qry2);
DataTable dtMisMatch = (from a in datatable1.AsEnumerable()
    join ab in exceptAB on a["ID"].ToString() equals ab.MobileNo
    select a).CopyToDataTable(); 

Fuente 

• What data has been updated recently
• Which tables have not been updated recently
• Who modified the price of Steeleye Stout to $20 / unit, and when did they do it?
• What was the unit price for Steeleye Stout before Jon monkeyed with it?

• The application is designed so that all changes are logged
• All data changes go through a data access layer which logs all changes
• The database is constructed in such a way that logging information is included in each table, perhaps set via a trigger

What if we're not starting from scratch?

• which tables were updated recently
• which tables have not been updated in the past year
• which tables have never been updated
• all changes made by a specific user in a time period
• most active tables in a time period

Enough talking, give us the script!

Creating a DataTable

// instantiate DataTableDataTable dTable = new DataTable("Dynamically_Generated");

Creating Columns in the DataTable

// create columns for the DataTable
DataColumn auto = new DataColumn("AutoID", typeof(System.Int32));
dTable.Columns.Add(auto);
// create another column
DataColumn name = new DataColumn("Name", typeof(string));
dTable.Columns.Add(name);
// create one more column
DataColumn address = new DataColumn("Address", typeof(string));
dTable.Columns.Add(address);

Specifying AutoIncrement column in the DataTable

// specify it as auto increment field
auto.AutoIncrement = true;
auto.AutoIncrementSeed = 1;
auto.ReadOnly = true;

auto.Unique = true;

Specifying Primary Key column in the DataTable

// create primary key on this fieldDataColumn[] pK = new DataColumn[1];
pK[0] = auto;
dTable.PrimaryKey = pK;

Populating data into DataTable

// populate the DataTable using DataRow objectDataRow row = null;
for (int i = 0; i < 5; i++)
{
row = dTable.NewRow();
row["AutoID"] = i + 1;
row["Name"] = i + " - Ram";
row["Address"] = "Ram Nagar, India - " + i;
dTable.Rows.Add(row);
}

// manually adding rows using array of valuesdTable.Rows.Add(6, "Manual Data - 1", "Manual Address - 1, USA");
dTable.Rows.Add(7, "Manual Data - 2", "Manual Address - 2, USA");

Modifying data into DataTable

// modify certain values into the DataTabledTable.Rows[2]["AutoID"] = 20;
dTable.Rows[2]["Name"] = "Modified";
dTable.Rows[2]["Address"] = "Modified Address";
dTable.AcceptChanges();

// Delete rowdTable.Rows[1].Delete();
dTable.AcceptChanges();

Filtering data from DataTable

DataRow[] rows = dTable.Select(" AutoID > 5");
DataRow[] rows1 = dTable.Select(" AutoID > 5", "AuotID ASC");

foreach (DataRow thisRow in rows)
{
// add values into the datatable
dTable1.Rows.Add(thisRow.ItemArray);
}

DataRow[] rows22 = dTable.Select("AutoID = max(AutoID)");
string str = "MaxAutoID: " + rows22[0]["AutoID"].ToString();

object objSum = dTable.Compute("sum(AutoID)", "AutoID > 7");
string sum = "Sum: " + objSum.ToString();
// To get sum of AutoID for all rows of the DataTable
object objSum = dTable.Compute("sum(AutoID)", "");

Sorting data of DataTable

// Sorting DataTableDataView dataView = new DataView(dTable);
dataView.Sort = " AutoID DESC, Name DESC";
foreach (DataRowView view in dataView)
{
Response.Write(view["Address"].ToString());
}

DataRow[] rows = dTable.Select("", "AutoID DESC");

Writing and Reading XmlSchema of the DataTable

// creating schema definition of the DataTabledTable.WriteXmlSchema(Server.MapPath("~/DataTableSchema.xml"));
// Reading XmlSchema from the xml file we just created
DataTable dTableXmlSchema = new DataTable();
dTableXmlSchema.ReadXmlSchema(Server.MapPath("~/DataTableSchema.xml"));

Reading/Writing from/to Xml

// Note: In order to write the DataTable into XML, // you must define the name of the DataTable while creating it
// Also if you are planning to read back this XML into DataTable, you should define the XmlWriteMode.WriteSchema too 
// Otherwise ReadXml method will not understand simple xml file 
dTable.WriteXml(Server.MapPath("~/DataTable.xml"), XmlWriteMode.WriteSchema);
// Loading Data from XML into DataTable
DataTable dTableXml = new DataTable();
dTableXml.ReadXml(Server.MapPath("~/DataTable.xml"));

Bob Marley dijo: '' Puedes no ser su primero, su ultimo o su único. Ella amo antes y puede amar de nuevo. Pero si ella te ama ahora, Que otra cosa importa? Ella no es perfecta, tú tampoco lo eres, y ustedes dos nunca serán perfectos. Pero si ella puede hacerte reír al menos una vez, te hace pensar dos veces, si admite ser humana y cometer errores, no la dejes ir y dale lo mejor de ti. Ella no va a ... recitarte poesía, no está pensando en ti en todo momento, pero te dará una parte de ella que sabe que podrías romper, su corazón.. No la lastimes, no la cambies, y no esperes de ella más de lo que puede darte. No analices. Sonríe cuando te haga feliz, grita cuando te haga enojar y extráñala cuando no esté. Ama con todo tu ser cuando recibas su amor. Porque no existen las chicas perfectas, pero siempre habrá una chica que es perfecta para ti.. ''

Siempre es preciso saber cuándo se acaba una etapa de la vida. Si insistes en permanecer en ella más allá del tiempo necesario, pierdes la alegría y el sentido del resto. Siempre es necesario cerrar ciertas puertas con una llave, que luego debes olvidar...