Bigmo's Q&A profile

• Windows Forms Stop selecting in Datagridview

  Facing a problem and not sure it can be solve or not. And my english is a bit weak, hope you still able to understand what i am trying to tell. In my program there are 2 main portion, left part is a treeview, right part is a datagridview. I want to implement drag and drop from datagridview's row(s). When you mouse down(left button) on datagridview, and move the mouse towards down the screen, it will select multiple rows for you, this is correct and I want it remains, but I want it to stop selecting if I drag my mouse towards left into the treeview, I will code the drag and drop operation in the treeview, but the problem is how do I code to stop the datagridview selecting mode Any response is welcome, thanks in advance. ...Show All

• Visual Basic ActiveX Control

  I have a problem on using ActiveX controls that I have been struggling with for quite sometime and just see no way out. Your help is much appreciated. I am trying to use ActiveX from my VB application to connect to the external application which does support ActiveX controls. This external application has provided a library of ActiveX events and methods for this purpose. In my VB application, I have included this under the 'Components' of the tool box as "TWS Control". I include the 'TWS Control' in my VB's custom-built window. The window contins details to seek connection with the external application. In my VB application, I declare the ActiveX library, at the beginning of the code, using ...Show All

• SQL Server Splitting Data in two columns

  Hi, I am working on SQL Server Reporting Services, and I want to fit a long column on one page by splitting the data in two columns side by side so that I can make more use of my space. How can I do it, please help... Thanks, -Rohit What i understood is you had a long columna and you want to split that into two columns. You can do these in backend . In the backend query itself you can divided the column into two columns by using substring function. or In reporting serbvices you can use instr function in expression to get two column with start and end position. ...Show All

• .NET Development ADO.NET Problems

  A small problem, this code fragment doesnt work /// <summary> /// Changes a user's details /// </summary> /// <param name="username">The user to change</param> /// <param name="newUsername">The new username for the user</param> /// <param name="newPassword">The new password for the user</param> public void ChangeUser(string username, string newUsername, string newPassword) { //Create a new command component OleDbCommand SQL = new OleDbCommand(); SQL.Connection = conn; SQL.CommandText = @"UPDATE Clients SET Username = @newUser, Password = @newPassword WHERE Username = @currentUser"; OleDbParameter newUserP = new OleDbParameter(); newUserP.Value = ...Show All

