asp.net - how to return a datatable if a register number exists -
i trying display grid if user entered register number exists in database, if register number not exists means need display 1 label also.i new 1 in asp.net,so please me. here code below.
public datatable madhrasaviewbyregno(string viewbyno) { try { madhrasainfo infomadhrasa = new madhrasainfo(); object decobj = new object(); if (sqlcon.state == connectionstate.closed) { sqlcon.open(); } sqlcommand sqlcmd = new sqlcommand("madhrasaviewbyregno", sqlcon); sqlcmd.commandtype = commandtype.storedprocedure; sqlcmd.parameters.add("@regno", sqldbtype.varchar).value = viewbyno; decobj = sqlcmd.executenonquery(); if (decobj == null) { decstuid = decimal.parse(decobj.tostring()); } else { datatable dtbclass = new datatable(); sqldataadapter sqlda = new sqldataadapter("madhrasaviewbyregno", sqlcon); sqlda.selectcommand.commandtype = commandtype.storedprocedure; sqlda.selectcommand.parameters.add("@regno", sqldbtype.varchar).value = viewbyno; sqlda.fill(dtbclass); return dtbclass; } } catch (exception) { throw; } return null; } public void gridfillbyno() { madhrasasp spmadhrasa = new madhrasasp(); datatable dtbl = new datatable(); dtbl = spmadhrasa.madhrasaviewbyregno(textbox2.text); gvsturesult.datasource = dtbl; gvsturesult.databind(); } public void regsearch() { madhrasasp spmadhrasa = new madhrasasp(); spmadhrasa.madhrasaviewbyregno(textbox2.text); if (madhrasasp.decstuid > 0) { gridfillbyno(); multiview1.activeviewindex = 1; } else { multiview1.activeviewindex = 0; label1.visible = true; label1.text = "invalid register number"; } } protected void button2_click(object sender, eventargs e) { regsearch(); }
you dont set grid view's emptydatatext 'reg no dosent exist'. solve ploblem.
Comments
Post a Comment