[RESOLVED] Saving and retrieving files to SQL

[Beast777]

I am creating an electronic library and would like to store the actual files (not their location) on the sql server in a database. I was thinking about storing the files using BLOB since it will hold alot of data. I started with the code below but as I am new to this, I am unsure how I would save two files in the same save. I have the document file and another file as a cover page.

{
SqlConnection con = new SqlConnection("Server=Darkover;uid=<username>;pwd=<strong password>;database=northwind");
SqlDataAdapter da = new SqlDataAdapter("Select * From MyImages", con);
SqlCommandBuilder MyCB = new SqlCommandBuilder(da);
DataSet ds = new DataSet("MyImages");

da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
FileStream fs = new FileStream(@"C:\winnt\Gone Fishing.BMP", FileMode.OpenOrCreate, FileAccess.Read);
			
byte[] MyData= new byte[fs.Length];
fs.Read(MyData, 0, System.Convert.ToInt32(fs.Length));
			
fs.Close();
			
da.Fill(ds,"MyImages");
				
DataRow myRow;
myRow=ds.Tables["MyImages"].NewRow();

myRow["Description"] = "This would be description text";
myRow["imgField"] = MyData;
ds.Tables["MyImages"].Rows.Add(myRow);
da.Update(ds, "MyImages");

con.Close();
		
}

[Beast777]

Nobody has saved two files in one database before?