Strong Coders Community

All,

I have a form with a drop down list (populates from a DB)

DataValudField = 126

DataTextField = blah blah

 

Once I select the blah blah from the ddl it displays a gridview.

 

Then I have an export button that directs it to: cmpDataGridToExcel.vb

 

All works great.

 

What I would like to have it do when it ask if I want to save or open I would like it to automatically name the file the datatextfield (blahblah.xls)

 

response.ContentType = "application/vnd.ms-excel"

        response.AddHeader( "Content-Disposition" , ( "attachment;filename=guide_name_display1.xls" ))

 

How would I pass the datatextfield to the above code in the cmpDataGridToExcel?

 

I have searched I have   tinkered but to no avail

now you can understand my image

 

Jeff

Couldn't you use DropDownList.SelectedValue?

---

Cheers,
     Kevin

I did try that, but must have done it wrong. the value is a #, I want to use the text value.

when it tried to use the value it gave me an error that it couldn't convert or use int as string.

tried many different ways but just can't seem to get it.

If you want the text and not the value then use DropDownList.SelectedItem.Text

---

Cheers,
     Kevin

yes that would work, How do I pass the DropDownList1.SelectedItem.Text to

cmpDataGridToExcel.DataGridToExcel(GridView1, Response)?

that is the question.

Thanks

Jeff

 

This case is solved,

One of the coders came to my office to do some testing on a Mac I have and I guess was tired of seeing me beating my head against the wall and showed me how it was done.

 

By adding:

 Public Shared Sub DataGridToExcel(ByVal dgExport As GridView, ByVal response As HttpResponse, ByVal filename As String )

And response.AddHeader("Content-Disposition", ("attachment;filename=" & filename & ".xls")) to the Public Class cmpDataGridToExcel

And then adding  cmpDataGridToExcel.DataGridToExcel(GridView1, Response , DropDownList1.SelectedItem.Text ) to my button it is now working.

I guess I'll learn this stuff one day.

 

Thanks Kevin.

 

Jeff