473,320 Members | 1,865 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Typed dataset and adapters

I want to create a typed dataset via Visual Studio but I don't want any of
the SQL adapters stuff. I just want a typed dataset, no need to connect to a
database. How can I stop Visual Studio from generating all that stuff?
Sep 23 '08 #1
2 1700
"Clive Dixon" <clived at digita dot comwrote in message
news:uS**************@TK2MSFTNGP03.phx.gbl...
>I want to create a typed dataset via Visual Studio but I don't want any of
the SQL adapters stuff. I just want a typed dataset, no need to connect to
a database. How can I stop Visual Studio from generating all that stuff?
This is one way in which you can do it:
In Visual Studio 2008, Add a New item to your project. Select DataSet,
and name it whatever.xsd. You get a blank, blue-colored, design surface.
Right-click on the surface and select "Add Table". Then configure your table
by adding columns. This will generate only the table in the dataset, without
any tableadapters.

Sep 23 '08 #2

"Alberto Poblacion" <ea******************************@poblacion.orgwro te
in message news:%2****************@TK2MSFTNGP05.phx.gbl...
"Clive Dixon" <clived at digita dot comwrote in message
news:uS**************@TK2MSFTNGP03.phx.gbl...
>>I want to create a typed dataset via Visual Studio but I don't want any of
the SQL adapters stuff. I just want a typed dataset, no need to connect to
a database. How can I stop Visual Studio from generating all that stuff?

This is one way in which you can do it:
In Visual Studio 2008, Add a New item to your project. Select DataSet,
and name it whatever.xsd. You get a blank, blue-colored, design surface.
Right-click on the surface and select "Add Table". Then configure your
table by adding columns. This will generate only the table in the dataset,
without any tableadapters.
Thanks for the suggestion, but I am working with a pre-existing database
with many tables - manual creation is not an option. I want to be able to
autogenerate my dataset by drag drop, but I don't want any adapter code with
it. I was hoping there would be some setting somewhere to stop this being
generated.
Sep 24 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Tim Smith | last post by:
Hi, Is it possible to create a progam to mimic the following action a) drag oledbadapter to form1.cs b) select my oracle ole connection c) enter 'select * from mytable' d) create adapter for...
0
by: Greg | last post by:
I am working on an application that requires working with numbers in scientific notation. I am using SqlServer as the database and I have created strongly typed data adapters and datasets. The...
4
by: Dave Taylor | last post by:
I've been using the dataset designer in Visual Studio to create typed datasets for my application by dragging over tables from the Server Explorer and dropping them into the designer. The problem...
8
by: Dot Net Newbie | last post by:
New to DOTNET so please be gentle: I have an in-memory dataset that I want move to a SQL Server database. The XML schema with which the dataset was built matches exactly the table schema in SQL...
2
by: amit | last post by:
I am having a play with typed datasets in ASP.Net 2.0 I am using the builder to create my data layer. I have the following tables.
0
by: billy.murray | last post by:
I have a system which comprises 4 servers (1 server per plant area). Each plant area server has 2 databases (Config<nand Runtime<nwhere <nis the plant area number) and 1 web application which uses...
1
by: Code Monkey | last post by:
Silly question maybe, but I've been doing the following for far too long now: public static DataTable myDataTable() { string sql = @"SELECT column1, column2, column3, column4 FROM...
2
by: rsandes1 | last post by:
Hello, Does anybody know how to construct an "asp:hyperlink" control using VS 2005 dataset object (.xsd)? I'm trying to code dynamic hyperlinks that reference some stored procedures in my dataset's...
0
by: Ptero | last post by:
We're using a lot of typed datasets in ASP.NET application, most of them have many tables+adapters and each table has some functions that call Oracle Stored Procedures. It works using...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.