Jump to content

kwilliams

Members
  • Content Count

    229
  • Joined

  • Last visited

Community Reputation

2 Neutral

About kwilliams

  • Rank
    Member

Profile Information

  • Gender
    Male
  1. I created a simple Stored Procedure (SP) that queries a table and renames the column names, and I'm able to push those results out to a CSV file *with* those header names when done manually.But when I try to export the results to a CSV file by running the same SP using xp_cmdshell with bcp, the header row (Col1, Col2, and Col3) does not appear in the resulting CSV file.ORIGINAL TABLE:ColumnName1-----ColumnName2-----ColumnName3Joe Schmo CustomerJane Doe CustomerTim Tiny MusicianQUERY WITHIN SP:SELECT ColumnName1 AS Col1, ColumnName2 AS Col2, ColumnName3 AS
  2. I recently got a new machine that runs Windows 7 Professional with 64-bit OS. I re-installed several programs, and tried to install SQL Server 2000 without success. I was told that it wasn't compatible with Windows 7, but that I could download MS's "SQL Server 2000 DTS Designer Components" to manage old DTS packages.This worked great a first for several weeks, and then blamo, it just stopped working for no reason. I can view all of the DTS packages with SQL Server 2005 under SERVERNAME > Management > Legacy > Data Transformation Services, but as soon as I try to open one, I get this e
  3. I thought that posting my solution might help others, so here it goes:After getting some advice from another forum user, I was able to solve the problem by taking a step back. I did that by using a simple example of the ArrayList at W3Schools at http://www.w3schools.com/aspnet/aspnet_arraylist.asp to compare it to my code. The issue ended up being in the page declaration. I had EnableViewState="false", and I changed it to EnableViewState="true". Once I did that, and I placed the initial code within an "If Not Page.IsPostBack Then...", it worked as it should.
  4. I'm having a problem getting the selected value from a DropDownList that uses an ArrayList as a DataSource. When I select a year and click on the submit button, I get the following error message: Object reference not set to an instance of an object. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. I'm not understanding why this isn't working. The years (1900 - 1993) are getting populated into the DropDownList without a problem, but on the btnSubmit_Click job gets submitted, I get that error. And and all help would be appreciated. Hopeful
  5. No replies yet? Too bad. I did find this article on 4guysfromrolla with using a DataGrid for the same thing: http://www.4guysfromrolla.com/articles/112603-1.aspx, but I don't like the limitations that the DataGrid gives me. If W3Schools doesn't intend on updating that page with another newer language, that's fine. I'd just like to know. It's been there for awhile now.
  6. I've always loved this simple code setup that allows you to edit an XML document with XSLT and ASP code: http://www.w3schools.com/xsl/xsl_editxml.asp But I've always wondered whether or not they'll add to that page with matching ASP.NET/VB.NET code. Is that something that W3Schools looks to do in the near future?
×
×
  • Create New...