govindkedia wrote:I am basically a novice on VS 2005 and not much expert in ASP and VS
You mean ASP.NET ? They are different.
govindkedia wrote:I am here trying to make a project in which i am using MYSQL Database .
and as I have XP home I am unable to install SQL server.
1 - if you're using MySQL, why would you want to use SQL Server?
2 - what makes you think you can't run SQL Server ? IIS is the thing you can't run in the home edition.
There is a site called VBMySQL.com or something, dedicated to connecting to MySQL using VB. Assuming you're using VB.
govindkedia wrote:while using FORM VIEW (data controls) and MYSQL as data Source...As i have been told i have to write "Coustom SQL Statements and stored procedures" while configuring the datasource,
so could anyone help here that how should i write that so that it behave as SQL database that is ...so that i don have to care about the coding part of the addition modification and deletion..i.e. how to write quires in that, I mean here is it possible to that if i write some quires in that and my database become fully comaptible with the control and perform addtion delition and modification without coding load.
There are ways to use ASP.NET controls to minimise the SQL you have to write, but if you want to have control over what's going on, you want to be writing the SQL. SQL is easier than VB, anyhow.
Christian Graus - Microsoft MVP - C++
- Rex and my new metal blog