Hi..
I want to have a multivalue parameter in my report... I have selected that parameter and clicked on multivalue and then when i run the report.. it works fine for one and and not for more than one...
any help will be appreciated.
Regards
Karen
Karen, a question, how is your multivalue parameter used in your datasource? It should be :
SELECT *
FROM HELLO_DATA
WHERE COLUMN1 IN (@.MULTIVALUEPARAMETER1)
Hope this helps,
thanks i figured it out and now it works fine.
Regards
Karen
sqlSet the Direction property of your Parameter.
Dim myParamAs New SqlParameter' ... set value, name, etc.' if you are sending a value (Default)myParam.Direction = ParameterDirection.Input' if you are requesting a value (assigned in SQL)myParam.Direction = ParameterDirection.Output' if you are sending a value AND requesting' it's changed valuemyParam.Direction = ParameterDirectioin.InputOutput' If you want the return code for the SQLmyParam.Direction = ParameterDirection.ReturnValue|||
no that doesn't work. i know how to use parameters, but i have only ever seen the Output Parameter used withcommand.executenonquery()when inserting data, but this is no good to me because I am only usingdataAdapter.Fill(myDataset)
how do i get the OutPut Parameter with only filling a dataset?
Theoretically, after your call todataAdapter.Fill(myDataset)
the out parameter should be accessible using
dataAdapter.SelectCommand.Parameters("paramname")
I haven't tried it out though.
|||Yes, this should work. I believe everything is copied by reference, though, when you add a parameter to a command, then a command to an adapter. Thus, you should still be able to use the original parameter.
'after dataadapter.fill()Dim strValueAs String = myParam.Value|||I posted some sample code here. Check if it helps:http://forums.asp.net/thread/1478830.aspx|||thanks that works
this is the sp:
CREATE PROCEDURE spInsertNews
@.uidArticleId uniqueidentifier OUTPUT,
@.strHeading nvarchar(300),
@.strAbstract nvarchar(600),
@.strText nvarchar(4000),
@.dtDate datetime,
@.dtDateStart datetime,
@.dtDateStop datetime,
@.strAuthor nvarchar(200),
@.strAuthorEmail nvarchar(200),
@.strKeywords nvarchar(400)
AS
SET @.uidArticleId = newid()
INSERT INTO tblArticles
VALUES(@.uidArticleId ,@.strHeading,@.strAbstract,@.strText,@.dtDate,@.dtDateStart,@.dtDateStop,@.strAuthor,@.strAuthorEmail,@.strKeywords)
my asp code is something like this:
...
SqlCommand sqlcmdInsertNewsArticle = new SqlCommand(insertCmd, sqlconCon);
sqlcmdInsertNewsArticle.Parameters.Add(new SqlParameter("@.strHeading", SqlDbType.NVarChar, 300));
sqlcmdInsertNewsArticle.Parameters["@.strHeading"].Value = strHeading.Text;
sqlcmdInsertNewsArticle.Parameters.Add(new SqlParameter("@.strAbstract", SqlDbType.NVarChar, 600));
sqlcmdInsertNewsArticle.Parameters["@.strAbstract"].Value = strAbstract.Text;
sqlcmdInsertNewsArticle.Parameters.Add(new SqlParameter("@.strText", SqlDbType.NVarChar, 4000));
sqlcmdInsertNewsArticle.Parameters["@.strText"].Value = strText.Text;
...
sqlcmdInsertNewsArticle.Connection.Open();
sqlcmdInsertNewsArticle.ExecuteNonQuery();
sqlcmdInsertNewsArticle.Connection.Close();
How do I do if I want to catch the OUTPUT-parameter (@.uidArticleId)?
anyone?Start by defining another parameter in the Parameters collection:
sqlcmdInsertNewsArticle.Parameters.Add(new SqlParameter("@.uidArticleId", SqlDbType.UniqueIdentifier));
sqlcmdInsertNewsArticle.Parameters["@.uidArticleId"].Direction = ParameterDirection.Output;
Then, after you call ExecuteNonQuery, grab the value of that parameter:
Dim id as GUID = sqlcmdInsertNewsArticle.Parameters["@.uidArticleId"].Value;
I didn't test this code so you may need to tweak it, but that's the idea.
Don|||thanks... that would probably work if I just could get the %#&¤ connection to work... :)
(see: http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=553656 )
I am trying to set the property of 1 parameter based on the results of another parameter.
For example:
Parameters: PA and PB
If the user selects All or multiple values for PA
Then PB should not be MultiValue
Otherwise PB should be MultiValue
Does anyone have any suggestions?
Thanks
You could make PB MulitValue always, but have it's dataset filtered based on the PA parameter values. You just have to make sure PA comes first in your parameters list.
Hope that helps.
