مشکل در آپلود عکس و بازیابی ان

[sf_1364]

این کد من در دکمه ذخیره ایت ولی عکس را ذخیره نمی کنه و در ضمن نمی دونم چجوری عکس را بازیای کنم ممنون می شم کمکم کنید
{
SqlConnection cn = new SqlConnection("Server=(local);Database=Reserve;uid=sa;pwd=123");
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "update T_News Set Title=@Title,Abstract=@Abstract,Date=@Date,Source= @Source where NewsID=@id";
cmd.Parameters.Add("@id", Request["id"]);
cmd.Parameters.Add("@Title", txtTitle.Text);
cmd.Parameters.Add("@Abstract", txtAbstract.Text);
cmd.Parameters.Add("@Date", txtDate.Text);
cmd.Parameters.Add("@Detail", txtDetail.Text);
cmd.Parameters.Add("@Source", txtSource.Text);
if (FileUpload1.HasFile)
{
SqlConnection cn2 = new SqlConnection("Server=(local);Database=Reserve;uid=sa;pwd=123");
SqlCommand cmd2 = new SqlCommand();
cmd2.CommandText = "Select * from T_News Where NewsID = @id";
cmd2.Parameters.Add("@id", Request["id"].ToString());
cmd2.Connection = cn2;
cn2.Open();
SqlDataReader dr;
dr = cmd2.ExecuteReader();
dr.Read();
char[] ch = dr["Image"].ToString().ToCharArray();
for (int j = 0; j < ch.Length; j++)
{
if (ch[j] == '/')
{
for (int k = j + 1; k < ch.Length; k++)
str += ch[k].ToString();
break;
}
}
cn2.Close();
dr.Close();
if (!System.IO.File.Exists(@"C:\Documents and Settings\sara\My Documents\Visual Studio 2008\WebSites\Reservation\Images\News" + FileUpload1.FileName))
{
FileUpload1.SaveAs(@"C:\Documents and Settings\sara\My Documents\Visual Studio 2008\WebSites\Reservation\Images\News" + FileUpload1.FileName);
cmd.Parameters.Add("@Image", FileUpload1.FileName);
Img1.ImageUrl = "Images/News/" + FileUpload1.FileName;
}
else
{
char[] ch2 = FileUpload1.FileName.ToCharArray();
string filename = "";
string extention = "";
for (int p = 0; p < ch2.Length; p++)
{
if (ch2[p] == '.')
{
for (int l = p; l < ch2.Length; l++)
extention += ch2[l];
break;
}
else
filename += ch2[p];
}
Random r = new Random();
string fileupload = "";
fileupload = filename + "Copy" + r.NextDouble() + extention;
while (System.IO.File.Exists(@"C:\Documents and Settings\sara\My Documents\Visual Studio 2008\WebSites\Reservation\Images\News\" + fileupload))
{
fileupload = filename + "Copy" + r.NextDouble() + extention;
}
FileUpload1.SaveAs(@"C:\Documents and Settings\sara\My Documents\Visual Studio 2008\WebSites\Reservation\Images\News\" + fileupload);
cmd.Parameters.Add("@Image", "Images/News/" + FileUpload1.FileName);
Img1.ImageUrl = "Images/News/" + fileupload;
}
}
//else
//cmd.Parameters.Add("@Image", "");
cmd.Connection = cn;
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}

[سار]

از تگ کد استفاده کن این طوری اصلن نمیشه فهمید که چی نوشتی یعنی این شکلی و کمی تو همین تالار بگرد کلی مطلب بدردبخور پیدا می کنی
http://barnamenevis.org/forum/showthread.php?t=93539&highlight=%D8%B0%D8%AE%DB%8C%D8%B1%D9%87+%D8%B9%DA %A9%D8%B3+%D8%A8%D8%A7%D9%86%DA%A9

http://barnamenevis.org/forum/showthread.php?t=81649&highlight=%D8%B0%D8%AE%DB%8C%D8%B1%D9%87+%D8%B9%DA %A9%D8%B3+%D8%A8%D8%A7%D9%86%DA%A9

http://barnamenevis.org/forum/showthread.php?t=57645&highlight=%D8%B0%D8%AE%DB%8C%D8%B1%D9%87+%D8%B9%DA %A9%D8%B3+%D8%A8%D8%A7%D9%86%DA%A9

http://barnamenevis.org/forum/showthread.php?t=52574&highlight=%D8%B0%D8%AE%DB%8C%D8%B1%D9%87+%D8%B9%DA %A9%D8%B3+%D8%A8%D8%A7%D9%86%DA%A9


{
SqlConnection cn = new SqlConnection("Server=(local);Database=Reserve;uid =sa;pwd=123");
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "update T_News Set Title=@Title,Abstract=@Abstract,Date=@Date,Source= @Source where NewsID=@id";
cmd.Parameters.Add("@id", Request["id"]);
cmd.Parameters.Add("@Title", txtTitle.Text);
cmd.Parameters.Add("@Abstract", txtAbstract.Text);
cmd.Parameters.Add("@Date", txtDate.Text);
cmd.Parameters.Add("@Detail", txtDetail.Text);
cmd.Parameters.Add("@Source", txtSource.Text);
if (FileUpload1.HasFile)
{
SqlConnection cn2 = new SqlConnection("Server=(local);Database=Reserve;uid =sa;pwd=123");
SqlCommand cmd2 = new SqlCommand();
cmd2.CommandText = "Select * from T_News Where NewsID = @id";
cmd2.Parameters.Add("@id", Request["id"].ToString());
cmd2.Connection = cn2;
cn2.Open();
SqlDataReader dr;
dr = cmd2.ExecuteReader();
dr.Read();
char[] ch = dr["Image"].ToString().ToCharArray();
for (int j = 0; j < ch.Length; j++)
{
if (ch[j] == '/')
{
for (int k = j + 1; k < ch.Length; k++)
str += ch[k].ToString();
break;
}
}
cn2.Close();
dr.Close();
if (!System.IO.File.Exists(@"C:\Documents and Settings\sara\My Documents\Visual Studio 2008\WebSites\Reservation\Images\News" + FileUpload1.FileName))
{
FileUpload1.SaveAs(@"C:\Documents and Settings\sara\My Documents\Visual Studio 2008\WebSites\Reservation\Images\News" + FileUpload1.FileName);
cmd.Parameters.Add("@Image", FileUpload1.FileName);
Img1.ImageUrl = "Images/News/" + FileUpload1.FileName;
}
else
{
char[] ch2 = FileUpload1.FileName.ToCharArray();
string filename = "";
string extention = "";
for (int p = 0; p < ch2.Length; p++)
{
if (ch2[p] == '.')
{
for (int l = p; l < ch2.Length; l++)
extention += ch2[l];
break;
}
else
filename += ch2[p];
}
Random r = new Random();
string fileupload = "";
fileupload = filename + "Copy" + r.NextDouble() + extention;
while (System.IO.File.Exists(@"C:\Documents and Settings\sara\My Documents\Visual Studio 2008\WebSites\Reservation\Images\News\" + fileupload))
{
fileupload = filename + "Copy" + r.NextDouble() + extention;
}
FileUpload1.SaveAs(@"C:\Documents and Settings\sara\My Documents\Visual Studio 2008\WebSites\Reservation\Images\News\" + fileupload);
cmd.Parameters.Add("@Image", "Images/News/" + FileUpload1.FileName);
Img1.ImageUrl = "Images/News/" + fileupload;
}
}
//else
//cmd.Parameters.Add("@Image", "");
cmd.Connection = cn;
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
}