ASP.NET

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";

hasani2007 wrote:

When I buy domain and host what should I do to use databases and is database on my hard drive or it's on the server?

public DataTable aggiorna()
{
     string IDModelloQ = Request.QueryString["IDModelloV"];
     string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
     string query = "SELECT * FROM Automobili WHERE IDModello = @IDModelloQ";
     DataTable table = new DataTable();
     using(SqlConnection connessione = new SqlConnection(connectionString))
     using(SqlCommand comando = new SqlCommand(query, connessione))
     {
         comando.Parameters.AddWithValue("@IDModelloQ", IDModelloQ);
         SqlDataAdapter adapter = new SqlDataAdapter();
         adapter.SelectCommand = comando;
         adapter.Fill(table);
     }
     return table;
}

catch (Exception ex)
{
   throw ex;
}