DataTable exceldt=new DataTable();
DataTable nomacdt=new DataTable();
exceldt = exceldt.AsEnumerable().GroupJoin(nomacdt.AsEnumerable(), a => a.Field<String>("COP_G_NO"), b => b.Field<String>("newmachineType"), (a, b) => new
                {

                    G_NO = a.Field<Int32>("G_NO"),
                    COP_G_NO = a.Field<String>("COP_G_NO"),
                    G_QTY = a.Field<String>("G_QTY"),
                    QTY_1 = a.Field<String>("QTY_1"),
                    NET_WT = String.IsNullOrWhiteSpace(a.Field<String>("NET_WT")) ? (nomacdt.Rows.Count > 0 ? b.Select(c => c.Field<Decimal>("NW")).Single().ToString() : a.Field<String>("NET_WT")) : a.Field<String>("NET_WT"),
                    GROSS_WT = String.IsNullOrWhiteSpace(a.Field<String>("GROSS_WT")) ? (nomacdt.Rows.Count > 0 ? b.Select(c => c.Field<Decimal>("GW")).Single().ToString() : a.Field<String>("GROSS_WT")) : a.Field<String>("GROSS_WT"),

                }).ToDataTable();

//十进制转二进制
Console.WriteLine(Convert.ToString(69, 2));
//十进制转八进制
Console.WriteLine(Convert.ToString(69, 8));
//十进制转十六进制
Console.WriteLine(Convert.ToString(69, 16));

//二进制转十进制
Console.WriteLine(Convert.ToInt32(”100111101″, 2));
//八进制转十进制
Console.WriteLine(Convert.ToInt32(”76″, 8));
//十六进制转十进制
Console.WriteLine(Convert.ToInt32(”FF”, 16));

--16进制数"0X00037FFE9994EE5E"转化为10进制:   
select CONVERT(bigint,cast(0X00037FFE9994EE5E as varbinary)) as converted
--或:  
select CONVERT(VARCHAR(50), CONVERT(bigint,0X00037FFE9994EE5E)) as converted

--在一个数据表中用nvarchar来存储该16进制数,用十进制取出
SELECT CONVERT(bigint, CONVERT(varbinary, CAST(N'0x' + N'00037FFE9994EE5E' AS char), 1))

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="WebUserControl1.ascx.cs" Inherits="WebApplication1.WebUserControl1" %>
<form id="form1" runat="server">
    <asp:GridView ID="GridView1" runat="server">
    </asp:GridView>
</form>

            //这里仅仅是手动组装了数据源
            DataTable dt = new DataTable();
            dt.Columns.AddRange(new DataColumn[] { new DataColumn("Column1"), new DataColumn("Column2") });
            DataRow dr = dt.NewRow();
            dr["Column1"] = "1";
            dr["Column2"] = 2;
            dt.Rows.Add(dr);
            //这里才是关键代码
            WebUserControl1 wuc = this.LoadControl("/WebUserControl1.ascx") as WebUserControl1;
            wuc.GridView1.DataSource = dt;
            wuc.GridView1.DataBind();
            Page p = new Page();
            p.Controls.Add(wuc);
            StringWriter tw = new StringWriter();
            HttpContext.Current.Server.Execute(p, tw, false);
            //html就是tw.ToString()啦
            Response.Write(tw.ToString());