|
My method adds parameters to stored procedure as:
public void AddParameter(string StrName, SqlDbType objType, ParameterDirection objDirection)
{
SqlParameter l_Param = new SqlParameter();
l_Param.ParameterName = StrName;
l_Param.SqlDbType = objType;
l_Param.Direction = objDirection;
Command.Parameters.Add(l_Param);
}
public void AddParameter(string strName, SqlDbType objType, ParameterDirection objDirection, object objValue)
{
AddParameter(strName, objType, objDirection);
}
I have send parameters to stored procedure using above method and used ExecuteScaler and ExecuteReader both. But it displays error while executing stored procedure.
|
|
|
|
|
What is the error message?
|
|
|
|
|
|
sharad Pyakurel wrote: SqlParameter l_Param = new SqlParameter();
l_Param.ParameterName = StrName;
l_Param.SqlDbType = objType;
l_Param.Direction = objDirection;
Command.Parameters.Add(l_Param);
Looks like you forgot to add:l_Param.Value
Add:
l_Param.Value = objValue;
You shouldn't be needing the other AddParameter method. All can be done in one.
|
|
|
|
|
For Parameter type Input it works perfectly. But with OUTPUT Parameter Type It Displays following Error in place of ExecuteScaler Method:
String[1]: the Size property has an invalid size of 0.
(Actually I have a Stored Procedure which takes @Amount as input and converts the input in word, here @word in output Parameter. It should convert input amount in word.
Stored Procedure is right. but something wrong with executing from application.
What should i do.
|
|
|
|
|
As per your error message , you should mention the size of outout value (irrespective of in or string whatever your output type). please give a try and let me know.
As an example: if you are exptecting to get "cheers" as a word that appears from @output valiable, then mention "6" as the size of the output parameter along with itoutput parameters type.Thanks,
Arindam D Tewary
|
|
|
|
|
Stored Procedure is executed after specifying the size of output parameter. I unable to get output parameters value as:
string s=ExecuteScaler(cmd);
Parameters value is not retrived in s. But if i cal using
com_parameters[strParameter].value it gives value. I mean it gives single row data.
How can i get OutPut parameters and other datas in tebular form, Like data returned by Select querry.
|
|
|
|
|
Hi
I need out put like this
DEVELOPMENT RESEARCH ADMIN
Subash sdlkjfkerlh fdsgefrghe
Suresh kbkfghkkj cvbfggh
Zjkgkefk ckvlgfkh bfvdnnbdf
,g,fhmh gfhkhk bgfhjgf
COUNTRY STATE XYZ
Subash sdlkjfkerlh fdsgefrghe
Suresh kbkfghkkj cvbfggh
Zjkgkefk ckvlgfkh bfvdnnbdf
,g,fhmh gfhkhk bgfhjgf
Any body idea how to implementment.From database data is fetch from order by header name i.e., DevelopmentSubash
|
|
|
|
|
What is your actual problem ? You can easily render the content either of them. Is there any specific requirment ?
|
|
|
|
|
I have to display an increment number every second in the same web page (.asp) but I don't know how to do it (refresh or update)?
Can anyone help? By the way, I do have a function delay 1 second
|
|
|
|
|
JavaScript. setInterval[^]
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Thanks for the link, it shows as I wanted 
|
|
|
|
|
please help me with
this......
i am trying to read more than 100000 record from my SQLite database very fast.
At the moment it takes 40-45 second to perform a select on the last record.
Does anybody knows the code for vb.net compact framework, to perform this search in less than 5 or 10 seconds?  al hajjaj
|
|
|
|
|
It's not question of the .net code, it's a question of how the data is structured and queried. Are you trying to use any complex joins? Do you have covering indexes? Do you really need to retrieve all 100000 at once? This seems extremely excessive for a mobile application.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hello, This is Vikash Gohil.
I have a problem related to Gridview as mentioned below.
I have a gridview page that displays All data from a table on page load.
Now I have also provided Data Filtering options on the same page for filtering data that is displayed.
Now when the user provides a filter condition, gridview only displays the filtered data.
But once the user clicks on Next or Previous in the Gridview pager, the filter gets removed and the grid again displays all the data.
What I want is the filter condition should remain until the user provides another condition for filtering.
How can I go about doing this.
Anyone can give me some idea.
This would be of great help.
Awaiting a reply, Thanks in Advance.
|
|
|
|
|
VikashGohil wrote: But once the user clicks on Next or Previous in the Gridview pager, the filter gets removed and the grid again displays all the data.
Make sure, you had put this in IsPostback condition. Might be grid is getting rebind with the data.
Filter client side implemented or server side?
|
|
|
|
|
Hello, Sandeep.
Thanks for the reply.
I have Used an SQL DataSource to Bind Data to the Gridview.
Initially I had written the Select Command for DataSource in Page_Load event as follows:
Page_Load(...)
if not page.Ispostback then
SDS.ConnectionString = <ConnectionString>
SDS.SelectCommand = <SQLQuery>
GridView.DataSourceID="SDS"
GridView.DataBind
end if
Now the problem here is when first time the page is loaded, the grid displays properly.
But when the page postback happens the gridview disappears, bcoz there is no selectcommand in the DataSource.
So I have to compulsorily write the above code as below.
Page_Load(...)
SDS.ConnectionString = <ConnectionString>
SDS.SelectCommand = <SQLQuery>
GridView.DataSourceID="SDS"
GridView.DataBind
if not page.Ispostback then
end if
And what do you mean by saying Filtering Client-Side or Server-Side, could you explain a bit about both types.
Thanks in Advance, awaiting a reply soon.
|
|
|
|
|
If you have a Next, Previous button you should be having PageIndexChange event for that GridView. In that event handler you need to "rebind" the data with filter condion that has already been selected. So you need to Save the select query too (using any session management technique ie. ViewState, Hidden field, session variable per your requirement.
Hope this helps,Thanks,
Arindam D Tewary
|
|
|
|
|
how to open ms word from asp.net with c#, give me the simple example which helps me.
|
|
|
|
|
|
|
|
i have the table fields in sql server
username nvarchar(50),
emailid nvarchar(50),
startdate datetime,
enddate datetime,
before 10 days of enddate i have to send the automatic email to the user .using asp.net with c#. can you give example which helps me
|
|
|
|
|
|
Hi,
Set up a sql job to send emails. Write a stored procedure and put the logic to send the email. Create a new sql job and associate the stored procedure with it. Hope this helps.
There is no foolish question, there is no final answer...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
