results of a query 1

[cmsbuffet]

Dim command As String
        command = "Select @ZipcodeID As ZipcodeID"
        Page.Response.Write(" " + command + " ")
        Dim cmd As SqlCommand
        cmd = New SqlCommand(command)
        Page.Response.Write(" " + command + " ")
       
        cmd.Parameters.AddWithValue("@ZipcodeID", TextBoxZipcode.Text)
        Page.Response.Write(" " + TextBoxZipcode.Text + " ")
page.response.write ( Here syntax of the result of the query )

How do I do the last line? Perhaps, a table, but how? Thanks.

 

[jbenson001]

You have to get your results into an object, like a dataset or a datatable. Then you can bind that object to a control like a datagrid, repeater, datalist, etc.

 

[cmsbuffet]

Ok. Would that be helpful? If yes, then how?

http://www.aspnettutorials.com/tutorials/controls/data-table-vb.aspx

Thanks.

 

[jbenson001]

Not really, because you have to query the database first, and get that resultset into a dataset/datatable.

Look into this first:

http://www.microsoft.com/downloads/...0a-9877-4a7b-88ec-0426b48df275&displaylang=en

This is a dataaccess block that will help you connect to your database and get/update insert data etc. Once you have the results, you can bind to the grid, repeater etc.

 

[cmsbuffet]

Are there any tutorials on how to use dataaccess block that could be helpful?

 

[jbenson001]

Google is your friend

 

[cmsbuffet]

I downloaded DAAB. Found a tutorial. The tutorial uses syntax

try{
}catch(Exception ex){
}
end try

As in Java. But the correct syntax in ASP is

  Try
  Catch(Exception ex)

            trow ex;

        End Try

Yet, this does give errors too. Weird. What do I do?

 

[cmsbuffet]

The code below suggest to do something with data reader, what can I do with it?

Database db = DatabaseFactory.CreateDatabase();

string query = "Select * from Customers Where CustomerID = @CustomerID";

DBCommandWrapper command = db.GetSqlStringCommandWrapper(query);

command.AddInParameter("@CustomerID", DbType.String, id);

using (IDataReader reader = db.ExecuteReader(command))
{
    // Do Something...
}

 

[ca8msm]

There are lots of things you could do with it. I suggest you start by going through some of the tutorials from

http://asp.net/learn.

Mark,

[URL unfurl="true"]http://lessthandot.com[/url] - Experts, Information, Ideas & Knowledge
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Website Design
[URL unfurl="true"]http://aspnetlibrary.com[/url] - An online resource for professional ASP.NET developers