I am trying to insert an image into my SQL & Trying to read the image,
After insertion immediately the image details are getting reflected on my
repeater,
in repeater there is a link called "view".
on click of "view" I am trying to read the image on a popwindow.
There is something going wrong while inserting,
Can anyone tell me where is wrong in my following functions.
private void btn_Upload_Click(object sender, System.EventArgs e)
{
string sFileName =
System.IO.Path.GetFileName(txt_GetImage.PostedFile.FileName);
if ( txt_GetImage.PostedFile.ContentType!="image/pjpeg" &&
txt_GetImage.PostedFile.ContentType.ToString()!="image/gif")
{
errMsg.Text="You can upload only .jpg/.gif Image";
}
else
{
/*string AppRoot=Request.ServerVariables["APPL_PHYSICAL_PATH"];
string ImgTempFolder =
AppRoot+ConfigurationSettings.AppSettings["TempImgFolder"]+"\\"+sFileName;
txt_GetImage.PostedFile.SaveAs(ImgTempFolder); //Upload the image in a temp
folder
*/
string sFilePathToStore = Server.MapPath("");
int iIdx = sFilePathToStore.IndexOf("\\StayNTravel",0);//42
string sMainAppPath = sFilePathToStore.Substring(0,iIdx);
string ImgTempFolder = sMainAppPath +
"\\StayNTravelProj\\StayNTravel\\TempImg" + "\\" +
sFileName;
//To upload the file into SaveLocation..
txt_GetImage.PostedFile.SaveAs(ImgTempFolder);
string ImgFile=ImgTempFolder;
FileStream fStream = new FileStream(ImgFile, FileMode.Open,FileAccess.Read);
byte [] buffer = new byte[fStream.Length];
fStream.Read(buffer,0, (int)fStream.Length);
long sFileSize=buffer.LongLength;
fStream.Close();
Hashtable HotelImgDetails=new Hashtable();
HotelImgDetails.Add("UID",Session["sesEmail"].ToString());
HotelImgDetails.Add("HOTEL_ID",Session["Hotel_Id"].ToString());
HotelImgDetails.Add("hotelName","Hotel International");
HotelImgDetails.Add("Picture_Buffer",buffer);
HotelImgDetails.Add("Pic_Name",sFileName);
HotelImgDetails.Add("Pic_Size",sFileSize);
Images objImg=new Images();
bool fSucess=objImg.SaveHotelImageIntoDB(HotelImgDetails);
DeleteTempImage(ImgTempFolder);// Delete Image from Temp Folder;
// Reload Images into Repeater from Database;
GetHotelImages(Session["sesEmail"].ToString(),Session["Hotel_Id"].ToString());
if (fSucess==true)
{
errMsg.Text="Image has been uploaded sucessfully.";
}
else
{
errMsg.Text="Image has NOT been uploaded.";
}
}
}
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
public bool SaveHotelImageIntoDB(Hashtable HotelImageDetails)
{
objDB.OpenConnection();
try
{
SqlCommand objCom=new SqlCommand();
objCom.CommandType=CommandType.StoredProcedure;
objCom.CommandText="sp_AddImages";
objCom.Connection=objDB.mysqlconn;
objCom.Parameters.Add("@userId",SqlDbType.VarChar).Value=
HotelImageDetails["UID"].ToString();
objCom.Parameters.Add("@HOTEL_ID",SqlDbType.VarChar).Value=
HotelImageDetails["HOTEL_ID"].ToString();
objCom.Parameters.Add("@hotelName",SqlDbType.VarChar).Value=
HotelImageDetails["hotelName"].ToString() ;
objCom.Parameters.Add("@Picture_Buffer",SqlDbType.Image).Value =
HotelImageDetails["Picture_Buffer"];
objCom.Parameters.Add("@Pic_Name",SqlDbType.VarChar).Value =
HotelImageDetails["Pic_Name"].ToString();
objCom.Parameters.Add("@Pic_Size",SqlDbType.Int).Value =
HotelImageDetails["Pic_Size"];
objCom.ExecuteNonQuery();
objDB.closeConnection();
return true;
}
catch
{
objDB.closeConnection();
return false;
}
}
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Thanks & Regards
Arindam
Web Designer & Developer
Yahoo! India Matrimony: Find your life partneronline.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
