prujohn's Q&A profile

• Windows Forms DataGridView Seek

  Hi, Is some way that I can make a search in a datagridview not whit Loops (For, while). I remember that the datagrid in VB 6 has a Find or Seek method that does this. I don’t remember the correct syntax but it was something like this: DataGrid1.Seek = “field LIKE ‘” & textbox1.text & “%’” Datagridview has that method or is some way that i can do this In this case I'm not sure. I understand you want to highlight the rows perhaps - this can be done using the Rows[] property of the datagridview, and setting the "Selected" value to true to highlight that row. The query above as said will show you all the matches found in the criteria and will only show ...Show All

• Smart Device Development DataBinding - OnValidation - Failure to fire - Not Firing - Bug? - Incorrect Usage?

  Hi all, Thanks for reading...   I've got a databound textbox which is bound to a property on a "business object". I've set the databinding mode to OnValidation (In the properties window (whilst my textbox is selected>>Expand '(Databindings)' node>>Select the sub-node '(Advanced)'>> click on the '...' button>>set Data Source Update Mode to 'OnValidation' - sorry if that looks like I'm teaching you how to suck eggs. :-) ). Ok. Now, I load the application, the form appears with the databound textbox empty (which is how it should be). I then enter "hello world" into the textbox, this then results in firing the events 'Validating' and 'Validated' (like I expect) - the databinding auto ...Show All

• SQL Server Autofilter Default in Exported Excel Reports?

  Hello, We are using SQL Server 2005 Reporting Services and mostly we deliver the reports through e-mail subscriptions as Excel documents. Is there a way to have the autofilter in Excel applied automatically I tried using the interactive sort on all the columns, but this does not seem to "transfer" in exported Excel documents. Has anyone tried this or been able to get this to work Thanks in advance. SHP ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. SpriteBatch and BlendModes

  When using SpriteBatch it seems to override any RenderState settings for SourceBlend and DestinationBlend. Is there a way to change these settings or is there another way to draw a texture using your own RenderState settings There are two I would like to use : graphics.GraphicsDevice. RenderState.AlphaBlendEnable = true ; graphics.GraphicsDevice .RenderState.SourceBlend = Blend .SourceAlpha; graphics.GraphicsDevice .RenderState.DestinationBlend = Blend .One; and graphics.GraphicsDevice.RenderState.AlphaBlendEnable = true ; graphics.GraphicsDevice .RenderState.SourceBlend = Blend .SourceAlpha; graphics.GraphicsDevice .RenderState.DestinationBlend = Blend . InverseSourceAlpha ; Cheers, Terry ...Show All

• Visual Studio Tools for Office MailMerge.CreateDataSource

  Is there anyway to get a Dataset or a DataTable as the source The header in any case would be > 255 characters. Is there another way to have <<variable>> fields populated without using MailMerge TIA Yes actually we can make word fool to overcome that problem. what we can do is if headerlength is greater then 255. then we will make it smaller so we will change all headers to "a0,a1,a2", so in this case we have 128 Merge Feilds as legth is only 2 per field. second thing we can do all things and then without saving the doc(dont save "a0,a1,...." like merge fields) close it. so we will delete all merge fields and temporary keep them into array (I mean array of Range). and generate new Me ...Show All

• SQL Server ACCESS2SQLSERVEREXPRESS

  Hello, First of all, please excuse my english... I'm french :-D Can someone give me a way to convert an Access2 DB to a SQL Server 2005 Express Is it possible Thanks, There is tool from Microsoft to convert Access Database into SQL Server 2005 database. I have no link for it. You can search it from Microsoft's website. ...Show All

• Visual Studio Team System Adding multiple <readonly> rules to a field.

  Hello, I am trying to make the Triage field read only for multiple groups, but I always get this error when importing the workitem to TFS. Error: TF26049: The field 'Triage' has rules ' < READONLY for = " [GLOBAL]\team_1stTeam " /> ' and ' < READONLY for = " [GLOBAL]\team_2ndTeam " /> ' that are inconsistent. Is there any way to do that Note that I am dealing with more that 5 teams so using 'not' qualifier would not work since I want more than one team to be able to edit this field. Thank you. Hi Hisham, Unfortunately this is a limitation in V1, that you can only scope a field rule to one group, and adding the same field rule multiple times with dif ...Show All

• SQL Server How do you store results from a system stored proce?

  Does anyone know how to store the results from a system stored procedure Both of the samples below don't work. Any suggestions SELECT * INTO tbl_My_Table FROM sp_Any_General_MS_Stored_Procedure SELECT * INTO tbl_My_Table FROM EXEC(sp_Any_General_MS_Stored_Procedure) Louie: Your "catching" table needs to be matched in structure to the intended stored procedure, but you can do: insert into tbl_my_table exec sp_proc_with_matching_structure Dave ...Show All

• Visual Studio Team System Best Practice for Adding a NOT NULL Column

  What's the recommended process for adding a NOT NULL column on an existing table controlled by Database Professional This may seem like a no brainer by editing the table script but follow the process all the way from the time the developer modifies the table script AND uses Write Updates to update the a schema. The Write Updates button will fail because the NOT NULL column cannot be inserted without a default value when the table already has data in it. Do we really have to put a bogus default value just to get the column added We ended up putting a bogus default value so Database Professional could apply updates as it normally does and we could create a SQL script for our DBA to apply the updates to other databases. We then coded a ...Show All

• Visual Studio Team System Moving Workspace in Team Foundation ( Web Site Project )

  I am struggling to solve the following problem with no success yet. I had 1 VSTF Solution file + 1 Web Site Project + 1 DLL Project + ... I moved files and directories between projects. [Checked in] --> Worked fine I removed all local files from C: and removed workspace reference from VSTF IDE. ( Completely cleared up) I re-created workspace in disk D: and retreived all project files from VSTF. Then I was getting some of the warnings like "Some of the properties associated with the solution could not be read." But bad enough, original web site project became a goner from solution explore and a bogus empty web project popped up ! ( "MyWebSite" --> "MyWebSite_1&qu ...Show All

• Visual C++ STL iterators in VC++ 8.0

  I am trying to port an application from VC++ 6.0 to VC++ 8.0 (VS 2005) and i am facing a problem with stl iterators. The code that gives the problem is ... void SomeFunction() { set<int*> mySet; ---------Added some items into the set setMibt*>::iterator myIterator; myIterator = NULL; //This line gives the problem saying no operator = is overloaded ------------//Some more tasks } The iterator is no longer a pointer i guess but now how should i check the validity of the iterator before deletion or some other functionality. For example.. this also now gives an error if( myIterator != NULL) //This lines also give an error... What should i do to check this { //Free resources... } So now how to check the valid ...Show All

• Smart Device Development Removing PDA's proxy settings programatically

  Good morning. In my company's project (CF1.0 , WM5.0, VS2003) , we run our app both in the cradle and out of it. When in the cradle, it automatically picks up the proxy server we use for internet access. When we take it out of the cradle, those settings remain and the app obviously can't access the web service on the net because it's trying to use a 192.168.X.X proxy address. At the moment we just go in and disable the proxy whenever we take it out of the cradle - which obviously isn't an option when the app goes into production useage and we give it to our techs. Is there a way to disable it via code (perhaps native API ) I've seen on MSDN the HttpWebRequest.Proxy Property but I couldn't see how to apply this to invoking a standard web ...Show All

• SharePoint Products and Technologies How to register an event handler declaratively by content type?

  Hi. everyone. I'd like to register an event handler declaretively by content type. According to a paragraph of   this article , it seems to be possible, but i don't know how to do this. 　Declaratively by content type, for example, to register an event handler for all documents of a specific type. Within the XML for a content type definition, you can register event receivers. I created two content type named ct_a, ct_b, and I derived them from document content type. ct_a and ct_b had a event handler respectively and  were associated with a list named list_a. What i want to know are how to associate a event hander with a content type and how to activate them. Thanks for in advance.   ...Show All

• Visual Studio 2008 (Pre-release) Programmatic Mex Binding

  Is it possible to expose a Mex binding programmatically In order to enable Mex the only way I can see is to use Config file settings and while this works in most siutations I have an Interop Scenario where using Config files is quite a bit of a pain. Is there a way to have a host expose these endpoints I can't seem to find the Binding class to use. Also, in this same interop app I can't seem to get Mex to work even with the .Config file. < xml version = " 1.0 " encoding = " utf-8 " > < configuration > < system.serviceModel > < services > < service behaviorConfiguration = " WcfFoxServiceBehaviors " name = " WcfFoxServ ...Show All

• Visual Studio Team System How to distinguish between a hardcoded string literal and a public const string ??

  Hi! I was wondering, if there is a possibility for fxcop to distinguish between string literals hardcoded in the program sources, and a public const string members From what I noticed, running fxcop on a dll in my project, with a rule that searches string literals, showed a large number of const strings used as well as hardcoded literals. While the latter case is unwanted, and thus a welcome result of the rule, the former is what we are expecting in the project. For performance reasons, thera are places in the code where consts are used rather than static readonly strings, and the former are substituted during compilation, which results in fxcop seeing them as string literals. Does anyone have an idea how to address this issue Thanks, Krz ...Show All