Is there on codeproject or other introductory articles on technical issues in ASP.NET web application development and deployment with MS SQL express 2005/2008? like db creation and attachment to application with connection strings for SQL authorization, setting folders security to access it with SQL authorization from web application and finally deployment from setup?
The DB engine is actually doing a great job of protecting you. What are you going to do with 90,000+ records on a web page ? It would be impossible for someone to browse that much data.
Change your logic to retrieve "blocks" of data, say 100 records or so. You will need to break the data down into "pages" of data where the user could click on a control and retrieve the next grouping of data. For example you could provide a A through Z filter on the top of the page, the user clicks "M" and you would retrieve the first 100 people with the last name beginning with M. The "Next" button would then fetch the next 100 people with the name beginning with M and so on ...
90,000 records is way too much data to display in a single query.
Actually that table's name is Tblvisitor, I want to get some more info about my visitors so i display that data in web page (100/page) before it is about 50000 i can display them. but now it is about 100000 so i got error.
Yes, your idea is good, now i display only data from 80000 and hide data from 1 to 79999 so it is working again.
I made a copy of our company website to a new server, planning to create a test environment. Both servers run IIS 6, and both are configured the same (except for where the configuration gives a server name.) All folders have the same permissions.
I cannot get the user authenticated.
As a last resort, I have this on a test login page:
ProtectedSub LoginButton_Click(ByVal sender asObject, ByVal e as EventArgs)
If Membership.ValidateUser(MyUser, MyPassword) Then
Feedback.Text="User not validated"EndIfEndSub
The second page has this code:
ProtectedSub Page_PreRender(ByVal sender asObject, ByVal e as EventArgs)
If User.Identity.IsAuthenticated Then
Feedback.Text = "User was authenticated"ElseIf User.Identity.Name = ""Then
Feedback.Text = "No user found"Else
Feedback.Text = "Not authenticated: " + User.Identity.Name
When I run this on the live server, it acts as expected: clicking the button transfers to Login2.aspx, and the literal on the page shows User was authenticated. Running this on the test server will transfer the page (meaning that the user is being validated) but show No user found, meaning that the user was not authenticated and there was no valid identity.
Any suggestions on how to fix this problem? I would rather not be mucking around with the live website that brands my company.
I didn't move the authentication database; both the old and new sites use the same connection string. The fact that Membership.ValidateUser is validating the user would seem to show that it is not a database problem.
Again, the issue seems to be that the authentication cookie for the test site is not being persisted.
I've a java webservice and would like to invoke it in .Net application. For that I created a .Net console application and added the webservice in service references.
It was added successfully and created the object to invoke functions of webservice. But I'm able to access only variables, not methods of webservice. Had I missed anything? Please correct me to access the functions. Thanks in advance
I am using vb script to open save dialog box in asp.net. This works fine in xp but it is not working in vista or windows 7 . I am using following code to execute the script
set objDialog = CreateObject("SAFRCFileDlg.FileSave")
objDialog.FileName = "C:\Scripts\Script1.vbs"
objDialog.FileType = "VBScript Script"
intReturn = objDialog.OpenFileSaveDlg
if intReturn Then
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.CreateTextFile(objDialog.FileName)