contact.Display opens the contact window as a dialog window due to which parent window is stuck. You can call the this function in another thread if you want your parent window to work normally.

Regards Shajeel

Hi all, I am using query something like that select * from table1 where column1 = 'value1' and column2 = 'value2'; and I have created the index like this create index index1 on table1( column2 ); i have used only one column because column2 is usually unique and can only sometimes repeat Will the query will use the index or do i have to create index with both columns? I am using Oracle database.

Regards Shajeel

thanx

Regards Shajeel

any thing similar for property?

Regards Shajeel

Hi Is it possible to get the current function or property name using reflection? If it is then how?

Regards Shajeel

Hi, I don't want to use the SessionID which is already expired. How can I avoid that in ASP.NET 1.1. RegenerateExpiredSessionId is available in later versions for this. Can anyone tell me the work around for 1.1.

Regards Shajeel

Check out the license. It's shareware.

Regards Shajeel

Try this http://www.geobytes.com/FreeServices.htm[^]

Regards Shajeel

If you are using crystal report then format the field and customize the format and change the currency symbol.

Regards Shajeel

yes you can use ExportToDisk option in the console application

Regards Shajeel

but i want to raise event for function xyz. post back is working but my code is in xyz.

Regards Shajeel

no its not null, i have a break point int the function but it is not fired.

Regards Shajeel

I am using ItemDataBound event to add a Link button to a column using following code

					LinkButton temp = new LinkButton();
					temp.Click += new EventHandler(xyz);
					temp.ID = e.Item.Cells\[i\].Text;
					temp.CommandArgument = e.Item.Cells\[i\].Text;
					temp.Text = e.Item.Cells\[i\].Text;

now when page is displayed i see these buttons but when i click on them, page is refreshed but Click event is not raised. how can i see which event control and which event is raised when i am clicking this link.

Regards Shajeel

Hi, can any one help me with this issue i have posted couple of days back on ASP.NET forum. I got no replies and problem can easily be reproduced. I hope someone here can help me with this. http://www.codeproject.com/script/Forums/View.aspx?fid=12076&msg=2377814[^]

Regards Shajeel

Hi, I am generating a report using a popup window i am opening the popup window using

window.open("Reports.aspx", "", "fullscreen=no, width=925,height=700,top=5,left=30", false);

In that window's code behind i am printing report using this code

CrystalDecisions.Shared.ExportOptions expOp=crDocument.ExportOptions;
CrystalDecisions.Shared.DiskFileDestinationOptions destOp=new CrystalDecisions.Shared.DiskFileDestinationOptions();
Response.ClearContent();
Response.ClearHeaders();
destOp.DiskFileName=Server.MapPath("..\\Reports\\")+Session.SessionID.ToString() + ".xls";
expOp.ExportFormatType=CrystalDecisions.Shared.ExportFormatType.Excel;
ExcelFormatOptions options = new ExcelFormatOptions();
options.ExcelUseConstantColumnWidth = false;
expOp.FormatOptions = options;
Response.ContentType = "application/vnd.ms-excel";
expOp.DestinationOptions=destOp;
expOp.ExportDestinationType=CrystalDecisions.Shared.ExportDestinationType.DiskFile;
crDocument.Export();
Response.WriteFile(destOp.DiskFileName);
Response.Cache.SetExpires(DateTime.Now.AddSeconds(-1));
Response.Flush();
Response.Close();
System.IO.File.Delete(destOp.DiskFileName);
Response.End();

problem is when i click the button for opening window twice second window takes the report of first window and first window shows blank. I want both reports to show. am i doing some thing wrong here??

Regards Shajeel

Thanks for reply. all examples in the article starts with ' which we have dealt with, there are some places where int is used that are not covered here but we are always validating int wherever user enters them in form, so they are covered also. So after going through article i assume my app is safe or is there other ways of SQL Injection which are not included in article.

Regards Shajeel

Hi, I have ASP.NET application in which i am showing some reports in pdf format. Application is login based some have rigths to see the report while some don't. Problem is whenever someone opens reports they are getting stored in Client Temporary folder. Any solution. I cannot change client setting. I have asked another question in ADO.NET forum, if anyone can give answer to that one too. Here is the link http://www.codeproject.com/script/comments/forums.asp?forumid=1725&noise=1&mpp=50&select=2319646#xx2319646xx[^]

Last modified: 60mins after originally posted --

Regards Shajeel

Expert Coming wrote:

To answer your question, no that does not solve SQL Injection attacks.

can you give me the example or article as i am pretty sure i looked at lots of articles and did not find any example that it does not solve my problem.

Regards Shajeel

Hi, We have an ASP.NET 1.1 application with SQL Server 2005. Database access layer of the application is written separately and provided to us as a dll to be used in application and we dont want to change it. DAL does not support parameterized queries. What we have done is that on every where clause we have replaced ' by ''. I know it is not very good approach but what i want to know is our application safe now, or SQL injection is still possible and if it is unsafe can anyone provide the example of how?

Regards Shajeel

thank you both of you

Regards Shajeel