Hi Bob,
Yes Foxpro does have SQL but I never did use it myself.
Thanks very helpful. It seems like you really have to do a lot of work just
to add a record in a table. In Foxpro it is so much easier as you do it all
in one statement with ease. :)
Roy
"Bob Powell [MVP]" <bob@_spamkiller_bobpowell.net> wrote in message
news:elw3EKc0FHA.3660@TK2MSFTNGP15.phx.gbl...[color=blue]
> 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" <royng@videotron.ca> wrote in message
> news:Oi94f.17374$HQ3.508912@wagner.videotron.net.. .[color=green]
>> 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:u6OYXQX0FHA.3956@TK2MSFTNGP09.phx.gbl...[color=darkred]
>>> 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" <royng@videotron.ca> wrote in message
>>> news:ec04f.26009$Tn2.585304@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
>>>>
>>>
>>>[/color]
>>
>>[/color]
>
>[/color]
