I was wondering if anyone knew how to add a row to a excel file. My code is a loop in which I display results in different rows. The problem is that I don't know how to display mutiple results. I am only capable of displaying the last record in my loop. I want to be able to create a new row in my loop for each of my records. An example of my code is as follows:

do while dr.read()
field1.text = dr.getfile(0)
field2.text = dr.getfile(1)
field3.text = dr.getfile(2)
loop

I would appreciate any help. Thank you.

Are you sure you have more than one row in your result set? Is your loop logic correct? Maybe you can post more of your code for us to look at.

I'm sure I have more than one row in my result because I tested the statement out in Query Analyzer and I should have ten. Yet, it is only displaying the last one because it's looping. Here is what I have:

sqlstring = sqlstring & " and a.filenumber in(121632,172041703)"
        Dim comm3 As New SqlClient.SqlCommand(sqlstring, SqlConnection1)
        Dim dr3 As SqlClient.SqlDataReader

        Try
            SqlConnection1.Open()
            dr3 = comm3.ExecuteReader

            Do While dr3.Read()
                Response.Write("<tr>")
                fld1.Text = dr3.GetValue(0)
                fld2.Text = dr3.GetValue(1)
                fld3.Text = dr3.GetValue(2)
                fld4.Text = dr3.GetValue(3)
                fld5.Text = dr3.GetValue(4)
                Response.Write("</tr>")
            Loop

        Catch ex As Exception
        Finally
            dr3.Close()
            SqlConnection1.Close()
        End Try

I tried adding a row by putting the response.write. But, that didn't work. Is there any other way?

I think the problem may be that you are using the GetValue method. This returns an object not the value of the column. You need to try the GetString() method.

Actually, it does return the value of the column. It reads it in fine. All I want to do is add a new row each time a record is read. Is there a way to do that?

Your code should be working correctly. Check some examples in VS help or GOOGLE datareader. From what I see, your code is correct. Maybe you can post all the page code.

It is working. But, I just want it to create another row, which isn't part of the code. Can you tell me how to do that?

Can you try it and tell me if it creates mutiple rows for you?

What do you mean by create another row? Do you mean a blank row?

Yes, I mean create a blank row. I took out the response.write statement since it doesn't work.