Hi all I'm building an application in VB.Net for entering Order information into our database. I'm comfortable with basic SQL commands and handling variables, but am looking for some guidance for dealing with user-defined sets of data. I'm using the generic Shopping Cart model to describe t...more >>

I'm looking for an efficient way to send a DataTable to Excel. The users of this app use anywhere from Office 97 to Office XP (most are Office 2000) My problem is that, the only way I've managed to do it so far is by copying cell by cell and that seems to take way too long. Another problem I'm ...more >>

How can I load an image from an Access DB? Thanks ...more >>

I'm a solo developer and had no idea there would be so much to learn to go from: - VB6 Windows apps using MS Access to: - ASP.NET web apps using SQL Server 2000 via OleDB, written locally and deployed to a web host. (www.discountASP.NET in my case.) There's a lot to grok! <g> I'm fin...more >>

VS 2002, vb.net, XP pro, Web forms Is the below code the faster, shortest and easiest way to delete a record from an MS Access database? Dim cnTC As OleDbConnection = New OleDbConnection() Dim adtpTC As OleDbDataAdapter = New OleDbDataAdapter() Dim SQL As String cnTC.ConnectionString = "Pr...more >>

Hi all I am new to vb.net but am fairly competent in Delphi!! Can anyone explain why I can connect to a Microsoft Access database using Delphi with NO code (ODBC) and be using the connection to it's full potential within seconds!!!! YET with MICROSOFT VB.NET I cannot for the life in me cr...more >>

