public void GetProvider()
{
try
{
var objProvider = new WSProvider.SwiftExpressWSProvider();
var pResult = "";
var ds = objProvider.GetProvider(Session["connectionString"].ToString(), ref pResult);
if (pResult == "")
{
var regionCombo = (ASPxGridView1.Columns["NAME_PROVIDER"] as GridViewDataComboBoxColumn);
if (regionCombo != null)
{
regionCombo.PropertiesComboBox.DataSource = ds.Tables[0].DefaultView.ToTable(true,
"NAME_PROVIDER");
regionCombo.PropertiesComboBox.ValueField = "NAME_PROVIDER";
regionCombo.PropertiesComboBox.TextField = "NAME_PROVIDER";
}
ASPxComboBox2.DataSource = ds;
ASPxComboBox2.ValueField = "PROVIDER";
ASPxComboBox2.TextField = "NAME_PROVIDER";
ASPxComboBox2.DataBind();
Session["dsProviderSKU"] = ds;
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
objProvider.Dispose();
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}