Web Application query

siri

13y4.3k.NET

Hi Experts please help me to write code for this .

my requirement is ........

i have an user id and pwd and one image box and one upload button..and one text box

so what i want is when user login and upload image he can be able to upload an image of any size no limitation for size for any number of time and he can write some text upto 300 words only and and also upload vedio for 2 mins when he clicks on save button then including this text and image and vedio can be stored on server plz help me out im in very urgency .....

thanks in advance
siri

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dorababu Meka13y ago

Check the video too

Here is your code, if you are saving the image in same table means change the necessary where ever needed

User ID :
User Name :
Password :
Image :

// change the connection string and table name and columns names as per required

protected void btnUpload_Click(object sender, EventArgs e)

{

if (FileUpload1.PostedFile != null &&

FileUpload1.PostedFile.FileName != "")

{

byte[] imageSize = new byte

[FileUpload1.PostedFile.ContentLength];

HttpPostedFile uploadedImage = FileUpload1.PostedFile;

uploadedImage.InputStream.Read

(imageSize, 0, (int)FileUpload1.PostedFile.ContentLength);

SqlConnection con = new SqlConnection();

con.ConnectionString = ConfigurationManager.ConnectionStrings

["vendorConn"].ConnectionString;

con.Open();

SqlCommand cmd = new SqlCommand();

cmd.CommandText = "INSERT INTO tblUsers(userID,Name,Password)" +

" VALUES (@usrID,@Name,@Pwd)";

cmd.CommandType = CommandType.Text;

cmd.Connection = con;

SqlParameter usrID = new SqlParameter("@usrID", SqlDbType.Int, 50);

usrID.Value = txtUserID.Text;

SqlParameter usrName = new SqlParameter("@Name", SqlDbType.VarChar);

usrName.Value = txtUsrname.Text;

SqlParameter pwd = new SqlParameter("@Pwd", SqlDbType.VarChar);

pwd.Value = txtPwd.Text;

cmd.Parameters.Add(usrID);

cmd.Parameters.Add(usrName);

cmd.Parameters.Add(pwd);

cmd.ExecuteNonQuery();

cmd.Parameters.Clear();

con.Close();

cmd.CommandText = "INSERT INTO tblImage(userID,Image)" +

" VALUES (@userID,@Image)";

cmd.CommandType = CommandType.Text;

cmd.Connection = con;

con.Open();

SqlParameter usrID1 = new SqlParameter("@userID", SqlDbType.Int, 50);

usrID1.Value = txtUserID.Text;

SqlParameter UploadedImage = new SqlParameter

("@Image", SqlDbType.Image, imageSize.Length);

UploadedImage.Value = imageSize;

cmd.Parameters.Add(usrID1);

cmd.Parameters.Add(UploadedImage);

cmd.ExecuteNonQuery();

imgEmployee.ImageUrl = "Handler1.ashx?userID=" + usrID1.Value + "";

}

}

Your handle.ashx should be as follows here also change as per required

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Data.SqlClient;

using System.Configuration;

namespace StaticHeader

{

///

/// Summary description for Handler1

///

public class Handler1 : IHttpHandler

{

public void ProcessRequest(HttpContext context)

{

SqlConnection con = new SqlConnection();

con.ConnectionString = ConfigurationManager.ConnectionStrings

["vendorConn"].ConnectionString;

// Create SQL Command

int empID = Convert.ToInt16(context.Request.QueryString["userID"].ToString());

SqlCommand cmd = new SqlCommand();

cmd.CommandText = "Select Image from tblImage" +

" where userID =@ID";

cmd.CommandType = System.Data.CommandType.Text;

cmd.Connection = con;

SqlParameter ImageID = new SqlParameter

("@ID", System.Data.SqlDbType.Int);

ImageID.Value =empID;

cmd.Parameters.Add(ImageID);

con.Open();

SqlDataReader dReader = cmd.ExecuteReader();

dReader.Read();

context.Response.BinaryWrite((byte[])dReader["Image"]);

dReader.Close();

con.Close();

}

public bool IsReusable

{

get

{

return false;

}

Dorababu Meka13y ago
Does image belongs to different table or the same table? post your table structure too
0
Dorababu Meka13y ago
To display image immediately you have to write your code by creating and Hadler.ashx, in this you have to write your code

SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings ["ConnectionString"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Your select command with condition";
cmd.CommandType = System.Data.CommandType.Text; cmd.Connection = con; SqlParameter ImageID = new SqlParameter ("@ID", System.Data.SqlDbType.Int); ImageID.Value = context.Request.QueryString["ID"]; cmd.Parameters.Add(ImageID); // con.Open();
SqlDataReader dReader = cmd.ExecuteReader();
dReader.Read();
context.Response.BinaryWrite((byte[])dReader["Image"]);
dReader.Close();
con.Close();

and your image url on your desired page should be

here in place of employeeid write yours if you have any

Still not clear post some images of your application what you are trying to do
0
siri13y ago
Thanku for your help but i still iam not satisfied/did not get exactly what i want:(

as i mentioned in my previous post.........

i have an user id and pwd and one image box and one upload button..and one text box

so what i want is when user login and upload image, the image must display there in the form

(jus like we fill some application for an exam) when we upload an image and the vedio file , the image url and the image shuld display in the form itself and also in database and apart from this the user can able to upload an image of any size no limitation for size for any number of time and he can write some text upto 300 words only in text box and clik save button so that it can be save in database
0
Dorababu Meka13y ago
check here

http://csharpdotnetfreak.blogspot.com/2009/07/fileupload-control-save-images-database.html
0
Dorababu Meka13y ago
What is your data type of the column can you copy paste your table structure
0
siri13y ago
please give me the step by step procedure for my query :(

there is an
user id == some value

pwd== some value

after clicking this
browse >and then

(2 min vedio)

and click on save

tis is my requirement
0
siri13y ago
i took it as like this

Column name = ImagePath and datatype as Image

hmmm
0
siri13y ago
Yes i wnat to save it in database:)
0
Dorababu Meka13y ago
Would you like to save to database? if so what is the data type of your image column in your table,
0