A kid's Q&A profile
SQL Server SQL Management Express Linked Server
I have created a Linked Server (in Server Objects) and set the linked server options. Now I need to set the Provider Options. In help I can see the page for the Provider Options dialog but I cannot get to it. Books-on-line suggest right-click the provider name but that gets me a menu with only a "Refresh" selection. How do I get to the Provider Options (or Properties) Dialog I see registry entries for SQL Server 2000 but I cannot find the same for SQL Server 2005. I would file this issue in the Feedback Center. In Managment Stuio, open the Community menu, then click Submit Feedback. You'll be taken to a wizard that allows to search for existing issues and then file a new one if you don't ...Show All
Visual Studio 2008 (Pre-release) Invalid attribute when attempting to bind slider Value
I get blue squiggles int the XAML when trying to bind a slider to a double value property (well of course it doesn't know that it's a double vlaue propert till runtime ..._ < Slider Margin = " 5 " Width = " Auto " Grid.Row = " 1 " Grid.ColumnSpan = " 2 " Grid.Column = " 0 " Orientation = " Horizontal " Value = " {Binding Path=Value} " Minimum = " 0 " Maximum = " 2 " TickFrequency = " 0.01 " IsSnapToTickEnabled = " True " /> Seems like a problem in the schema -- Dan I thought this was where I was supposed to report faults .... I'll write them u ...Show All
Visual Studio Express Editions message box show without stopping program
In a console application. Is there a way to display a message box that does not stop the execution of the program Use ShowDialog instead of show...this will keep the form open until you decide to close it... "relevant message" are you setting that in the designer You are not using McAfee Version 8 ...Show All
Architecture Database Design
Hi All, I need some advice and reference on database design. The database my application uses will have many tables, each with many columns. Most of the columns store data generated automatically by the application, and the data could be regenerated and overwritten by the app when necessary. However, I want to have the ability to let user overwrite the values through UI, so the app would not overwrite them. This is similar to the Tax software, where you can overwrite almost anything. What is the best design for this Thanks in advance. Regards, Q One way to do that is not to store the generatable fields and generate them when needed (e.g. for display). Only stor ...Show All
SQL Server group data by weeks
I have data entered into a table using a datetime field. How can I group the data one week at a time and show mulitple weeks at a time Well, try this. select repname, weekend, sum(Product1Col), sum(Product2Col), sum(Product3Col), sum(Product4Col) from ( select [repname], 'weekend' = case datepart("dw",[YourDateField]) when 1 then dateadd("dd",6,[YourDateField]) when 2 then dateadd("dd",5,[YourDateField]) when 3 then dateadd("dd",4,[YourDateField]) when 4 then dateadd("dd",3,[YourDateField]) when 5 then dateadd("dd",2,[YourDateField]) when 6 then dateadd("dd",1,[YourDateField]) &nb ...Show All
.NET Development Add server-side code at runtime
I am building an application that is totally data driven. The pages are built from scratch at runtime.I have everything working fine. Now all I need to do is to have the ability to add code both server-side and client-side at runtime. I think I have pretttty much figured out the client side part. My problem is the servre-side code. How do i inject and/or run server-side code (from the database) at runtime I guess you must be more specific in your question if you expect an answer. It is not clear what you are trying to achieve. ...Show All
Visual Studio Team System Looking for documentation about build targets
Hey I'm trying to find some documentation on the different build targets. Mainly I'm trying to figure out what attributes they have and what they are used for. ex: how to use the "Label" attribute, what's the difference between "CoreCompile" and "Compile", etc. Any help would be appreciated. Hi David, Please take a look at: http://msdn2.microsoft.com/en-us/library/aa337655(VS.80).aspx Hope that helps, Swaha ...Show All
Visual C# Method Description
Hi i was wondering how to create a method on my class so when u call it u can see a brief description of what that method do. for example when u call System.Console.WriteLine u can see that it say "Writes the representation of the array objects........................" and after that also say what expcetions could be thrown by calling this method,, and i was wondering how to add this description and alos how to add the exception list.. i allready tried the System.ComponentModel.Description and put it right before the method, but no results.. mig16 Perhaps XML Documentation Comments is what you are looking for http://msdn2.microsoft.com/en-us/library/b2s063f7.aspx ...Show All
Visual Studio Tools for Office Question re the SetCurrentFormPage() method
i have developed a VSTO solution with a custom ribbon. when i am clicking the 2 buttons on my ribbon i am successfully swapping the form regions so it is acting like pages. however, as soon as i input some text into one of my form region then when i next click the button it does not swap the form region like before. can anybody help me understand what is going wrong here below is my handler code: public void ShowRegion1(Office. IRibbonControl control, bool isPressed) { Outlook. Inspector inspector = (Outlook. Inspector )control.Context; inspector.SetCurrentFormPage( "MyFormRegion1" ); } public void ShowRegion2(Office. IRibbonControl control, bool isPressed) { Outlook. Inspector inspector = (O ...Show All
Software Development for Windows Vista Workflow runtime hosting questions
We're interested hosting a single workflow runtime to manage all our workflow instances. These workflow instances are mostly human user approval processes that could span days. The primary method GUI for approving/rejecting will be through a web application. If I implement my workflow runtime in a Window Service how difficult would it be to access the runtime instance. Can the workflow runtime be remoted by a web app or web service I have looked at implementing a workflow as a web service but they seem better suited for short-lived sequential workflows. I'm curious how SharePoint v3 implements the workflow runtime. I read that they use a specially tailored web service to broker the workflow runtime calls but I am not sure where the runtim ...Show All
Visual Studio Express Editions Changing The state of a Row or Column or Cell Programmatically in a DataGridView
Hi I Want to change the state of the a Cell or row or Column. For example i want to set the state to frozen to 2 or three columns ( the first columns) . The State property is readOnly. In the documentation I found the following description in the remarks section of DataGridViewElementStates Enumeration: "Although these different states, like Frozen, are enforced by the UI, they can be programmatically overruled." The question is How Hi, RafaBotero this.grid.Columns[0].State is used to g et the user interface (UI) state of the element.But not to set. And if you want to set its ReadOnly and Frozen property, you'd do like this: this.grid.Columns[0].ReadOnly = true; this.grid.columns[0].Frozen ...Show All
Windows Forms binding problem to classes and stored procedues
hi i have a stored procedure in my db that returns me a sql select command. i use this command to fill a table class as below. now i have a class that i want to map to each field of this datatable. how do i go about or am i going the wrong way i could basically have a list of detailedbills(see detailed bills) on next post now. which i will bind to a manager. but how i map these two Imports System.Data.SqlClient Public Class bills Inherits DataTable Private Sub FillBill() Dim myConnection As New SqlConnection( My .Settings.CostingConnectionString) Dim myCommand As New SqlCommand( "DetailedBill" , myConnection) myCommand.CommandType = CommandType.StoredProcedure myConnection.Op ...Show All
Smart Device Development How to use a context menu on DataGrid?? Can't get row.
If you hold-click on a Data Grid to pop-up the Context menu you're obviously wanting options based on the item that was clicked on. I've found no way what-so-ever to determine what row was clicked on since the Mouse Down event doesn't fire on a hold-click. How in the world can you do provide Context specific menus on a Data Grid Something simple like Delete Row in a context menu. Well, the problem is that the Context Menu Item that is clicked on might not be over the Row that initially launched the Context Menu. For instance, using HitTest with Control.MousePosition with a Context Menu that has several items in it will not return the correct row for any but the first (likely). The menu event is fired when ...Show All
Visual Studio Team System Using AssemblyMajorVersion to update AssemblyInfo in Team build
Hi, Haivng used the build script according to http://blogs.msdn.com/gautamg/archive/2006/01/04/509146.aspx , I find that the AssemblyMajorVersion is not updated for the binaries that are compiled. Anybody else who is having the same issue If you know, how to resolve this issue, can you please help me. Thanks Ill try that. Why does this not grab all files with AssemblyInfoFiles within the level < CreateItem Include = " $(SolutionRoot)\*\*\*\*\AssemblyInfo.cs " > < Output ItemName = " AssemblyInfoFiles " TaskParameter = " Include " /> </ CreateItem > It only grabs one when there are about 15 in different directories. How do I get 135 files to be placed ...Show All
Visual C# Opening Password protected PDF files using a password list
The Scenario: I have a list of possible passwords and lots of protected pdf files. I need to use the passwords to open the files and then save an un protected version in a different directory. Is this possible in .NET If so any help or code would be greatly appreciated! Thanks ...Show All
