JawKnee's Q&A profile
Windows Forms DateTimePicker focus
Why is it that when the valuechanged event of the datetimepicker is triggered, its focused is not set to true unlike the other controls like combo boxes etc. I need to check this for i only want to check the values only when user is clicking on the selected date time.thanks Regards Alu I'm getting Focused = true when I change the date in the control itself but false when I use the calendar dropdown. Makes sense, it is a separate window. As a workaround, consider setting a boolean form member to True when you change the date in your code. Then check this member in the ValueChanged event. If it is set to true, you know your code caused the event. When set to false, it can only be the user that changed the value. ...Show All
Visual C# Classes with the same name in the same namespace....
Hi All, In my solution I have 2 classes with the same name in the same namespace. This was legal in VS.net 2003 (.Net 1.1) and all the compiler did was to raise warning about this problem. However with VS.net 2005 (.Net 2.0), this has changed it now throws a compiler error for the same. Is it possible to get around this issue in any way without having to change the class names... Thanks in Advance andypai I just did a small test in .NET 1.1 but even their it is not allowed. Can you sent me the code that you used in .NET 1.1 to see what you mean exactly Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All
SQL Server prevent matrix rowgroup subtotals in excel export
I have a matrix report that allows for the expanding/collapsing of the various row group levels. It is setup with 3 rowgroups and 1 column group. Date Customer EmployeeTitle Employee Sum(Hours) The Employee group's visibility is toggled by the EmployeeTitle group. Everything works as expected until I export to Excel. In Excel, a subtotal row is inserted for every group. I did not manually create the subtotal row and it is not displayed when viewing the report in the browser. Any suggestions on how to prevent the subtotal row from magically appearing in the Excel export Not yet... I'm hoping to convince my business that the subtotal row is a useful "feature&q ...Show All
.NET Development delete in sql
i have a table with columns Name, StudentID how do i update the studentID column on all of the student and increment them by 1 say original table is name studentid a 23 b 14 c 15 now i want to make it like this name studentid a 1 b 2 c 3 could anyone help than kyou you could use dataadapter to update. However, the following 3 t-sql will also do the job: alter table your_table add newid int identity alter table your_table drop column studentid sp_rename 'your_table.newid', 'studentid', 'COLUMN' ...Show All
Windows Live Developer Forums When I Select Source & Destination Dynamically, Path Getting Scatter Across The Map
When I Select Source & Destination Dynamically, Path Getting Scatter Across The Map hi, i can able to get the Correct Route and Path for the corresponding Source and destination, like this, map.GetRoute('Redmond, Washington, United States','seattle, Washington, United States',VEDistanceUnit.KiloMeter,VERouteType.Shortest); when i try to do the same dynamically, i fails there, <html> <head> <title>Driving Directions in Virtual Earth</title> <style type="text/css" media="screen"> ul, li {margin:0;padding:0;} ul.popMenu { position:absolute; margin: 0; padding: 0px; list-style: none; font-family: arial; font-size:10px; text-align: center; width: 100px; /* Width of Menu ...Show All
SQL Server How do you add multiple data sources to a report?
I have a query that pulls information from 2 different servers. I have created two shared data source now I need to connect them to my dataset. The only way I've found to combine data from different data sources into a single dataset is to use techniques like OPENROWSET or use linked servers at the SQL Server level. RS cannot combine data from 2 data sources into one dataset and cannot internally join 2 separately retrieved datasets. ...Show All
.NET Development SQL my final Straw
I am having a bad time with a join, what I am trying to do is get the details of a customer into a data grid. The problem is that the on info available is a booking ID which is linked to the customer table. "SELECT tblCustomer.[customerID], tblCustomer.[firstname], tblCustomer.[surname] FROM tblCustomer WHERE tblBooking.[bookingID] =" & bookingref, myConnection) This is what I have so far. Please any help you may be able to give I would be great full for. Kind Regards Graham A few mistakes here: "SELECT * FROM tblCustomer, tblBooking WHERE tblCustomer.ID = table2.FK" & bookingref First, correct the table name references (query does not know what table2 is, replace with tblBooking): "SELECT * ...Show All
Visual Studio Simple change
Hello ! a newbie question. 1. I have used a "Minimal Sample" example. The DslDefinition shows an "Example Shape" that has a "Light Blue" color. I have tried a lot to change it to "Red", and to see the change in the VS test instance (after F5). No way to see the difference... 2. I have added my own domain class, and its own shape. The two are linked... but I cannot see it in the VS test instance... What did I miss Thanx a lot for any answer/clue/wish/prayer... Messaoud. Select all .tt files inside the GeneratedCode folder, right click and choose 'Run Custom Tool'. This will regenerate all templates and all changes should be committed/generated. Christoph ...Show All
SQL Server How can i split the rows in 2 textboxes - Urgent
Hi, I have a report and its been populating from a sproc. and i have 2 text boxes called both of them are poplulated by Fields!Investment Names, but right i can display the data left to right but i want to display the Data starting top to bottom and then towards the right. I tried grouping the data in this way for one text box = CountRows()/2 > 10 . and this shows all the records one below the other, so is there a way that i can display half the records in one text box and the other half in the other text box. I am going kinda nuts over this. Can someone please help me. Regards Karen Sounds like you will need to use some conditional visibility and math on the rowcounts. Try using a ...Show All
.NET Development xml namespaces problem
I am experiencing a problem with xml namespaces , I would like to to create a document of exactly this format: < xml version='1.0' > < mso-application progid='Excel.Sheet' > <s:Workbook xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:s="urn:schemas-microsoft-com:office:spreadsheet"> <o:DocumentProperties> <o:Author>Somebody</o:Author> </o:DocumentProperties> <s:Styles> <s:Style s:ID="style1"> <s:Font s:Bold="1" /> </s:Style> </s:Styles> <s:Worksheet s:Name="SampleSheet"> <s:Table> <s:Row> <s:Cell s:StyleID=& ...Show All
SQL Server Grand Total Needed
I have two subreports (Revenue and Expense) that each have subtotals. This works just fine, but I need a Grand Total that would sum the two subtotals. How would I go about doing this So it looks something like this: Revenue Report (matrix) Subtotal Expense Report (matrix) Subtotal <~~~~ Need Grand Total here. Greg, I added a textbox to the bottom of my 2 matrix to make my Grand total align correctly. Ham ...Show All
Visual Studio 2008 (Pre-release) certificateValidationMode="ChainTrust" ?
hi, unless i do not set certificateValidationMode = " PeerOrChainTrust " i get a security error .. the default certificateValidationMode = " ChainTrust " does not work , however the issuer of the certificate is in the trusted root certification auhtority (local computer and current user) .. how is that thanks When the certificateValidationMode is set to "ChainTrust", WCF also performs certificate revocation check. So even if the issuer of the certificate is in Trusted Root certificate authority, if WCF cannot perform revocation check (for example revocation server is offline) or the revocation check fails (client certificate is revoked by issuer), y ...Show All
SQL Server Appears to load 3.0 in emulator instead of 3.1
Here's what I did to a VS2005 Smart Device application. Removed the reference to System.Data.SqlServerCe.dll. Set a reference to C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\SDK\bin\wce500\ System.Data.SqlServerCe.dll. While it’s loading in the emulator I notice that it appears to still be loading SQLCE3.0 instead of 3.1. Deploying 'C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\ARMV4i\sqlce30.ppc.wce5.armv4i.CAB' Deploying 'C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\ARMV4i\sqlce30.repl.ppc.wce5.armv4i.CAB' Deploying 'C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\ARMV4i ...Show All
Visual Studio Team System reset work items refnames
hi, i`m defining work-items with specific refnames. but i`m not satisfied with my naming conventions and want to change the names of some fields. but this is not possible and i get the following error: tfs does not support renaming of fields. i thought i just could delete the project where i imported the work-items. but the refnames are obviously remembered and i can`t redefine them. so my question is: is it possible to reset tfs relating to refnames of work-items maybe delete all projects ok i didn`t really deleted the project, i just removed it from team explorer :) TFSDeleteProject /Server:atvie-tfs01 /force test5 this cmd he ...Show All
Visual C# Close() & Dispose(): which one or both?
In relation to ConnectionString property: shall I Close() it or Dispose() of it or both More generally for SqlConnection - the same question: what is the proper way SqlCommand give only a Dispose() option, I guess There is nothing to Close in there, right Thank you. Yes. I think no need to close it. Its just a "command" Object where you can put your SQL Statement or set your Stored Procedure and its parameters. But you can dispose it, it will save you a memory space in RAM. Good luck! ...Show All