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; }