I have the following code
DataSet dsRegion = Region.GetRegions(int.Pars
e(kv["Coun
try"]));
The above needs to be changed to handle a string.
public class Region
{
public static DataSet GetRegions()
{
DBAccess db = new DBAccess();
return db.ExecuteDataSet("prcRegi
ons_Select
All");
}
public static DataSet GetRegions(string countryid)
{
DBAccess db = new DBAccess();
db.AddParameter("@sCountry
ID", countryid);
return db.ExecuteDataSet("prcRegi
ons_Select
ForCountry
");
}
public static string GetRegionName(string id)
{
DBAccess db = new DBAccess();
db.AddParameter("@sRegionI
D", id);
return db.ExecuteScalar("prcRegio
ns_GetRegi
onName").T
oString();
}
}
Start Free Trial