uploading Documents with meta data to SharePoint Doc lib Folder

public static void UploadFileWithMetaData(string Asset, string fileName)

{

SqlConnection cn = new SqlConnection("server=aaa;database=aaa;user id=sa;password=sa");

SqlCommand cmd = new SqlCommand("SELECT FORMAT2.FILENAME, FORMAT1.ISCI, FORMAT2.PATH+FORMAT2.FILENAME as FullPath, Format2.FileLocation,Format2.Format, Format2.RES FROM FORMAT as Format1 inner join Format as Format2 on Format1.ISCI=Format2.ISCI WHERE FORMAT1.FORMAT = 'HFD' AND Format2.Format <> 'DATA' AND FORMAT1.ISCI='" + Asset + "' AND FORMAT2.FILENAME='" + fileName + "'", cn);

cn.Open();

SqlDataReader dr = cmd.ExecuteReader();

SPSite siteCollection = new SPSite("http://localhost:10010/");

while (dr.Read())

{

using (SPWeb web = siteCollection.RootWeb)

{

SPList list = web.Lists["Video Library"];

SPFolder folder = GetFolder(list, dr[1].ToString());

if (dr[0].ToString() != String.Empty)

{

SPFileCollection fcol = folder.Files;

FileStream fstream = File.OpenRead(dr[2].ToString());

byte[] content = new byte[fstream.Length];

fstream.Read(content, 0, (int)fstream.Length);

fstream.Close();

string destFile = fcol.Folder.Url + "/" + dr[0].ToString();

SPFile addedFile = fcol.Add(destFile, content, false);

SPItem item = addedFile.Item;

if (dr[0].ToString() != String.Empty)

item["Name"] = dr[0].ToString();

if (dr[1].ToString() != String.Empty)

item["ISCI"] = dr[1].ToString();

if (dr[2].ToString() != String.Empty)

item["FullPath"] = dr[2].ToString();

if (dr[3].ToString() != String.Empty)

item["FileLocation"] = dr[3].ToString();

if (dr[4].ToString() != String.Empty)

item["Format"] = dr[4].ToString();

if (dr[5].ToString() != String.Empty)

item["RES"] = dr[5].ToString();

item.Update();

addedFile.Update();

}

}

}

cn.Close();

}