Getting data from sql table inside a GridView (C#) -
i've got gridview
made in asp.net. want fill method. doesn't work. return()
doesn't work , getdata
inside page_load
underlined red(compiler error cs1501).
public partial class pages_gridview1 : system.web.ui.page { protected void page_load(object sender, eventargs e) { getdata(); } public string getdata(chart chart) { string connstr = configurationmanager.connectionstrings["crm_sql"].connectionstring; sqlconnection conn = new sqlconnection(connstr); conn.open(); sqlcommand query = new sqlcommand(chart.sql, conn); sqldatareader rst = query.executereader(); gridview1.datasource = rst; gridview1.databind(); return gridview1(); } }
you calling getdata()
method without parameters , in method definition using getdata(chart chart)
. plus returning string in method definition!!
method call : getdata()
method definition : public string getdata(chart chart)
method call , definition should match
now should :
protected void page_load(object sender, eventargs e) { getdata(); } public void getdata() { chart chart = new chart(); string connstr = configurationmanager.connectionstrings["crm_sql"].connectionstring; sqlconnection conn = new sqlconnection(connstr); conn.open(); sqlcommand query = new sqlcommand(chart.sql, conn); sqldatareader rst = query.executereader(); gridview1.datasource = rst; gridview1.databind(); }
note : assuming setting sql query in chart class
Comments
Post a Comment