Sub LoadBoxes() Dim dtBoxes As New DataTable Dim aColumn(1) As DataColumn 'Primary key column With dtBoxes aColumn(0) = .Columns.Add("BoxNo", System.Type.GetType("System.int32")) ..PrimaryKey = aColumn ..Columns.Add("BoxNo", System.Type.GetType("System.int32")) ..Columns.Add("Qu...more >>

I'm building an application around a process that I've been given, which runs several stored procedures in a row. I have all the code to run the sProcs, but when I'm in Query Analyzer, I get a message saying: "The command(s) completed successfully." My code at this point, which runs the sProc...more >>

Hi I'm sorry if this question is a bit basic for most people, but I'm really new to VB (I'm using the .NET 2005 Express Edition), but I've set myself a task and would love to see it through. The problem is that an application we use has a config file which looks XML-like and contains the...more >>

Hi All! I'm looking for a new book on how to do Stored Procedures using either VB.net or C# against a SQL Server 2005 Database. I'm not looking for a Transact-SQL (T-SQL) book. If you know of one or know of one being written please let me know I'm very interested. I'm also interested...more >>

Hi at all! I have an HASTABLE (datatable) used as schopping-cart in my web application (.aspx). When I confirm the order I want insert in my table "ORDERS" of SQL Database all data of my HASHTABLE. How could I do ? Thanks, Antonio ...more >>

My problem is the following one it is in a datagridview I am showing some data and I would like to locate me in a certain line. Ex. Locate me in a line that has the telephone 999 and this orderly one for name ID - NAME - TELEPHONE 1 - AAA - 111 2 - BBB - 444 3 - CCC - 555 4 - DDD - 666...more >>

Hi I'm a bit of (ie complete) a newbie when it comes to VB, but I need to do some coding, and have come across my first hurdle - I hope someone can help me! Using VB.NET Express, I can open a text file and read the contents into a TextBox. What I want to do though is to ignore the lin...more >>

VB.Net of Visual Studio.Net 2003 VS Visual Basic 2005 Express Edition Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and drag a table listed in the Server Explorer from a connected database to...more >>

I am very new to VB and have what for many here is a very simple question. If I create a VB application that queries a small Access database, does the individual I deploy the application to need to have Access installed on their computer to run the application? If I am constrained to deploy...more >>

Hi I am trying to Update and also Append to an Access Table from a DataSet using Parameters. I can't find the right Syntax. I am having problems getting the Parameter defined to hook to the DataRow I have created. I am at: IF ConnectToServer() 'Checks Server connection and returns True ...more >>

Hi, all! Using ASP.Net 2.0 with VB.Net code-behind. Trying to get access to data in an Access database (all SQL-based code works perfectly) using OLEDB provider, and I'm getting errors from MS sample code. According to MS, this code should work: Dim accessConnection As New OleDbConnecti...more >>

Hi, I have an Access MDB database with a Table1. From VBNET I would like to CREATE a NEW table, which is a copy of Table1, but not with the Data, only the definition. I would also like to have the possibility to DROP a table in that Database. -- Filip http://www.ww2airborne.net/ Offici...more >>

Hi, I try ro insert programmatically data into 2 fields of a Access table from a detailsview. My problem is: when clicking on the 'insert' button, nothing happens (no error but no data inserted). When 'burning' the values in the sql command, it works, but when using the inputted values i...more >>

I have a DATATABLE which I have populated in my application, and I need it written out to a particular table I specify in my ACCESS database. My code works to the point of the MERGE and UPDATE, but it creates exactly the number of BLANK records per the populated DATATABLE. Here is my code......more >>

How would I go about excluding a list of specific directories in a listbox from being queried using the following code? Any ideas? Thank you. Private Sub rAllStats(ByVal sDir As String) Try Dim objFolder As New System.IO.DirectoryInfo(sDir) Dim objFile As System.IO.FileInfo() = objFold...more >>

Sorry if this is not the place for this ?. I have some code that was created by another developer using System.Data.OracleClient. It is using the OracleException vs the Exception object. I want to know if you can pass in to a method an instance of the OracleException into the argument tha...more >>

I'm trying to move away from working in microsoft access and try and work with SQL Server. I'm going to be storing around 50K records of data in a table within SQL server at first. I tried using the visual studio.net Dataset control to create all my bound fields in the set, but what I noticed ...more >>

Hi, I have a vs Form with a txtMovieTotalTile textbox on where I put the duration of a movie in (example: 01:45:00 for 1 Hour, 45 minutes and 0 seconds) On that form there's also an update buton to update my sql-server 2005 moviedatabase with a Stored procedure. How keep I track of the ti...more >>

hi, i want to know, how to get connected to the MS ACCESS database using sql or oledb connections in .NET....more >>

Hello. I’m developing a medical application in VB.NET 2003 & Access database for a client and I’ve a question about printing graphics. The essential system logic is a Data Form created with the Data Form Wizard (with the Single Record in Individual Controls option), which updates an Acc...more >>

Hello, I'm trying to solve an issue when reading a csv file into a dataset. Suppose the next csv content : Item,Value Book,0 CD,0.52 When reading the csv content into the dataset, the 0.52 value is converted to an integer value, because the first row does not contain a decimal value....more >>

Oracle.DataAccess.Client.OracleException.get_Source() +5 ...more >>