First of all, thanks a lot for all your help....My special thanks goes out to "iwilld0it"...Thanks buddy.
I am putting up some of my doubts again, request for assistance....
Q.1. Whenever we create an SQLCommand object after creating SqlConnection object, do we need to write something like
SqlDataReader dr = cmd.ExecuteReader();
I mean, does'nt the query get executed just by creating a cmd(SqlCommand object)? Do we need to create a SqlDataReader object as well?
Q.2. I am trying to store the error information inside the database incase an error occurs. For this I am using Application_OnError event inside global.asax file.
I am using Session["err_info"] = Context.Error.ToString() method to store the error information in the err_info session variable. Then this variable is used to store the error info in the dbase inside the same event handler
inside SqlCommand object.
My problem is that the data never gets stored...!!!
Please correct me if I am wrong...