Member Avatar for 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.

  • 2 Contributors
  • 8 Replies
  • 247 Views
  • 3 Hours Discussion Span
  • Latest Post Latest Post by DaveAmour
Member Avatar for 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?

Member Avatar for JerrimePatient

MySQL and C# sir.

but now I am using MSSQL.

my programming skills is above average.

Member Avatar for 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);
Member Avatar for JerrimePatient

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

Member Avatar for DaveAmour

Really? What happens? Which country are you in?

Member Avatar for JerrimePatient

now.png Philippines

Edited by JerrimePatient
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.