In that case I have to update the database. Thank you Graus.

Chaitra N

Thank you. I too think so. But the images have been stored already. Is there is no way to solve this problem?

Hi, I want to open the tif files in web pages. but picture box will not support tif files. How convert tif files into gif or jpeg files programatically when i retrieve the data from database (I am storing only the path of picture files).

Hi Gandalf, Thank you for the reply. Actually it is not mandatory to have login. I thought having logins will be a good idea. Anyway i tell you what I want. I have already have data in the database which have been stored to some other application. Now I want to do some process on the data. But when i open the application it should load the data aumatically. This I can do for the first time and for a single user. But the requirement is suppose when a user1 uses the application data in the first row has to be loaded and when next user uses it simultaneously second row has to be loaded. like wise if 20 users runs application in the same time or at different time data of 20 rows has to be loaded for the 20 users.

Chaitra N

Thank you. But how?

Chaitra N

Hi, I want to develop an application, wher on each users login some data has to get displayed. But it should not be same for any two. example let us assume I have 10 rows of data in database. i.e. d01, d02, d03,d04,d05.....etc. and there are 5 users u1, u2, u3, u4, u5. when u1 logins data or d01 has to get display in his login. then when next user logins next row data has to get displayed. If d06 is completed in one day, next day when the user logins it has to start with data of d07. I am not getting any idea how to start with, any suggestions will be appreciated. Thanks in advance

Hi, I want to play video files stored in the virtual directory. But I could not pass "File name" to that from the sql table. I could only play the specified file. How to overcome this problem? -- modified at 2:56 Thursday 18th October, 2007

Chaitra N

Hi Michael, The code i sent is working fine but i want it to get displayed based on the title present in bulletedlist. See I am storing the path of the video files in my database. I am using the following code to retrieve the path of the file. What I am finding difficult is to assign that path to the " filename " of the mediaplayer object Protected Sub Show_Products(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.BulletedListEventArgs) Handles BulletedList1.Click Dim SQLString As String = "SELECT filepath FROM pictures WHERE title = '" & BulletedList1.Items(e.Index).Text & "'" Dim dr As Data.SqlClient.SqlDataReader Dim comm As New Data.SqlClient.SqlCommand(SQLString, dbconn) If dbconn.State <> ConnectionState.Open Then dbconn.Open() End If Dim str As String dr = comm.ExecuteReader While dr.Read str = dr.Item(0) End While dr.Close() str = str End Sub

Hi , i am using the following code in html to play videos in media player. But i want to give the filename based on the value present in radiobuttonlist. But how to do this? I am confused. Any help ?

Chaitra N

Even when i keep the files in the current application, how to open that? Are u suggesting Response.redirect

Chaitra N

Thank you Abhi, but image control does not have Src property. I can open a picture file using imageurl property. But how to open other files?

Chaitra N

I am uploading files (.doc,.gif,.excel,etc) and storing in the server. Now I want to open those files when i click the link buttons. But I am able to get only the path but how to open it. what changes i need to the following code? Dim SQLString As String = "SELECT filepath FROM pictures WHERE title = '" & BulletedList1.Items(e.Index).Text & "'" Dim dr As Data.SqlClient.SqlDataReader Dim comm As New Data.SqlClient.SqlCommand(SQLString, dbconn) If dbconn.State <> ConnectionState.Open Then dbconn.Open() End If Dim str As String dr = comm.ExecuteReader While dr.Read str = dr.Item(0) End While dr.Close() TextBox1.Text = str

Chaitra N

Thank you. It is working. One more doubt. I am uploading files (.doc,.gif,.excel,etc) and storing in the server. Now I want to open those files when i click the link buttons. But I am able to get only the path but how to open it. what changes i need to the following code? Dim SQLString As String = "SELECT filepath FROM pictures WHERE title = '" & BulletedList1.Items(e.Index).Text & "'" Dim dr As Data.SqlClient.SqlDataReader Dim comm As New Data.SqlClient.SqlCommand(SQLString, dbconn) If dbconn.State <> ConnectionState.Open Then dbconn.Open() End If Dim str As String dr = comm.ExecuteReader While dr.Read str = dr.Item(0) End While dr.Close() TextBox1.Text = str

Chaitra N

But since it does not possess navigateurl property, how can i give the link to that?

Chaitra N

Thank you. It worked.

Chaitra N

hi, I am using bulletedlist control and have set displaymode as linkbuttons. And binding data to that. Till here it is working fine. Now when i select some link on that it has to move to some other page. but how to do this i am not able to retrieve the text from the bulleted list. I mean based on the value present in the bulletedlist i need to write the query. But finding difficult since it does not have either a text property or selecteditem property.

Chaitra N

Hi Ather Ali, I understood what you are telling but not getting how to do it. I have the following code. Picture is getting displayed. It is ok. But not in the image control. suppose if I have a imagecontrol Image1 how can i do this? Dim ImageID As Integer = Convert.ToInt32(Request.QueryString("ImageID")) 'Connect to the database and bring back the image contents & MIME type for the specified picture Const SQL As String = "SELECT [MIMEType], [Image] FROM [Pictures] WHERE [ImageID] = @ImageID" Dim myCommand As New SqlCommand(SQL, myconnection) myCommand.Parameters.AddWithValue("@ImageID", 1) myconnection.Open() Dim myReader As SqlDataReader = myCommand.ExecuteReader If myReader.Read Then Response.ContentType = myReader("MIMEType").ToString() Response.BinaryWrite(myReader("Image")) End If myReader.Close() myconnection.Close()

Chaitra N

Hi, how to bind image present in sql server to image tool.

Chaitra N

Hi, I want to create a elibrary. Like I should be able to update the data regularly and other users should be able to access them. My problem is how to store the data in database? especially images and videos? Thank you in advance.

Chaitra N

I set the AutoPostBack to "True". It is working now. Thank you.

Chaitra N