|
When I began the programming for http://www.sceptermarketingtechnologies.com, I quickly noticed that Asp.net does not support the MessageBox class that I was familiar with in windows forms.
Since Asp.net runs on the server it doesn't have access to produce a modal dialog box on the client. However, by using a scripting language that runs in the clients browser a similar construct is available. In javascript the window.alert() function will produce a modal dialog similar to what you would expect from MessageBox in windows forms.
So, I decided to create a static class MessageBox with a static method Show(), which will give you the ablility to to still use the syntax MessageBox.Show("Your Message"); and then convert it into the javascript window.alert("Your Message"); and add the script to the end of the current response stream.
I've written a how to on my blog at: http://sceptermt.blogspot.com/2008/02/how-to-create-message-box-class-in-c.html that shows the source code that I used in C# for my web application and details on how it works.
You could also write overloads for the static show() method to allow the class to do a javascript confirm() or a prompt(). I haven't needed that functionality yet so I've just kept it simple.
|
|
|
|
|
We have articles on this site. Sounds like you're looking to write one ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi,
I am new to ASP .NET and I am creating an e-exam website for a customer, the customer will have at most 50 students taking an exam simultanously.
I want to create a Microsoft Jet (Access) database (.mdb), but I know that Access database format is not designed to be used in websites where concurrency is an issue.
The question is:
Can Microsoft Access database files bear the load of 50 students submitting their answers almost at the same time or do I need an SQL server database? I don't know but I think that 50 users is a very small load even for this kind of database.
Any answers?
Thanks 
And ever has it been that love knows not its own depth until the hour of separation
|
|
|
|
|
Mohammad A Gdeisat wrote: I am new to ASP .NET and I am creating an e-exam website for a customer
It's only a matter of time before the backlash starts because of people who take on clients in technologies they are new to.
I would say go with SQL Server. According to google[^], 10 is the limit for the Jet engine, even across different apps. That doesn't mean that you can even have 10 concurrent users for an Access DB, let alone 50.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Ok, now my client wants to install the website on his own server (in the school). The server is running Windows XP.
Does my client need to install any applications (other than IIS) to make the website work with SQL server database?
Thanks 
And ever has it been that love knows not its own depth until the hour of separation
|
|
|
|
|
I recommend reaing this[^].
No, he doesn't need anyting else, but for 50 users, he's going to have to buy SQL Server, I believe that's more than the Express Edition will support.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
I just have one more question about the same issue.
I don't want my client to buy SQL server (if possible), so I would suggest myself to place the code that tries to connect to the database in a loop that checks whether the connection has succeeded or not, if it succeeds then it will update the database, if not, then it will try to connect again and again until it succeeds and then update the database, and so on.
Does this solve part of the issue or is it a BAD solution?
Thanks
And ever has it been that love knows not its own depth until the hour of separation
|
|
|
|
|
I guess it depends. He's probably paying you little enough that if you can handle the work, writing some sort of caching that does the DB updates when the DB is free, may be a viable solution. It's a hack tho. You still will be using a tool that's not suited to the task, when 50 students make a request that takes some time, if they all have to wait their turn, you risk web pages timing out, and your app breaking.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Only 2 out of our 190 client sites use full SQL Server. There are no more connection limits on 2005, just CPU and RAM, so for a standard DB, without additional services, there is nothing wrong with Express for 50 users.
|
|
|
|
|
Christian Graus wrote: only a matter of time before the backlash starts because of people who take on clients in technologies they are new to
Yep.
Christian Graus wrote: 10 concurrent users for an Access DB, let alone 50
A client of mine uses Access with about 10-15 concurrent and I've warned them about consequences of overloading the database. They want to add a few more people, and we'll see 
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
Why not use SQL Server 2005? Access may run into trouble with more than 10 concurrent users.
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
My client will install the website in his local server that runs WinXP, and I don't think that he will buy SQL server. He wants to run the application only in his local network, and I guess that the application is too small to deserve buying SQL server..
I would support your comment if my clien wants to install the website on a public web server because he will have to pay nothing, but buying SQL server for this application for which he paid me $1400 is not an option.
Thanks
And ever has it been that love knows not its own depth until the hour of separation
|
|
|
|
|
Mohammad A Gdeisat wrote: for which he paid me $1400
OK then....
MySQL is always an option and there are other DBs out there. MySQL may even be free ( check the license ), because he's a non commercial user.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Go with SQL Server 2005 Express edition. Works better than Access...
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
I think the express edition has a pretty low number of concurrent users, too.
No[^], that was the previous edition. Live and learn. So, I agree, that's probably the best option.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Yes, Thanks.
But if I develop my application using Microsoft SQL Sever (not express edition), and my user tries to run it under the Express edition, will he be able to get it to work? are those similar products compatabile?
I am asking because I have SQL server installed on my computer, so should I uninstall it, then install the Express edition to make the application compatible with the express edition?
Thanks 
And ever has it been that love knows not its own depth until the hour of separation
|
|
|
|
|
Mohammad A Gdeisat wrote: I have SQL server installed on my computer, so should I uninstall it, then install the Express edition
No. They should both be able to run side-by-side. The instance name for the SQL Server 2005 Express should be something different than SQL Server. You might want to look at FirebirdSQL, as well.
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
I suggest you to use MySQL. It's proven the performance and can access many concurrent connection. It can be downloaded from MySQL site freely. Download MySQL connector for .NET also. I use MySQL with many projects which I have, it works really well.
|
|
|
|
|
Hi !
I have found the solution from the Google and put the things under system.web in web.config file but still it show the same error
Unrecognized element 'membership'
I have found the solution from the below link for
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
http://www.aquesthosting.com/HowTo/Sql2005/SQLError26.aspx[^]
But although its not working
I really appreciated if someone can help me thanks in adv.
modified on Friday, March 21, 2008 4:20 PM
|
|
|
|
|
Have you placed the membership section in the right place? It needs to be a child item of system.web.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
|
<blockquote class="FQ"><div class="FQA">amistry_petlad wrote:</div><compilation debug="true"></compilation></blockquote>
You haven't closed the compilation tag.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Oh that not an issue i have sent you the partial code ..the prob. is something different..
The web.config is almost ok.. According to me ..
|
|
|
|
|
I get the error "Update requires a valid UpdateCommand when passed DataRow collection with modified rows." on the line adap.Update (ds,"Config"). Everything else works fine. Here is the rest of the code for that section. If anyone can help me to correct this message when I try to update the database that would be great.
sub btnUploadTheFile_Click (sender As Object, e As EventArgs)<br />
dim strFileNameOnServer<br />
dim strBaseLocation<br />
strFileNameOnServer = txtServername.Value<br />
strBaseLocation = Server.MapPath("")<br />
if strFileNameOnServer ="" then<br />
txtOutput.InnerHtml = "Error - a file name must be specified."<br />
return<br />
end if<br />
try <br />
dim imageUrl as string<br />
Dim connect As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= "& Server.mappath("matt.mdb") & ""<br />
Dim conn as New OleDbConnection(connect)<br />
dim adap as OleDbDataAdapter<br />
Dim ds as New Dataset<br />
adap= New OleDbDataAdapter ("SELECT * FROM Config",conn)<br />
adap.Fill (ds,"Config")<br />
dim de as datarow<br />
ds.Tables("Config").Rows(0)("Logo") = txtServername.Value<br />
response.Write (ds.Tables("Config").Rows(0)("Logo")) <br />
adap.Update (ds,"Config")<br />
imageurl=(ds.Tables("Config").Rows(0)("Logo")) <br />
Image1.ImageUrl = imageurl<br />
conn.close()<br />
uplTheFile.PostedFile.SaveAs(strBaseLocation+"\"+strFileNameOnServer)<br />
txtOutput.InnerHtml = "File <b>" + strBaseLocation+"\"+strFileNameOnServer+"</b> uploaded successfully"<br />
catch ex as exception <br />
txtOutput.InnerHtml = "Error saving <b>" + strBaseLocation+"\"+strFileNameOnServer+"</b><br>"+ ex.message <br />
end try<br />
end if<br />
end sub
|
|
|
|
|
Where is your UPDATE command?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