hi there i`m very new to ms development tools and here comes my problem: in VB.NET 2002 app there is an SqlDataAdapter with this select command " SELECT employes.name, jobs.description, employes_1.name AS chief, employes.id, employes_1.id AS chief_id, jobs.id AS job_id FROM employes INNER ...more >>

Hello Everybody, What is the difference between creating SQLConnection object from the toolbox (Data Control) and creating SQLConnection object inside your program i.e. using: Dim cn as new SqlConnection. Which is better. Any help regarding this will be higly appreciated. Thanks, Vin...more >>

The code below produces an error "Syntax error in INSERT INTO statement" I can't figure out how to look at the completed statement or what it means? Dim tblCL As DataTable = New DataTable() Dim dsCL As DataSet = New DataSet() Dim cnCL As OleDbConnection = New OleDbConnection() Dim adtpCL As...more >>

Does anyone have any code samples of insert data into a MySQL db located somewhere on the web from a winforms app? TIA Russ ...more >>

I need to be able to test an already started MSDE/SQL server for a specific database. If that database doesn't exist, I want to create it. I have the following statement someone provided on site, but if I can't connect to the database, how can I execute the sql command? Dim sql As String...more >>

Hi, I am attempting to connect to a MSDE server on another PC on the local network. I eventually want to connect via a pocketpc and CF app, but am testing from the desktop first, as I am running into trouble. I can ping the machine without problems. I installed MSDE with DISABLENETWORKPR...more >>

I'm reading F. Scott Barker's book titled "Database Programming with Visual Basic.NET and ADO.NET Tips, Tutorials, and Code" and an example sub is below Private Sub frmHowTo3_3_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim strSQl As String ...more >>

I have a table named TIM_TICKET_MASTER30, and there are 0 records in the table. I have validated this from the datasource personally. When I run this query I recieve a message saying I have a value of 737968? I don't get it. Dim sConnString As String = _ "Provider=...more >>

I'm at a loss as to just where to post this question because it sorta depends on the answers. I need to write a POS application that can handle Invoicing, ordering and stock control (amoungst others) I'm using VB.Net, Windows Forms and Sql Server 2000. Our main issue is in trying to design ...more >>

A newbie to databases question. I am developing a windows app that needs to store approx 1000 rows of data every minute. This app will be run 24/7 and that equates to approx 1-2 GB of data each month being stored. The database I'm using is MSDE and I want to develop a way for the app to copy ...more >>

Is there a way to make the default values for a new row in a DataGrid the same as the previous row? (and if so how? :-) Thanks Dave Taylor ...more >>

Nothing shows up when I try and execute the stored procedure. I've tried a million different ways, and I figured the Reader would have something in it, but it doesn't even iterate through that. dim objConni as new SqlConnection("user id=ASPNET;Trusted_Connection=yes;server=LUCAS;Initial Cata...more >>

We currently use the Microsoft Native .NET Provider for Oracle to do our connections with... For one app we really need to be able to connect to the db as a SYSDBA user. Does anyone know how this can be done using the MS.NET Oracle provider?? Thanks in advance, ...more >>

Hello, What is the best approach to use a global connection object so all the classes in the project can use it? Where should I initialize the connection string (this info is in another database, so I can't use a dynamic property). Thank you! Ramiro.- ...more >>

Hi I am looking for vb.net code sample to add/edit/delete records in a single column table using datagrid. Would appreciate if someone can please post it here. Thanks Regards ...more >>

I recently installed Visual Studio .NET 2003 on my computer which is running Windows XP Home Edition. After the installation I have two additional users on my computer. Both of the accounts are limited accounts that are password protected. One of the accounts is called SQLDebugger, and ...more >>

I have a DataTable based on data from a SQL table that has 3 fields which comprise the "Primary Key", the fields are guid_simulation (unique identifier) guid_object (unique identifier) day (integer) The DataGrid is used to display/edit data for all days for a specific combination of guid_s...more >>

Can you sum and group a DataTable? If so how? ...more >>

Hi , In a client/server environment, how can i client application hold a mirror table from db server and update the changed rows once the db server's table is updated? please advise Thx a lot ...more >>

I have a program that loads simple VarChar data from a SQL table and then I convert it to a class I had made (about 10 string properties) but I am wondering what the best method is to get the data back to the SQL table. If I returned 50 rows of data it is conceivable that the user may add new row...more >>

why ODP.NET download free... HELP:......... ...more >>

I'm using Microsoft Visual Basic .NET from Visual Studio. I'm trying to figure out where to create a compound object so I can manipulate it across multiple windows in an application but I'm not sure where to instantiate it at. There are lilke 18 tables in 1 database to be used and some 30 or ...more >>

Hi All, I can edit and add new rows to my table and save them to my SQL server using a simple form created via the Data Form Wizard... What I would like to do is edit an existing row and save this row as a new row. For the like of me I cannot find how to accomplish this. What event do I trap?...more >>

Hello, We want to develop a database system for record keeping. Also we have a number of users who travel with their notebooks collecting new and updating existing data. Mobile users will have the same front-end as office users, but their data will be filtered by their geographical location. ...more >>

On a Windows form i have added a data grid. The Code i am using correctly gets the data i need to show in the grid. However when the form is first opend up on the grid all i see is a plus sign. I have to click on this plus sign to expand to see a table name, then click on that table name to sh...more >>

Hello all, This is an extremely frustrating issue. I have a datagrid that is populated with three different custom datagridtextboxcolumns that I inherited they all work perfectly, while the code exist! The problem is that every now and then, when I switch between the design view and the cod...more >>

I'm having a challenge connecting to my Access databases with programs other than Access. For instance, I am in the process of learning Visual Basic .NET. When I try to establish a connection to an Access database from within Visual Basic I can choose the provider, but as soon as I highl...more >>

Sorry for the wide posting, but i really need some help and I posted somethind a few hours ago and have heard nothing, so i thought that I would try reacing more developers... I am trying to get a date range from the first of whatever month is previous to the current one to exactly one year pr...more >>

I am fairly new to .net so if someone can help me I would appreciate it. I am getting this error on as asp.net page from within a dll. "IErrorInfo.GetDescription failed with E_FAIL(0x80004005)." The error is occurring when I try to read from an Access Database within a function. Here is...more >>

Can i close Datareader before starting reading data? The connection is used(shared) by many events, which may occurs = concurrently. But i read that the connection can't be used if data reader is not = closed.=20 This mean that while one event is working with data reader, others = events ca...more >>

Has anyone seen a reference for the ACT! api using .NET? I am looking for some easier ways to translate the custom collection objects into datasets. TIA, - Marc ...more >>

[Vb.net question] how to apply online update function into program (the effect just like Norton system work live update) The situation is below: I want to develop a program that contains some product information (in the database) for customer choosing. My partner suggest that the prog...more >>

1. In VB6 it wasn't recommended to create a single connection object to an SQL server and instead create/destroy it as needed. Is VB.Net better in that I can create a single connection to the DB for use during the life of the client? 2. If I create a connection and it sits idle for some peri...more >>

Hi, in a nutshell, is there a quick and efficient way of storing data from a database on each user's machine so that a WinForm application can query/analyze/do whatever it wishes to this local data? the winform app will never need to interact with the original database except the first time...more >>

I'm just getting started using Visual Basic .NET. Currently studying the "Step by Step" book from Microsoft Publishing. Chapter 19 provides instructions on connecting to a Jet 4.0 database. As I follow the instructions, after I choose to connect to the provided Jet 4.0 database that cam...more >>

Hi, I wrote an application using an Access Database. I've remarked the .mdb files rapidly grows in sized. Is it possible to bypass this problem ? Thanks P.S: my application on used the select/update query, no addition or deletion is made on database. ...more >>