SamGB's Q&A profile

• Visual Basic Parameters in TableAdapters

  In a project done to test some feautures in VB 2005 we create some datasource and a datagridview in order to show data from a simple table using parameters.  Dataset is: Comprobantes, Table is tb_datos and datagridview is comprobantesDataGridView. The code to fill the table adapter is: Me .comprobantesTableAdapter1.FillTemp( Me .Comprobantes.tb_datos, 2005, 1, 8888) Me .comprobantesDataGridView.DataSource = Me .Comprobantes.tb_dat ...Show All

• Visual Basic Capturing text from a stored procedure

  The following stored procedure: SELECT 'FROM:/SA- CLBSCODE' AS Transfer FROM vwImport GO correctly displays three records in Query Analyzer. But the file produced by the following code: Dim stExport As String = "" Dim stExportFile As String = "" For Each dr As DataRow In ManForexCLSDataSet.Tables("spExport").Rows For Each dc As DataColumn In ManForexCLSDataSet.Tables("spExport").C ...Show All

• Windows Forms binding combobox to object

  Hello all I have a combobox that I have added a binding to an object.  The combo box uses a datatable as its datasource like so cbo.datasource = myDatatable cbo.displaymember = "display" cbo.valuemember = "value" then I add my affor mentioned bindi ...Show All

• Windows Forms Error when attempting to Close a form

  I get the following error: ************** An unhandled exception of type 'System.InvalidOperationException' occurred in system.windows.forms.dll Additional information: Cannot call Close() while doing CreateHandle(). ************** When executing the following code after frm2 opens and the user simply&n ...Show All

• SQL Server Numerous (every 10 minutes) Event log entries

  Hi, Every 10 minutes, I get and information application event log of type ID:17137 Info: Starting up database 'ReportServer$SQLExpressTempDB' This is a brand installation of the Express SP1 advanced package and the reporting service has not been yet used. Thanks Hi Edmund, Could you copy the entire log entry into the thread so we can get all the information. From the info, it doesn't look like a ...Show All

• Visual C++ "list iterator not decrementable", error.

  I am trying to use some code written in C++, by a third party and I am having problems with the run time error: list iterator not decrementable I am using VS 2005. I have limited C++ experience by the way. This happens when an STL list, in decrementing backwards, pass the beginning of the list. I am told that the list is ‘Circular’, so this should not matter because it will hit the end of the list. This code h ...Show All

• Visual Basic Combobox.SelectedValue

  dim cmb as combobox cmb.SelectedValue=1 This means that it will select item whose value member is 1. Am I right If yes then In my datatable, i have following data ID  NAme -1  None  1  India  2  USA Then I bind it to combobox and it works then if i do like this, cmb.SelectedValue=-1 then it should select None. but it gives error "Specified argument was out of the range of valid values." So let me know what ...Show All

• Windows Forms Menu like office toolbar in windows.

  Hi I need to create a menu like the office tool bar. That will show when you move the mouse to the left side of the screen. I think I will create it whit windows forms, but how to i get it to show only when I move the mouse to the left side of det screen The menu should show when doing it from inside an other program or when at the desktop. Help Brian You are looking to create an Application Desktop Toolbar.  The following links ...Show All

• Windows Forms How can i attach a file to install during setup, to my program ?

  hello, i would like to attach a file to copy onto My Documents when installing the software, i don't know from where to start. thank you. You can not download files to custom locations if you are using ClickOnce to download and deploy your application. All ClickOnce apps are downloaded and installed only into ClickOnce store. -Sreekanth ...Show All

• SQL Server How to get status of sp_executesql

  Hello The basic requirement is to import data from excel sheet and save it to a table. The excel filename and sheet name is passed in as a parameter to a stored procedure. I am using sp_executesql to execute the statement. First I delete all the records from the table and then copy the data from excel into the table. I want to do this as a transaction so that if there is any error in the import process, I want to rollback the transaction o ...Show All

• .NET Development XMLNodeList + Arraylist

  Hello, everybody! I have big problem: I have informaton from two different xml files. I get specified node by using GetElementsByTagName( "appName" ); I will then put this information in arraylist: arraylistA, arraylistB. Then I compare the arraylist to find the difference. And the deference is also in an arraylist. MY QUESTION IS HOW DO I IDENTIFED ALL THE ANOTHER NODES IN THAT ARRAYLIST: Example: < ...Show All

• .NET Development config question

  how to write in a config file the port number & ip of a host thanks ok..and in the server side its the same i aslo saw some examples that use the tag <channel> , when it is useabel thanks for the help ...Show All

• Windows Forms graphics flicker problem (double buffer not working)

  I am trying to create a simple Breakout type game. I have a game panel on my form that holds my game (the paddle, ball, and board of blocks). I use a timer with an interval of 10 to move the ball a set distance every tick. The problem is that I also draw the board everytime this timer ticks and it flickers. I tried setting the doublebuffered attribute of my form to true but it didnt help. Anyone have any ideas either a different/ebtter way t ...Show All

• .NET Development Serial Port - Encoding problem

  Hi I'm having some problems reading from the serial port. ASCII > 127 are displayed as ' '. I know this is an encoding issue, and I've read other post here on the same issue, but I haven't found a solution. I tried using _serialPort.Encoding = Encoding.GetEncoding(28591) which didn't make a difference. I've also tried to set the Encoding property to Encoding.Default and loads of other encodings with no luck. For some encodings, characters ...Show All

• SQL Server WTF: Management Studio hoses Foreign Keys when Insert Column fails

  Hi, Try the following experiment! CREATE TABLE Test ( X int PRIMARY KEY ) GO CREATE TABLE Test2 ( Y int, ToX int FOREIGN KEY REFERENCES Test(X) ) GO INSERT Test2 VALUES (1, null) GO Now, in Management Studio, open Test2. View Relationships -- you see the FK to Test. Insert a non-nullable column between Y and ToX. Save. INSERT fails because the new column can't be null. Fine. Close the table (don't save changes), then reload it -- view Rela ...Show All