如何在C#中使用jquery从SQL Server(varbinary列)绑定图像 [英] How to bind image from SQL server (varbinary column) using jquery in C#
本文介绍了如何在C#中使用jquery从SQL Server(varbinary列)绑定图像的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
这是我的json代码
This is my json code
function OnSuccess(response) {
$('#dvGrid').show();
var xmlDoc = $.parseXML(response.d);
var xml = $(xmlDoc);
var compmst = xml.find("COMPANY_MASTER");
if (row == null) {
row = $("[id*=gvCompList] tr:last-child").clone(true);
}
$("[id*=gvCompList] tr").not($("[id*=gvCompList] tr:first-child")).remove();
if (compmst.length > 0) {
$.each(compmst, function () {
var compmst = $(this);
$("td", row).eq(6).html('');
$("[id*=gvCompList]").append(row);
row = $("[id*=gvCompList] tr:last-child").clone(true);
});
}
//Webmethod call
[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public static string fetchCompMst(int pageSize, int pageIndex)
{
string query = "[FETCH_COMPANY_MASTER]";
SqlCommand cmd = new SqlCommand(query);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PageIndex", pageIndex);
cmd.Parameters.AddWithValue("@PageSize", pageSize);
cmd.Parameters.Add("@RecordCount", SqlDbType.Int, 4).Direction = ParameterDirection.Output;
return getCompData(cmd, pageIndex, pageSize).GetXml();
}
private static DataSet getCompData(SqlCommand cmd, int pageIndex, int pageSize)
{
DataSet ds = new DataSet();
try
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);
SqlDataAdapter sda = new SqlDataAdapter();
cmd.Connection = con;
sda.SelectCommand = cmd;
sda.Fill(ds, "COMPANY_MASTER");
DataTable dt = new DataTable("Pager");
dt.Columns.Add("PageIndex");
dt.Columns.Add("PageSize");
dt.Columns.Add("RecordCount");
dt.Rows.Add();
dt.Rows[0]["PageIndex"] = pageIndex;
dt.Rows[0]["PageSize"] = pageSize;
dt.Rows[0]["RecordCount"] = cmd.Parameters["@RecordCount"].Value;
ds.Tables.Add(dt);
}
catch (Exception)
{
}
return ds;
}
//Here returning datatable
我的尝试:
我试过从如下通用处理程序中提取图像
< img src =<%#Handler.ashx?companyid =+ Eval(COMPANY_ID) %>中class =img-logo1/>
但是,因为我在gridview中从客户端绑定数据它没有帮助。我已经搜索了更多的代码超过四个小时,但没有得到任何帮助。
我真的非常感谢你的帮助
What I have tried:
I have tried to pull image from generic handler like the following
<img src="<%# "Handler.ashx?companyid="+ Eval("COMPANY_ID") %>" class="img-logo1" />
But Since,I am binding data from client side in gridview it does not help.I have searching the code for more than four hours,but not getting any help.
I will really be very gratefull to you for your help
推荐答案
(' #dvGrid')。show();
var xmlDoc =
('#dvGrid').show(); var xmlDoc =
.parseXML(response.d);
var xml =
.parseXML(response.d); var xml =
(xmlDoc);
var compmst = xml.find( COMPANY_MASTER跨度>);
if (row == null ){
row =
(xmlDoc); var compmst = xml.find("COMPANY_MASTER"); if (row == null) { row =
这篇关于如何在C#中使用jquery从SQL Server(varbinary列)绑定图像的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文