David Friesen's Q&A profile

• SQL Server Microsoft OLE DB Provider for DB2

  The Microsoft OLE DB Provider for DB2 can be downloaded as a part of the SQL Server 2005 Feature Pack located at: http://www.microsoft.com/downloads/details.aspx familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en It worked great for me to receive data, but when it came to Inserting data or updating data, I could not get it to work. Using the statement Select col1, col2 from LinkedServer.DB2.X.Y works, but using Insert Into Li ...Show All

• Visual Studio Team System Response time

  Hi, I am testing one win form application. I have written unit test and i am calling this unit test in my load test to test the web services. I have given following details Run duration: 5 min = 600 seconds Users: 20 After running the test I am seeing the following results in avg column. User load: 13 Tests/sec: 0.11 Avg.test time: 89 Is th ...Show All

• Visual Studio Express Editions TreeView question #2

  Hi Is there any way to get a TreeView which is being populated with Files to read the appropriate file icons for each of the files I do have a useful program (Audacity) which can rip icons from files, but I suspect that would be a rather long and laborious procedure. Is there any inbuilt function or method to do this kind of thing Even just the system file icons would do most of the job for me. It is a bit boring when I just have on ...Show All

• Windows Forms VS 2005 CheckBox bound to SQL Server 2000

  Using VS 2005 beta 2. I did a drag and drop of a data source table that points to an existing SQL Server 2000 table. I want to use a chekbox with a few fields. They are defined as smallint and have nulls, 0, and 1 in the exisitng data. The chekboxs show up OK on the form in IDE but at runtime they do not track the data values. If I add a teckbox instead the data displays OK. When I click on any of the checkboxs in run mode the program hangs. I ...Show All

• SQL Server Unexpected Exceptions in SQL/COM+ Since Converting to VS 2005

  We are running a COM+ DLL that handles transactions and security with a SQL Server back-end.  This project was started in VS 2003, but we just converted it to VS 2005.  Since the conversion, creating a number of transactions in a row generates errors at consistent, but moving, locations in the code (i.e. the location where the failure occurs changes when I do things such as add additional try/catch statements, so it is not random ...Show All

• Windows Forms Initializing a Windows Forms datagrid

  Does anybody know how to reset a datagrid back to it's original state with all the data cleared from the grid Ok I will use  next time... Anyway... nobody seems to be able to solve this problem... *sigh* ...Show All

• Visual C# TextBox TextChanged_Event

  Ok. I am trying to do something when a person types something in a textBox. I am having the user input 3 numbers, but while she is typing it in, I want to add a "-" between the 3 numbers. So I decided to do it in the TextChanged Event with the following code: textBox1.Text = textBox1.Text + "-"; But I get an overflow error with some type of .dll file. Can someone explain to me what I am doing wrong, or tell me another w ...Show All

• Visual Basic how to add a component collection in a groupbox

  I want to build a bindable Radiobutton group,so I extend radiobutton with new property value,as the base.build a groupbox which have a extendRadiobutton collection. question:1.when add item(extendRadiobutton),the groupbox doesnt display it ,it seem I add it in designer,but it doesnt add in collection. 2.I want only see property value and text in designer,how do I do it ,I dont want overried all property then modified with browseable(false) ...Show All

• Visual Studio Express Editions Inserting Images in the Sql Express database

  I would like to insert images that I have stored on my hard drive into a sql server database using my vwd express.  I have created a table but cannot figure out how to insert (convert) the image (.jpg or bmp formatted) file into the recommended varbinary(max) column.  Any sql sample code available   Thanks Hi, If you want to look at the example mentioned above, you need to install VB Express Editio ...Show All

• SQL Server Good SSIS Example tutorial - User Variables

  Hi There I have read BOL extensively and gone to SSIS tutorial/example web links all day. Problem is the examples are way to simple. And the tutorials on BOL especially the DW warehouse example have no explanantion or step by step flow, and the others are to simple. I would REALLY appreciate it if some had a link or resource to a good complicated step by step SSIS tutorial/example. Or more specifically not a basic one, i am most interested ...Show All

• Windows Forms Enforcing Windows XP Silver Theme in application

  Hi, I am currently developing an application, where I would like to enforce the Windows XP Silver Theme onto the whole application. Also if the machine where the application runs has another version of Windows installed. Is this possible, and if yes how Than ...Show All

• Windows Forms Authentication with a WebService through WindowsForms

  I know that I can either use SOAP Authentication or just regular Authentication in ASP.NET to do this and I'd probably rather just keep it simple and use Authentication in ASP.NET, but honestly, I have no clue how to pass them along when I ...Show All

• Visual C# Using a Timer

  Hello, Here's my problem, i'll write it in text code: now time = 18.00 turn on alarm = 20:00 start_program(); check_time() if (now time = time to turn on alarm) --> turn on alarm else if(now time = 30min to turn on alarm) --> make a sound else if(now time = 15min to turn on alarm) --> make a sound else if(now time = 5 min to turn on alarm) --> make a sound So I kind of want a timer that know what time it is, so when its ...Show All

• Visual Basic HOWTO READ REG_BINARY

  I have a problem to encode a Registry value with the type REG_BiNARY. I will like to know how to read the binary code fron REG_BINARY to transform it to normal letters or if there is a program where i can find it PLEASE HELP ME See this post http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=207075&SiteID=1 Its about converting to REG_BINARY, but you should be able to use the same technique to decode them as well. Regards, ...Show All

• Windows Forms DataGridView and Focus

  I am trying to use the RowValidating event of the DataGridView to Cancel any edits and return focus to the DataGridView. I have created a small application that replicates the problem I am having. Create a form named "Form1", add a TextBox named "TextBox1", add a DataGridView named "DataGridView1", add a Button named "Button1", then paste in the code below. Tab into the DataGridView and then type a v ...Show All