Fill: SelectCommand.Connection property has not been initialized.

Please try this

DataTable dt = new DataTable();
MySqlConnection objDBcon= new MySqlConnection(@"connection string");//tested and working
objDBcon.Open();

MySqlCommand strcmd= new MySqlCommand("select city_name,c_id from citys_info Where city_name like '" + strname + "%' order by city_name asc",objDBcon);
MySqlDataAdapter dap = new MySqlDataAdapter(strcmd);

dap.SelectCommand = strcmd;
dap.Fill(dt);
conn.Close();

Gow.Net, if this helps please login to Mark As Answer. | Alert Moderator

Please mark as answer if it helpful to you..That helps others who search the same..

Gow.Net, if this helps please login to Mark As Answer. | Alert Moderator

hi Gow.net,
please open connection before command.that is only the problem.u can try like this.
con.open();
strcmd="select city_name,c_id from citys_info Where city_name like '" + strname + "%' order by city_name asc";
SqlDataAdapter dap = new SqlDataAdapter(strcmd, obj_dbconnection.objDBcon);
DataSet ds = new DataSet();
dap.Fill(ds);
return ds.Tables[0];
con.close();

Thanks & Regards
Hari

Gow.Net, if this helps please login to Mark As Answer. | Alert Moderator

Please mark as answer if it helpful to you..That helps others who search the same..

Thanks & Regards
Hari

Gow.Net, if this helps please login to Mark As Answer. | Alert Moderator

Its saying that .. 'obj_dbconnection.objDBcon' connection object doesnot belong to any SqlConnection Class.
means u have not initialized SqlConnection class.

Regards,
Vikash Pathak

Gow.Net, if this helps please login to Mark As Answer. | Alert Moderator

If found interesting mark as answer............

Regards,
Vikash Pathak

Gow.Net, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

Please add "obj_dbconnection.objDBcon.open" above to your code or make sure your connection is open as the error is related with "Connection is not opened".

Hope this helps.

Thanks and Regards,
Gayathri P

Gow.Net, if this helps please login to Mark As Answer. | Alert Moderator

Please Mark As Answer if any of the reply answers u.

Gow.Net, if this helps please login to Mark As Answer. | Alert Moderator