Jimmy Blanquet's Q&A profile

• SQL Server Management Studio - Error when trying to delete rows

  Hi, I recently migrated my SQL Server 2000 database to SQL Server 2005 and when I try to delete rows from some of my tables I receive the following error: Data has changed since the Results pane was last retrieved. Do you want to save your changes now (Optimistic Concurrency Control Error) This is not the case - the data has certainly not changed. After some investigation, it turns out that this only happens for certain rows in the table. Also, I can delete the row by using MS Access or Enterprise Manager. The problem only occurs with Management Studio. One of the tables in question is used to log Exceptions thrown by an ASP.NET 2.0 website ...Show All

• Visual Studio Team System DoNotCastUnnecessarily: Release vs Debug

  When I compare the outputs of FxCop for my assemblies in Debug and Release build modes, the results are very different. The Debug report shows 233 more issues that are all related to "DoNotCastUnnecessarily" messages. Is the compiler optimizing things for a release build and that's why I don't see the messages in my Release report That's interesting (and worrying) that the optimizations are disabled if you enable the pdbs. In all my 3 years of using .NET/Visual Studio .NET I never realized that. It's going to have to be something I look at when I get into work today and will probably mean that I w ...Show All

• Visual Studio 2008 (Pre-release) Focused control

  Hi How can I find currently focused control Best regards, Thomas Andersen Keyboard::FocusedElement HTH, Drew ...Show All

• Software Development for Windows Vista Custom Sql Persistence

  Hi, I need to store the state of the workflowInstance in sql db. Apart from that, I need to store UserId, taskID, etc., in the database. As per the sql schema that comes with WF [sql scripts] does not support. So, I need use my own custom sql persistence. Kindly let me know, if someone has solution for this, please share with me. Thanks in advance, chandru. Chandru - you want to look at tracking for storing data other than the persisted workflow. Workflow Persistence is really for robustness (saving the last known good state to start the workflow again in case of a exception) and loa ...Show All

• SQL Server Using SQL Profiler to trace sp_executesql statement

  I have a SQL Profiler question that I can't find answer anywhere: for the following SQL statement, is there anyway to find the actual SQL for @SQL , its CPU usage and Duration using SQL Profiler without changing the code EXEC sp_executesql @SQL, N'@EvalID int, @Return_Value bit OUTPUT', @EvalID=@EvalID, @Return_Value=@Return_Value OUTPUT Thanks in advance. Thank you very much, Simon. I believe that I did get the dynamic SQL when I captured SP:StmtComplete event, however the duration and CPU for that dynamice SQL SP:StmtComplete are all 0s -- that is why I "believe" that I got it. The dynamic SQL is like: set @ ...Show All

• Windows Forms Inserting Data to Word 2002

  Any one know how to insert particular words to a word document from an sql database   DoEvents   SendKeys ",~~"   ActiveDocument.MailMerge.OpenDataSource Name:=""   ActiveDocument.MailMerge.ViewMailMergeFieldCodes = False   I am trying find the path of a sqldatabase but every path name i give it seems to not be recongnized by the VBA in my ms word document.....I want my ms word document to pull data from a sql server db and help ...Show All

• Windows Forms Changing a property of a dynamically added control

  Hi, I hope you can help me with this. I don't seem to be able to change the ".image" property of a dynamically added PictureBox. How do I refer to the "myPicture" PictureBox within a Module Private Sub MainForm_Load( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Load Dim  myPicture As New PictureBox() myPicture.Image = My .Resources.Picture myPicture.Size = New Size(10, 10) myPicture.Location= New Point(30, 30) Me .Controls.Add(myPicture) End Sub Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click    C ...Show All

