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

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

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

put the anchor tag and give the url of the file you want to open sorry for late reply Thanks and Regards Sandeep If If you look at what you do not have in life, you don't have anything, If you look at what you have in life, you have everything... "

hi.... sorry for late reply.... here u r selecting filepath in query.... so, .. your data reader will give you only path of that file... if you want to open u need to download on client machine .. at that time it will give option for save or open file.... OR .................. OR ............... OR ............. Use System.IO and using this class create streamreader and read file .... ..... Try ... this.... - Best of work...........

Thank you. It worked. Chaitra N

Now you're talking!!! Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

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

But Michael it returns only the values present in a table where i am storing all the values. See i put my requirement in another way. For the subscription of a website i enter some area of interest in checkboxes. Suppose if i want to modify them(addition or removal), i need to see all the options(area of interest) as well a which i had selected. All the values options will be present in one table and when i request the page it displays all the options and the options i had chosed previously have to be checked. Let say i am storing all the options in a table "Options" in the column "Interest" and when i select them i will store the values in the table "Web" which has the columns "Email" And "Area_Of_Int". Chaitra N

I have one more doubt. This is regarding bindng of listbox. Let us assume I store A B C D in from listbox2. It stores as A,B,C,D . When i bind the data to listbox it comes as the same. But i want to display each value in different row. How to do this? I tried split function but no use. Here is the code snippet i have used to bind the data to listbox, lstselectedemployees is the listbox. Dim sql As String = "Select * from A_desktops where assetcode='" & TextBox1.Text & "'" Dim da As New SqlDataAdapter(sql, dbconn) Dim ds As New DataSet() da.Fill(ds, "a_desktops") lstselectedemployees.DataSource = ds.Tables("a_desktops").DefaultView lstselectedemployees.SelectedIndex = 0 lstselectedemployees.DataTextField = "swinstalled" Page.DataBind() Chaitra N

The legs, especially the left one. Don't follow any man spiritually, don't do anything that will get you in sh*t if god is real - Bradml[^]

Hi, This function is working, But the each value is getting stored in different row of the table. I want them to get stored in a single row. Dim str As String If dbconn.State <> ConnectionState.Open Then dbconn.Open() End If For Each item As ListItem In lstselectedemployees.Items str = "insert into a (soft)values('" & item.Text & "')" Dim comm As New SqlCommand(str, dbconn) Try comm.ExecuteNonQuery() Label1.ForeColor = Drawing.Color.Green Label1.Text = "Success" Catch ex As Exception Label1.Text = ex.Message End Try Next If I use the following code then, only the last item of the list box is getting stored, Dim str As String If dbconn.State <> ConnectionState.Open Then dbconn.Open() End If For Each item As ListItem In lstselectedemployees.Items str = "insert into a (soft)values('" & item.Text & "')" next Dim comm As New SqlCommand(str, dbconn) Try comm.ExecuteNonQuery() Label1.ForeColor = Drawing.Color.Green Label1.Text = "Success" Catch ex As Exception Label1.Text = ex.Message End Try Chaitra N

Now it is working. I have changed the enableviewstate property of all the controls to true and readonly property of datetextbox(text boxes where we have date value) to false. But i want datextbox readonly. What can I do for this? Chaitra N

When I run the statement in query analyzer, it does work. And how to read up on SQL injection attacks Chaitra N

Fetch the string value and using pares method as coded below you can convert string to date datatype vb Code Dim s As String = TextBox1.Text Dim d As Date = Date.Parse(s) Response.Write(d) ganeshk

I dont know whether i have to use cursor or simply a stored prcedure. This is FIFO inventory system. Recieved and Issue items will be in different table say, RECIEVE & ISSUE. Each item may be recieved and issued many times. Each time may be with different rate,quantiy and date. For example let us considere the following tables, RECIEVE TABLE PARTNO RDATE RRATE/UNIT rQUANTITY A 10/10/2006 15 20 A 10/10/2007 20 50 A 1/11/2006 18 10 B 10/12/2006 15 30 B 13/2/2007 25 15 ISSUE TABLE PARTNO IDATE IRATE/UNIT iQUANTITY A 10/5/2007 18 18 A 1/12/2007 20 45 A 13/2/2007 20 15 B 13/2/2007 20 20 B 1/5/2007 20 25 Ultimately i have to get the following table PARTNO IDATE IRATE/UNIT iQUANTITY ShortTerm LongTerm Here I want to find the LongTerm Value and Shorttem value depending on the difference in date between idate and rdate of each item. This is to find the gain or loss of the item in that particular date. The formula is iquatity(irate)+iquatity(irate-rRate),if the date difference between recieve and issue is >365 day then the calculated value should be place in LongTerm value column else in the Short term value column First we take A, the first issue quanitity is 18, but the no of quantity recieved was 20 so the value will be 18(18)+18(18-15). Now the remaining no of items present in first recieved is 2.The difference between issue date 10/5 /2007 and recieve date 10/10/2006 is less than 365 days so has to be placed in ShortTerm column. So when calculating the amount of second issue first we have issue remaining 2, then go for second recieve. Here issue quantity is 45. so, the value must be (2(20)+2(20-15)). The difference between issue date 1/12/2007 and recieve date 10/10/2006 is more than 365 days so has to be placed in LongTerm column. Then remaining 43 items, the value has to be (43(20)+(43(20-20). The difference between issue date 1/12/2007 and recieve date 1/12/2007 is less than 365 days so has to be placed in ShortTerm column. Now the remaining items in Recieve table for A item is 7+10. Now we have to calculate the next A item as we did for second. i.e. fir

Use a WHERE in the UPDATE UPDATE receipt set longvalue=datediff(dd,transactiondate, Issuedate) WHERE datediff(dd,transactiondate, Issuedate) >365 UPDATE receipt set shortvalue=datediff(dd,transactiondate, Issuedate) WHERE datediff(dd,transactiondate, Issuedate) <= 365 Upcoming events: * Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ... "I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless." My website

select 'Difference in Date'=datediff(dd,r.rdate,i.idate) from receive r,issue i where r.partno=i.partno Chaitra N