Retrieving Multiple data in web service

Olaide Azeez

10y854

The code below refers: How can I display the result in gridview at the consumer site.

public class dclinic

{
public string ddays { get; set; }
public string dperiod { get; set; }
}

[WebMethod]

public List clinicPeriod(string clinic)
{
string sq = "select Days,Period from clinicperiod where clinic = @clinic";

gap.Open();
SqlCommand cq = new SqlCommand(sq, gap);
cq.Parameters.AddWithValue("@clinic", clinic);
SqlDataReader reader = cq.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(reader);
gap.Close();
List rlist = new List();
for (int i = 0; i < dt.Rows.Count; i++)
{
dclinic dcc = new dclinic();
dcc.ddays = dt.Rows[i]["days"].ToString();
dcc.dperiod = dt.Rows[i]["period"].ToString();
rlist.Add(dcc);
}

return rlist;

}

2 Replies

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

Bikesh Srivastava10y ago
Hi,
According your code you are doing correct but you are using some unnecessary code:use simple this:-
publicclassdclinic
{
publicstringddays{get;set;}
publicstringdperiod{get;set;}
}
[WebMethod]
publicListclinicPeriod(stringclinic)
{
stringsq="selectDays,Periodfromclinicperiodwhereclinic=clinic";
gap.Open();
SqlCommandcq=newSqlCommand(sq,gap);
SqlDataAdapteradp=newSqlDataAdapter(cq);
DataTabledt=newDataTable();
adp.fill(dt);
gap.Close();
Listrlist=newList();
for(inti=0;i
{
dclinicdcc=newdclinic();
dcc.ddays=dt.Rows[i]["days"].ToString();
dcc.dperiod=dt.Rows[i]["period"].ToString();
rlist.Add(dcc);
}
returnrlist;
}
But if you want something else please explain me.
Bikesh Srivastava10y ago
Hi,
According your code you are doing correct but you are using some unnecessary code:use simple this:-
publicclassdclinic
{
publicstringddays{get;set;}
publicstringdperiod{get;set;}
}
[WebMethod]
publicListclinicPeriod(stringclinic)
{
stringsq="selectDays,Periodfromclinicperiodwhereclinic=clinic";
gap.Open();
SqlCommandcq=newSqlCommand(sq,gap);
SqlDataAdapteradp=newSqlDataAdapter(cq);
DataTabledt=newDataTable();
adp.fill(dt);
gap.Close();
Listrlist=newList();
for(inti=0;i
{
dclinicdcc=newdclinic();
dcc.ddays=dt.Rows[i]["days"].ToString();
dcc.dperiod=dt.Rows[i]["period"].ToString();
rlist.Add(dcc);
}
returnrlist;
}
But if you want something else please explain me.