ASP.NET Discussion Boards

Web Server for Multiple User Connections

ollysmith9-Jul-07 4:53

9-Jul-07 4:53

I may be asking a very obvious question but here goes:

Assume that the Web Server has a Database (an Access .mdb) for each User, the Tables, Fields, etc are the same in each Database, the WebMethods are the same for each User as are the Web Forms for their data.

Obviously I could setup a Service for each User and put the appropriate Database into it together its own copy of all the WebMethods, Web Forms, etc.

Equally obviously this is not the 'way to do it'; the coding overhead might be considerable!
So for each User I need to 'tell' the Server which OleDBConnection/Database to use. I just cannot see how this is done particularly if/when 2 or more Users are active at the same time.

Help would be appreciated.
I am using VS 2003 and coding with VB.
I don't need long, detailed explanations just a couple of pointers to get me going.

ollysmith

Re: Web Server for Multiple User Connections

Fred_Smith9-Jul-07 5:22

Fred_Smith

9-Jul-07 5:22

Seems an extraordinary setup, but anyway...

First, you need to know which user is making the request, so you'll need a login of some sort - so you need a "users" database and keep a reocrd for each user of their username, password, and database name - then when they login you can construct the appropriate database connection string from the information received from the database, and use that for their subsequent database requests. It won't matter if two or more users are logged in at the same time, they will each be accessing their own database using their own database connection.

I'm not sure how scalable this sort of setup is, if you have thousands or even just hundreds of users...

Fred

Re: Web Server for Multiple User Connections

Not Active9-Jul-07 6:03

Not Active

9-Jul-07 6:03

Fred_Smith wrote:
I'm not sure how scalable this sort of setup is

Not very.

I would suggest using SQL Server Express.

only two letters away from being an asset

Re: Web Server for Multiple User Connections

ollysmith9-Jul-07 12:24

ollysmith

9-Jul-07 12:24

Thanks for replying Fred.
I can see how to do as you suggest but I also think you have hit upon the real difficulty that I have - It is an 'extraordinary problem' but this is because I have no idea how to tackle it and started with what I thought was a reasonable description. How wrong can one be!

I think now that what I need is a single Database and each Database request query has to contain the specific Users ID. I can maintain a Users Table and provide each User with some sort of a 'Key'or maybe a 'cookie' on their machine to identify them.

The program I have written is, at the moment for a single Cricket Club but 2 or 3 others have shown an interest and I want to rewrite the program to include them and their results, etc.

My biggest problem is that I am retired, over 70, self taught and noone now to float ideas with and be told I'm a fool.

If you are interested in Cricket let me know on djs@springfield.f2s.com and I will reply with a 'link' to the program I have written.

David Smith

Configuration Error> allowDefinition='MachineToApplication' beyond application level??

Amr M. K.9-Jul-07 4:39

Amr M. K.

9-Jul-07 4:39

Hello all;
I am using Asp.net 2.0 and I want to make form authencation in sub folder admin in my application is the following
- root
- admin
- App_Data
...
so web.config in root folder I have done the following :-
...
</system.web>
<location path ="Admin">
<system.web>
<authentication mode ="Forms" >
<forms loginUrl ="loginAdmin.aspx" defaultUrl ="Default.aspx"></forms>
</authentication>

<authorization >
<deny users ="*"/>

</authorization>

</system.web>

</location>
</configuration>

and give the following error
Server Error in '/Webauthentaction2' Application.
--------------------------------------------------------------------------------

Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.

Source Error:

Line 40: <location path ="Admin">
Line 41: <system.web>
Line 42: <authentication mode ="Forms" >
Line 43: <forms loginUrl ="loginAdmin.aspx" defaultUrl ="Default.aspx"></forms>
Line 44: </authentication>

Source File: C:\Documents and Settings\magic\My Documents\Visual Studio 2005\WebSites\Webauthentaction2\web.config Line: 42

...................
I have made some search and I didnt get proff answer any one can help??

aj123

ERROR: Cannot have multiple items selected in a DropDownList.

Anand krishna9-Jul-07 3:39

Anand krishna

9-Jul-07 3:39

Hi,
I am developing one web application in .net 2.0.One page has 3 dropdown list.Drop down values loaded to the database and i need select specific value to the dropdown list.But i got the
"ERROR: Cannot have multiple items selected in a DropDownList".

The coding is below

Me.ddlParam.DataSource = dsParam
Me.ddlParam.DataTextField = "ParameterValue"
Me.ddlParam.DataTextField = "ParameterValue"
Me.ddlParam.DataBind()
Me.ddlParam.ClearSelection()
Me.ddlParam.Items.FindByText("Params").Selected = True

I tried many more ways.but i got the same error.
Pls help
Thanks in Advance
Anand

Re: ERROR: Cannot have multiple items selected in a DropDownList.

Vasudevan Deepak Kumar9-Jul-07 3:48

Vasudevan Deepak Kumar

9-Jul-07 3:48

Are you resurrecting the value from ViewState and rebinding the columns at Postback. A !IsPostBack check might be missing.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Re: ERROR: Cannot have multiple items selected in a DropDownList.

