JavaScript

<pre lang="c#"> protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
         
            
           JavaScriptSerializer jss = new JavaScriptSerializer();

           ClientScript.RegisterStartupScript(this.GetType(), "TestInitPageScript",
               string.Format("<script type=\"text/javascript\">drawVisualization({0},'{1}','{2}');</script>",
               jss.Serialize(GetData()),
                "Text Example",
                "Name,type,"));

        }
    }

    [WebMethod]
    public static List<Data> GetData()
    {
        SqlConnection conn = new SqlConnection("Data Source=84.18.208.130;Initial Catalog=cdw;Persist Security Info=True;User ID=cdwadmin;Password=remote8313");                                                                                                  
        DataSet ds = new DataSet();
        DataTable dt = new DataTable();
        conn.Open();
        string cmdstr = "select top 100 Name, [Decimal price],Cover from [dbo].[database_BWICs]";
        SqlCommand cmd = new SqlCommand(cmdstr, conn);
        SqlDataAdapter adp = new SqlDataAdapter(cmd);
        adp.Fill(ds);
        dt = ds.Tables[0];
        List<Data> dataList = new List<Data>();
        string cat="";
        float val=0;
        string typ = "";
        
        foreach (DataRow dr in dt.Rows)
        {
            try
            {
                cat = dr[0].ToString();

                val = Convert.ToInt32(dr[1]);

                typ = dr[2].ToString();

            }
            catch
            {
            }
            dataList.Add(new Data(cat, val, typ));
        }
        return dataList;
    }

ClientScript.RegisterStartupScript(this.GetType(), "TestInitPageScript",
    string.Format("<script type=\"text/javascript\">google.load('visualization','1.0',{'packages':['corechart','controls']});google.setOnLoadCallback(function(){drawVisualization({0},'{1}','{2}');});</script>",
    jss.Serialize(GetData()),
    "Text Example",
    "Name,type,"));

public class test
{
    public string ColumnName = "";
    public float Value = 0;
    public string Type = "";
    public DateTime Date = DateTime.Now;

    public test(string columnName, float value, string type, DateTime date)
    {
        ColumnName = columnName;
        Value = value;
        Type = type;
        Date = date;
    }

    var yesterday = DateTime.Today.AddDays(-1);
    string cmdstr = "select top 500 Name, [Decimal price],Cover, UploadDate from [dbo].[database]";
    SqlCommand cmd = new SqlCommand(cmdstr, conn);
    SqlDataAdapter adp = new SqlDataAdapter(cmd);
    adp.Fill(ds);
    dt = ds.Tables[0];
    List<test> dataList = new List<test>();
    string cat = "";
    float val = 0;
    string typ = "";
    DateTime dat = DateTime.Now;

    //dat.ToString("ddmmYYYY", System.Globalization.CultureInfo.InvariantCulture);

    foreach (DataRow dr in dt.Rows)
    {
        try
        {
            cat = dr[0].ToString();

            val = Convert.ToInt32(dr[1]);

            typ = dr[2].ToString();

            dat = (DateTime)dr[3];

        }
        catch
        {
        }
        dataList.Add(new test(cat, val, typ, dat));
    }
    return dataList;
}

function drawVisualization(dataValues, chartTitle, columnNames, categoryCaption) {
        if (dataValues.length < 1)
            return;

        var data = new google.visualization.DataTable();
        data.addColumn('string', columnNames.split(',')[0]);
        data.addColumn('number', columnNames.split(',')[1]);
        data.addColumn('string', columnNames.split(',')[2]);
        data.addColumn('datetime', columnNames.split(',')[3]);

        for (var i = 0; i < dataValues.length; i++) {

            //var dateTimeString = "\/Date(1358294400000)\/";
            //var dateTime = new Date(parseInt(dateTimeString.split("/"[\(\)]/)[3]));

            var date = new Date(parseInt(dataValues[i].Date.substr(6), 10));

           // var dateString = dataValues[i].Date.substr(6);
            //var currentTime = new Date(parseInt(dateString));
          //  var date = new Date(parseInt(dateString));
            //var month = currentTime.getMonth() + 1;
           // var day = currentTime.getDate();
           // var year = currentTime.getFullYear();
           // var date = day + "/" + month + "/" + year;

           
            //var date = new Date(parseInt(jsonDate.substr(6)));
            //var date = new Date(new Number(jsonDate.replace(/(^.*\()|([+-].*$)/g, '')));
            //var date = eval(jsonDate.replace(/\/Date\((\d+)\)\//gi, "new Date($1)"));
            alert(date);

            data.addRow([dataValues[i].ColumnName, dataValues[i].Value, dataValues[i].Type, date]);
            
        }

        // Define a Pie chart
        var pie = new google.visualization.ChartWrapper({
            'chartType': 'LineChart',
            'containerId': 'PieChartContainer',
            'options': {
                'width': 950,
                'height': 450,
                'legend': 'right',
                'hAxis': {
                 'format': "dd-MMM-yyyy",
                 'maxValue': date (2013, 01, 16), 'minValue': date (2013, 01, 17), 'viewWindow':{'max': date (2013, 01, 17)}},
                'title': chartTitle,
                'chartArea': { 'left': 100, 'top': 100, 'right': 0, 'bottom': 100 },
                'pieSliceText': 'label',
                'tooltip': { 'text': 'percentage' }
            },
            'view': { 'columns': [3, 1] }
        });

Member 10573384 wrote:

so they tell me threw bing map

<div id="fileDisplayArea">
    <img src="GetImageHandler.ashx" />
</div>

System.Byte[]

Dim imageBytes As Byte() = DirectCast(sdr(2), Byte())
context.Response.BinaryWrite(imageBytes)

• You should wrap the SqlDataReader in a Using block.
• You don't need to check sdr.HasRows before calling the sdr.Read() method.
• Since you're only returning one record, you can replace the While sdr.Read() ... End While block with an If sdr.Read() Then ... End If block.
• You should probably set the status code to 404 if you don't find an image to return.
• I'm not sure what you're doing with the ArrayList variable; you seem to store things in it, but never use it. You also have an unused DataSet variable at the top of your method.

Sub ProcessRequest(ByVal context As HttpContext) Implements IHttpHandler.ProcessRequest
    Using con As New SqlConnection(GetConnectionString("myconnection"))
        Using cmd As New SqlCommand()
            cmd.CommandType = CommandType.StoredProcedure
            cmd.CommandText = "spRFIDocumentByRequestIDSelect"
            cmd.Parameters.AddWithValue("@pRequestID", 531)
            cmd.Connection = con
            
            con.Open()
            
            Using sdr As SqlDataReader = cmd.ExecuteReader()
                If srd.Read()
                    Dim imageBytes As Byte() = DirectCast(sdr(2), Byte())
                    
                    context.Response.ContentType = "image/jpeg"
                    context.Response.BinaryWrite(imageBytes)
                Else
                    context.Response.StatusCode = 404
                End If
            End Using
        End Using
    End Using
End Sub