arsheena.alam

Hi Friends!! I am coming across this problem that whenever I am trying to retrieve the data in a dataset through SQLDataAdapter and Dataset, it is taking around 10 min to get the data on the localhost. And when I am running the same code on the live server it …

Hi Friends!! I am coming across this problem that whenever I am trying to retrieve the data in a dataset Through database, it is taking around 10 min to get the data no the localhost. And when I am running the same code on the live server it doesnot take …

Hi, I have a table that stores records of students. Now what I want is that after a particular period of time the account of the student gets disabled automatically. Is there any time based trigger that can be hit automatically if i set the time limit for that. Or …

Hi, I have a table QuestionAsked which contains a column DateofAsking. Now what i need is to extract each date value and check whether the difference between that day and the current day is 14 or not. If yes than i have to update a particular column in that table.I …

Hi, I have a table with more than 3000 records. I need to replace a particular string of all the rows wid some other string But when i am using replace function Its only replacing half of the rows of the table while the other half are not getting replaced. …

I have a button in grid view.I am not able to select the current row through that button.I have to enable SELECT before clicking that button. But I dont want to enable SELECT. Now I want to know is there any way to directly select the currentrow without enabling SELECT.

Hi, I am creating the dll of my website by building the website. Now the problem is I am not getting the XML documentation file in the debug folder of the bin folder. There is no debug folder inside the bin folder!! I am unable to see comments in my …

Use OBJECT DATA SOURCE while binding the dataset with the Grid view. It will automatically bind the dataset of the method and will return the values in a grid view. I hope your class method is returning a DATASET. Hope it helps!!!!

Hi, I have a variable @FranchiseId declared in my stored procedure If I try the following select command, will it work???? SELECT @FranciseId=(select FranchiseName FROM franchise WHERE username=@username),username FROM MyTable I hope you Understood My problem!!

Hi, I have completely documented my project, And when i am creating the dll of my project and giving it to the people, the comments are not visible due to which they are getting problem in performing their tasks. Please give me some solution for it. Thanks in advance!!

I have created a user control and i am using it in login view control. to get the value in the textbox the code is [CODE] TextBox mytext = (TextBox)LoginView1.FindControl("mycontrolname"); [/CODE] but when i try to do the same with usercontrol it is not working; ie. I am unable to …

Hi guys, In C# when i use the using statement. in case of try catch do i have to close the connection in case of any error. [CODE] try { using (connect=connecttodabase()) { SqlParameter demo_ID = new SqlParameter(); SqlCommand command = new SqlCommand("Demo", connect); command.Parameters.Add(demo_ID); int rowsAffected = command.ExecuteNonQuery(); return …

I have a base class kaysonsSPdetails. which is internal and DemoDVD which is public and inherits SPdatabase. [CODE] internal class kaysonsSPdetails { /// <summary> /// This method is used to connect to databse is returns an open connection /// </summary> private System.Data.DataSet connecttodabase() { throw new System.NotImplementedException(); } } public …

just publish the web site. go to the precompile folder. copy the bin folder as it contains all the dlls and give it to any other system.:) Mark as complete if you like my answer!!