Hi
i need to perform a calculation in my code and i need the values to be retrived from Table1, so far i took this approach:
[code]
Dim con AsNew SqlConnection(ConfigurationManager.ConnectionStrin gs("test").ConnectionString)
Dim cmdd AsNew SqlCommand("select NumberEmailSent from Users Where Name= @Name")
cmdd.Parameters.Add("@Name", Data.SqlDbType.NVarChar, 50).Value = Me.Label4.Text
cmdd.Connection = con
con.Open()
cmdd.ExecuteNonQuery()

con.Close()
???????????

[code/]

This code get ste value but i don know how to store it in a variable so i can perform the calculation.

the calculation gonna be (NumberEmailSend * Payrate1)
thanks

__________________
bx

Can anybody provide me list of questions and answers of Silver Light 2.0 for interview.

Thanks in Advance,
Prashant

Hi there,

ExecuteNonQuery executes a query on the server but returns no results. It's used for statements like DELETE and INSERT that don't return data.

You'll need to use ExecuteScalar (for a single value) or ExecuteReader (for a result set) instead. Check out the ADO.NET quick starts for more info: http://www.dotnetjunkies.com/quickst...ldtreader.aspx

Cheers.

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!