if (Parms != null)
for (int i = 0; i < Parms.Count; i++)
{
PostParm p = (PostParm)Parms[i];
BIR.AddFormParam(p.ParmName, p.ParmValue);
}
if (BIR.Request())
{
try
{
SrvResponse r = new SrvResponse(BIR.Response());
DataTable dt = r.GetResultTable();
cmb.DataSource = dt;
cmb.DisplayMember = DisplayMember;// "";
cmb.ValueMember = ValueMember;// "";
}
catch (Exception ex)
{
// MessageBox.Show(ex.Message);
}
}
}
///
/// 把数据库中的数据填充到DataGridView控件
///
/// DataGridView控件对象
/// 存储过程名称
/// 查询参数
public static void FillDataGridViewByTable(DataGridView dgv, string act, System.Collections.ArrayList Parms)
{
BIRequest BIR = new BIRequest();
BIR.url = JCFXBL.API.Helper.ServerUrl + "Execute.ashx Serlet=GetDBStore&ACT="+act;
if (Parms != null)
for (int i = 0; i < Parms.Count; i++)
{
PostParm p = (PostParm)Parms[i];
BIR.AddFormParam(p.ParmName, p.ParmValue);
}
if (BIR.Request())
{
SrvResponse r = new SrvResponse(BIR.Response());
if (r.return_value == "1")
{
DataTable dt = r.GetResultTable();
dgv.DataSource = dt;
}
else
{
MessageBox.Show(BIR.Response());
}
}
else
{
MessageBox.Show(BIR.Response());
}
}
///
/// 把从数据库查询到的数据填充到一个DataTable对象中
///
/// 存储过程名称
/// 查询参数
///
public static DataTable FillDataTable(string act, System.Collections.ArrayList Parms)
{
BIRequest BIR = new BIRequest();
BIR.url = JCFXBL.API.Helper.ServerUrl + "Execute.ashx Serlet=GetDBStore&ACT=" + act;
if (Parms != null)
for (int i = 0; i < Parms.Count; i++)
{
PostParm p = (PostParm)Parms[i];
BIR.AddFormParam(p.ParmName, p.ParmValue);
}
if (BIR.Request())
{
SrvResponse r = new SrvResponse(BIR.Response());
if (r.return_value == "1")
{
DataTable dt = r.GetResultTable();
return dt;
}
else
{
MessageBox.Show(BIR.Response());
}
}
else
{
MessageBox.Show(BIR.Response());
}
return null;
}
}
}