I've nearly finished the development of a project and would like to test its performance, especially the database query calls. I'm using Linq to SQL to search via usernames, but I've only got around 10 'users' in my database, so I can't really get a decent speed reading. How can I simulate thousands/millions of users in the database without actually creating new records? I've read about Selenium, but it seems that is good for repeat actions (simulating concurrent users?). Are there any other tools I should look into, or are there any options in VS 2008 (Professional Edition)?
can i add new records in gridview by entering value in textbox in runtime?suppose a value is entered in textbox and concerned record is displayed in gridview again if i want to add a new record in gridview along with the old record how can i add?
I am a beginner with ASP.Net and I am trying to build a Web site which searches a MS SQL database for a person by name using a search form. I have decided to do this project in two steps. Step one was to develop the functionality in basic .aspx page, and then step two is to transfer the working code into the 'business starter kit' template provided with Visual Studio Express 2008. During step 1, I have created the search form, a results page, and also a detailed results page which all work exactly as desired. However, I have now been working on step 2 and trying to place the search form portion of generic page into a page created within the actual web site created using the business starter kit and this is where i am running into problems.
My search form will not work and gives me no results when I enter in a person's name. I have checked, double-checked, and qtriple checked all of the controls I am using, the database connection, the gridview settings, etc... and everything appears correct. I can create simple .aspx pages, not utilizing the masterpage.master file, and copy and paste my search from code into that and again everything works perfectly, but it does not work within my actual Web page being used for the site. Thus, this leaves me to believe the probelm has something to do with the masterpage.master page. Can someone take a look at my code and see if they see anything which may be causing my problem(s)? I have been working on this since sunrise this morning and it is getting quite frustrating that I cannot figure out what the problem is.
I ve design a page that has nine text box name txtSubject1 to txtSubject9 with the visibile properties to be false.I now have a method called Save1, Save2 to Save9 depending on the no of subject selected from the dropdown.But i think that is not professional bellow is a sample of how i did't and i believe the textbox can n number of an array that can be selected from the drop down. i need someone to put me through how to insert this into the database out side the fake method i ve used.
The website is over half way done and the functionality for the blog is (except for adding posts) is already implemented and working correctlyI have a SQLExpress 2008 backendBlog posts are rendered on the page with full HTML markup within a label control.
All of the above is done and working. Though I am essentially new to creating websites with ASP.NET, CSS and SQL, I am sure that I could simply carry on and make a login page with some controls that would allow me to add records (blog posts) directly to the database on the host server. However, I am fearful of doing this because I know that malicious code can be passed in this way. Also, because of my lack of knowledge, the only way that I know of to pass the code from a control to the database is to disable validation for the page the control is on. Without a doubt I do not want to do that.
So what are my options for getting blog posts into the database? Is it safest for me to fully create the post in html and update a copy of the database that resides on my local machine? If I do it this way, how can I merge the records from the database on the local machine with the records on the remote server?
I am working on a project in .NET (C#), connected with a database. And I am entering values in database through 'text-box' control, for a part of the project. What I want is to check if the user entering value already exsists in the database and if so, shows error during that time only.
I have searched for any familiar post here, that could solve my query, but didn't get any.
my EXACT objective(if not cleared earlier):-
when the user enter the value in textbox, automatically an event to check any duplicate records in database should occur. And if found, displays an error message
I have a sql database and want to store the image format into the database. I want to then display the image in a gridview. For the database I have entered the location of the image and not sure if this is the right thing to do. I'm not very good at this stuff so could you make it as simple as possible.
I am inserting the records in Database thru asp.net??One of the columns is unique, I want that suppose the user inserted the same value once,control goes to catch block, I wnat to show my own error message ,only if unique index is same ,Rest for the other exceptions,it thrown by .Net?/
currently I am doing an online store project using an example from one of your tutorials. In the grid view is populated with data and at the below of the grid view, there is a row of empty fields populated below. After user have enter all the necessary info and clicks on the Add New link, the data will be inserted into the database and it will also be displayed in the grid view itself. The software that I am using is called: MS VS 2008 C# The database that I am using is called: MS SQL Server 2008 This is the database.cs for inserting records into the database:
Code:
public bool Insert_ItemsRecords(string id, string itemName, string itemDesc) { SqlCommand cmd_ItemsList = new SqlCommand(); cmd_ItemsList.CommandText = "[VRM].[INSERT_ItemsRecords]"; cmd_ItemsList.CommandType = CommandType.StoredProcedure; cmd_ItemsList.Parameters.Clear(); SqlParameter sqlParaID = new SqlParameter("@id", SqlDbType.VarChar, 10); sqlParaID.Value = id; cmd_ItemsList.Parameters.Add(sqlParaID); SqlParameter sqlParaItemName = new SqlParameter("@itemName", SqlDbType.VarChar, 100); sqlParaItemName.Value = itemName; cmd_ItemsList.Parameters.Add(sqlParaItemName); SqlParameter sqlParaItemDesc = new SqlParameter("@itemDesc", SqlDbType.VarChar, 1000); sqlParaItemDesc.Value = itemDesc; cmd_ItemsList.Parameters.Add(sqlParaItemDesc); return executeNotQuery(cmd_ItemsList); } This is the stored procedure:
Code:
ALTER PROCEDURE [OS].[INSERT_ItemsRecords] @id varchar(10), @itemName varchar(100), @itemDesc varchar(1000) .................
I have the code below which does work, but I need to add further functionality to it. The functionality I want to add to it is the text I have commented in the code below.
Dim objSQLConnection As SqlConnection Dim objSQLCommand As SqlCommand Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Dim intID As Integer = CType(Request.Form("ID"), Integer) Dim strHeading As String = CType(Request.Form("Heading"), String)....
Before the if statement, I want to find out if the database already has records with the username in the strUser variable.
I have an ASP.NET web form application that on the server side I need to know the user's identity. I do not need to impersonate the user. I just need their username so I can update some records in a database correctly.When the request is processed I have the following line of code:
In my development & QA environment this works perfectly - I see the userName in the log file and all of the database records have the lastModifiedBy field filled in correctly. However, when we go to production - userName is an empty string.
I am select one mdb database from open dialog box.All records in the database (all table data value)will automatically delete. How to implement this concept.
I am doing a project where I need to be able to pick a records from a dropdown list and then have the rest of the records in the database display below in a table.
I attached an image of what i have so far which is the dropdown box and the table of data, but whenever i pick another item from the dropdown box it doesnt update the data listed below.
I am trying to trigger button click event from another event. In other words I am trying to invoke a Protected Sub function from another Protected Sub functions.
Is there anyway I can simulate the loss of the InProc session state? I am trying to see how my app handles if such a thing happens. Can this be done from IIS Manager?
doesn´t work for me because the button does not postback. Is there an easy way to prevent a second click while still keeping the functionality of the button?
in my system folder(E:\santhu) i have flat files(.txt and .doc ) .my problem is how to read those files automatically one by one and store the data(records) in to database?
