all groups > dotnet ado.net > november 2004 > threads for saturday november 13
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Is there an Ole DB (or ODBC) provider for Microsoft Works db
Posted by PIEBALDconsult NO[at]SPAM aol-dot-com.no-spam.invalid at 11/13/2004 11:56:38 PM
Is there an Ole DB (or ODBC) provider for Microsoft Works database?
*-----------------------*
Posted at:
www.GroupSrv.com
*-----------------------*... more >>
SQL Select satement question
Posted by Mike_NH at 11/13/2004 7:02:01 PM
Hi All,
This may be a bit of a newbie question with an obvious answer, but I've dug
around everywhere and can't find out how to do it. I'm creating a .net web
app and have a series of drop-down lists that are all tied to sql tables.
The select statement in each of the drop-downs is based... more >>
Select statement based on previous field
Posted by Mike_NH at 11/13/2004 7:01:03 PM
Hi All,
This may be a bit of a newbie question with an obvious answer, but I've dug
around everywhere and can't find out how to do it. I'm creating a .net web
app and have a series of drop-down lists that are all tied to sql tables.
The select statement in each of the drop-downs is based... more >>
remoting/web services passing typed datasets
Posted by Masa Ito at 11/13/2004 6:18:18 PM
We are testing speed/functionality of remoting and web services while
planning a distributed windows forms application.
With web services, it is very easy to pass a dataset, but is it possible to
pass a typed dataset? If not, is there a way to convert the dataset into
the typed dataset?
... more >>
Get Table and Field Names
Posted by et at 11/13/2004 2:23:23 PM
How do I get the names of the tables in a database via ado.net? Once I have
the table names, how do I get the names of the Fields for each table? I
used to use OpenSchema in vb6 but do not find a correlating command for
..net. Thanks.
... more >>
Windows SP2 conflicts with SQL Server
Posted by Phil Townsend at 11/13/2004 1:40:21 PM
Has anybody had problems arise with connecting to SQL Server from a web
app after installing SP2? I am getting an access denied error on a web
app after installing SP2. I have verified that the ASPNET user is
permitted in SQL server. I can connect through Enterprise Mgr., and the
database was no... more >>
Unspecified Error on MyConnection.Open() to MS Access File
Posted by Alex Maghen at 11/13/2004 11:13:02 AM
Hi. I'm trying to connect to an MS Access .MDB file from ASP.NET (in C#).
I've Imported System.Data and System.Data.OleDb. My code looks like:
OleDbConnection myConnection = new OleDbConnection();
myConnection.ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\xyz... more >>
Connection string does not work from asp.net web application
Posted by Clay at 11/13/2004 10:38:01 AM
If I run the following code on my development machine as a "Windows
Application", it works. If I run the following code on my development
machine as an "ASP.NET Web Application", I get the error "SQL Server does not
exist or access denied." when trying to open the connection. I would
app... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQLConnection
Posted by vb at 11/13/2004 9:39:01 AM
I have few forms that I am trying just to display the data.
In each form I need to fire different sqlstatements to get the data. Before
executing each sql statement I am opening the connection, executing
sqlreader, closing sqlreader and closing the connection. Sometimes I get
errors like S... more >>
Missing SourceColumn mapping?!
Posted by Val at 11/13/2004 3:47:40 AM
Hi all,
having trouble with an Access database, it has a table "Books", the program
uses a dataset to work with the database.
I set up the schema for the table "Books" as follows:
(C#)
////////////////////////////
m_dataset.Tables.Add("Books");
DataColumn PrimaryKeyColumn =
m_dataset.Tabl... more >>
|