ASP.NET

WBGT.DAL.dsWBGT = new dsWBGT();

Illegal Operation wrote:

My question is how can I access the dataset in the DAL?

Mark Nischalke wrote:

I would suggest you contact godaddy technical support.

<br />
da = New SqlDataAdapter(sQuery, Conn)<br />
        da.Fill(ds)<br />
        Dim GridView1 As New GridView<br />
        GridView1.AllowPaging = False<br />
        GridView1.DataSource = ds<br />
        GridView1.DataBind()<br />
        Response.Clear()<br />
        Response.Buffer = True<br />
Response.AddHeader("content-disposition", "attachment;filename=Report.csv")<br />
        Response.Charset = ""<br />
        Response.ContentType = "application/text"<br />
        Dim sb As New StringBuilder()<br />
<br />
        For k As Integer = 0 To ds.Tables(0).Columns.Count - 1<br />
             sb.Append(ds.Tables(0).Columns(k).ColumnName + ","c)<br />
            <br />
        Next<br />
       sb.Append(vbCr & vbLf)<br />
        For i As Integer = 0 To ds.Tables(0).Rows.Count - 1<br />
<br />
            For k As Integer = 0 To ds.Tables(0).Columns.Count - 1<br />
                'add separator <br />
                'sb.Append(ds.Tables(0).Rows(i)(k).ToString().Replace(",", ";") + ","c)<br />
                sb.Append(ds.Tables(0).Rows(i)(k).ToString() + ",")<br />
            Next<br />
            'append new line <br />
            sb.Append(vbCr & vbLf)<br />
        Next<br />
        Response.Output.Write(sb.ToString())<br />
        Response.Flush()<br />
        Response.End()<br />

Response.ContentEncoding = Encoding.UTF8;
Response.Charset = "UTF-8";

Response.ContentEncoding = Encoding.UTF8;
Response.Charset = "UTF-8";