I have an output of a stored procedure thats declared as @message

depending on when it is used a different message should be seen.

-customer added
-already exists
-get help

the returned value for @message needs to come back

how would i accomplish this with a new pop up box?

So you use your asp.net code to call the SQL stored pocedure, retrieve and store your @message as a variable( say String retrievedMessage).
Next you script the popup box and set the text of that popupbox to retrievedMessage.
You can use the javascript alert() box if you like (easy), or launch a new popup window (harder, see http://www.velocityreviews.com/forum...in-aspnet.html ).

So the best route to go is the Alert box?

sorry i am still new to this the link you gave me is for the easy way right?

Spawning an alert box from inside an ASP.NET page is simple:

string sJavaScript;
string sMessage = "your message";

sJavaScript = "<script language='javascript'>";
sJavaScript += "alert('" + sMessage +"');";
sJavaScript += "</scr" + "ipt>";
Response.Write(sJavaScript);

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

GREAT!!

so how would I populate that box with my output from my stored procedure?

its declared as @message

(I know its very creative, but I am just learning)

I would imagine it would be a cmd.Parameter.IdontKnow

basically i am using VB and dont know how to get my OUTPUT

I have the Data entry down LOL

Something like this:
cmd.Parameters.Add("@message", SqlDbType.VarChar, [length])
cmd.Parameters("@message").Direction = ParameterDirection.Output

then you would call
cmd.ExecuteNonQuery() (or whatever method you are using)

and then
Dim sMessage as String = Convert.ToString(cmd.Parameters("@message").Value)

hth.


================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

sorry, I think i am missing something like an Imports

I am getting an "end of statement expected" on
SqlDbType.VarChar, [200])

and on
ParamaterDirection.output
its telling me Name "ParameterDirection" not Declared?

how would i declare that?

Thanks again!

This code compiles fine as i just tested it:

        cmd.Parameters.Add(New SqlParameter("@message", SqlDbType.VarChar, 200))
        cmd.Parameters("@message").Direction = ParameterDirection.Output

My Imports are System.Data and System.Data.SqlClient (In the case of the latter, you will use the namespace that correlates to your database)

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

I am very thankful!

just to clarify =)

i have this

Bunch of declarations
Dim Message As String = lblMessage

Using Conn As New SqlConnection ETC ETC

Conn.Open
Dim cmd As New SqlCommand ("AddCustomer", Conn)
Cmd.CommandType = Data.Comandtype.StoredProcedure

Bunch of parameters

cmd.Parameters.Add(New SqlParameter("@message", SqlDbType.VarChar, 200))
cmd.Parameters("@message").Direction = ParameterDirection.Output

cmd.ExecuteNonQUery()->what is this called so i can look it up and others like it

Dim sMessage As String = Convert.ToString (cmd.Parameters("@message",Value))

I am getting "Value is not a member of String on "@message.Value"

Thanks again

i just need to understand it then i wont ask again you know what i mean?

Your code is wrong, it should be:
Dim sMessage as String = Convert.ToString(cmd.Parameters("@message").Value) (Value is a property, you are trying to supply it as a parameter)

ExecuteNonQuery is called just that, and is used to execute querys (UPDATE, DELETE, INSERT) that do not return a result set. By result set I mean you do not call a SELECT statement to return a bunch of data.

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========