Saving images in the database to file.

string sPath = "c:\\inetpub\\wwwroot\\iwkoeln\\import\\";

string sFileName="";

string sFilePath="";

divContent.Visible = false;

divBanner.Visible = false;

divImageP.Visible = true;

sqlDaImage.SelectCommand.Parameters["@ID"].Value = Convert.ToInt32(sId);

sqlDaImage.Fill(dsBericht);

if(dsBericht.Tables[0].Rows.Count>0)

{

if(!File.Exists(dsBericht.Tables[0].Rows[0]["strImagePicName"].ToString()))

{

baImage = (byte[])dsBericht.Tables[0].Rows[0]["imgImagePic"];

try

{

sFileName = dsBericht.Tables[0].Rows[0]["strImagePicName"].ToString();

if(sFileName.IndexOf("wwwroot")<=0)

{

sFilePath = sPath + sFileName;

}

else

{

int iWeg = sFileName.LastIndexOf("\\");

sFileName = sFileName.Substring(iWeg, sFileName.Length - iWeg);

sFilePath = sPath + sFileName;

}

FileStream fs = new FileStream(sFilePath, FileMode.Create);

BinaryWriter bw = new BinaryWriter(fs);

bw.Write(baImage);

bw.Close();

fs.Close();

}

catch(Exception ex)

{

string sError = ex.Message;

}

}

imgShow.Src = "import/" + sFileName;

}