public void chargerblob(fichier file)
{
string smt = "SELECT blob FROM dbo.Fichier Where nom=@Name";
cmd = new SqlCommand(smt, conn);
cmd.Parameters.AddWithValue("@Name", file.GetNom());
SqlDataReader rs = cmd.ExecuteReader();
while (rs.Read())
{
if (DBNull.Value != rs[0])
{
byte[] byteData = (byte[])rs[0];
file.Setblob(byteData);
}
}
rs.Close();
}
private void button1_Click(object sender, System.EventArgs e)
{
file.Setblob(file.texttobinary(richTextBox1.Text));
db.insertfilblob(file);
this.Visible = false;
}
