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!

Recent content by Echilon

  1. Echilon

    Sharepoint / ASP.NET - Login and user creation

    I'm trying to integrate SHarepoint with ASP.NET and automate some things. First, I need to login to sharepoint automatically when a user logs into ASP.NET using the ASP.NET membership provider. So far I've found limited information about Active Directory and LDAP, but nothing with standard...
  2. Echilon

    Crosstab with MSSQL

    Thanks that worked a charm. =)
  3. Echilon

    Crosstab with MSSQL

    Thanks. That seems to have fixed a few errors, but the real query is still giving me problems. The 'forename' field is actually called 'languages' and the 'surname' is called 'translation'. When I try the query: SELECT MAX(CASE WHEN language = 'de-DE' THEN translation ELSE 0 END) AS 'de-DE'...
  4. Echilon

    Crosstab with MSSQL

    I posted a couple of weeks ago regarding a crosstab in MySQL ( http://www.tek-tips.com/viewthread.cfm?qid=1513428 ). The solution I found worked perfectly, but now I need to implement the same thing in SQL Server 2008 and it's more difficult than I though. There's a graphic to illustrate the...
  5. Echilon

    GROUP BY and DISTINCT

    I have a few tables and I need to select multiple fields from each. This query works but it doesn't class rows as unique, since if multiple translationids exist, there are multiple rows with the same translationid. I need a single row for each translationid. SELECT DISTINCT...
  6. Echilon

    Remapping fields

    That's exactly what I needed. It works using: SELECT MAX(IF(forename='john',surname,null)) AS john, MAX(IF(forename='lucy',surname,null)) AS lucy, MAX(IF(forename='jenny',surname,null)) AS jenny, MAX(IF(forename='steve',surname,null)) AS steve, MAX(IF(forename='richard',surname,null)) as...
  7. Echilon

    Remapping fields

    I'm trying to reorder/group a set of results using SQL. I have a few fields (which for the example have been renamed to something a bit less specific), and each logical group of records has a field which remains constant - the address field. There are also fields which are present for each...
  8. Echilon

    Indexes and integrity

    That's what I was hoping wouldn't happen. This might be easier to do programatically instead.
  9. Echilon

    Indexes and integrity

    I'm trying to get an index working on a table. This is my data structure (with non important columns omitted): Each translation in the translations table can be used by none or more elements. For example: --Elements-- (id, translationid, elementname) 1000, 1, 'btnDay' 1001, 1...
  10. Echilon

    Unusual Events

    I'm trying to create an HTML editing control in C# using the technique at http://www.codeproject.com/KB/IP/WYSIWYG_netHTML2.aspx . The control works fine, but there's a nagging thing I'd like it to do. Usually in a text editor, when you change the selection, if the selected text is bold or...
  11. Echilon

    Small Icons in a ListView

    I need to display a grid of icons to allow a user to select one. The only way I can think of doing this is with a ListView in Small Icons view, which works, but not as I need. The problem is that the width of each item is too big. For example, the ListView is filled using this code: for(int i =...
  12. Echilon

    Unix Times in DataGridView

    I eventually used the CellFormatting event of the DataGridView.
  13. Echilon

    Unix Times in DataGridView

    I have a DataGridView which gets data from a DataSet, one of the columns in the DataSet has an integer (a unix timestamp). I need to display the timestamp as a formatted DateTime, but I can't figure out how. I have a static method which converts unix times to DateTimes, but I can't find any...
  14. Echilon

    Docking/Anchoring controls

    I was thinking about a tablelayoutpanel, but each user control could be a different height. I think calculating the bounds is the only way to do it.
  15. Echilon

    Icons from resource name

    That was it. I needed to leave off the extension. Problem solved. :)
See more

Part and Inventory Search

Back
Top