• Visual C++ I need some help

  I have Visual C++ 6.0 and i knw how to program in C++ but i dont know where to go from here. Could anyone point me into the right direction Since you are just starting to use VC++ 6.0, I would recommend using VC8.0 (you can install the Express sku for free from http://lab.msdn.microsoft.com/express/visualc/default.aspx . You just need to read a little bit in the help ( http://msdn.microsoft.com/  or http://msdn2.microsoft.com/ ) on how to create projects and what type of projects VC8.0 offers. After you start using VC8.0 and you still have some issues or questions, please feel free to post at this forum. Thanks,   Ayman Shoukr ...Show All

• .NET Development how to refusal from different site request data?

  Asked how refuses to come from the different stand request My meaning is wants to refuse other websites to transmit to my website data In other words, actually the website or other regions to mine website transmission data, my website refuse to accept and to process, asked how establishes like example: allow: http://www.myWebSite.com/a.aspx send to http://www.myWebSite.com/b.aspx http://www.myWebSite.com/c.aspx send to http://www.myWebSite.com/b.aspx b.aspx allow request current send data disabled: http://www.mysadfsdfaWefsafsdabSfsdite.com/ send data to http://www.myWebSite.com/b.aspx http://www.otherWebSite.com/ sen ...Show All

• Visual Studio 2008 (Pre-release) Max()

  How to return a Max(seq) while also using a join in DLinq Here is the tsql: SELECT MAX(Messages.ID) AS MaxSeq FROM Logs INNER JOIN Messages ON Logs.LogID = Messages.LogID WHERE (Logs.LogName = N'log1') This is easy to do, but does not look like SQL. using query comprehension syntax: from log in db.Logs select ( from message in db.Messages where log.LogID == message.LogID select message ).Max(m => m.ID); using query operators: db.Logs.Select(log => db.Messages .Where(message => log.LogID == message.LogID) .Max(m => m.ID) ); The difference between C# LINQ and SQL is that aggregat ...Show All

• Visual C++ Japanese Application

  Hi I developed an Jananese application in MFC (VS 7.2). When i run this application in Japanese Windows its working fine, if i run in other then japanese it display charactors. How can i solve this problem Manoj Jangid I haven’t really tried this stuff but the subject "Languages, Locales, and Keyboard Layouts" might help: http://msdn.microsoft.com/library/default.asp url=/library/en-us/winui/winui/windowsuserinterface/userinput/keyboardinput/aboutkeyboardinput.asp There are other subjects that you might need to look up like "globalization" and "localization". ...Show All

• Visual Basic TextBox BackColor change OnFocus and LostFocus

  Hello, Is it possible to extend the TextBox class to include an event where the TextBox changes it's background color on focus and returns it to the default on lost focus Kind regards, Hello, Appreciate your answer. It works perfectly. Would the same solution apply with a form that has, say ten TextBoxes- I mean, repeating the same code for each one of the TextBoxes (TextBox1,....2,...3. etc) Kind regards, -------------------------------------------------------------------------------------------------------------------------- This newbie can't talk and can't walk. Embarrassing. ...Show All

• Visual FoxPro records disappear forom tables

  A few days ago I ran into yet another problem with Fox. i have a database where the tables were supposed to be filled with the content of some text files. Those files are dumps of my old dBase tables. I have a routine in Fox code that reads the text file, generates necessary number of records and fills the fields with the content between some delimiters in the text file. Anyway, it is not the first time I do it with almost the same code. I transferred a dozen tables this way a few months ago, then got distracted by other necessities. I resumed the transfer two weeks ago creating 12 Fox tables and dumping the content of 12 dBase tables int ...Show All

• Visual C++ C Program. Desperately seeking help.

  This is a C program. In the program, I open the letter_u.ic, then zoom it twice. Then I'm suppose to save it into a packed file. The thing is I can't get it to save properly into an array and when it's opened, the letter icon comes out garbage. Also could someone tell me how I could create a new icon by manually drawing I am suppose to draw a 8 by 5 arrow icon. Can someone please help me And if can do some explanation Really appreciate any help. Thanks in advance. ============================================================== #include <stdio.h> #include <stdbool.h> #define MAXSIZE  512   /* the size limit f ...Show All

• Visual Studio Team System rule to check does every control statements have body.

  hi, i need to write a rule to check does control statements such if,for and while has body i also need to check do all switch statements have default Plz help me writing these rules. Thanks in advance... Hi Guns, if,for and while statements are all higher level constructs that get compiled away. In IL you'll only be able to find branch & jump statements. As said in my other post, you'll need dataflow to really detect loops well and then you won't be able to see if it was a for, foreach, while or do while loop as that information is just not available in IL. Regards, Jeffrey ...Show All