Imran Khan Pathan9-Jul-07 4:06

Imran Khan Pathan

9-Jul-07 4:06

try this
Me.ddlParam.selectedValue="Params"
Insted of Me.ddlParam.Items.FindByText("Params").Selected = True

Best Regard

Pathan

Plz vote If U got solution

GOD HELP THOSE WHO HELP THEMSELVES

generate an assembly from a resource file programatically

Prajin9-Jul-07 2:54

Prajin

9-Jul-07 2:54

Hi,
Can anybody tell me how to generate an assembly from a resource file programatically

Thanks,
Prajin

Formatting GridView

Jay_se9-Jul-07 2:54

Jay_se

9-Jul-07 2:54

I wish to format my gridview in such a way that,

Suppose there is a column "Description", which has been dynamically bound. It may be a 3000 chars long (max). Whatever the case, I wish to display only 2 lines (Approx 200 chars) using DIV tag, while displaying normally. Whenever the user mouseover on it, it should be displayed in the popup and show the detailed (full) content.

I am using export to excel also. Can u suggest any idea?

Jey

Re: Formatting GridView

Not Active9-Jul-07 3:58

Not Active

9-Jul-07 3:58

Jay_se wrote:
Can u suggest any idea?

Use CSS and javascript

only two letters away from being an asset

Re: Formatting GridView

Jay_se9-Jul-07 4:30

Jay_se

9-Jul-07 4:30

Mark,

Too Generic answer !! ANYWAY thanks. The problem is that, I have been used the Template control& Bind the value to the Label control in the GridView.

Suppopse, if it contains 10 lines, I wish to show only the first two lines. Upon the user explicit request I may display the entire content there itseslf OR in seperate popup window.

You may suggest the outline(in Design). Its helpful to proceed further.

Jey

Re: Formatting GridView

Not Active9-Jul-07 5:10

Not Active

9-Jul-07 5:10

"Can u suggest any idea?"

I see, by this you mean, give me the code to do it.

How about we do a little exercise I like to call research. I'll even give you more of a hint. window.popup, style.text-overflow

only two letters away from being an asset

Re: Formatting GridView

Jay_se9-Jul-07 18:30

Jay_se

9-Jul-07 18:30

Mark, Good Morning. Thanks. I would like to learn. I never had the intension to get the code directly from this forum. Since I was worked with C#.Net (Creating BLL classes) for the past 2 years, I am a beginner in design.

Now I am having the opportunity to work in designing of web pages. So I am just learn & do my work. Its interesting too.

Mark Nischalke wrote:
window.popup, style.text-overflow

Thanks for the hints.

Jey

Web.Config, DLLs and NUnit

Malcolm Smart9-Jul-07 2:45

Malcolm Smart

9-Jul-07 2:45

I am using NUnit to test DLL components of a C# web app. All is working a treat except code that accesses the Web.Config file. As the DLL is being run through NUnit and not a webserver, it can't access the web.config file and falls over.

Is there a way I can explicitly tell the ConfigrationManager class to use a specific file to get its config settings? Something like

ConfigurationManager myMgr = new ConfigurationManager("c:\mywebfolder\web.config");

Cheers

Malc

"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF

Re: Web.Config, DLLs and NUnit

Malcolm Smart9-Jul-07 3:43

Malcolm Smart

9-Jul-07 3:43

1) Install TestDriven.NET, which integrates with Visual Studio,
2) copy the web.config file to MyDLLIamTesting.Config
3) Right Hand Mouse click - Run Tests

"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF

Re: Web.Config, DLLs and NUnit

Kevin McFarlane9-Jul-07 11:51

Kevin McFarlane

9-Jul-07 11:51

I ran into something like this a couple of years ago but with App.config. I added some post-build steps to keep everything in synch.

Kevin

Filtering files

suparichit9-Jul-07 2:20

suparichit

9-Jul-07 2:20

Hi,

Anyone have idea about how to filter file types in asp.net file upload control. So that we ask user to select those files from Dialog box instead of regular exp/java script msg box.

Thanks

suparichit

Re: Filtering files

Dave Sexton9-Jul-07 2:32

Dave Sexton

9-Jul-07 2:32

I usually just put it through a conditional expression to check the file extension before the upload. Works pretty well.

I think I'm going to call my next project "Chuck Norris". It's a sure way to guarantee it's unbreakable.

• • •

But fortunately we have the nanny-state politicians who can step in to protect us poor stupid consumers, most of whom would not know a JVM from a frozen chicken. Bruce Pierson

Re: Filtering files

suparichit9-Jul-07 2:34

suparichit

9-Jul-07 2:34

thnq..

suparichit

Control Memory Footprint

Dave Sexton9-Jul-07 1:54

Dave Sexton

9-Jul-07 1:54

Does anyone know where I can get a table or list of the memory usage of various controls?

I'm working on an ASP.NET project & would rather use a label control over a disabled textbox (small water cooler debate). It seems logical to me to assume that a label control carries a smaller footprint than a textbox control.

