I think manipulation on C# side is better than looping at the stored procedure level. (Writing cursur,fetching the data and manipulate eaither into a string or temp table is I think expensive) Thanks, Nyoti

ok. Are you able to execute the events in your user controls? If not, then you need to do something like this. EventInfo SomeEvent = AnyControlInYourUserControl.GetType ().GetEvent("Click"); SomeEvent .AddEventHandler(AnyControlInYourUserControl, new EventHandler( this.AnyControlInYourUserControl_Click)); Write a handler for this. But I think, you are already executing postback, however, since the page is dynamically being created, on post back you are loosing the value of the hidden variable. So in the event handler function above you can store the value of the variable in the session and then can access it. I am sorry, if I misunderstood anything. I will post the code tonight if you want. Thanks, Nyoti

I can post the code may be by EOD today for this. Thanks, Nyoti

With T-SQL you will return an input from select query, which will look something like this. Description Cost Template description1 9 description2 10 description1 29 description3 8 description3 4 Get this into a datatable. You can do it either using adaptor.Fill (Dataset) and then dataset.Tables[0] Let me know if I understood your question correctly. Thanks.

I do not know if the way I am telling is a correct way. But I solved this problem for me like this. 1) Fetch the data from the database into datatable. 2) Create another datatable and add new row to it. 3) Get the "Description" Column and add it as a column to the new table. Get the corresponsing Cycle Template solumn and add to table. 4) Loop throught the table with table.Select() to get all the rows having same description. 5) For each such row, get the cycle template and add it to the same column (Cycle Template which you added previously) In short, create a dynamic table this way and bind it to grid. Thanks, Nyoti

OK. In this case, you can add dynamic events at the time of Control Creation and write handlers for them.

If the button is in the page, I am not sure why it was needed to execute Postback forcefully? Did you try debugging on the page load on the click of button to check if the control comes there? Thanks, Nyoti

Can you put this code (for LoadAgain()) inside the page load event of user control? If it is a dynamic user control, it needs to be regenerated on post back of page. Thanks & Regards, Nyoti

Hi Paritosh, The link below may provide solution for your problem. http://www.dotnetfunda.com/articles/article201.aspx This worked fine for me. Regards, Nyoti

Specify in header section of your page where IFrame resides. Regards, Nyoti

ActivityCtrl1.load_Again(); Is this written on Page_Load of your aspx page?

Hi Guys, I need to send and receive SMS through my asp.net application based on some changes in database (SQL Server 2005). I am going to have one continuously monitoring process which will check any database changes and will then send the SMS to appropriate user. The process will also listen to the port if there is any new received SMS. I have come accross many gateways available in the market like 1) Ozeki (http://www.ozekisms.com/index.php?owpn=230) 2) http://www.clickatell.com/developers/api\_soap.php 3) esendex etc. (I will not bore you with the list :) ) So far, I liked "Ozeki". But I want to know if anybody knows any better gateway which has been used in your applications earlier. I would also like to know your experiences on Ozeki if any of you have used it. Your inputs will be a big help. Thanks in advance. Nyoti

Hi, I am creating a search utility for my ASP.NET web application. There is a page Search.aspx, which accepts the search criteria and sends the search request to web service, which does the processing of that request and sends back the reply as a dataset. The search page then binds the dataset to the datagrid and is displayed on the page. When I navigate through various pages of datagrid, I can see the results on the same page (Search.aspx)as paging is applied on the grid. But when I click on browser back button, I want the page load event to be executed, which is not being executed. I tried with following code in Page_Load event of Search.aspx Response.CacheControl = "no-cache" Response.AddHeader("pragma", "no-cahe") Response.Expires = -1 But page load event does not occur. Please let me know the solution for this issue. Thanks in advance.