VS has a developer version of SQL server which is OK for developing apps
that you can test out.
Storing and retrieving data is as simple ad writing the SQL statements that
manipulate the tables. I don't know anything about FoxPro so, to be honest,
I don't even know if it does SQL.
Because I'm a cheapskate I often use access databases or MySQL. SQL server
is really an option for a company that can afford the license fees. It's by
far the best choice but one needs to be committed to a certain level of
monetary outlay.
Here for example is a simple set of commands I used to populate a repeater
on a website I did a while back. It uses Access...
DataSet ds=new DataSet();
OleDbConnection cnx=new
OleDbConnection(Constants.ConnectionString(this.Se rver));
OleDbDataAdapter da=new OleDbDataAdapter("SELECT * FROM content",cnx);
da.Fill(ds);
this.Repeater1.DataSource=ds;
this.Repeater1.DataBind();
That was a pretty simple one. The Constants class just lets me get a
connection string according to whether i'm in debug mode so the connection
string points to my local access database file or in release mode in which
case it uses Server.MapPath to get to where my DB is stored.
Here's me adding a record to a table...
cmd=new OleDbCommand("INSERT INTO products(product_name, stock, minstock,
price, content, category, description) VALUES(?,?,?,?,?,?,?);",cnx);
cmd.Parameters.Add("product_name",OleDbType.Char). Value=this.name.Text;
cmd.Parameters.Add("stock",OleDbType.Integer).Valu e=int.Parse(this.stock.Text);
cmd.Parameters.Add("minstock",OleDbType.Integer).V alue=int.Parse(this.minstock.Text);
cmd.Parameters.Add("price",OleDbType.Currency).Val ue=decimal.Parse(this.price.Text);
cmd.Parameters.Add("content",OleDbType.Integer).Va lue=content;
cmd.Parameters.Add("category",OleDbType.Integer).V alue=int.Parse(this.DropDownList1.SelectedValue.To String());
cmd.Parameters.Add("description",OleDbType.Integer ).Value=description;
cmd.ExecuteNonQuery();
and here's me updating a table with some changed data...
OleDbCommand cmd=new OleDbCommand("UPDATE products SET product_name=?,
stock=?, minstock=?, price=?, content=?, category=?, description=? WHERE
productid=[i];",cnx);
cmd.Parameters.Add("product_name",OleDbType.Char). Value=this.name.Text;
cmd.Parameters.Add("stock",OleDbType.Integer).Valu e=int.Parse(this.stock.Text);
cmd.Parameters.Add("minstock",OleDbType.Integer).V alue=int.Parse(this.minstock.Text);
cmd.Parameters.Add("price",OleDbType.Currency).Val ue=decimal.Parse(this.price.Text);
cmd.Parameters.Add("content",OleDbType.Integer).Va lue=(int)ViewState["content"];
cmd.Parameters.Add("category",OleDbType.Integer).V alue=this.DropDownList1.SelectedValue;
cmd.Parameters.Add("description",OleDbType.Integer ).Value=ViewState["description"];
cmd.Parameters.Add("i",OleDbType.Integer).Value=it em;
cmd.ExecuteNonQuery();
As you can see it's all pretty straightforward. Even I can manage it :-)
--
Bob Powell [MVP]
Visual C#, System.Drawing
Ramuseco Limited .NET consulting
http://www.ramuseco.com
Find great Windows Forms articles in Windows Forms Tips and Tricks
http://www.bobpowell.net/tipstricks.htm
Answer those GDI+ questions with the GDI+ FAQ
http://www.bobpowell.net/faqmain.htm
All new articles provide code in C# and VB.NET.
Subscribe to the RSS feeds provided and never miss a new article.
"Roy Gourgi" <ro***@videotron.ca> wrote in message
news:Oi********************@wagner.videotron.net.. .
Hi,
Thanks for replying.
I think I will break ties with FoxPro and COM and go for either SQLServer
or Access. There seems to be a lot more support for SQLServer than Access,
so I think that I will try SQLServer. 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?
All I really need is to store and retrieve information from a database.
What do you recommend and are there any examples?
TIA
Roy
"Bob Powell [MVP]" <bob@_spamkiller_bobpowell.net> wrote in message
news:u6**************@TK2MSFTNGP09.phx.gbl... Hello,
There are many possibilities. You can use SQLServer or Access, If you
want to go cheap there are alternatives such as MySQL that have C# or
Visual Basic wrappers.
Probably more attractive to you is the fact that VFP can be automated via
COM. Therefore you can write VB or C# applications that use the database
engine you're most familiar with.
You'd really be petter asking these questions over in a VFP group I
guess.
Oh... have you seen this??
http://foxcentral.net/microsoft/NETforVFPDevelopers.htm
--
Bob Powell [MVP]
Visual C#, System.Drawing
Ramuseco Limited .NET consulting
http://www.ramuseco.com
Find great Windows Forms articles in Windows Forms Tips and Tricks
http://www.bobpowell.net/tipstricks.htm
Answer those GDI+ questions with the GDI+ FAQ
http://www.bobpowell.net/faqmain.htm
All new articles provide code in C# and VB.NET.
Subscribe to the RSS feeds provided and never miss a new article.
"Roy Gourgi" <ro***@videotron.ca> wrote in message
news:ec********************@weber.videotron.net... Hi,
I am used to working in Visual FoxPro and I would like to be able to
create a database and store and retrieve information from it. What is
the simplest way to do it and what should I be using as there are many
choices to choose from.
My database will contain a lot of records.
TIA
Roy
