RolandLee's Q&A profile

• Visual Studio Yellow Arrows??

  I seem to be having a very basic yet confusing dilema. For some reason when I debug the program just runs through and no yellow arrows come up at all. It's as if I ran the program. I tried using breakpoints but there is no effect. Is there any answers for this That happen when the debugger has no sufficient information to run trace to your procedure. My guess is, probably you're debugging something that's turned off, like ASP.NET, or something else. If so, check your project's settings, under Debugging tab, select which debugging options should be turned on. Regards, -chris ...Show All

• SQL Server How to achieve rowid of Oracle in SQL Server?

  Any suggessions If you have a suitable single column primary key in a table then you can use it instead of rowid. Otherwise consider adding a column to the table with the IDENTITY property. This is from Books Online IDENTITY Indicates that the new column is an identity column. When a new row is added to the table, the Database Engine provides a unique, incremental value for the column. Identity columns are typically used with PRIMARY KEY constraints to serve as the unique row identifier for the table. The IDENTITY property can be assigned to tinyint , smallint , int , bigint , decimal(p,0) , or numeric(p,0) columns. Only on ...Show All

• Visual Studio Express Editions OpenFileDialog example not working - but why?

  Hi Wonder if anyone can help out Copied directly from system help on OpenFileDialog -> FileNames. Started with blank form1, and as per example setup instructions, added button named filebutton, picturebox named picturebox1, and created form load with InitializePictureBox() InitializeOpenFileDialog() When I run the Application, and step through the Sub OpenFileDialog1_FileOk routine, I can see the 'file' variable is holding the proper data for the file(s) that were selected, but when it gets to the PictureBox1.Image = System.Drawing.Image.FromStream(fileStream) Application.DoEvents() then nothing is displayed in th ...Show All

• Windows Forms Expand and display the child table on same screen

  Hi!  I want to expand and dispaly the child records on the same screen while displaying parent records. just like normal Master/Child detailed grids.            Can any one help regarding this Component one has a nice grid that does this. it's called truegrid www.componentone.com Now the other ways to do this would be to cr ...Show All

• Visual Studio How can I change the background color of the code window using an add-in?

  Hello, I need to write add-in thats changes code background in code window. Is there any samples how to do this I will very glad if somebody help me to do this. Thank you. Hi, Aaron. Yes. I mean highlighting. User selects text and this text changes background. This background saves after selecting another fragment. Can VSIP help with this problem. Thank you. ...Show All

• SQL Server Move table

  How can i move tables from one database to another without losing any of the PK, FK or the identity column constraints I currently use wizard and thought maybe you can do this with some Tsql code... Is it possible Thanks for any help You can do the following in TSQL: 1. Use SELECT INTO to create the tables with data (identity property of column will be copied over including the NULLability constraints) 2. Add the constraints using metadata from INFORMATION_SCHEMA.TABLE_CONSTRAINTS, CHECK_CONSTRAINTS etc. 3. Create defaults, computed columns using syscomments information In SQL ...Show All

• Visual C# session and cookie in asp.net

  I want example simple about session and example simple about cookie and project simple explain more basic that use in asp.net ; thank you Hi! You can't get much help with such questions, because the answer will be very, very, very long. Ask more specific questions. If you do not know anything about ASP.NET - you need to get some book and read it first. For simple example - create new empty project. This is simple and easy example. ...Show All

• Visual Basic programmatically round corners in excel chart

  Im looking too programmatically round the corners of an excel chart using VB8.   Manually its located in the format chart area, under the patters tab there is a round corners check box right under the shadow box. In intellisense I did find the shadow option With chart .ChartArea.Shadow = True end with but I dont see the round corners option and havent seen any examples of anyone doing it online. Any help you could provide would be much appreciated. Thank you, Hi, Ryedunn, You might want to check the Visual Studio Tools for Office forum. (For my part, I’ve not done much programming on Excel objects except t ...Show All

• Windows Forms combobox.selectedvalue

  i have a combobox name: useridcombobox displaymember: username valuemember: userid i want to save it to the database using Insert command. I've tried (int)useridcombobox.SelectedValue but it didn't work. How can i get the userid integer value You will need to give more information. How did you attempt to get the value, how did you attempt to insert it into your database, and in what way did it not work ...Show All

• Visual FoxPro Need help Database trigger

  Hi    I have been tasked to convert an old Clipper app to Foxpro Ver 9.0. The old software has 2 fields in all the databases one called ChangedOn and one called DeletedOn. These fields hold the date,time,computer name, and login name of the machine and user. These fields were updated anytime a record was changed or marked for deletion.   I would like to use the database triggers to update these fields because of the numerous places in the app that modify or delete records. I have created a procedure to modify this field in the record but I get an error that the cursor is read only. I am not sure what I am doing wrong. I would ...Show All

• Visual Studio Express Editions Modify Datebase Records

  Hi all: I'm trying to modify my database with a small VB Express application.  I could add new records but not modify existing records.  The error message was (the error pointer was on the "Update" statement):  "Update requires a valid UpdateCommand when passed DataRow collection with modified rows."  The following is my code.  It was generated automatically when I drag the dataset grid view to my form.  Private Sub TblPumpBindingNavigatorSaveItem_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TblPumpBindingNavigatorSaveItem.Click Me .Validate() Me .TblPumpBindingSour ...Show All

• Visual C# Accessability of other projects

  hi all, i have a problem: in vs 2005 i have a solution which contains two projects (winfx and workflow). i can only set a reference from project a to project b, but not back from b to a. so i have the problem, that i am able to use the classes and methods of project b (there is a reference of b in project a), but cannot use the classes and methods from a in project b - but i need to...how can i do that would anybody be able and so kind to help me out thanks in advance. regards, .k If you were allowed to have A reference B and B reference A then a circular dependency would occur. You ...Show All

• Visual Studio Step over (F10) responds slowly

  Hi, I have start using VS 2005 this week and i notice that when i am using the step over while debuging it is response very slowly compered to VS -6. I notice that the call stack and Autos windows also addes to the poor performance, and each step the auto windows refresh. 10xs alon The autos window has always refreshed on every step, and performance has always been affected by what Windows you have open. Can you be more specific about what you are seeing: 1) What do you mean by 'poor' performance 1/10 second per step, 1 second per step, 10 seconds per step 2) What kind of hardware do you have 3) What kind o ...Show All

• SQL Server Retieving ODBC Settings.

       I'm having some issues grabbing ODBC Settings. First off I need to present a user with the options to select thier DSN, Server, UID, PWD, and Database settings. I have come up with a way using the SQLBrowseConnect function to obtain the Server and Database information I need. Therefore, I have a semi working version of the program.      I just need a way to make the program a little more user friendly/fool-proof. I know that there is an option in the ODBC settings to set an default database. I need a way of retrieving this setting and the default server as well. Lastly I would like to turn a text ...Show All

• Visual Studio Sharing Files\unsharing files

  I noticed in Sourcesafe that some up my forms had what looks like the shortcut icon on them. from another thread I have seen it looks like this might mean they are shared. They shouldn't be as there is only one project in sourcesafe. How do I get them to be unshared Thanks. If you move a file from a folder to another in VSS (by dragging the file), the file is actually shared between the two folders. So the most common thing you can do is go to the source folder and delete the file, so that it exists only in the destination folder. However, the shared icon will not go away since the file was only deleted fro ...Show All