• Windows Forms Deploying a C#.NET WinForm Application with SQLSERVER 2005 Express Edition

  Hi everybody; I'm developing a small business software for my uncle and it is using SQL Server 2005 Express Edition for database and related services. But i need a solution that deploys both WinApp and SQL Server 2005 database engine (it may be full package) and attach the required database files (mdf and ldf). Is this possible If it's possible how can i achieve it with minimal work If i have some duties i'm ready to handle it but i need a way. Please help me! Well i have'nt looked yet. But does this method helps to attach the database. I have produced lots of setup projects up to now but i only have included the Crystal Reports merge modules. Assume that i set the SQL Server prerequisite true, does the setup system analys ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. .swm

  These files are very simple in structure, and it wouldnt be hard to write a converter. Heres how it goes: {       String version (i.e "1.0.0.0")       String originalFile (i.e "E:\dev\xna\source\starterkits\SpaceWar\media\projectiles\pea_proj.x")       Int32 triangleCount       Int32 vertexStride       Int32 vertexStart       Int32 vertexCount       Int32 batchCount             (for each batch)             {   &nbs ...Show All

• Visual Studio Express Editions Can't download from microsoft also

  I ve been having a similar challenge. I can not download from microsoft. I have comcast and have spoke with them they say they are not blocking my modem and that it is a microsoft problem. I have three PC's in my home and none of them can download from microsoft. They all have valid windows XP installed. I am able to get auto updates, and when XP is reinstalled onto my pc its goes through the validation just fine. I get a can not display the webpage every time i try and download something. I am not able to even open the validation link pages to run the validation checker tool. I have XP pro and Explorer 7 which i have made sure that all the active X options are enablesd and that the enable third party extentions in the ad ...Show All

• Visual Studio Install VS.Net 2002 on WinXP - VS Installer Launches Installation of Dell Modem on Hold in Spanish!!

  This is very, very weird. I had VS.Net 2002 installed on Win2K, which crashed on Windows Auto Update, couldn't recover it. So I installed WinXP SP2 from scratch on new drive partition. Was able to re-install VS-97, VS-6 with no problem. On re-installing VS.Net 2002, I was prompted to install Windows components, plus security updates, IIS, FrontPage extensions, etc. I could not get the Windows Components installation CD to launch from the VS.Net installation window, so instead of select components, I installed all components on the Windows Components CD. That seemed to satisfy the pre-req, so I was able to launch the VS.Net installation--I THOUGHT--BUT WHAT HAPPENED WAS VERY WEIRD--instead of installing VS.Net 2002, the installer launch ...Show All

• SQL Server Restoring SQL2000 after upgrade

  I performed an in-place upgrade of my SQL2000 database to SQL2005. I am having too many problems at the moment with compatability issues between SQL 2005 and VS2003 and need to roll back SQL 9.0 to 8.0. Are there any white papers, or published procedures for doing this I have a tape backup of the 2000 system, but there have been various updates to the databases during the past 3 weeks since the upgrade. The structure of the databases have not changed. Please help! There is no vehicle to rollback. You will want to reinstall sql2k as a different instance, restore data from your tape backup and then use data import/export to update sql2k data with sql2k5 data. If you're looking for a way to mount a sq ...Show All

• SQL Server Restart required after setting 'clr enabled' = 1?

  Is a restart of SQL Server required after changing the 'clr enabled' setting The SQL documentation clearly states that a restart of SQL Server is not required: The clr enabled option is an advanced option. If you use the sp_configure system stored procedure to change the setting, you can change clr enabled only if show advanced options is set to 1. The setting takes effect immediately after sp_configure is run. No restart of the SQL Server instance is required . I've seen updated documentation where it points out that this setting is not really an advanced setting, so, there is one error that was corrected. Also, the documentation seems to imply that RECONFIGURE is not needed. Although, after you run EXEC sp_configure 'clr enab ...Show All

• SQL Server XML Source into Recordset ( ADO Enumerator )

  In "Data Flow", I am attempting to use "XML Source" to read a XML document into a recordset and in "Control Flow", into a Foreach Loop Container ( foreach ADO enumerator ), where I map the attributes to DTS variables. SSIS allows you to specify the input columns by means of an index number. The problem is you don't know what index value to use for a particular input attribute. It does not seem to be in the same order as the what the XML input is. This is very troublesome. Ideally, you should be allowed to select the value based on attribute name. Has anyone seen this problem Any ideas Is there anyway in XSD to force the parser to return attributes in a specific order Thx. ...Show All

• Visual Studio Team System Where can I find some custom rules for FxCop?

  Hi, I would like to find out, where can I find a place where developers share their own custom rules for FxCop. Wojtek See the FAQ for locations of custom rules. ...Show All

• Visual Basic error. "Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key colum

  Hello im new to vb.net 2003 but have used vb 6 for years and dabbled with 2005. A program that would usually take me a few hours to make i am on day 5, 4 and a half of which have been trying different ways to get it to update, and not one of them will post the information back to the SQL 2000 database I am actually going insaine. Please Please can somebody help me!! The best i can get out of it is this error. " Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information " I have googled it and come up with the fact the primary key isnt set right, but i still cant get that to work. Here is the peices of code that are relevant. Dim strSQL As ...Show All

• Visual Studio Express Editions Image Conversion

  Hi Is there a way to convert a GIF, PNG or whatever to an icon (ICO). thanks. When you save an image to 'ICO' icon format in VB EE, it is actually saved in PNG format. (Which sucks.) Microsoft says: SYMPTOMS When you use the Image.Save method to save a graphic image as a Windows Metafile Format (WMF), Enhanced Metafile Format (EMF), or ICON file type, the resulting file is saved as a Portable Network Graphics (PNG) file instead. Back to the top CAUSE This behavior occurs because the GDI+ component of the .NET Framework does not have an encoder that allows you to save files as WMF, EMF, or ICON files. Back to the top STATUS This behavior is by desig ...Show All

• Visual C# ToolBoxBitmap not showing for custom control

  Hi, I have created a custom control called IFrame. When i complie i get the famous blue defualt gear icon on the toolbox. I then created a new project and added the DLL and i got the control to show up and of course with the default blue bitmap. Now the fun begins: I then went back to the my DLL project and i have tryed all the following permutations and i can't get the bitmap to show up. O yeah, i created a Bitmap called IFrame.bmp thru the VS 2005 IDE and made it 16x16 with 16 colors. Also made it embeded as well. Tryed: [ ToolboxBitmap ( typeof ( IFrame ), "IFrame.bmp" )] [ ToolboxBitmap ( typeof ( IFrame ), "IFrame" )] [ ToolboxBitmap ( typeof (MyNamespace. IFrame ), "IFrame.bmp" ...Show All