I am an amateur programmer and trying to move from VB6 to VB.net.
I can't figure out how to create a ADO.NET database in code. I know how to
create a dataset and wonder whether there is a way to "export" it into a new
empty database.
Since I am at it: How do you programmaticall y store a query into an ADO
database?
I am using ADOX to create an ADO database.
Thanks for any help.
Peter Schoots 5 6494
Peter Schoots wrote: I am an amateur programmer and trying to move from VB6 to VB.net.
I can't figure out how to create a ADO.NET database in code. I know how to create a dataset and wonder whether there is a way to "export" it into a new empty database.
Since I am at it: How do you programmaticall y store a query into an ADO database? I am using ADOX to create an ADO database.
Thanks for any help.
Peter Schoots
"How do you programmaticall y store a query into an ADO database?"
You want to create a stored procedure? or are you using MS Access to
store a query and recall it later? It would help to know the database
you are talking to.
Chris
Peter,
In addition to Chris, you need to know what database for that.
However we have some samples on our website for that. http://www.vb-tips.com/default.aspx
Search or take the AdoNet part.
I hope this helps,
Cor
"Peter Schoots" <Pe**********@d iscussions.micr osoft.com> schreef in bericht
news:92******** *************** ***********@mic rosoft.com... I am an amateur programmer and trying to move from VB6 to VB.net.
I can't figure out how to create a ADO.NET database in code. I know how to create a dataset and wonder whether there is a way to "export" it into a new empty database.
Since I am at it: How do you programmaticall y store a query into an ADO database? I am using ADOX to create an ADO database.
Thanks for any help.
Peter Schoots
I am trying to create an Access database in code. In VB6 I used the
following code to create a ADO database.
cat.Create("Pro vider=Microsoft .Jet.OLEDB.4.0; " & _
"Data Source=" & strFileName & ";" & _
"Jet OLEDB:Engine Type=5")
How is this done for ADO.net?
With respect of the Query question: I used for a DAO database the following
line to store a query.
newQdf = db.CreateQueryD ef("StartingDat e", strSql)
What is the equivalent for ADO? (I don't mean ADO.NET but the "old" ADO)
Peter Schoots
"Cor Ligthert [MVP]" wrote: Peter,
In addition to Chris, you need to know what database for that.
However we have some samples on our website for that.
http://www.vb-tips.com/default.aspx
Search or take the AdoNet part.
I hope this helps,
Cor
"Peter Schoots" <Pe**********@d iscussions.micr osoft.com> schreef in bericht news:92******** *************** ***********@mic rosoft.com...I am an amateur programmer and trying to move from VB6 to VB.net.
I can't figure out how to create a ADO.NET database in code. I know how to create a dataset and wonder whether there is a way to "export" it into a new empty database.
Since I am at it: How do you programmaticall y store a query into an ADO database? I am using ADOX to create an ADO database.
Thanks for any help.
Peter Schoots
Peter,
You cannot use ADONET to create an Access database.
However if it is there you can use it, did you see this sample. http://www.vb-tips.com/default.aspx?...1-d6dda3c888c8
I saw that you saw the link to ADO
ADO had in past some very famous football players.
I think that the most famous player was Ad Mansveld but he is not the only
one, however I can be wrong in that. It was a long time ago, in the time
there was also DOS which was number 4 and that kind of clubs.
Just after the introduction of proffesional footbal in holland and before
that.
However, I am not from theHague, I am and was never a real football fan.
Cor
"Peter Schoots" <Pe**********@d iscussions.micr osoft.com> schreef in bericht
news:9E******** *************** ***********@mic rosoft.com... I am trying to create an Access database in code. In VB6 I used the following code to create a ADO database. cat.Create("Pro vider=Microsoft .Jet.OLEDB.4.0; " & _ "Data Source=" & strFileName & ";" & _ "Jet OLEDB:Engine Type=5")
How is this done for ADO.net?
With respect of the Query question: I used for a DAO database the following line to store a query.
newQdf = db.CreateQueryD ef("StartingDat e", strSql)
What is the equivalent for ADO? (I don't mean ADO.NET but the "old" ADO)
Peter Schoots
"Cor Ligthert [MVP]" wrote:
Peter,
In addition to Chris, you need to know what database for that.
However we have some samples on our website for that.
http://www.vb-tips.com/default.aspx
Search or take the AdoNet part.
I hope this helps,
Cor
"Peter Schoots" <Pe**********@d iscussions.micr osoft.com> schreef in bericht news:92******** *************** ***********@mic rosoft.com... >I am an amateur programmer and trying to move from VB6 to VB.net. > > I can't figure out how to create a ADO.NET database in code. I know > how > to > create a dataset and wonder whether there is a way to "export" it into > a > new > empty database. > > Since I am at it: How do you programmaticall y store a query into an ADO > database? > I am using ADOX to create an ADO database. > > Thanks for any help. > > Peter Schoots
On Wed, 7 Dec 2005 06:17:02 -0800, "Peter Schoots" <Pe**********@d iscussions.micr osoft.com> wrote:
¤ I am trying to create an Access database in code. In VB6 I used the
¤ following code to create a ADO database.
¤ cat.Create("Pro vider=Microsoft .Jet.OLEDB.4.0; " & _
¤ "Data Source=" & strFileName & ";" & _
¤ "Jet OLEDB:Engine Type=5")
¤
¤ How is this done for ADO.net?
¤
Same method. There is no native method in ADO.NET http://support.microsoft.com/default...b;en-us;317867
¤ With respect of the Query question: I used for a DAO database the following
¤ line to store a query.
¤
¤ newQdf = db.CreateQueryD ef("StartingDat e", strSql)
¤
¤ What is the equivalent for ADO? (I don't mean ADO.NET but the "old" ADO)
¤
If you don't want to use DAO or ADOX (ADO) you can use Jet SQL: http://msdn.microsoft.com/library/de...l/acadvsql.asp
For ADO you use ADOX (Microsoft ADO Ext. 2.x for DDL and Security): http://msdn.microsoft.com/library/de...adocreateq.asp
Paul
~~~~
Microsoft MVP (Visual Basic) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: ALthePal |
last post by:
Hi,
I'm not sure if we are able to or even how to loop through the web forms in
a VB.NET project during design time. In MSAccess we are able to go through
the database -> forms collection and loop through all the forms in a database
and pull information about the form (controls and properties). We would need
to do the same in our VB.NET project; loop through the project and get the
web form's control and property information...
|
by: Null Reference |
last post by:
Anybody here who can explain or point me to a link ?
I wish to create a blank MS Access DB file programmatically
using C# .
Thanks, nfs
|
by: R Reyes |
last post by:
Just wondering if anyone knows the pros/cons between creating a database
programmatically vs using the application's tool windows/features that come
with SQLServer, Access, Oracle, etc...
Is it the same? Does it really matter? I have created databases with .NET
programmatically and it works fine, but why would anyone want to do all this
typing when they can easily point and click inside the program?
It took a few hours of typing for...
|
by: Bradford |
last post by:
I have an Windows application that displays lots of different colored lines in a Panel by using the Graphics.DrawLine method. The location and length of each line comes from a database query that takes two minutes to complete.
I am using the Panel's Paint event to call my drawing method, which accepts PaintEventArgs as a parameter. The problem is that every time the Window is moved or hidden, it needs to be repainted, which takes a long time...
|
by: Arpan |
last post by:
The following ASPX code snippet creates a DataSet programmatically right from the scratch:
'create an empty DataSet
Dim objDS As New DataSet("MyDataSet")
'create a new table & add columns
Dim dTable As New DataTable("Users")
dTable.Columns.Add("ID",System.Type.GetType("System.Int32"))
dTable.Columns.Add("FirstName",System.Type.GetType("System.String"))
dTable.Columns.Add("LastName",System.Type.GetType("System.String"))
| |
by: johnb41 |
last post by:
Can anyone help me? I need to create a SQL Server Express 2005 database
programmatically in my app. I have searched the web and I found
nothing. Can anyone help?
Are there classes in the new framework 2.0 that makes this easier?
Thanks for all your help!
John
|
by: Brian McClellan |
last post by:
Just wondering if anyone has a simple example of creating a gridview
completely programmatically, i'm not doing anything terribly sophisticated.
When creating the gridview declaratively evertying works fine, however
programmatically, while the grid will display data that exsists in the
database, any operation on the data ( editing/updating/deleting ) seems to
cause a rowdeleting/updating etc error. Or is this simply not meant to be
done?
|
by: mistral |
last post by:
Need php script to create mySQL database programmatically; since
hosting configuration may not allow create database from script, script
also need eliminate/rewrite all restrictions in appropriate places in
that hosting.
|
by: =?Utf-8?B?UGV0ZXIgSw==?= |
last post by:
I am working with Visual Studio or alternately with Expression Web. I need
to create about 50 aspx pages with about 1200 thumbnali images, typically
arranged in three to four groups per page, having hyperlinks to the
corresponding full size images.
Can anybody point me to locations in MSDN or elsewhere giving the references
to attach, the commands & objects for creating or opening the pages and
possibly available classes?
I have done...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |