to my knowledge this can be done only using trigger. Regards KP

Try the following code:- Dim ds As New DataSet("Account") Dim dt As New DataTable("Account") dt.Columns.Add("FName", GetType(System.String)) dt.Columns.Add("LName", GetType(System.String)) dt.Columns.Add("Salary", GetType(System.String)) Dim dr As DataRow = dt.NewRow() dr("FName") = "Suresh" dr("LName") = "Dayma" dr("Salary") = "30300" dt.Rows.Add(dr) Dim dv As DataView = New DataView(dt) ds = dv.Container Thanks & regards, Suresh Dayma Thanks & regards, Suresh Dayma Everything Is Possible!

You have to iterate through all the items of the datagrid and then you can find the other dropdown list(findcontrol method) and populate that. Best Regards, Apurva Kaushal

Don't bother; it's a waste of time. You're doing an arbitrary query on text in the middle of a bunch of strings. Short of rearranging your data, the only significant optimization you're going to get is by throwing more hardware at it. What does the schema or the rest of the data in the data set look like? Maybe there's some optimization based on the sequences your're looking for vs. the sequences in the data set. It's unlikely, though.

Check the image path. it must localhost change it to a virtual path like "../images/xyz.png" Regards. Sudhakar D P

What report server?? What are you using to generate reports? RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Install VS 2005 and SQL Server 2005 - gotta go to 2005 sometime. ...Steve 1. quod erat demonstrandum 2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once :-) (Translation: I'll show you the way, but not write the code for you.)

since your datasource is "server" I assume it's a different machine? if that's the case, have you recently installed SP2 or SP1 (in Server 2003)? They change the security model and as a result you won't be able to connect to sql server over a network connection unless you tweak some settings. Search for SP2 in Microsoft and then SQL Server and you will find a work around. If it's not SP 2, then there is some problem with your connection, or SQL server is not running, or the database NIA is not started, there are a number of reasons why this can happen.

Hi there, You might have a look at a great article[^] authored by Mike Ellison, also clickety[^]

Are you using the SqlCommand object? A SqlCommand object has a CommandTimeout property which is independant of the "Connect Timeout" property in the connection string which I believe defaults to 30 seconds. If you are using a SqlCommand, change this property as wel as that in the connection string. Rhys The use of COBOL cripples the mind; its teaching should, therefore, be regarded as a criminal offense Edsgar Dijkstra If life were fair, Dan Quayle would be making a living asking 'Do you want fries with that?' John Cleese

Hi there, When you export the datagrid control to excel, you basically render the control and send the output html markup to the the client side. When the datagrid control is rendered, it also renders its child controls, and there are a couple of controls like LinkButton .... that require to be placed in a server form when they render. So in this case, you need to clear those controls before exporting, you can have a look at an example from here[^]. Another way is to use a second datagrid that simply contains the controls for display like label ... only to do the exporting.

Hi!!!! U can Enjoy with this..... http://msdn.microsoft.com/library/default.asp?url=/library/en-s/tsqlref/ts\_fa-fz\_9yuk.asp Regrads Shashank under2811@yahoo.co.in

that's right above

Smita, Check out CommunityServer http://www.communityserver.org/[^] or .Text WebLogs http://www.gotdotnet.com/Workspaces/Workspace.aspx?id=e99fccb3-1a8c-42b5-90ee-348f6b77c407[^] Vasudevan Deepak Kumar Personal Web: http://www.lavanyadeepak.tk/ I Blog At: http://deepak.blogdrive.com/

How do i do that

Well - withouth the error-message(s) it would be hard to guess, but my bet is that they all access the same database/datasource and deadlock eachother yeilding various errors..... but it is a guess. --------------------------- 127.0.0.1 - Sweet 127.0.0.1

(1) How can i hide a database to be listed in sql enterprise manager ? Just Detach the Database in the Enterprise Manager. (2) How can i prevent data from being deleted in a table through enterprise manager ? Remove the permission from the user REVOKE priv_type [(column_list)] [, priv_type [(column_list)]] ... ON [object_type] {tbl_name | * | *.* | db_name.*} FROM user [, user] ... REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ...