Brad Carroll's Q&A profile

• .NET Development Query with PostgreSQL

  I am using NpgsqlConnection and NpgsqlCommand to connect to PostgreSQL in a C# application this is my code.. using (npg_connection) { npg_command = npg_connection.CreateCommand(); // npg_command.CommandText = "Select ACCOUNTS.Account, Substring(ACCOUNTS.Account, 3) || '-000-' || ACCOUNTS.Sequence_Number as Sequence, ACCOUNTS.Starting_Balance/1000 as Starting_Balance, ACCOUNTS.Balance/1000 as Balance, ACCOUN ...Show All

• Windows Forms Problem displaying data in Dropdownlist while writing

  Hi. I am developing a Web Page in Visual Basic 2005. I am using a DropDownList control, and I filled it with data, I want that DropDownList control behaves like a TextBox control, What I mean is I want to write on DropDownList control, and I don’t know how to do it, besides while I am typing a key in DropDownList control should display the possible words that user is writing, for example if user type the letter B in DropdownList control, t ...Show All

• SQL Server How find WHICH HW requirement that is not met?

  Dear All, I get a warning from the SQLExpress 2005 installation that a hardware requirement is not met. The error printout gives absolutely NO info about which requirement that is not met. So far I have manually scrutinized the HW req's and compared with my machine and found no errors. Is there a test program somewhere that can tell exactly which requirement that is not met How can this error message have passed system test I reminds ...Show All

• Visual Studio Team System Scheduling Build

  Hi, How do you schedule a build with Team Foundation System Thanks Shals You'll find information about that in the following thread  http://forums.microsoft.com/msdn/ShowPost.aspx PostID=3593 . Buck ...Show All

• Windows Forms Manipulating the Form's system menu

  Hi all, I want to add menu commands to the system menu (the menu that opens under the controlbox). I've done this by declaring external Win32Api calls:  [DllImport("user32.dll")] static extern int GetSystemMenu(int hWnd, bool bRevert); [DllImport("user32.dll", CharSet=CharS ...Show All

• Visual C# Window's form - control what happens when user closes it

  I have a windows form. If the user goes to FILE>>CLOSE to close the form, code is executed to save some information. But, how can I get the same code to be executed if the user clicks the X at the top right of the form to close it Thanks! ~Lauren i think you can use the form closed event FormClosed += new FormClosedEventHandler(MyForm_FormClosed); ...Show All

• Visual Studio 2008 (Pre-release) how to implement a clarity window or button?

  how to implement a clarity window or button in Avalon provide a few reference to me. thanks in advance. for example : http://blog.joycode.com/images/blog.joycode.com/johnnyhu/892/o_Grap3DApp.JPG ...Show All

• Visual Basic How to use unmanaged com dll in VB.NET

  How can I use an unmanaged com dll in VB.NET. I used Add Reference to use it in my project but can't seem to get it to work properly: Public Sub AccessDll( ByRef objMyDll As MyDll.IMyDll) Trying the above I get a curly green line under objMyDll with a message that Type of parameter 'objMyDll' is not CLS-Compliant. When I get to the MyDll. the Intellisense shows the Interfaces available. I've tried numerous unclear ...Show All

• Windows Forms Clickonce vs. Updater Application Block

  We have a rather large ERP system in .NET that we are writing.  After considerable performance tuning, we have our main forms loading in 4 to 5 seconds on first load and and .5 seconds on second load.  Obviously we are taking a big hit on the jit compiling and began looking at the new 2.0 ngen to see if that will increase performance.  Ok, here is our problem.  After adding clickonce to our application we learn that you can ...Show All

• SQL Server Article - delete all data property

  Hi There I think this is a pretty straight forward question , just want confirmation. I am using snapshot replication to a subscriber, it is essentially a re-publisher, these same tables are replicated from the subcriber to another. If i select the delete all data option on the snapshot articles will it truncate the table or delete all data , i am sure it is delete as it says so but i need to be 100% sure that it does not truncate, as the trunca ...Show All

• Windows Forms UserControl with multiple listboxes

  I'm sorry, but I'm very new to this and I don't have anyone who can help me. This may be basic but I've been researching this most of the night and I can't figure out how I'm supposed to code this. I have developed a user control  ...Show All

• SQL Server Copying Database without data

  Hi, Does anyone know, with either the Apr or Jun CTP, how to copy an entire database without the data   I know to use the SSIS wizard to copy tables with data, but there seem to be no option to not copy the data. Thanks. you can 1. left click source database ->Script database ->create to 1.1. change database and filenames on the script created 1.2 execute script to create new databas ...Show All

• SQL Server delete text character

  hi, for example ; select price from table query results:195dollar I want to see query result only numeric:195 how can I do You could try this: select convert(int, price) as price from table That would round the value to the nearest integer value. ...Show All

• Visual Studio VSS to VS2005 - it did work, now it doesn't

  Starting last week my VS2005 SSRS project stopped being able to interact with VSS. The first issue I noticed was VS2005 crashing when i made any change to a dataset. I'm being literal here... Open a report, click on Data tab, click to position cursor, hit space bar, get error and VS2005 restarts. Sorry, I don't have the exact error, it was related to VSS though. This behaviour doesn't happen currently since I've now monkeyed with it enough that ...Show All

• Visual Studio Express Editions Debugging running processes

  hi there, I want to make a programm that can e.g change values in another application e.g. notepad for example: i have a textbox1 and a button1 in my form1 when i click the button the text form textbox1 should be send to a open application e.g. notepat. so i can manipulate the text inside notepad with my programm. is that possibel with VB are there tutorials for this (for newbies ^^) Yes it is possible, Howeve ...Show All