I am using VS2010.
I set my connection string as :
connectionString="Server=server;Database=surya_db;Uid=root;Pwd=root;Provider=SQLNCLI10.1;"
providerName="MySql.Data.MySqlClient"/>
And My code under button_click event is:
protected void btnl_Click(object sender, EventArgs e)
{
int dept;
string dname;
sql = "select Ename,EmailId,Password,DepId from Emp";
ds = new DataSet();
da = new OleDbDataAdapter(sql, con);
da.Fill(ds, "Employee");
if (ds.Tables["Empl ...
Go to the complete details ...