I am creating an application for a asp.net class that I am taking. One of the pages in the application needs to allow a user to search for a specific student via last name or user ID. When the student is found the page should display the students data and his/her class schedule.
The last two lines of this code do not work correctly — the results are coming back from the LINQ query. I’m just not sure how to successfully bind the indicated columns in the results to the textfield and valuefield of the dropdownlist:
I’m new to working with stored procedures. We have an existing system which uses stored procedures that check usernames and url paths. The Stored procedure will check whether user details exist. If it exists it returns 1 if not it returns 0. I am trying to write asp.net code to call this stored procedure by … Read more
I have application running on my server. The problem with this application is that daily I am getting nearly 10-20, System.Data.SqlClient.SqlException Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding only one of my SP. Here is my SP,
I have one DataTable which has four columns such as
I have the following parameter for SqlCommand. How do I make it to both in and out the paramter value for the Stored Procedure.
I am getting exception: “Specific cast is not valid”, here is the code
We have a operation in which more than 100.000 records are read from a csv file and inserted in a database. When I am using a file with 10 records, the operation is completed successfully in less than one minute.
How to the select top n rows from a datatable/dataview in ASP.NET? Currently I am using the following code, passing the table and number of rows to get the records. Is there a better way?