How can i access single method into all webpages using class

Gururaj Jewargi

10y950.NET

Hi,

here it is small method for binding employee data. i want to access this method into 5 webpages. instead of keeping every page load method i want to access only one method to all webpages how ? ?

private void BindGridviewData()

{

con.Open();

SqlCommand cmd = new SqlCommand("Bindemployee", con);

cmd.CommandType = CommandType.StoredProcedure;

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

con.Close();

gvDetails.DataSource = ds;

gvDetails.DataBind();

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Midhun Tp10y ago
Accepted answer
Hi,
Just add parameters in function and pass parameters to it -
public DataSet Getdata(string param1,string param2)
{
con.Open();
SqlCommand cmd = new SqlCommand("Bindemployee", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
return ds;
}
Grid binding function will become like below -
private void BindGridviewData()
{
MyClass obj = new MyClass();
gvDetails.DataSource = obj.Getdata(param1,param2);
gvDetails.DataBind();
}
Gururaj Jewargi10y ago
with parameter how to pass?
Midhun Tp10y ago
Hi,
The normal practice is to keep the database access codes in a class like below -
public class MyClass
{
public MyClass()
{
//
// TODO: Add constructor logic here
//
}
public DataSet Getdata()
{
con.Open();
SqlCommand cmd = new SqlCommand("Bindemployee", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
return ds;
}
}

Now in your grid binding function will be like below -
private void BindGridviewData()
{
MyClass obj = new MyClass();
gvDetails.DataSource = obj.Getdata();
gvDetails.DataBind();
}