Hi friends I want to execute the procedure which is as shown below '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' CREATE procedure xyz(@refno as varchar(25),@Type as varchar(15)) as set nocount on Create Table #tbl_xyz ( 'some fileds ) Set @Tempcode=0 Declare xyz_cursor Cursor for Set @sql1 = 'Select a,b c and d like ''' + @labrefno + ''' order by e ' + @Type exec sp_executesql @sql1 Open xyz_cursor Fetch next from xyz_cursor into some values While @@Fetch_status=0 BEGIN ''''''''' BEGIN END '''''''''''''' '''''''''''''' '''''''''''''' Close xyz_cursor Deallocate xyz_cursor select * from #tbl_xyz ''''''''''''''''''''''''''''''''''''''''''''' In the execution of above procedure , it won't allow me to set any value under the cursor declaration and even if execute under the cusor and i want to perform this procedure by passing the '@refno' and '@Type' dynamically as a parameter . Is there any solution regarding this , then please guide me. Thanks Param

param

Hi friends I want to execute the procedure which is as shown below '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' CREATE procedure xyz(@refno as varchar(25),@Type as varchar(15)) as set nocount on Create Table #tbl_xyz ( 'some fileds ) Set @Tempcode=0 Declare xyz_cursor Cursor for Set @sql1 = 'Select a,b c and d like ''' + @labrefno + ''' order by e ' + @Type exec sp_executesql @sql1 Open xyz_cursor Fetch next from xyz_cursor into some values While @@Fetch_status=0 BEGIN ''''''''' BEGIN END '''''''''''''' '''''''''''''' '''''''''''''' Close xyz_cursor Deallocate xyz_cursor select * from #tbl_xyz ''''''''''''''''''''''''''''''''''''''''''''' In the execution of above procedure , it won't allow me to set any value under the cursor declaration and even if execute under the cusor and i want to perform this procedure by passing the '@refno' and '@Type' dynamically as a parameter . Is there any solution regarding this , then please guide me. Thanks Param

param

Hi Friends , I want to put the repeater control on my webpage , and want to develop the functionality for Editing and Deleting like datagrid .Is it possible to inser Edit and Delete Functionalities using repeater like datagrid? If it is possible , please guide me Thanks

param

Hi Friends , 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 . Can you please guide me. Thanking you , Param.

param

Hi Friends , 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 . Can you please guide me. Thanking you , Param.

param

Hi Friends , I want to set the Internet Explorer's Page Setup Property for printing automatically , when the page is loaded . Means i want to set the margin defalult , so no need to set the margin manually after loading the page when we r going to print the document.And if possible ,i want to set it through javascript. Please , guide me, regarding this. Thankin you, Param -- modified at 3:52 Thursday 7th December, 2006

param

Hi Friends , I have 2 dropdown on my webpage . I am taking the index value from one dropdown using javascript , so i have make the AutoPostback Event property off for that dropdown control . Now , i want to fill the another dropdown , by filtering on the basis of value selected from first dropdown. Can you please guide me , for above problem? Thanking You, Param

param

Hi friends , I am entering some values , in the datagrid , throudh it's text boxes and saving it in the database , i want that added data in the dropdownlist of another .aspx page. pls ,guide me. Thanking you , Param

param

Hi firends , I have dropdownlist on my datagrid , i want that dropdownlist's zero index as null , and i want to bind my inserted record on first index. Please Guide me. Thanking you , Param

param

Hi Friends I want to bind the String with the DataGrid , in such a way that i have one string say "125:test" . I want this string to be bound with the datagrid , so that , each and every character , means 1 2 5 : t e s t , will store individually ,in the individual cell of the datagrid. Please , guide me. Thanking you, Param

param

Hi Friends I want to put the control , on which when we click , color dialogbox will open and we can select one of the color from it.And that selected color will be displayed on the page. please , guide me regarding this. Thanking you, Param

param

Hi Everybody , Can anybody guide me , that how to add color picker into the Datagrid or datarepeater? Tanks in Advance, Param

param

Hi Friends , I have installed .NET1.1 Framewrork and Visual Studio2003 On my PC. After , installing .NET 1.1 while I am trying to run the simple asp.net application, It is giving me the message Error while running the project and terminate the debug and run process. Is there any work around rigarding this problem? Please Suggest your solutions. In Advance , Thanking you , Param

param

Hi everybody , Can anybody tell me , how to find printer status in aspx page ? using VB language .Is there any method/event or inbuilt library to check it on web-page? Thanking you. param

param

Hi everybody , Can anybody tell me , how to find printer status in aspx page ? Is there any method/event or inbuilt library to check it on web-page? Thanking you.

param

Hi everybody, Can anybody tell me the exact difference between SqlCommand and SqlCommandBuilder. Thanking you.

param

Hi Everybody Can any body tell me the differnce beetween Client-Side Cursor and Server-Side Cursor. Thanking you , Param Thaker

param

Hi Friends , I have problem regarding creation bin folder in ASP.NET 2.0 which includes .DLL and assemblies for deploying the website.Whenever , I am compiling and running my asp.net 2.0 application , it won't create bin folder in the application.And I want to create bin folder automatically , as like in .NET versio 1.1 Please, suggest me that , what's the solution of this problem? Thanking You, In Advance.

param

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

Hi Friends, My problem is that , my application is using common transaction object , when multiple users trying to access the application resources simultaneously it will show me the error datareader is already opened . Can anybody suggest me , how to maintain these problem? My application is using ASP.NET as front-end. Could it be maintained by maintaining isolation/concurrency in database? Please , reply your suggestions. Thanking you in advance, Param

param