Francois Menard's Q&A profile
SQL Server How to set douplicate id in sql server 2005?
Hi There, Some one please help me to achieve this task. I have task to join 2 tables and insert values.The table which i am inserting values has typeid column which is primary key column.I supposed to insert values except this column(TypeId).When i m trying insert values its throw an error saying Error: Cannot insert the value NULL into column column does not allow nulls. INSERT fails. Please let me know ther is a way to set duplicate id for this rows Thanks in advance. See if this helps you. Take a look at my post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1211015&SiteID=1 ...Show All
Visual Basic Label Lext
i can't get te text in a label change. i'm using VS2005 and this code: myReader.Read() lblNombre.Text = myReader( "nombre" ).ToString MessageBox.Show(myReader( "nombre" ).ToString) myReader.Close() The message box displays the right information, but the text in the label doesn't. Ok, i put Me.Show() after i changed the value and it worked, but opened a new instance of the form, but i've solved that. thanks for the tip and ahmedilyas, intellisense didn't put the () so i'm guessing its also correct. And i'd tried both ways, with text in the labels and without text, but thank you anyways Thanks . . . ...Show All
Smart Device Development Is there any memory leak tool available?
Hello I'm currently using VLD (Visual Leak Detector) when doing mockup applications in win32. My problem is that I don't know of any tool I can use to find memory leaks for smartphone. Is there anything available Many thanks, Martin Malek Hello Sorry for not being clear from the start. I use unmanaged code and the examples in the article use .NET CF. Since it is not possible to mix unmanaged/managed code for smartphone I can't use the tools provided in the article. Is there any other way to do this Perhaps by using some C++ classes from the SDK or a tool written entirely in unmanaged code Many thanks, Martin Malek ...Show All
.NET Development TableAdapter InsertQuery and query builder unhelpful
Alright well I could write out some code create a generic Sqlconnection and command and execute an insert with execute scalar to return my identity or that returns my identity as an output parameter but why should I have to do that.. I'm using ADO.NET 2.0.. I want my table adapter to be smart in some way and give me the identity. I want to be able to do this using the built in tools like query builder. Should be easy right I'll specify an output parameter in my query with the nice query builder tool. And tell it to give me scope_identity(). No, there's no way to do that in the query builder.. it cannot parse any command like that. Hey maybe I'll add a new query to insert a row... and look at the code it generat ...Show All
Visual Studio Why So Many Unanswered Questions
If this forum a source of information and problem solving Does anyone from Microsoft monitor the posts in here Has Microsoft abandoned this forum I have never seen such a high percentage of unanswered questions. I like the report writer control. Have used it in many situations but I am at a loss to why there is such little feedback and question answering. Is there a better source for problem solving related to the report control I would love feedback from other frustrated individuals who also have attempted to use this forum as a source of knowledge and problem solving. I don't know why, but it does feel the support is lacking. Maybe this isn't a long term project for MicroSoft, they don't want ...Show All
.NET Development Streaming Sql Server Opening Connection
So im trying to figure out a way to streamline establishing a connection with a sql db. In other words I don't want my app to 'hang' while its attempting to connect because the db might not be online or the users computer is not properly connected. Either way I wouldn't want the app to hang. Any ideas doing any form of connection will result in a delay, especially databases since they are expensive to work with. you could spin up another thread to do your database work, which will prevent the main thread (UI) from being unresponsive. ...Show All
SQL Server AMO vs. ADOMD
I use AMO to programmatically create a complete database with datasource, datasourceview, dimensions, and cubes. I also have a webservice that uses ADOMD.NET to retrieve metadata about those objects (for security purposes and also for .NET 1.1 applications). However, I notice that using ADOMD's GetSchemaDataSet only return certain metadata. For example, for a dimension, it doesn't return the DimensionID or other properties I am able to set with AMO. I want to use ADOMD.NET because it returns the metadata in XML format already. With AMO, I have to serialize the dimension object. Is there any other way to retrieve additional metadata for AMO objects You can use "DISCOVER_XML_METADATA" with GetSche ...Show All
Windows Search Technologies WDS 3.0 and PDF iFilter
I have WDS 3.0, Adobe iFilter 6 (install file ifilter60.exe) and am unable to find pdf files when searching on text that is located in the body or in the properties of the pdf file. I am able to search on the file name. I have checked the advance options and pdf is listed and the radio button for properties and content is selected. I have verified that the text in the body of the pdf file is searchable when i have the pdf open. I am using Adobe Acrobat 7.0 Professional. My preview window in WDS is working on these files. Try using Adobe Reader 8.0: http://brandonlive.com/2006/12/10/index-pdf-files-in-wds-30-or-vista ...Show All
Customer Care Framework CCF - Adding and executing Actions on hosted applications
Hi, I have added an action "TestAction" to a hosted application "MyApplication" and want another hosted application "MyApplication2" to fire that action. Both these hosted applications are hosted controls. The action has been added in ContactCenterAIF.Action table. The initialization string is "<ActionInit><GetFocus>true</GetFocus></ActionInit>". From "MyApplication2", I call the following code, FireRequestAction(new RequestActionEventArgs("MyApplication","TestAction","<GetFocus>true</GetFocus>"); When the above code is executed, focus is shifted to "MyApplication", however the handler DoActi ...Show All
Windows Forms NotifyIcon and fileSystemWatcher issue
Greetings, I am writing a fairly simple app that uses a NotifyIcon and a FileSystemWatcher. The idea behind this is to alert users who share a resource to that resource's status. We have about 15 users who utilize this resource but only one can use it at a time. I want to use the NotifyIcon to display the status of the resource (in use or available). A user selects an option from the NotifyIcon menu (logging in or logging out) which updates a central xml file. The FileSystemMonitor monitors the xml file for changes and triggers an update to occure for each NotifyIcon running changing the Icon image and popping up an message bubble to the user. The problem: This all works as expected of only 1-4 instances are monitoring the XML file. But if ...Show All
Visual Studio Tools for Office CommandBarButton Click event is not raised
Hi, I have several buttons in a toolbar in an Outlook Addin. All buttons are members of the class (The instance of the class), so the garbae collector does not collect them, and they are kept referenced. When clicking them, they work fine. The problem is when the toolbar is wider than the window, so some buttons are hidden. When i click the button, it does not raise the event, but only replaces it with a button that is not hidden. When clicking it again (after unhiding it) it raises the event. Any help Adrian Trying to recreate this issue in Word (since I already had a C# Word proto-type app ready to go) So, I added a CommandBarButton to an existing CommandBar and cannot ge ...Show All
Windows Forms FileInfo
hello i have a windows form applicaiton and i have created a timer to check somethings in every 60 seconds.. now what i want to ask is that i want my timer to look at the last write time of a specific file and if it has changed perform some action.. to do this i have created a FileInfo object named myfile and two DateTime objects time1 - for the first time the application will determine as the last write time- and time2 that will change in every tick of the timer as the last write time of myfile . to perform these private void Form1_Load( object sender, EventArgs e) { time1 = myfile.LastWriteTimeUtc; MessageBox .Show( Convert .ToString(time1)); System.Threading. Thread .Sleep(15000); } in these 1 ...Show All
Visual Studio 2008 (Pre-release) ListView with ContextMenu
Hello, I have a Problem to determine the ColumnHeader over which a Contextmenu opened : I have a ListView and the View is set to a Grid View. To the GridViewHeader a ContextMenu is attached: ... < Grid Name = " gv " > < ListView Name = " lv " Margin = " 0,0,0,0 " HorizontalAlignment = " Stretch " VerticalAlignment = " Stretch " GridViewColumnHeader.ContextMenuOpening = " OnContextMenuOpening " > < ListView.View > < GridView ColumnHeaderContextMenu = " {StaticResource GridContextMenu} " > ... In the Codebehind I have the following Handler: void OnContextMenuOpening( object sender, ContextMenuEventArgs e ...Show All
Game Technologies: DirectX, XNA, XACT, etc. ID3DX10Mesh setting an undefined IA topology randomly at start of app.
Morning all, I've been observing some strange behaviour that appears to trace back to ID3DX10Mesh, the fact it's randomly reproducible is worrying me a bit... There is no obvious visual errors - I get the image rendered exactly as I expected it to be. I'm rendering the Stanford Bunny (note: large mesh = 32bit IB & lots of data) and for one or more initial frames the DrawSubset() call triggers: IASetPrimitiveTopology: Topology value D3D10_PRIMITIVE_TOPOLOGY_UNDEFINED is OK to set during IASetPrimitiveTopology; but will not be valid for any Draw routine. < STATE_SETTING INFO #237: DEVICE_IASETPRIMITIVETOPOLOGY_TOPOLOGY_UNDEFINED > I can be lucky and have it only emit that for the first frame, more often ...Show All
SQL Server Grouping question
I know I'm overlooking something obvious, but I can't seem to find direct help on this in BOL. This should be simple so please forgive my ignorance for not being able to figure this out on my own. Ok, I have a table that is updated with multiple rows tied to a userid. I want to select out distinct user ids and the max timestamp on any row containing that userid. I cannot seem to get that result set and it's driving me nuts. e.g. source table: Userid LastModified --------------------------------- user1 1/1/07 user2 1/1/07 user1 1/2/07 user2 1/3/07 Here's the result set I want to select out that for some reason is eluding me: Userid LastModified ------------------------------- user1 1/2/07 user2 1 ...Show All
