|
Updated! that didn't mean the way you took... yet!
BTW: I thought every member of CP is a contributor and very much a part of CP...modified on Sunday, March 14, 2010 1:00 PM
|
|
|
|
|
i want the same solution in asp.net with c# in web application not in windows application
|
|
|
|
|
It would be same as you would delete any other record from the database. A quick google search should reveal it.
|
|
|
|
|
hi, iam using asp.net 2.0 with c# with ajax and database is sql server.
so when iam using a textbox control when user enter the any part of column or any filed in the text box it should come like popup in the textbox from database . can you give me a simple example which helps me.
|
|
|
|
|
developerit wrote: when iam using a textbox control when user enter the any part of column or any filed in the text box it should come like popup in the textbox from database
Can you clearer? It's really difficult to understand what you are trying to ask right now.
like: Where from column came into question when talking of textbox? What do you mean by, field in textbox should come like popup in textbox from database?
Elaborate a little and tell where DB comes into picture and what exactly needs to be displayed in the popup?
|
|
|
|
|
iam having table fields in sql server
branchname nvarchar
address nvarchar
emailid nvarchar
phoneno nvarchar
mobileno nvarchar
iam having textbox in asp.net when user enter any value either branchname oraddress or emailid or phone no or mobileno the solution should comes like autocomplete extender . popup should come in textbox text
using asp.net with c#. give me a example which helps me.
|
|
|
|
|
|
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
|
|
|
|