Search results for query: *

  1. G

    Answered Sending multiple values to an SQL Query

    It is amazing though how shear determination can make up for a lack of knowledge/intelligence.
  2. G

    Answered Sending multiple values to an SQL Query

    Mostly just throwing it together, no books, what fundamentals do you suggest? I am Vmware support at a well known company, just struggling through the c# when I have down time - I am not a programmer, as you can see.
  3. G

    Answered Sending multiple values to an SQL Query

    I changed it as follows since there were a couple of red squiggles one under list which I changed to values which made the squiggled disappear but Record is still show as a red squiggle, why is that? It says the namespace Record could not be found. var values = new List<string>()...
  4. G

    Answered Sending multiple values to an SQL Query

    Ok thanks I will take a look at it.
  5. G

    Answered Sending multiple values to an SQL Query

    Isn't the list already in the Data Reader?
  6. G

    Answered Sending multiple values to an SQL Query

    Can you show me how I send the results from the Data Reader to an Array? Thank-you.
  7. G

    Answered Sending multiple values to an SQL Query

    The output is going to a grid. As shown below. So are you saying compare the contents of the listbox with the contents of the results in the grid? Can you give me an example of how that might look? Thank-you. command.CommandText = query.ToString()...
  8. G

    Answered Sending multiple values to an SQL Query

    I have another question about the code you gave me. Right now if someone produces a list of 200 machines and enters them into the list box via a text file. The page searches and produces the report based on what it found. For instance if it found 195 out of 200 machines it will only show the...
  9. G

    Need to Export Gridview1 box to Excel

    Never mind I figured it out - It was the theme I was using on the gridview.
  10. G

    Need to Export Gridview1 box to Excel

    I found the code below to export a gridview to an excel file and it works but the grid lines do not show up in the spreadsheet. I have tried all kinds of variations of different code with no luck. If anyone has any ideas please feel free to share. Thank-you. Response.Clear()...
  11. G

    Need to Export Gridview1 box to Excel

    I guess if the gridview is null after being populated isn't it pointless trying to pull data from it.
  12. G

    Need to Export Gridview1 box to Excel

    I will check tomorrow when back at work, but I am thinking after the gridview1.databind() command the grid displays the data but then resets itself to zero, which is why nothing can be pulled from it, does that make sense?
  13. G

    Need to Export Gridview1 box to Excel

    No there is nothing in the spreadsheet, just blank :(
  14. G

    Need to Export Gridview1 box to Excel

    A friendly reminder, I am at the beginner level and my programmer friend is telling me this is advanced level code, which is above my pay grade, so I don't know what to do with it, I thought if you don't mind looking at this code and telling me why it isn't working, the document downloads but...
  15. G

    Need to Export Gridview1 box to Excel

    Thanks I will try them.
  16. G

    Need to Export Gridview1 box to Excel

    The problem is the columns for each of the buttons have different names, they are not static, each button is pulling a different query - select, name AS 'Vm Name' , vmhost where name like '%name%' so each button will have its own column names.
  17. G

    Need to Export Gridview1 box to Excel

    All I need is a .csv file, which can then be imported into Excel. Thanks. Jason.
  18. G

    Need to Export Gridview1 box to Excel

    I will remember the tip about the whitespace - Thank-you - Jason. I found the following as an example and it doesn't work - System.IO.StringWriter sw = new System.IO.StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); Response.AddHeader("content-disposition", "attachment; filename=" +...
  19. G

    Need to Export Gridview1 box to Excel

    Here you go - Thanks again. var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlconnection"].ConnectionString); connection.Open(); var command = new SqlCommand(); var query = new StringBuilder("SELECT db_owner.vms.name AS 'Vm Name', db_owner.vms.vmhost AS 'ESX Host'...
  20. G

    Need to Export Gridview1 box to Excel

    I have a webpage that is using ASP.net textboxes and an ASP.net GridView1. I am using C# to place the SQL data into the asp boxes, one of them being the GridView1 box. On the web page there are several buttons that fetch VMware object information and then send the information to the gridview...
Back
Top Bottom