|
I do not personally use stored procedures, but I'm thinking that instead of doing a cmd.ExecuteNonQuery you are going to want to
- declare a DataAdapter object,
- set it's command object to your cmd variable,
- use it's .Fill method to fill a new DataTable object
- and set your grid's .DataSource property to the DataTable.
Hope this helps.
|
|
|
|
|
Dim da as new sqldataAdapter
da.sqlcommand = cmd
conn.open
dim dt as new datatable
da.fill(dt)
gridview.datasour = dt
gridview.databind()
You can also bind to an sqldatareader which is more efficient.
|
|
|
|
|
da.sqlcommand is not valid. how about da.selectcommand?
|
|
|
|
|
Does anybody know of a way to extract the parameter values given at runtime to the crystal report viewer? For example, if I load a report into the viewer that contains parameters, I will be prompted to enter parameter values via the CRV.
These values are then used in the selection criteria of the report. If I wanted to print the values into the text property of a label, how could I access those values? (I actually want to do something else with them, but this would be
the simpliest way to explain). I have been unsuccessful locating any documentation on this. I am using VS2005 ASP.Net, VB, Version 10.2.36 Crystal Assemblies.
Basically, the built in print and export options of the Crystal Report viewer are slow and clunky. I need another way to do it, but when I try to print a parameterized report I recieve an error indicating the parameters are missing. I need to bring the parameters from the viewer into my "export to stream".
Thanks
|
|
|
|
|
I'm using the MaskEdit and have a question.
I'm using a mask like 99/99/9999 on a textbox which works great.
I keep the mask after focus is lost as I save the data to the database that way.
However, if the user deletes their entry the textbox text is "__/__/____". I'd prefer the textbox just to be blank.
I know there is a way to keep the mask if a value has been entered but discard it if the entry has been deleted (I see it done on the Atlast Control Toolkit example site).
Does anyone know how this is done ?
Thanks.
|
|
|
|
|
Hi,
I have the following maps in hand
Country map - India map
States map - All the states inside the country.
I am developing a tourist website. My requirements are as follows
1. I want to show the destinations on the map - Like all the hill
stations on the country and its highlighted may be in small dots with hill
names
2. I want to show the state maps when user selects from the country.
Inside the state user will have the tourist destinations thats also to be highlighted.
3. when the user selects the destination, user will have the details about
the destinations and the hotels available in the particular destination.
Will it possible to do this programmatically through x,y coordinates as I am having the images of country and states,
or I have to go the other way?
what is the right way to do this requirement. Please suggest.
Thanks
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
Try having a look at Google Maps as they provide some good functionality.
|
|
|
|
|
I want to start programming whith ASP.NET,and i dont know how should i start doing that!
Khodadad Pakdaman
|
|
|
|
|
go to www.w3schools.com and start from there.
|
|
|
|
|
wrote: I want to start programming whith ASP.NET,and i dont know how should i start doing that!
Quick Start[ ^]
Knock out 't' from can't,
You can if you think you can
|
|
|
|
|
i m creating an online editor and need to generate a context menu the way ms word do in order to give options for the spell errors how can i generate this context menu
|
|
|
|
|
My problem is to open design view of report so that end user can design report acording to his choice...
is it possible to open design view of rdlc or crystal report at runtime to give control to end user.
sweety
|
|
|
|
|
Hello,
I am developing application which upload the mp3 files using input control of file type in ASP.NET 1.1 framework.
In that I want to apply filter on that so that user can only select mp3 files.
Please let me know if any have solution.
Swapnil Bhavsar
-- modified at 9:00 Tuesday 20th March, 2007
|
|
|
|
|
You'll have to check the file extension in your ASP.NET code once the file has been uploaded.
|
|
|
|
|
Hi all, I new to the web development side so please be patient.
I want to track users as they progress through the site, selections they have made and settings they have changed.
So I had a class with static variable keeping track of that, but the problem with that is when a second user accesses the site it overwrite all the values to what the second user has made, how can I keep that unique for each user?
If you can just give me an indication of what I should use I will be able to find out how to use it.
Thanks in advance
He who laughs last is a bit on the slow side
|
|
|
|
|
Use session variables for each user
|
|
|
|
|
thanks
He who laughs last is a bit on the slow side
|
|
|
|
|
No probs. Quick example if you don't know how to use them:
To add them:
Session.Add("username","bob")
To retrieve them:
Label1.Text = Session.Item("username")
|
|
|
|
|
Thanks, got a hopefully good article from here[^]
He who laughs last is a bit on the slow side
|
|
|
|
|
hi to all,
i have created a web application which is running successfully on local machine. i have copy my application through copy website option. but its not running on the server .
please help me , its urgent.
|
|
|
|
|
You'll have to provide more information than "its not running on the server". That could mean anything.
|
|
|
|
|
dotnethunk wrote: hi to all,
i have created a web application which is running successfully on local machine. i have copy my application through copy website option. but its not running on the server .
please help me , its urgent.
try with publish website.
Knock out 't' from can't,
You can if you think you can
|
|
|
|
|
Hi,
How can we get data or characters which is present on image.Actually i have captcha images in .JPEG extension and from that images i have to remove noise, extract the characters and then i have to convert the extracted characters in to string.So please give some idea how to proceed further.
|
|
|
|
|
how can i print the data from datagrid?
i try by using div for datagrid
its shows some error..
plz help me..
thks..
|
|
|
|
|
Hi,
I've a TreeView(IE WebControl and a Grid Controls in my WebForm. I want to Load Grid according to the Tree node selection.
I wrote some Javascript coding to get the selectedNode value(not available directly in treeview events, because I'm using VS.Net 2003).So with respect to selected node, the corresponding child Nodes should be displayed in the DataGrid(which is accessing from Data Table with some conditions, stored procedures).
Pls tell me how can i invoke the C# code behind function LoadGrid(), in my JavaScript function selectNode(), Im very thankful to u If i got an answer.
Satheesh
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
