Hi,
I need to store and retrieve information from a database. It looks as though
there is a lot more support for SQLServer than there is for Access, correct
me if I am wrong.
What do I have to do to get SQLServer and which version should I be using.
Or is SQLServer already part of the VS.Net? Are there any good examples that
you know of.
TIA
Roy
14  2098 
Hi Roy,
I guess you need a small database.
Perhaps you might look at MSDE 2000 or MSDE 2005 which are scaled down
versions of Sql Server 2000/2005 and are free (when distributed with a
application produced with MS tool I think - not sure about licensing).
--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
"Roy Gourgi" <ro***@videotron.ca> wrote in message
news:%l********************@wagner.videotron.net.. . Hi,
I need to store and retrieve information from a database. It looks as
though there is a lot more support for SQLServer than there is for Access,
correct me if I am wrong.
What do I have to do to get SQLServer and which version should I be using.
Or is SQLServer already part of the VS.Net? Are there any good examples
that you know of.
TIA
Roy
Hi Miha,
No, unfortunately I am just learning C# and eventually I am going to need to
store and retrieve a lot of information. My database will be very, very
large.
Which is faster by the way. SQLServer or Access. I would imagine SQLServer
is faster.
I am shocked at the plethora of tools available and the many different ways
of doing things. I am overwhelmed to tell you the truth.
I found a little code that allows me to display a database in Access on the
screen. How do I write to the database for example. Furthermore, is this
example a good way to retrieve information or are there more efficient
methods. There seem to be so many ways, it's hard to know where to start.
using System;
using System.Data.OleDb;
class OleDbTest
{
public static void Main()
{
//create the database connection
OleDbConnection aConnection = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=d:\\dbaccess\\db1.mdb");
//create the command object and store the sql query
// OleDbCommand aCommand = new OleDbCommand("select * from emp_test",
aConnection);
OleDbCommand aCommand = new OleDbCommand(
try
{
aConnection.Open();
//create the datareader object to connect to table
OleDbDataReader aReader = aCommand.ExecuteReader();
Console.WriteLine("This is the returned data from emp_test table");
//Iterate throuth the database
while(aReader.Read())
{
Console.Write(aReader.GetInt32(0).ToString());
Console.Write(" {0} {1} ",aReader.GetString(1),aReader.GetString(2));
Console.WriteLine();
// Console.WriteLine(" {0} ",aReader.GetString(2));
}
Console.ReadLine();
//close the reader
aReader.Close();
//close the connection Its important.
aConnection.Close();
}
//Some usual exception handling
catch(OleDbException e)
{
Console.WriteLine("Error: {0}", e.Errors[0].Message);
}
}
}
TIA
Roy
"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:%2***************@TK2MSFTNGP12.phx.gbl... Hi Roy,
I guess you need a small database.
Perhaps you might look at MSDE 2000 or MSDE 2005 which are scaled down
versions of Sql Server 2000/2005 and are free (when distributed with a
application produced with MS tool I think - not sure about licensing).
--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
"Roy Gourgi" <ro***@videotron.ca> wrote in message
news:%l********************@wagner.videotron.net.. . Hi,
I need to store and retrieve information from a database. It looks as
though there is a lot more support for SQLServer than there is for
Access, correct me if I am wrong.
What do I have to do to get SQLServer and which version should I be
using. Or is SQLServer already part of the VS.Net? Are there any good
examples that you know of.
TIA
Roy
Sorry I copied the wrong example, here is the right one.
using System;
using System.Data.OleDb;
class OleDbTest
{
public static void Main()
{
//create the database connection
OleDbConnection aConnection = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=d:\\dbaccess\\db1.mdb");
//create the command object and store the sql query
OleDbCommand aCommand = new OleDbCommand("select * from emp_test",
aConnection);
// OleDbCommand aCommand = new OleDbCommand(
try
{
aConnection.Open();
//create the datareader object to connect to table
OleDbDataReader aReader = aCommand.ExecuteReader();
Console.WriteLine("This is the returned data from emp_test table");
//Iterate throuth the database
while(aReader.Read())
{
Console.Write(aReader.GetInt32(0).ToString());
Console.Write(" {0} {1} ",aReader.GetString(1),aReader.GetString(2));
Console.WriteLine();
// Console.WriteLine(" {0} ",aReader.GetString(2));
}
Console.ReadLine();
//close the reader
aReader.Close();
//close the connection Its important.
aConnection.Close();
}
//Some usual exception handling
catch(OleDbException e)
{
Console.WriteLine("Error: {0}", e.Errors[0].Message);
}
}
}
"Roy Gourgi" <ro***@videotron.ca> wrote in message
news:%l********************@wagner.videotron.net.. . Hi,
I need to store and retrieve information from a database. It looks as
though there is a lot more support for SQLServer than there is for Access,
correct me if I am wrong.
What do I have to do to get SQLServer and which version should I be using.
Or is SQLServer already part of the VS.Net? Are there any good examples
that you know of.
TIA
Roy
Hi,
when you just start developing apps with database
access you could also make use of Firebird. Firebird
is an open source database and totally free of charge.
On Codeproject.com you'll find an example of using
Firebird. One big advantage is that it's just enough to deliver
the firebird dll within your apps, instead of installing
a new database on the user computer.
Embedded Firebird: http://www.codeproject.com/cs/databa...edFirebird.asp
Cheers
Lars
Nothing is impossible. UML is the key for all your problems.
AODL - Make your .net apps OpenOffice ready http://aodl.sourceforge.net/
Roy Gourgi schrieb: Hi,
I need to store and retrieve information from a database. It looks as though
there is a lot more support for SQLServer than there is for Access, correct
me if I am wrong.
What do I have to do to get SQLServer and which version should I be using.
Or is SQLServer already part of the VS.Net? Are there any good examples that
you know of.
TIA
Roy
Hi Roy,
--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
"Roy Gourgi" <ro***@videotron.ca> wrote in message
news:WO********************@weber.videotron.net... Hi Miha,
No, unfortunately I am just learning C# and eventually I am going to need
to store and retrieve a lot of information. My database will be very, very
large.
Which is faster by the way. SQLServer or Access. I would imagine SQLServer
is faster.
Sql server should be faster. But Ithen it depends on scenario - Access is
simplier (it isn't in the same category as Sql Server) thus it might do some
actions faster..
However, there are other database features that are more important, such as
reliability.
I am shocked at the plethora of tools available and the many different
ways of doing things. I am overwhelmed to tell you the truth.
I found a little code that allows me to display a database in Access on
the screen. How do I write to the database for example. Furthermore, is
this example a good way to retrieve information or are there more
efficient methods. There seem to be so many ways, it's hard to know where
to start.
You might start by reading help on ado.net topic.
It is a good starting point.
Other than that - a book perhaps?
--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
<la***********@web.de> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com... Hi,
when you just start developing apps with database
access you could also make use of Firebird. Firebird
is an open source database and totally free of charge.
On Codeproject.com you'll find an example of using
Firebird. One big advantage is that it's just enough to deliver
the firebird dll within your apps, instead of installing
a new database on the user computer.
Yes, this is a deployment heaven :-)
--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLQS and Access address two distinct application domains with some
overlap.
MSDE is basically a connection crippled version of SQLS minus
administration
tools that is included free with VisualStudioPro. SLQS provides 24X7
live backup,
transactional support, and logging for disaster recovery. So if you are
writing an
application that can grow to hundreds of users across a WAN you may want
to
program to SQLS.
Regards,
Jeff
*** Sent via Developersdex http://www.developersdex.com ***
<sh**********@yahoo.com> wrote... Go for MSDE 2005 version. Its a scaled down version of SQL Server. When
you ever migrate to SQL Server you will be quiet comfortable , as
everything is almost the same. MSDE is far far better than Access as
one is a RDBMS and other DBMS.
I wouldn't say that Access is a DBMS at all.
Access is "just" a front-end application to administrate, manage and
manipulate the data in a database, which can be an RDBMS or other. You can
use against Oracle, SQL Server, or whatever database that you can find an
ODBC-driver for.
Many people seem to confuse Access with its default databaseengine Jet,
which actually *is* an RDBMS.
Apart from that I agree with you that the OP should try MSDE as its scales
nicely to the full SQL Server.
// Bjorn A
<sh**********@yahoo.com> wrote... Hi Bijorn
If i am not mistaken access also stores data --- so said from that
perspective.
Not from the database perspective.
It can store forms, etc, inside the same file (mdb) as the Jet-engine stores
the data for the database.
But that still doesn't make Access more of a DBMS than MS Word, which also
stores data...
// Bjorn A
Hi Roy,
Don't pay attention to what seems to have "the most" support in the .Net
CLR. Look at your requirements. The Framework has plenty of capability for
handling any kind of database.
In your case, you say that your application will eventually need to store
and retrieve a lot of data. You didn't say, but it could be presumed by the
scale, that it will also have to handle a lot of traffic, and possibly over
a network. In that case, you're talking about a large-scale database server,
not a medium-scale file-base database. So, SQL Server is the way to go.
Now, if you're worried about designing your SQL Server database, well, you
should be. First of all, you have to think about the amount of data it will
hold, and how to most efficiently store it, and maintain it. SQL Server is
well-equipped with plenty of functionality for everything you can imagine.
So, I would suggest that what you know about databases from working with
Access will be inadequate at some near point in the future. You might
consider contracting the database design out, hiring a DBA, or whatever fits
your budget.
In the meantime, there's no reason why you can't get started. Fortunately,
Access can integrate with SQL Server quite well, and you can work with a SQL
Server database via Access, and use the familiar Access interface to create
your database tables, stored procedures, etc. Just read the Access help on
SQL Server database projects.
--
HTH,
Kevin Spencer
Microsoft MVP
..Net Developer
Ambiguity has a certain quality to it.
"Roy Gourgi" <ro***@videotron.ca> wrote in message
news:WO********************@weber.videotron.net... Hi Miha,
No, unfortunately I am just learning C# and eventually I am going to need
to store and retrieve a lot of information. My database will be very, very
large.
Which is faster by the way. SQLServer or Access. I would imagine SQLServer
is faster.
I am shocked at the plethora of tools available and the many different
ways of doing things. I am overwhelmed to tell you the truth.
I found a little code that allows me to display a database in Access on
the screen. How do I write to the database for example. Furthermore, is
this example a good way to retrieve information or are there more
efficient methods. There seem to be so many ways, it's hard to know where
to start.
using System;
using System.Data.OleDb;
class OleDbTest
{
public static void Main()
{
//create the database connection
OleDbConnection aConnection = new
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=d:\\dbaccess\\db1.mdb");
//create the command object and store the sql query
// OleDbCommand aCommand = new OleDbCommand("select * from emp_test",
aConnection);
OleDbCommand aCommand = new OleDbCommand(
try
{
aConnection.Open();
//create the datareader object to connect to table
OleDbDataReader aReader = aCommand.ExecuteReader();
Console.WriteLine("This is the returned data from emp_test table");
//Iterate throuth the database
while(aReader.Read())
{
Console.Write(aReader.GetInt32(0).ToString());
Console.Write(" {0} {1} ",aReader.GetString(1),aReader.GetString(2));
Console.WriteLine();
// Console.WriteLine(" {0} ",aReader.GetString(2));
}
Console.ReadLine();
//close the reader
aReader.Close();
//close the connection Its important.
aConnection.Close();
}
//Some usual exception handling
catch(OleDbException e)
{
Console.WriteLine("Error: {0}", e.Errors[0].Message);
}
}
}
TIA
Roy
"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:%2***************@TK2MSFTNGP12.phx.gbl... Hi Roy,
I guess you need a small database.
Perhaps you might look at MSDE 2000 or MSDE 2005 which are scaled down
versions of Sql Server 2000/2005 and are free (when distributed with a
application produced with MS tool I think - not sure about licensing).
--
Miha Markic [MVP C#]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
"Roy Gourgi" <ro***@videotron.ca> wrote in message
news:%l********************@wagner.videotron.net.. . Hi,
I need to store and retrieve information from a database. It looks as
though there is a lot more support for SQLServer than there is for
Access, correct me if I am wrong.
What do I have to do to get SQLServer and which version should I be
using. Or is SQLServer already part of the VS.Net? Are there any good
examples that you know of.
TIA
Roy
Actually I believe it is a ISAM.
--
Derek Davis dd******@gmail.com
"Bjorn Abelli" <bj**********@DoNotSpam.hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
<sh**********@yahoo.com> wrote...
Go for MSDE 2005 version. Its a scaled down version of SQL Server. When
you ever migrate to SQL Server you will be quiet comfortable , as
everything is almost the same. MSDE is far far better than Access as
one is a RDBMS and other DBMS.
I wouldn't say that Access is a DBMS at all.
Access is "just" a front-end application to administrate, manage and
manipulate the data in a database, which can be an RDBMS or other. You can
use against Oracle, SQL Server, or whatever database that you can find an
ODBC-driver for.
Many people seem to confuse Access with its default databaseengine Jet,
which actually *is* an RDBMS.
Apart from that I agree with you that the OP should try MSDE as its scales
nicely to the full SQL Server.
// Bjorn A
Hi,
Thanks everybody for your input. I think that I will heed the advice with
regards to MSDE 2000 or 2005 because inevitably I will have to go with
SQLServer and since MSDE 2000 or 2005 is a watered down version, it will be
easier to make the transition.
Roy
"Roy Gourgi" <ro***@videotron.ca> wrote in message
news:%l********************@wagner.videotron.net.. . Hi,
I need to store and retrieve information from a database. It looks as
though there is a lot more support for SQLServer than there is for Access,
correct me if I am wrong.
What do I have to do to get SQLServer and which version should I be using.
Or is SQLServer already part of the VS.Net? Are there any good examples
that you know of.
TIA
Roy
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: YURYSSG |
last post by:
I migrated a DB from Access 2000 to SQLserver 2000.
The tables are OK, but I see the old Access views... as TABLE in
SQLserver!!
Any suggestions?
--
|
by: Byrocat |
last post by:
I am using a tool called AppDetective to identify database servers and
then to scan them for vulnerabilities.
I've just been handed a list of machines and have been asked to
determine which ones...
|
by: Ray |
last post by:
Hi folks,
I have a database that goes to a client for evaluation/purchase as an
Access2k2FE / Access2k2 BE. When they decide to upsize to MySQL or SQL
Server, I would like an easy way to allow...
|
by: Devonish |
last post by:
I am planning to convert an existing Access database which has a back
end
(data tables and relationships only) on a server and a copy of the front
end
(form, queries, reports) on each of about a...
|
by: Jim Devenish |
last post by:
I am continuing my exploration about upsizing to SQLServer from Access
2000.
I have a split database with a front-end and a back-end, each of which
is A2K. I have spent some time in bookshops...
|
by: Papa_K |
last post by:
I want to connect from a .net web server to a sqlserver.
i read an article a while ago on how to do this but i have
since 'filed' it and no longer can i find it.
i remember that i was able to...
|
by: Jenniflower |
last post by:
Hi Gurus,
Our system is using SqlServer 2005 on XP.( On my machine,only this
application access SQLServer.) The sqlserver memory is configured to
128MB (Min)~512 MB(Max)
After our system get...
|
by: olle |
last post by:
hi I have a real problems with comparering date in asp and sqlserver
In sqlserver I have a table tblDates with the field dtmDate
the field dtmDate in a sqlserver table may contain a date like...
|
by: adjo |
last post by:
I am working on an app with an Access2002 frontend and Sql2005
backend. I have to use integrated security. I want to prevent my users
from altering data in another way than via the frontend.
It...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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...
|
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...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
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...
|
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...
|
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,...
|
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...
| |
