Recent content by Echilon

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...

Thanks that worked a charm. =)

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'...

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...

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...

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...

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...

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

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...

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...

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 =...

I eventually used the CellFormatting event of the 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...

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.

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