Please don't post the same questions to multiple forums, its justs encourges other developers to ignore you. Blog Have I http:\\www.frankkerrigan.com

Do you have to use cursors 99% of the time you don't. What are you trying to do ? Blog Have I http:\\www.frankkerrigan.com

param thaker wrote: I want to create a table in which , i want to declare some fields as encrypted at the time of creation so that tha data entered in that fields could not be seen by anybody . This is not possible in SQL Server 2000. It may be possible in SQL Server 2005, but I doubt it. Certainly you could use CLR stored procedures to encrypt and decrypt data, however doing so on key or indexed columns is not advisable because it will dramatically hurt the performance of your database. Upcoming Scottish Developers events: * We are starting a series of events in Glasgow in 2007. Are you interested in a particular subject, or as a speaker? * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog | Photos

here is a FREE Password Has library for .NET projects. http://passwordhash.jassimrahma.com[^] Regards, Jassim www.JassimRahma.com Technology News @ www.JassimRahma.com

hi, use the follwing code in section and change the text in BOLD to your values javascript:window.open('http://www.YOUR URL.com','YOUR PAGE TITLE','width=570,height=650,top='+((screen.height/2)-(NaN))+',left='+((screen.width/2)-(NaN))+',toolbar=no,scrollbars=no,resizable=no,menubar=no,status=no,directories=no,location=no'); Regards, Kapil Thakur (Where's there is Kapil , there is a way) - thakur.kapil@gmail.com </x-turndown>

You can write following code on SelectedIndexChanged event of first dropdown list. and then load the data based on first dropdown's detail. and in second drop down keep AutoPostback off. /***************************** Code ************************************* Protected Sub Dropdown1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles SelectCmpCmb.SelectedIndexChanged Dim str As String str = "Select CompanyName from Company where CompanyName = '" & dropdown1.Text & "'" (Name of your first dropdown list) dropdown2.DataSource = dbaccess.ExecuteDataReader(str) dropdown2.DataTextField = "GroupName" dropdown2.DataBind() End Sub Note : Here dropdown1 is name of first dropdown list. and dropdown2 is name of second dropdown list. I hope this will help you.

use to store value in cookie and use it another page

This you can do in onitemdatabound event of the datagrid. There you have to find the control and then insert one item at the top of it, like this: DropDownList1.Items.Insert(0, New ListItem("select", "0")) Best Regards, Apurva Kaushal

hai its working out,i checked string value1="123 test"; DataGrid1.DataSource=value1; DataGrid1.DataBind(); with regards

What is the Error Message.

Hi... Please go through the following link.... http://www.codeproject.com/csharp/printeroffline.asp "Walking on water and developing Software on a specification is easy, if both are frozen..."

An SQLCommand object can also be used to return query results. Under the covers, this is what happens in the DataAdapter - the command buider builds commandtext for the other sqlcommand instances used by the adapter, using the commandtext provided for the query or read command. SqlCommand instances can also be used to return query results as a datreader, which is like a fast forward-only cursor.

There are many differences. Basically, Client-Side cursors work on a default result set that is cached on the client. They can be forward-only or static. Server-Side cursors have much more functionality, for example, Dynamic cursors reflect all changes made to the rows in their result set when scrolling through the cursor. Steve

Hi Param, Below two articles will help you. You need to understand this two Articles.:) http://msdn2.microsoft.com/en-us/library/ms229863.aspx http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspp/html/aspnet\_merge\_exe.asp Regards, Jay

Hi Thanks for your reply. But, I have closed the connection n used seperate connection foe every logical database query..but in my code i have used common transaction object for every query..will it create any problem? becoz every time wen multi user are accessing the system random error are comings.sometime it gives internal fatal error.some time it gives ur reader is opened with this connection.I am very sure tht i have close the connection n the data reader both. I wud be very pleased if u can give some solution to this problem Thanking you in advance Param param