all groups > vb.net data > october 2004
Updating a table with a dataset from another database
Posted by Vicente Cartas via .NET 247 at 10/31/2004 3:56:32 AM
Hello,
I?m recieving a serialized dataset from a sql server database=2E I=
want to create a similar table in a access database using the=
dataset to populate it=2E The dataset was created in this way:
'da is a DataAdapter
ds =3D New DataSet
da=2EFillSchema(ds, SchemaType=2ESource)
da=2E... more >>
nbmvbn
Posted by m m at 10/29/2004 3:15:46 AM
nmvbm
Posted by m m at 10/29/2004 3:15:33 AM
OdbcDataAdapter
Posted by Fred at 10/28/2004 11:52:28 AM
I am trying to fill a dataset table using an OdbcDataAdapter but I keep
getting the error:
"An unhandled exception of type 'System.Data.Odbc.OdbcException' occurred in
system.data.dll
Additional information: System error."
It must be Microsofts idea of a joke if 'system error' is supposed t... more >>
selection on LISTBOX ??
Posted by Martin at 10/26/2004 4:53:22 PM
I'm developing a library application that needs to input several authors to
the database. So I decided to populate a listbox control with the names of
book's author. The question is how to select several names ( list ) using
{ctrl + click} like in windows explorer and then add the selected names ... more >>
[ANN] October 26, 2004, "ADO.NET with Visual Basic .NET" chat
Posted by Jason Cooke [MSFT] at 10/25/2004 9:53:33 AM
Every application uses data. Join members of the Visual Studio and SQL teams
for a discussion of the best approaches for working with data in your
applications.
Date:
October 26, 2004
1:00 - 2:00 P.M. Pacific time
4:00 - 5:00 P.M. Eastern time
20:00 - 21:00 GMT
(For a list of local time ... more >>
Acces Database
Posted by Lou at 10/22/2004 2:24:08 PM
I am trying to create my first .Net app comming from VB6.
I a have an Access DB. I want to show it in a grid. I have spent
2 days looking through MSDN, Google and can't find any samples on how this
is done.
I find it hard to believe the lack of sample code. Everthing seems to
require sql ... more >>
DataRow.Delete Question
Posted by Daniel at 10/22/2004 7:31:01 AM
Hello Everyone,
I am developing an application where the user can select an employee from a
list of employees (ListBox) and delete it. The problem is that when I call
DataRow.Delete method the row in question remains "Unchanged".
The code looks like this: (gl_dsCpm is the Dataset)
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
how to get the id of a new record
Posted by Ray at 10/21/2004 7:51:25 PM
This is a multi-part message in MIME format.
------=_NextPart_000_0006_01C4B7A7.592C3F70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi guys.
I have here a pretty common scenario I should think.
Let's say that I have a sub like this one belo... more >>
Connecting to Access Database with a VB.NET Windows Application
Posted by ulchm NO[at]SPAM lonelyprogrammer.com at 10/20/2004 1:26:30 PM
Hello all...
I'm just curious to see what people think the best way to connect to
an Access database on a network with a VB.NET application.
The Access DB will be on one of the computers on the network with
multiple instances of the application running on the other networked
computers.
I... more >>
Connecting to MySQL from a web app on IIS.
Posted by duck_thunder NO[at]SPAM msn.com at 10/19/2004 4:08:50 PM
I'm trying to connect to a Mysql server version 4.0.21 running on
localhost. The localhost is running on XP Pro and is hosting the web
page using the bulit in Microsoft web server.
I am using the ODBC drivers and can connect to the server from the
development platform on the host pc and run qu... more >>
vb.net newbie - ado...
Posted by Tym at 10/19/2004 1:49:35 PM
OK - thre has to be an easy solution to this...
Migrated from VB6 to vb.net
*eventually* got to populate a datase (instead of a recordset) with
the contents of a table based on an SQL query, but...
how the heck do I naviagete?
VB6:
rsRECORDSET.move
rsRECORDSET.moveftist
rsRECORDSET... more >>
Copying Data from SQL Server to Access
Posted by SQLScott at 10/18/2004 2:05:03 PM
What is the most effecient way to copy data, programatically, from SQL Server
to Access?
The table in Access is already created so need to create that
programatically, and the structure of both tables (columns, datatypes) is
identical.
I'm just trying to figure out the fastest and most ... more >>
Problem with DataRead
Posted by Markus Ellebrecht at 10/17/2004 3:15:30 PM
Hello,
I am new to this group and I hope someone can help me *g*.
I am good in VBS but now I want to switch to vb.net because of getting crazy while creating every form in VBS with InternetExplorer an HTML.
OK. Now here is my first question:
I have an Access-Database and I want to get so... more >>
Updating a table with a dataset from another database
Posted by Vicente Cartas via .NET 247 at 10/17/2004 3:12:03 AM
Hello,
I?m recieving a serialized dataset from a sql server database=2E I=
want to create a similar table in a access database using the=
dataset to populate it=2E The dataset was created in this way:
'da is a DataAdapter
ds =3D New DataSet
da=2EFillSchema(ds, SchemaType=2ESource)
da=2E... more >>
Problems with adding a record
Posted by davemckie66 NO[at]SPAM yahoo.com at 10/11/2004 9:07:04 AM
Hi all,
I am new to VB.NET and ADO.NET, but have experience in VB6 and ADO. I
have been trying a simple routine...adding a record to a MS SQL
database with no success. I can connect to the database and read
records without problem. I have been following a sample from
MSDN....the routine fin... more >>
Copy XML data to Access Database
Posted by james at 10/10/2004 5:43:25 PM
I finally found a way to read an XML data file into a dataset and display
that in a datagrid.
And found a way using ADOX, to create an empty Access database. (no tables)
What I am having a problem doing now (after tons of research) is once the
xml data is loaded into the dataset, copying the c... more >>
Extracting an array from another array in vb.net
Posted by cdouillet NO[at]SPAM yahoo.com at 10/10/2004 6:43:19 AM
Hi to all,
I am trying to find a quick "pointer like" method to extract an array
from another array without havong to assign points one by one (too
many points).
Example:
arr1={0,1,2,3,4,5,6,7,8}
with LBound(arr1)=0 and UBound(arr1)=8
arr2=extract from arr1, position 2, length=3
result:
... more >>
odbcdataAdapter
Posted by Robert Bravery at 10/7/2004 4:18:58 PM
Hi all,
Using VS.net 2003
I dragged an odbcdataadapter onto a new form, the configer dataatapter
wizard apears, I click next, and get an error dialog box:
unable to log onto the database.
Now up to now, I have not specified any database or even what server or
anything
Help!!!
Thanks Robe... more >>
How to Retrieve CLOB with ADODB Command Parameter (StoredProc), NOT by a Select statement
Posted by Khodr at 10/7/2004 3:33:48 PM
Hi everyone,
I am calling an Oracle StoredProc that returns a CLOB data type value as an
output parameter. What parameter data type should I use?
>> I tried adLongVarChar and adVarChar with the sizes 1000, 32000, 1000000
and they all fail. Size of returned value will exceed 50k.
>> I know tha... more >>
DataSet killed the Custom Object Model???
Posted by Shannon Richards at 10/5/2004 9:01:09 PM
Hello: I am building a new application and I am investigating data tier
options and find myself torn between two approaches:
1) Building a "custom object model" (Collections and Collection items:
example: CustomerCollection containing Customer objects) that uses data
readers to retrieve da... more >>
Column required???
Posted by nielsh NO[at]SPAM hollandridderkerk.nl at 10/4/2004 3:32:22 AM
Hello,
When i crate a database (mdb) with a table, the columns in the table
are set to required.
So when i want to insert data into the first column and leave the rest
of the columns empty, i get an error.
For creation of the database i use the following code:
///Code///
Dim tbl A... more >>
Unable to log into the database
Posted by Robert Bravery at 10/1/2004 9:41:10 AM
Hi all,
I am using VS.net 2003, and VB. I am new to VB programming.
I am trying to connect to a database on a server on our network. There are
two databases one is Interbase, and the other is MYSQL. Both are being
accessed via odbc. I can open the connections in the server explorer connect
to... more >>
|