Assigning a value to const int

Hello,

I want to select all the values from a table in my database and then put each value in order into labels that are on the asp page.

I can Select all the values from that database fine but I am rather stuck as how to put the values into the individual labels? Here is the code I have connecting to my database.

  Dim cmd As New SqlCommand
     
        Try
            Dim myConnection As New SqlConnection("Data Source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\Alerts.mdf;User Instance=true")

            myConnection.Open()
            cmd.Connection = myConnection
            cmd.CommandText = "SELECT DateTime, Description FROM EmailTemplateLoad"

                cmd.ExecuteNonQuery()

        Catch ex As Exception

        End Try

How can I put the DateTime value into Label1 and the Decription into Label2??

I have had a nose about but can't seem to find the information I need.

Any pointers greatly appreciated.

ISSUE:

I am using an ASP webservice to return a jagged array.  I need to be able to define the tags names in the XML which is returned.  How do I do this?

Code and Example XML follow.

        CODE:

        SQLDataAdapter.Fill(dtResult);

        orderListId = new string[100];
        orderListTime = new string[100];
        orderListEmail = new string[100];
        orderListStatus = new string[100];
        orderListSubtotal = new string[100];

        int orderCount = 0;
        foreach (DataRow drRow in dtResult.Rows)
        {
            orderListId[orderCount] = (drRow["SubmittedFormId"].ToString());
            orderListTime[orderCount] = (drRow["SubmitTime"].ToString());
            orderListEmail[orderCount] = (drRow[&quo

Hi All,

I'm using VS C# express with SQL 2005 express.

I have the following problem:

I would like to assign database roles in a given database for a login by using smo. Let's say:

I have a Login, created with smo named MyLogin and a database name MyDatabase.

How can I map MyLogin to MyDatabase and give for example db_datawriter database role membership for it, using SMO?

I do not find the way, propably I miss something...

Any help is highly appreciated, I would be thanksfull if one could give a code example to solve this.

Regards,

Lacko

hi all ;

i ve a string like

var Ans="a<br>b<br>c";

wen i assigned input using document.getElementById(id).value = Ans;

it display input as it is

i wanna show input lyk 

a

b

c

i am tryin to replace <br>wit "\n" but it is not working... it is showing 

a<br>b<br>c or

a\nb\nc\n

I have a Script Component and in it I want to assign a value from a row to a variable. I am iterating through a For Each Loop, so I am only getting 1 row at a time. I have a variable declared as ScriptedSaleID and the following code in my Input0_ProcessinputRow method: