This works fine but I rather prefer to return datarow obj instead of binding to combobox (for code reusability) , so that I can use it like this
comboBox1.Items.Add(PopulateMainCat("mytable"));
Thanks for having a look .Code:public object PopulateMainCat(string MainTableCat) { OpenDB(); DataSet ds =new DataSet(); string sqlstr ="SELECT * FROM " + MainTableCat + ""; OleDbDataAdapter adp =new OleDb.OleDbDataAdapter(sqlstr,MyConnection); adp.Fill(ds,MainTableCat); foreach(DataRow dr in ds.Tables[MainTableCat].Rows) { //I don't want this comboBox1.Items.Add(dr[1]); //but I would love this way //return dr[1]; } DBSpace.CloseDB.CloseDB1(); }![]()





Reply With Quote