private void btDeserializeLine_Click(object sender, EventArgs e)
{
try
{
using (DbConnection cnn = new SQLiteConnection("Data Source=DBLines.db3"))
using (DbCommand cmd = cnn.CreateCommand())
{
cmd.CommandText = "SELECT PointPairsList FROM TableLines WHERE PointPairsList IS NOT NULL";
cnn.Open();
using (DbDataReader rd = cmd.ExecuteReader())
{
if (rd.Read() == false) throw new ArgumentOutOfRangeException();
long length = rd.GetBytes(0, 0, null, 0, 0);
byte[] baDeseri = new byte[length];
rd.GetBytes(0, 0, baDeseri, 0, baDeseri.Length);
BinaryFormatter formatter = new BinaryFormatter();
MemoryStream ms = new MemoryStream(baDeseri);
list2 = (PointPairList)formatter.Deserialize(ms);
ms.Close();
}
}
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
}
}
Partager