How to get and set data in static string dynamically

Question

I have a desktop application, which verifies the finger and prompt the result I am calling that app in wpf, then this all is showing in asp.net

On asp.net user put the finger, results comes to him how is that done?

On asp.net I created a static class & a web service having a two static members which gets 'query' & connection string, these both member set by asp.net i.e

button1_click() {
      string query = "select * from employee where userid='123'";
        string connString = "Data Source=mypc;Initial Catalog=abc;Persist Security Info=True;User ID=re;Password=12345";

    StaticClass.Query = query;
    StaticClass.ConnStr = connString;
}

Value setting in web service

[WebMethod]
public string Query()
{
    string SelectDataQuery = StaticClass.Query;
    return SelectDataQuery;
}

Desktop application subscribed the web-service which gets and give data. All is well, NOW then I hosted the application on IIS, multiple users are using the application now, on the same time, user1 set the query while user2 gets it. I want to make it multi user, so whats the suggestion, should i create static strings dynamically as much as users create requests which uniqueness or any thing else?

So do these none of these answers help you? – workabyte Aug 06 '15 at 23:33 — workabyte, Aug 06 '15 at 23:33

score 0 · Answer 1 · edited Jul 25 '15 at 11:35

0

You could try to create an instance object holding the query and connection and then pass it along to the query method. this way each user will have their own instance.

something like this

[WebMethod]
public string Query(StaticClass query)
{
    string SelectDataQuery = query.Query;
    return SelectDataQuery ;
}

edited Jul 25 '15 at 11:35

marc_s

732,580
175
1,330
1,459

answered Jul 24 '15 at 13:32

workabyte

3,496
2
27
35

score 0 · Answer 2 · answered Jul 25 '15 at 16:25

Just use String.Format to place in the current user id.

button1_click() {
    string query = "select * from employee where userid='{0}'";
    string connString = "Data Source=mypc;Initial Catalog=abc;Persist Security Info=True;User ID=re;Password=12345";

    StaticClass.Query = String.Format(query, currentUserId);
    StaticClass.ConnStr = connString;
}

How to get and set data in static string dynamically

2 Answers2