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 …

i have to show data in datagrid using store procedure...but remember...i m using store procure in seprate class so i m facing difficulties.. how to do it.. thats my class coding... but how to pass it in main form? public Searching() { Myconnection = new SqlConnection("Data Source=.;Initial Catalog=Bahria_Managment;Integrated Security=True"); } …

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 …

Hello I have created an dll for my windows application ...the app contains two buttons which on click displays message box with some message. Now i create another windows application which contains one button, when i click this button my dll has to be executed . i.e the form with …