如何在C＃中使用jquery从SQL Server（varbinary列）绑定图像 [英] How to bind image from SQL server (varbinary column) using jquery in C#

问题描述

这是我的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屋！