Arithmetic Overflow when manipulating as400 data using vb.net 2008
I will include the code so you can see what I am talking about at the end. I have a vb.net 2008 app that I am writing. Everything seems to go fine until I add/edit/delete a record. I am getting the following error: Arithmetic Operation resulted in an overflow. If I ignore the error everything [...]
Answer Question
| May 16, 2012 4:44 PM
AS/400, VB.NET, Visual Basic
I will include the code so you can see what I am talking about at the end. I have a vb.net 2008 app that I am writing. Everything seems to go fine until I add/edit/delete a record. I am getting the following error: Arithmetic Operation resulted in an overflow. If I ignore the error everything [...]
Answer Question
| May 16, 2012 4:44 PM
AS/400, VB.NET, Visual Basic
condition based color changing of labels
Imports System.Data.OleDb Imports System.Data Imports System.Threading Imports System.Data.SqlClient Public Class Form1 Dim bm As BindingManagerBase Dim ds As New DataSet Dim adp As OleDb.OleDbDataAdapter Sub showrecord(ByVal pos As Integer) Button1.Text = ds.Tables(0).Rows(pos)("Question") Button2.Text = ds.Tables(0).Rows(pos)("Option1") [...]
Answer Question
| April 9, 2012 5:52 AM
VB.NET, Visual Studio 2008 Professional
Imports System.Data.OleDb Imports System.Data Imports System.Threading Imports System.Data.SqlClient Public Class Form1 Dim bm As BindingManagerBase Dim ds As New DataSet Dim adp As OleDb.OleDbDataAdapter Sub showrecord(ByVal pos As Integer) Button1.Text = ds.Tables(0).Rows(pos)("Question") Button2.Text = ds.Tables(0).Rows(pos)("Option1") [...]
Answer Question
| April 9, 2012 5:52 AM
VB.NET, Visual Studio 2008 Professional
Insert values into database from form VB.NET
Hi guys, Having abit of trouble with inserting values that i have in my form into my sql database. Basically it supposed to calculate a customer who borrowed a DVD or CD. I select the date that the customer brings the returned item by selecting a datepicker. The calculation works fine, but i want to [...]
Answer Question
| March 28, 2012 9:52 AM
SQL Database, VB.NET
Hi guys, Having abit of trouble with inserting values that i have in my form into my sql database. Basically it supposed to calculate a customer who borrowed a DVD or CD. I select the date that the customer brings the returned item by selecting a datepicker. The calculation works fine, but i want to [...]
Answer Question
| March 28, 2012 9:52 AM
SQL Database, VB.NET
DPI settings different on user machines
How do I fix my VB.Net application to handle different DPI settings on the users machine?
Answer Question
| March 14, 2012 3:16 PM
DPI, VB.NET
How do I fix my VB.Net application to handle different DPI settings on the users machine?
Answer Question
| March 14, 2012 3:16 PM
DPI, VB.NET
vb.net telnet
my job is to telnet a cisco router, pass the credentiials and build configuration. after building the same, i have to search for a line in the config. i want to automate this whole pocess with vb.net. help me
Answer Question
| February 29, 2012 8:41 AM
Cisco router, VB.NET
my job is to telnet a cisco router, pass the credentiials and build configuration. after building the same, i have to search for a line in the config. i want to automate this whole pocess with vb.net. help me
Answer Question
| February 29, 2012 8:41 AM
Cisco router, VB.NET
Need a little VB.Net help -2
Continues thread Need a little VB.Net help and previous lost thread We need a VB programmer to turn my rough shot at a function into VB.Net and put it through it’s paces to see how it works, code is below in discussion. .. earlier thread question Need a little VB.Net help. TheFinder was attempting to [...]
Answer Question
| February 28, 2012 11:36 PM
Random, Random Number Generator, VB Functions, VB.NET
Continues thread Need a little VB.Net help and previous lost thread We need a VB programmer to turn my rough shot at a function into VB.Net and put it through it’s paces to see how it works, code is below in discussion. .. earlier thread question Need a little VB.Net help. TheFinder was attempting to [...]
Answer Question
| February 28, 2012 11:36 PM
Random, Random Number Generator, VB Functions, VB.NET
How to make my VB.Net application communicate with a barcode scanner
Good day! Please i need your assistance as i am trying to achieve a goal. I am designing a POS application using VB.Net 2008 and really need the barcode scanner to be integrated but i dont know much about barcode and so i dont have any idea of the sourcecode to write. Kindly help me [...]
Answer Question
| February 28, 2012 11:47 AM
VB.NET, VB.NET 2008
Good day! Please i need your assistance as i am trying to achieve a goal. I am designing a POS application using VB.Net 2008 and really need the barcode scanner to be integrated but i dont know much about barcode and so i dont have any idea of the sourcecode to write. Kindly help me [...]
Answer Question
| February 28, 2012 11:47 AM
VB.NET, VB.NET 2008
Need a little VB.Net help
Need a little VB.Net help. TheFinder was attempting to find a good solution to a lottery number picking problem. He needed to pick 6 numbers, each from 1 to 50 but no two duplicating. The six numbers had to total to a target value input by the user between 21 and 285. I developed an [...]
Answer Question
| February 28, 2012 2:57 AM
Random, VB.NET
Need a little VB.Net help. TheFinder was attempting to find a good solution to a lottery number picking problem. He needed to pick 6 numbers, each from 1 to 50 but no two duplicating. The six numbers had to total to a target value input by the user between 21 and 285. I developed an [...]
Answer Question
| February 28, 2012 2:57 AM
Random, VB.NET
Visual Basic and SQL database design
i have vb.net & sql application sql database have one tabe with 37 column (there is no normalization) after runing the application more than three million of rows will enterd by users . I’m afraid it Will give a bad performance or have (out of memory massge) so i Made a solution (i make [strong]Queries(with vb.net wich [...]
Answer Question
| March 31, 2012 6:56 AM
Database design, SQL Database, VB.NET, Visual Basic, Visual Basic .NET
i have vb.net & sql application sql database have one tabe with 37 column (there is no normalization) after runing the application more than three million of rows will enterd by users . I’m afraid it Will give a bad performance or have (out of memory massge) so i Made a solution (i make [strong]Queries(with vb.net wich [...]
Answer Question
| March 31, 2012 6:56 AM
Database design, SQL Database, VB.NET, Visual Basic, Visual Basic .NET
How to use an object to travel data from one form to another
Hi, I have two forms.Both having DatagridView.There are two comboboxes to filter the record from Database and fill in Datagridview.My requirement is when all the data is populated in DataGrid after selecting the comboboxes and when the user clicks on Delete. The comboboxes and Datagrid on second form should have the same values as that [...]
Answer Question
| March 31, 2012 7:18 AM
DataGrid, DataGridView, VB DataGrid, VB.NET, Visual Basic .NET
Hi, I have two forms.Both having DatagridView.There are two comboboxes to filter the record from Database and fill in Datagridview.My requirement is when all the data is populated in DataGrid after selecting the comboboxes and when the user clicks on Delete. The comboboxes and Datagrid on second form should have the same values as that [...]
Answer Question
| March 31, 2012 7:18 AM
DataGrid, DataGridView, VB DataGrid, VB.NET, Visual Basic .NET
SQL Server 2005 with VB.net
Hello, i am hareen. I am working on collegedatabase managment software. which is develope in vb.net. i am using sql server database 2005 and my database name is collegedatabaseMV.mdf . i have some question..? what is necessary to load sql server 2005 on client computer when i am install my application setup with .mdf database [...]
Answer Question
| March 31, 2012 10:11 AM
SQL Server, SQL Server 2005, VB.NET, Visual Basic, Visual Basic .NET
Hello, i am hareen. I am working on collegedatabase managment software. which is develope in vb.net. i am using sql server database 2005 and my database name is collegedatabaseMV.mdf . i have some question..? what is necessary to load sql server 2005 on client computer when i am install my application setup with .mdf database [...]
Answer Question
| March 31, 2012 10:11 AM
SQL Server, SQL Server 2005, VB.NET, Visual Basic, Visual Basic .NET
How to retrieve, add and update data from SQL Server 2005 manually using VB.NET 2005?
How to retrieve, add and update data from SQL Server 2005 manually using VB.NET 2005?
Answer Question
| January 21, 2012 6:03 PM
SQL Server 2005, VB.NET, VB.NET 2005, Visual Basic, Visual Basic 2005
How to retrieve, add and update data from SQL Server 2005 manually using VB.NET 2005?
Answer Question
| January 21, 2012 6:03 PM
SQL Server 2005, VB.NET, VB.NET 2005, Visual Basic, Visual Basic 2005
How to make the connection in SQL 2000 with Visual Basic 6
i want to make the sql connection with vb6,how to open the connection in sql
Answer Question
| May 16, 2011 2:26 AM
SQL 2000, SQL connection, SQL connectivity, VB, VB.NET, Visual Basic 6
i want to make the sql connection with vb6,how to open the connection in sql
Answer Question
| May 16, 2011 2:26 AM
SQL 2000, SQL connection, SQL connectivity, VB, VB.NET, Visual Basic 6
Dynamic SQL query
Hi! I’m making an application in vb.net using MS Access as DB.. Nw in this, i want to do some complex stuff, that is dynamically making sql queries or in other words, changing the where clause according to user preference. The scenario let’s say is…in a form the user can search for records thru 1) [...]
Answer Question
| May 5, 2011 5:59 PM
Access Database, Dynamic SQL, SQL Query, VB.NET
Hi! I’m making an application in vb.net using MS Access as DB.. Nw in this, i want to do some complex stuff, that is dynamically making sql queries or in other words, changing the where clause according to user preference. The scenario let’s say is…in a form the user can search for records thru 1) [...]
Answer Question
| May 5, 2011 5:59 PM
Access Database, Dynamic SQL, SQL Query, VB.NET
VB.NET Conversion Help: Bool Array to Integer and Inteher to Bool Array
Hello everyone, I would like to know how to convert an 32 bit Boolean array to an integer value from one command line instead of writing a For Loop. dim myBOOL(32) as Boolean dim myINT as Integer myBOOL(0) = True myBOOL(1) = True myBOOL(5) = True myINT = xxx(myBOOL) where INT will be 35 ——————————————————– [...]
Answer Question
| March 14, 2011 6:27 AM
VB, VB.NET, Visual Basic, Visual Basic .NET
Hello everyone, I would like to know how to convert an 32 bit Boolean array to an integer value from one command line instead of writing a For Loop. dim myBOOL(32) as Boolean dim myINT as Integer myBOOL(0) = True myBOOL(1) = True myBOOL(5) = True myINT = xxx(myBOOL) where INT will be 35 ——————————————————– [...]
Answer Question
| March 14, 2011 6:27 AM
VB, VB.NET, Visual Basic, Visual Basic .NET
Retrieving data from Visual Studio database
How to edit,delete and update data in database which we fetch in gridview control in vb.net 2008? The data within the gridview control only be used
Answer Question
| February 28, 2011 9:01 AM
GridView, GridView Control, VB.NET, Visual Studio 2008
How to edit,delete and update data in database which we fetch in gridview control in vb.net 2008? The data within the gridview control only be used
Answer Question
| February 28, 2011 9:01 AM
GridView, GridView Control, VB.NET, Visual Studio 2008
Search: Error with SQL : Login failed for ‘SA’.
I’m using a softawre written in VB(.net). It runs normal on XP and 2003 server. it supports both Access and SQL 2000 and 2005. but I recently upgraded my OS to Win7+SQL 2008, and I’ve been having the following error anytime a call for a screen in the software”Search: Error with SQL : Login failed [...]
Answer Question
| June 28, 2011 11:53 PM
SQL Server 2000, SQL Server 2005, VB.NET, Visual Basic, Windows Server 2003
I’m using a softawre written in VB(.net). It runs normal on XP and 2003 server. it supports both Access and SQL 2000 and 2005. but I recently upgraded my OS to Win7+SQL 2008, and I’ve been having the following error anytime a call for a screen in the software”Search: Error with SQL : Login failed [...]
Answer Question
| June 28, 2011 11:53 PM
SQL Server 2000, SQL Server 2005, VB.NET, Visual Basic, Windows Server 2003
In Excel how to autofill a cell that references a list?
I have defined a list. Now I am at the drop down on another sheet. Instead of scrolling to the item in the list… (a very long list), I would like to be able to start typing a few letters, and the lists shortens to just that initial input. Much like a combo box can [...]
Answer Question
| May 10, 2012 1:42 PM
ComboBox, Excel 2003, Excel 2003 functions, VB.NET
I have defined a list. Now I am at the drop down on another sheet. Instead of scrolling to the item in the list… (a very long list), I would like to be able to start typing a few letters, and the lists shortens to just that initial input. Much like a combo box can [...]
Answer Question
| May 10, 2012 1:42 PM
ComboBox, Excel 2003, Excel 2003 functions, VB.NET
VB6 and VB.NET Serial (COM1) data error
Hello, I’m new to .NET. I have an application that is running in VB6. It sends text through COM1 port to another device. When I converted the VB6 code to .NET the string it sends out is different! I have tried so many things and don’t know what to do. I used a serial data [...]
Answer Question
| February 4, 2011 4:29 AM
.NET, COM1, RS232, Serial ports, VB 6.0, VB.NET
Hello, I’m new to .NET. I have an application that is running in VB6. It sends text through COM1 port to another device. When I converted the VB6 code to .NET the string it sends out is different! I have tried so many things and don’t know what to do. I used a serial data [...]
Answer Question
| February 4, 2011 4:29 AM
.NET, COM1, RS232, Serial ports, VB 6.0, VB.NET
IPv6 support
We are configuring routers with IPv4 addresses and would like to configure IPv6 address instead of IPv4 for some devices. Please suggest me the best way of doing it and things to be considered (IP validations & subnet Mask, etc) while doing this enhancement.
Answer Question
| January 13, 2011 4:02 PM
IPv4, IPv6, VB.NET, Visual Basic
We are configuring routers with IPv4 addresses and would like to configure IPv6 address instead of IPv4 for some devices. Please suggest me the best way of doing it and things to be considered (IP validations & subnet Mask, etc) while doing this enhancement.
Answer Question
| January 13, 2011 4:02 PM
IPv4, IPv6, VB.NET, Visual Basic