I'm sure the difference between the two is minimal and not really worth considering, it's really more a matter of curiosity than anything else. I've done a few fruitless searches, thought someone maybe had something more readily available.

Google results for MSDN[^]
More search results[^]

I think I'm going to call my next project "Chuck Norris". It's a sure way to guarantee it's unbreakable.

• • •

But fortunately we have the nanny-state politicians who can step in to protect us poor stupid consumers, most of whom would not know a JVM from a frozen chicken. Bruce Pierson

Populating DropDownList from XML?

chand109-Jul-07 1:36

chand10

9-Jul-07 1:36

Hi
I am trying an application, in that their are two DropDownList controls.Both are to be filled with the XML node items.With the selection change in the first DropDownList, second one should be populate with the corresponing result of the selection one.

I am able to populate two DropDownLists with all the nodes in the XML file but I am not getting the particular selection of First DropDownList.

My XML File is something like this.....

<NewDataSet>
<Table>
<StateCode>AK</StateCode>
<CountyName>Aleutians East</CountyName>
</Table>
<Table>
<StateCode>AK</StateCode>
<CountyName>Aleutians West</CountyName>
</Table>
<Table>
<StateCode>AK</StateCode>
<CountyName>Anchorage</CountyName>
</Table>
<Table>
<StateCode>AL</StateCode>
<CountyName>Jackson</CountyName>
</Table>
<Table>
<StateCode>AL</StateCode>
<CountyName>Jefferson</CountyName>
</Table>
<Table>
<StateCode>AL</StateCode>
<CountyName>Lamar</CountyName>
</Table>
<Table>
<StateCode>AL</StateCode>
<CountyName>Lauderdale</CountyName>
</Table>
<NewDataSet>

All StateCode will be displayed on DropDownList1 and for the corresponding StateCode selection all the CountyNames in that StateCode Should be displayed on DropDownList2,this I am not getting.

Help me out suggest me an example if possible.

I have not failed. I've just found 10,000 ways that won't work. -Thomas A. Edison

Thank u
Chandu

Re: Populating DropDownList from XML?

valerian.precop9-Jul-07 2:05

valerian.precop

9-Jul-07 2:05

Here is one method you could use:

1.
create a "ListItemCollection" (eg. lstAllNodes) object and populate it with all the pair values (StateCode,CountyName) from your XML (the text should be StateCode and the value should be CountyName).

2.
After that you should do something like this

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
string sText = DropDownList1.SelectedItem.Text;
ListItemCollection lstCountyName = new ListItemCollection();

foreach (ListItem lstTempItem in lstAllNodes)
{
if (lstTempItem.Text == sText)
{
lstCountyName.Add(lstTempItem);
}
}

DropDownList2.DataSource = lstCountyName;
DropDownList2.DataBind();
}

Where:
-lstAllNodes is the ListItemCollection object populated with all the nodes like I said at 1.

-DropDownList1 is your first drop down list with StateCodes (be carefull to have it runat server and set AutoPostBack="true" so that the SelectedIndexChanged event may trigger)

-lstCountyName is a second ListItemCollection (it is a temporary object and it's empty at first)
it's used to bind the second drop down list with the required values

-DropDownList2 your second drop down list with CountyNames

Just call me Valy... Smile | :)

Re: Populating DropDownList from XML?

Imran Khan Pathan9-Jul-07 2:07

Imran Khan Pathan

9-Jul-07 2:07

Try this

<br />
function Dataset XMLfile()<br />
{<br />
XmlDataDocument xdoc = new XmlDataDocument();<br />
return xdoc.DataSet.ReadXml(Server.MapPath("XMl.xml"));<br />
}<br />
 protected void Page_Load(object sender, EventArgs e)<br />
{<br />
dataset ds=XMLfile();<br />
dd1.datasource=ds;<br />
dd1.datatextField="StateCode";<br />
dd1.databind();<br />
}<br />
<br />
<br />
protected void dd2_SelectedIndexChanged(object sender, EventArgs e)<br />
{<br />
 dataset ds=XMLfile();<br />
 datarow[] dr=ds.table.select("StateCode='"+dd1.selectedItem.Text+"'");<br />
datatable tb1; <br />
foreach(datarow dr1 in dr)<br />
  tb1.ImportRow(dr1);<br />
<br />
dd2.datasource=tb1;<br />
dd2.datatextfield="CountyName"<br />
dd2.databind();<br />
}<br />
<br />

Best Regard

Pathan

GOD HELP THOSE WHO HELP THEMSELVES

SqlDataSource - use info in cs file??

munklefish9-Jul-07 1:30

munklefish

9-Jul-07 1:30

Hi,

Ive created an SqlDataSource on my page using VS2005 (ASP.Net 2.0 c#), that gets infor from an SQL2005 DB as a DataSet. How do i capture / use this data in the codebehind?

I am ok with capturing this data in the CS file when using a DataReader, but for this problem i need to use a DataSet. How do you grab the data in the DataSet, so its rows etc can be counted and used in the codebehind ?

Please help.

Thanks.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.