How to use pure ado.net in MVC?

[JerrimePatient]

Seriously, I don't know how to use ado.net in MVC, any one how to use aso.net in MVC?

any comment is appreciated.

[DaveAmour]

I know how.

Depends how you want to architect/tier this though - any thoughts?

Also what database are you using and do you want to use stored procedures?

Finally what is your level of programming skill and which language do you want this in?

[JerrimePatient]

MySQL and C# sir.

but now I am using MSSQL.

my programming skills is above average.

[JerrimePatient]

Here is my Insert Command: in C# and MySQL.

MySqlConnector c = new MySqlConnector("server=server;uid=root;pwd=pwd;database=database");
MySqlDataAdaptor d = new MySqlAdaptor();
string q;
DataTable t;

q="insert into product (id, name, price) values (null,'"+txtName.Text
    +"','"+txtPrice.Text+"')";
t = new DataTable();
d.SelectCommand = new MySqlCommand(q, c);
d.Fill(t);

[DaveAmour]

Does this help?

http://www.paxium.co.uk/PublicArticle/Article/360

[JerrimePatient]

I can't access to that site Sir. Dave, Maybe my country is block from this that site. :(

[DaveAmour]

Really? What happens? Which country are you in?

[JerrimePatient]

Philippines

[DaveAmour]

Can you try with a different browser?

Also can you see any of these sites?

http://www.rugeleychessclub.co.uk/
http://www.katmaid.co.uk/