Search results for query: *

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

I'm trying to access image resources in my application, but I can't the resources from the application, I just end up with null. I've added the resources in the properties section in visual studio 2008, and the code I'm using is private ResourceManager res = new...

Thanks bledazemi, the one problem is that I don't know how many containers will occupy the same Y-Position. In the example there are a maximum of two, but there could be up to ten depending on the situation. I'll have a play with the anchor settings using your examples and see if I can come up...

I have a user control (which for the purposes of this post is just a container), and several nested user controls. I want to lay out the child controls inside the container in a similar way to the attached picture. I've tried different combinations of Anchor and Dock properties as well as using...

I've managed to get it working by using panelName.AutoScrollPosition.

I'm trying to draw a sort of table onto a UserControl in C#. The table will resemble something like an Excel spreadsheet, with a header at the top and a column visible to the left side (these will always be visible, regardless of scroll state). I'm also going to have a number of vertical...