this code...i try search result name of school.but grid view didnt show thing.my code is
public void gridfill() { marksp spmark = new marksp(); datatable dtbl = new datatable(); dtbl = spmark.markviewall(); gvresult.datasource = dtbl; dtbl = spmark.markviewbyschool(txtschoolname.text); gvresult.datasource = dtbl; } protected void button1_click(object sender, eventargs e) { gridfill(); } public datatable markviewall() { datatable dtbl = new datatable(); sqldataadapter sqlda = new sqldataadapter("markviewall", sqlcon); sqlda.selectcommand.commandtype = commandtype.storedprocedure; sqlda.fill(dtbl); return dtbl; } public datatable markviewbyschool(string viewbyschool) { datatable dtbclass = new datatable(); sqldataadapter sqlda = new sqldataadapter("markviewbyschool",sqlcon); sqlda.selectcommand.commandtype = commandtype.storedprocedure; sqlda.selectcommand.parameters.add("@schoolname", sqldbtype.varchar).value = viewbyschool; sqlda.fill(dtbclass); return dtbclass; }
change below, there few problems in code, why 2 times databinding same gridview? data bind 2 times show set @ last time. have removed few lines of code , forgot call gvresult.databind()
public void gridfill() { marksp spmark = new marksp(); gvresult.datasource = spmark.markviewbyschool(txtschoolname.text); gvresult.databind(); }
Comments
Post a Comment