public static void ModifyArchive(string currentRow)
{
var newArray = new List <DataSql>();
// Connect to the Database
using (SqlConnection sqlConn = new SqlConnection(_connectionString))
{
string cmdString = "SELECT * FROM [dbo].[ArchivesV2] WHERE ID = @val1";
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = sqlConn;
cmd.CommandText = cmdString;
cmd.Parameters.AddWithValue("@val1", currentRow);
sqlConn.Open();
var dr = cmd.ExecuteReader();
while (dr.Read())
{
DataSql dataSql = new DataSql
{
Cote = dr["cote"].ToString(),
Versement = string.IsNullOrEmpty(dr["versement"].ToString()) ? new DateTime(1900, 1, 1) : Convert.ToDateTime(dr["versement"].ToString()),
Etablissement = dr["etablissement"].ToString(),
Direction = dr["direction"].ToString(),
Service = dr["service"].ToString(),
Dossiers = dr["dossiers"].ToString(),
Extremes = dr["extremes"].ToString(),
Elimination = dr["elimination"].ToString(),
Communication = dr["communication"].ToString(),
Localisation = dr["localisation"].ToString()
};
newArray.Add(dataSql);
}
}
}
}