27,579
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// 定义方法将得到的数据绑定到GV_AllInfo上
/// </summary>
private void BoundGV_AllInfo()
{
//strTableName = Request.QueryString["TableName"].ToString();
strTableName = "SpWsBjdXxk";
string unitName = txb_UnitSel.Text.ToString().Trim();
SqlParameter[] sp = new SqlParameter[2];
sp[0] = new SqlParameter("@unitName", unitName);
sp[1] = new SqlParameter("@tableName", strTableName);
DBOperator Dop = new DBOperator();
try
{
DataTable dt_unitName = Dop.GetUnitNameLike(sp);
GV_AllInfo.DataSource = dt_unitName;
GV_AllInfo.DataBind();
}
catch (SqlException se)
{
Response.Write(se.ToString());
}
}
#region 查找类似单位的信息
public DataTable GetUnitNameLike(SqlParameter[] sp)
{
DataTable dt_unitName = SqlHelper.ExecuteDataset(str_con, CommandType.StoredProcedure, "UnitLikeSelect", sp).Tables[0];
return dt_unitName;
}
#endregion
select * from T_UnitInformation as a inner join SpWsBjdXxk as b on a.UI_ID = b.unitID where UI_Name like '%'+ '' + '%'
--TRY
CREATE PROCEDURE UnitXinxikaSelect(@unitName varchar(50),@tableName char(20))
as
begin
declare @sql varchar(1000);
set @sql='select * from T_UnitInformation as a inner join ' +@tableName+' as b on a.UI_ID = b.unitID where UI_Name like ''%' + @unitName +'%''';
exec(@sql);
end
GO