473,390 Members | 1,589 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,390 software developers and data experts.

dataform wizard in visual studio 2003 and sql server 2000 database

I am trying out the dataform wizard in visual studio using a sql server
2003 database.
It seems to want to create ole db adapters and connections and
commands.
How do I make it use sql commands adapters and connections?
This wizard could save time, however would prefer it used sqlconnection
command and adapter.

thanks in advance,
sincerely

Ralph

Nov 20 '06 #1
4 1941
Hi Ralph,

Make sure the data connection is using the proper connection type.

In server explorer, modify connection and in the Provider tab, make sure
"Microsoft OLE DB Provider for SQL Server" is selected.
On Mon, 20 Nov 2006 12:55:50 +0100, Ralph <ra******@gmail.comwrote:
I am trying out the dataform wizard in visual studio using a sql server
2003 database.
It seems to want to create ole db adapters and connections and
commands.
How do I make it use sql commands adapters and connections?
This wizard could save time, however would prefer it used sqlconnection
command and adapter.

thanks in advance,
sincerely

Ralph


--
Happy Coding!
Morten Wennevik [C# MVP]
Nov 20 '06 #2
Hi Morten,
Thanks for your prompt response.
Unfortunately I suspect I hit some kind of bug in the 2003 IDE.
Seems as though if I drop and drag onto a form from the server explorer
it does indeed produce sqlconnection and sql dataadapters,
however if I use the dataform wizard it wants to create the oledb
connections and oledbadapters.
Again thanks Morten.

Ralph

Morten Wennevik wrote:
Hi Ralph,

Make sure the data connection is using the proper connection type.

In server explorer, modify connection and in the Provider tab, make sure
"Microsoft OLE DB Provider for SQL Server" is selected.
On Mon, 20 Nov 2006 12:55:50 +0100, Ralph <ra******@gmail.comwrote:
I am trying out the dataform wizard in visual studio using a sql server
2003 database.
It seems to want to create ole db adapters and connections and
commands.
How do I make it use sql commands adapters and connections?
This wizard could save time, however would prefer it used sqlconnection
command and adapter.

thanks in advance,
sincerely

Ralph

--
Happy Coding!
Morten Wennevik [C# MVP]
Nov 20 '06 #3
Ah, Sorry,

Never tried the DataForm wizard, but I couldn't find any way to specify
sql types over oledb. However, you can easily change from OleDb to Sql
with a search and replace the following

Important! Open the designer generated code region before you do a search
and replace or you won't find all items.

System.Data.OleDb.OleDbType =System.Data.SqlDbTypes
System.Data.OleDb.OleDb =System.Data.SqlClient.Sql
oleDb =sql

Then you need to change a few data types as oledbtypes and SqlDbTypes are
differently named.

Alternately, Create a dataset before you start the wizard and use this
dataset instead of a new dataset when running the wizard.
On Mon, 20 Nov 2006 14:12:53 +0100, Ralph <ra******@gmail.comwrote:
Hi Morten,
Thanks for your prompt response.
Unfortunately I suspect I hit some kind of bug in the 2003 IDE.
Seems as though if I drop and drag onto a form from the server explorer
it does indeed produce sqlconnection and sql dataadapters,
however if I use the dataform wizard it wants to create the oledb
connections and oledbadapters.
Again thanks Morten.

Ralph

Morten Wennevik wrote:
>Hi Ralph,

Make sure the data connection is using the proper connection type.

In server explorer, modify connection and in the Provider tab, make sure
"Microsoft OLE DB Provider for SQL Server" is selected.
On Mon, 20 Nov 2006 12:55:50 +0100, Ralph <ra******@gmail.comwrote:
I am trying out the dataform wizard in visual studio using a sql
server
2003 database.
It seems to want to create ole db adapters and connections and
commands.
How do I make it use sql commands adapters and connections?
This wizard could save time, however would prefer it used
sqlconnection
command and adapter.

thanks in advance,
sincerely

Ralph

--
Happy Coding!
Morten Wennevik [C# MVP]


--
Happy Coding!
Morten Wennevik [C# MVP]
Nov 21 '06 #4
I've never used any of the drop functionality. I am used to coding it
all manually.
However if what gets produced is close to what I am looking for and
saves time I believe I should give it a try.
I noticed that if I just create a dataadapter it autmatically does that
using the SQL Client.
However for some reason the dataform wizard uses oledb.
With the difference in how the two deal with parameters there is a
little more to do than just search and replaces.

Creating the dataset before.
I will have to give that a try.
I wonder if the xsd file cotains info to specify which database it was
created from?
Morten Wennevik wrote:
Ah, Sorry,

Never tried the DataForm wizard, but I couldn't find any way to specify
sql types over oledb. However, you can easily change from OleDb to Sql
with a search and replace the following

Important! Open the designer generated code region before you do a search
and replace or you won't find all items.

System.Data.OleDb.OleDbType =System.Data.SqlDbTypes
System.Data.OleDb.OleDb =System.Data.SqlClient.Sql
oleDb =sql

Then you need to change a few data types as oledbtypes and SqlDbTypes are
differently named.

Alternately, Create a dataset before you start the wizard and use this
dataset instead of a new dataset when running the wizard.
On Mon, 20 Nov 2006 14:12:53 +0100, Ralph <ra******@gmail.comwrote:
Hi Morten,
Thanks for your prompt response.
Unfortunately I suspect I hit some kind of bug in the 2003 IDE.
Seems as though if I drop and drag onto a form from the server explorer
it does indeed produce sqlconnection and sql dataadapters,
however if I use the dataform wizard it wants to create the oledb
connections and oledbadapters.
Again thanks Morten.

Ralph

Morten Wennevik wrote:
Hi Ralph,

Make sure the data connection is using the proper connection type.

In server explorer, modify connection and in the Provider tab, make sure
"Microsoft OLE DB Provider for SQL Server" is selected.
On Mon, 20 Nov 2006 12:55:50 +0100, Ralph <ra******@gmail.comwrote:

I am trying out the dataform wizard in visual studio using a sql
server
2003 database.
It seems to want to create ole db adapters and connections and
commands.
How do I make it use sql commands adapters and connections?
This wizard could save time, however would prefer it used
sqlconnection
command and adapter.

thanks in advance,
sincerely

Ralph


--
Happy Coding!
Morten Wennevik [C# MVP]

--
Happy Coding!
Morten Wennevik [C# MVP]
Nov 21 '06 #5

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

Similar topics

17
by: Andi Plotsky | last post by:
I am not a .NET developer. I want the Developer's Edition of Visual Studio for use with my Access2000 databases. Does anyone have a clue as to where to find it - my office manager says only .NET...
2
by: Chesne | last post by:
I have just read Larry Linson's reply to another user as follows = "If you mean the runtime support in "Visual Studio Tools for Office 2003 System", which contains the runtime support for Access...
4
by: wASP | last post by:
Hi, I am contemplating the purchase of Microsoft Visual Studio .NET, and I've noticed that the prices range anywhere from $200 to $600 USD:...
2
by: Belee | last post by:
1. I am using sql server express and visual studio 2003. I have been able to create the connection to the database in server explorer but cannot update table definitions. It gives an error that...
5
by: Microsoft | last post by:
Hi, I have Visual Basic .net 2003 (Standard Edition) & SQL Server 2000 Developer Edition. When trying to create a connection in the server explorer from the .net IDE I get a number of problems;...
1
by: eisenb | last post by:
microsoft.public.dotnet.languages.vb.upgrade isn't getting much traffic, so I'll try here. Ours is a VB6 shop exploring .NET. First I wrote a new application with VB .NET 2003 to create a pdf...
3
by: Hansen | last post by:
I hope that there is someone here that can help me. It's not directly related to this group but maybe someone here can help me. I wanted to deploy my Access database to another pc using the Access...
0
by: Meenu4vs | last post by:
Hi i'm using Visual Studio 2005 professional edition. I'm currently doing a customer maintanence project in C#.I need to use DataForm Wizard.I cannot find any DataForm Wizard From the Template.Tried...
4
by: Cindy H | last post by:
Hi I am currently using Visual Studio.Net 2003 running on Windows Server 2000 operating system. I have used Visual Studio.net 2003 connecting to Access 2002 databases in the pass with great...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

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.