your welcome :)

ur welcome dear...

your welcome

i think you are missin to fill your dataset your command object not executing use

DataSet ds = new DataSet();
OleDbDataAdapter adapter = new OleDbDataAdapter(dbCmd)

adapter.Fill(ds);

after

dbCmd = new OleDbCommand(strSQL, dbConn);

then it fill dataset and your debug will show your dataset contain value.

http://it-ebooks.info/book/1617/ try this link to download the book on mvc4

try this code protected void Button1_Click(object sender, EventArgs e) { ClearTextBoxes(Page.Controls); } void ClearTextBoxes(ControlCollection control) { foreach (Control ctrl in control) { if (ctrl is TextBox) ((TextBox)ctrl).Text = string.Empty; ClearInputs(ctrl.Controls); } }

SELECT ISNULL(empid, '') + ' ' + ISNULL(empname, '') AS emp_personal, ISNULL(empdept, '') + ' ' + ISNULL(empbranch, '') AS emp_official FROM emp check this query and please confirm me is this working for you or not?

i am working on multilevel marketing project and need to display data in tree view please reply in c# code not vb want to fetch data by stored procedure if possible. i have a table with following column customer id, reference id, related level mlm-fff123, mlm-fff124, 1 mlm-hhhh125, mlm-fff124, 1 mlm-hh ,mlm-hhhh123, 1 mlm-hh ,mlm-fff124 , 2