Search results for query: *

Hi, I am developing a Table PC application using C# and VS.NET that is executed in portrait mode with a resolution of 768 X 1024. When I set the size of the form to 768 x 1024 in VS.NET it immediately sets the size to 768 x 780. I can programmatically position text boxes and buttons so they...

Hi, I have a method to render HTML from XSLT. Here is the method: /// <summary> /// Method that renders HTML from XSLT document /// </summary> /// <param name=&quot;writer&quot;></param> protected override void Render(HtmlTextWriter writer) { XPathDocument xdoc = new...

Hi, I have a method to render HTML from XSLT. Here is the method: /// <summary> /// Method that renders HTML from XSLT document /// </summary> /// <param name=&quot;writer&quot;></param> protected override void Render(HtmlTextWriter writer) { XPathDocument xdoc = new...

I agree with you that what you say makes sense but unfortunately that is not the case. I simplified the query and it returned only three rows. select firmID from manageTable where firmID = 189 the result is three rows with two columns FirmID 189 189 189 also there is only one row in the...

Thank you very much for the help. I still don't get the results I expect. Here is a further breakdown in case you might be able to point out where I'm going wrong. If I select user name and firm id from the user table and the manage table with: select u.userName, m.firmID from userTable u join...

I have a User table with: UserID UserName I have a Manage table with: UserID FirmNumber and I have a Firm table with: FirmID FirmName If I know the user's ID, what query would I use to return a table with two columns, UserName and FirmName for only the rows that the UserID in the User...

I just did the same thing and you are correct, it does work! I had posted a simple example to try to understand my problem and when I applied the simple example to your query it worked correctly. That led me to re-evaluated the much lengthier query in my code and led me to my mistake. The false...

SQLSister, If you look at the original data in the tables from the first post on this thread you will see that the Managed(Y/N) flag for EmployeeKey 2 Company2 is set to N. The results return Y as a result of the join. dodge20, I tried both and and where and got the same results. cmgaviao...

Thanks for your help but I am still unable to get the results I need. I tried the query select distinct E.EmployeeName, C.CompanyName, C.Managed from Employee E inner join Company C on E.EmployeeKey = C.EmployeeKey and Managed = 'Y' I get Bob Company1 Y Bob Company2 Y Bill Company1 Y...

I have two tables, one with EmployeeKey EmployeeName and the other with EmployeeKey CompanyName Managed(Y/N) Table 1: 1 Bob 2 Bill Table 2: 1 Company1 Y 1 Company2 Y 2 Company1 Y 2 Company2 N I need to query the two tables and return the employee name and company name for...

Terry, I just tried the advanced search feature again and got the same results as you. I had used it incorrectly before which resulted in the limited returns. Thanks for clearing that up for me. Kyle

Thanks for all the help! I thought I'd share my experience as a result of your posts. While I have been programming for years, I am relatively new to SQL. The first post from Terry introduced me to the term crosstab. While I didn't find alot of examples in the forum as he suggested, it did give...

How do I create a table from a query in Microsoft SQL 2000?

I have two tables that have been joined into a single table. The first table contains primary key Customer Number and Customer Name. The second table contains a foreign key Customer Number and Location Number. There can be multiple locations for each customer. When I join these two tables with...

I am creating a custom control that inherits the ComboBox class. I would like to use the ISite.DesignMode indicator to determine if the control is being viewed in design mode but the property always comes up false. MSDN documentation says the design mode indicator is stored in the ISite...

After creating a new class that inherits the System.Windows.Forms.TextBox, in the new class I would like to set the value of the default Name for the TextBox (other defaults as well) when a new instance is created by dragging the control from the Toolbox and dropping it on a Form. Any idea how...

I'm looking for information about parsing a RichText file for printing with C#. Can anyone help with some information or a lead to finding more about this process? Thanks, Kyle

Can anyone tell me how to center selected text in a RichTextBox. I loaded a rtf formatted document from Word that was centered in Word and it displayed centered in the RichTextBox so I think it can be done. I would apprectiate any help. Thanks, Kyle

Jack, Here's what I learned. The Common Information Model (CIM) is part of the Windows Management Instrumentation (WMI) architecture. The CIM defines objects in the managed environment through classes. These classes include methods to describe behavior and properties to describe data. Some...

Anyone have the code worked out to scan every file in every directory on a hard drive to locate a single file possibly using DirectoryInfo and FileInfo? Kyle Hey Jack, this was really just an excuse to say hello and of course it's always possible that you will have the answer to my question...