Saving BLOB in SQL-Server

SqlConnection con = new SqlConnection(”Data Source=(Local);Initial Catalog=Pack;user id=sa;pwd=murugesan”);
con.Open();
SqlDataAdapter sd = new SqlDataAdapter(”Select *from Signatures”, con);
SqlCommandBuilder builder = new SqlCommandBuilder(sd);
DataSet ds = new DataSet(”Signatures”);
sd.MissingSchemaAction = MissingSchemaAction.AddWithKey;
FileStream fs=new FileStream(@”D:\\VijayMallya.Jpg”,FileMode.OpenOrCreate,FileAccess.Read);
byte[] size = new byte[fs.Length];
fs.Read(size,0, System.Convert.ToInt32(fs.Length));
fs.Close();
sd.Fill(ds, “Signatures”);
DataRow drow;
drow = ds.Tables["Signatures"].NewRow();
drow["image"] = size;
ds.Tables["Signatures"].Rows.Add(drow);
sd.Update(ds, “Signatures”);
con.Close();

Hello world!

Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!