Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AlexCuse

    convert string ordinals to integer

    You'll probably need to roll your own. You could make your life much easier by representing as 1st, 2nd, 3rd, 4th .. 9th Here's an integer to word implementation: http://weblogs.asp.net/Justin_Rogers/archive/2004/06/09/151675.aspx I suspect that the reverse would be much harder to implement...
  2. AlexCuse

    Query Select not working

    In your folder tree in visual studio, expand the "Properties" folder. Look for a file called Settings.settings. Open this file. You'll see a table for entering your different settings. In the "name" field enter a name (I used "PrimaryConnectionString"). Then set the "type" to (Connection...
  3. AlexCuse

    SQL to LINQ translation help!

    I think you need something like this: var set = new List<Test>() { new Test(){CartItemId = 1, ProductId = 1, Extra = false}, new Test(){CartItemId = 2, ProductId = 1, Extra = true}, new Test(){CartItemId = 3, ProductId = 2, Extra = false}, new Test(){CartItemId = 4, ProductId = 2, Extra =...
  4. AlexCuse

    Portable Wikis

    Does it need to be something you can carry around with you? If web-based service would work you might like http://delicious.com/ They have a firefox add-in that is fantastic, or you can just log into the delicious site and see all your bookmarks there. ----signature below---- The author...
  5. AlexCuse

    ReportViewer controlling nulls

    You need to do this in the report item's expression. OTOMH something like: =IIf(blah = "", "", String.Format(”{0:(###) ###-####}”, blah)) Since this issue is with the Report itself (not the report viewer) I'd suggest trying this forum next time: forum1462 Hope it helps, Alex ----signature...
  6. AlexCuse

    creating click event for control created on the fly

    Sorry, but there isn't. Its' a limitation of the page lifecycle for webforms. If using a link won't do what you want, then maybe you could use ajax to execute the operations that need to be carried out? FWIW, there is a dedicated ASP.net forum: http://tek-tips.com/threadminder.cfm?pid=855...
  7. AlexCuse

    SqlCommand.ExecuteReader vs SqlDataAdapter.Fill

    can you post the code you're using? ----signature below---- The author of the monograph, a native of Schenectady, New York, was said by some to have had the highest I.Q. of all the war criminals who were made to face a death by hanging. So it goes. My Crummy Web Page
  8. AlexCuse

    Other option of reporting for C#

    If you truly need to dynamically change the column sets (it sounds to me like you are trying to write one report to take the place of many) then I don't think you have much choice. I'd create a form for showing your "reports" and use a gridview or something like that to display your data. Then...
  9. AlexCuse

    Other option of reporting for C#

    Is this for a web application or desktop? I would recommend a little more background for your question. There is a built in report type in visual studio (file extension .rdlc) that is mostly analogous to SQL Server Reporting Services' .rdl report format, except it is rendered on the client...
  10. AlexCuse

    Can a store procedure be written in c#

    How are you trying to split up this column? It sounds like you have some design concerns to be honest, but if you are stuck with the current design at this point, you might still be better off doing the splitting from T-SQL. You could still use the CLR for things like regular expression...
  11. AlexCuse

    SSRS Header row repeat and lock?

    In the future, I think you'd have better luck in the SSRS forum: http://morethanlessthandot.com/threadminder.cfm?pid=1462 But there is a RepeatOnNewPage property that you can set directly in the RDL. Here are some instructions (may be VS2008 specific, I can't confirm ATM): Been a while...
  12. AlexCuse

    Two phase commit/Distributed Transaction

    I got the impression from reading this: http://bugs.mysql.com/bug.php?id=28709 that using the Transaction Scope would work, and that the normal transaction management (using BeginTransaction, Commit) would not. I could be mistaken though. If you tried using the Transaction Scope before, then I...
  13. AlexCuse

    Two phase commit/Distributed Transaction

    I haven't worked a whole lot with MySQL but I have found the .net connector to be the most predictable way to access it. Could you control the transactions from your application? For example, you could implement your own "DistributedQuery" class (probably not the best name but you get the...
  14. AlexCuse

    Hey SQL Gurus.....

    Sorry, I should have capitalized it. The -1 and 0 threw me off. Glad you got it working though! ----signature below---- The author of the monograph, a native of Schenectady, New York, was said by some to have had the highest I.Q. of all the war criminals who were made to face a death by...
  15. AlexCuse

    Hey SQL Gurus.....

    SQL Server stores bit columns as 1 and 0, is this an access table by any chance? If so, take a look at the IIf function. Something like iif(BitColumn = 0, 'No', 'Yes') If not, carry on :) ----signature below---- The author of the monograph, a native of Schenectady, New York, was said by...
  16. AlexCuse

    Suggested Design for Multi-File Export to Tab Delimited ...

    ...best bet would be to write a looping package that's driven by your row identifier? your source query could be something like: select top 10000 * from daTable where rowid > ? order by rowid asc where the parameter is the last row id processed the last time through (you should be able to...
  17. AlexCuse

    Problem inserting record into Database

    How are you checking the database? Does it exist on a local instance of SQL Express? Or are you attaching the same .mdf that you used in your app? It may just be that you are using the wrong connection string, and the database being updated is not the one you inserted to. I've never tried...
  18. AlexCuse

    Generating Word Document on the Server

    For the love of Bob, DON'T use server-side word automation. I don't think that the license allows it (at least not with a single license - not sure about the setup you describe), but it causes major headaches down the road. Something like this might be useful for you...
  19. AlexCuse

    Problem inserting record into Database

    You need to prefix your parameters with an @ sign I believe: string query = "INSERT INTO UserProfile VALUES(@Fname,@Lname,@UserName,@Email,@Pword,@RePword,@UserNumber)"; Hope this helps, Alex ----signature below---- The author of the monograph, a native of Schenectady, New York, was said...
  20. AlexCuse

    Get logon credentials

    Check out the System.Environment class, particularly the UserName and UserDomainName properties. ----signature below---- The author of the monograph, a native of Schenectady, New York, was said by some to have had the highest I.Q. of all the war criminals who were made to face a death by...

Part and Inventory Search

Back
Top