Comments by sathiyak (Top 82 by date)

protected void btnnadd_Click(object sender, EventArgs e)
{

if (uploadcollogo.HasFile == true)
{
try
{
//string fileName = Server.HtmlEncode(uploadcollogo.FileName);
System.Drawing.Image image_file = System.Drawing.Image.FromStream(uploadcollogo.PostedFile.InputStream);
int image_height = image_file.Height;
int image_width = image_file.Width;
int max_height = 240;
int max_width = 320;
image_height = (image_height * max_width) / image_width;
image_width = max_width;
if (image_height > max_height)
{
image_width = (image_width * image_height) / image_width;
image_width = max_width;
}
else
{
}
Bitmap bitmap_file = new Bitmap(image_file, image_width, image_height);
System.IO.MemoryStream stream = new System.IO.MemoryStream();
bitmap_file.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
stream.Position = 0;
byte[] image = new byte[stream.Length + 1];
stream.Read(image, 0, image.Length);
string fileName = Path.GetFileName(uploadcollogo.FileName);
//string image1 = MapPath("~/userside/collogo/" + fileName);
string ServerSavePath = Server.MapPath("/Upload");
string path = Path.Combine(ServerSavePath, fileName);
string image1 = "~/userside/collogo/" + fileName;
string status = "Active";
////SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ConnectionString);
SqlConnection cn = new SqlConnection(ConfigurationManager.AppSettings["constring"].ToString());
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "pcolinsert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@colname", txtcolname.Text);
cmd.Parameters.AddWithValue("@colmobile1", txtcolmobile1.Text);
cmd.Parameters.AddWithValue("@colmobile2", txtcolmobile2.Text);
cmd.Parameters.AddWithValue("@collandline", txtcollandline.Text);
cmd.Parameters.AddWithValue("@collemail1", txtcolemail.Text);
cmd.Parameters.AddWithValue("@colaltemail", txtcolaltemail.Text);
cmd.Parameters.AddWithValue("@coladdress", txtcoladdr.Text);
cmd.Parameters.AddWithValue("@colwebsite", txtcolwebsite.Text);
cmd.Parameters.AddWithValue("@colcountry", ddlcountry.SelectedItem.Text);
cmd.Parameters.AddWithValue("@colstate", ddlstate.SelectedItem.Text);
cmd.Parameters.AddWithValue("@colcity", txtcolcity.Text);
cmd.Parameters.AddWithValue("@collandmark", txtcollandmark.Text);
cmd.Parameters.AddWithValue("@collogo", image);
cmd.Parameters.AddWithValue("@status", status);
cmd.Connection = cn;
cmd.ExecuteNonQuery();
uploadcollogo.SaveAs(Server.MapPath(image1));
cn.Close();
clear();
// Response.Write("<script>alert('Record Inserted Sucessfuly')</script>");
Page.ClientScript.RegisterStartupScript(this.GetType(), "Inserted", "<script>alert('Record Inserted Sucessfuly')</script>");


}

catch (Exception ex)
{
lblerrmsg.Text = "Record Not Inserted Successfully";
}



}


}

got it...

thanks.

for this i got soln but dont know how to do for image...

ok

i have alredy added that price also..

excuse me in that coding in a condition line it shows like input string should be in correct format...i dont know...i m asking that one...