|
Not possible to have a real time app polling a database, sorry  . Rethink your design. I don't even know what your app does, but I'm guessing its not changing the entire table every second. Rethink your approach. You will likely need to write an IOCP based UDP server to be able to keep up with real time updates on multiple clients and stop sending entire tables to the client. Its not necessary. You just need to send new data.
|
|
|
|
|
Basically my app is a monitoring application for status codes on alarms. The reason I need fast refreshes is that the application needs to see when the other operators do things - i.e. acknowledge a status code, etc.
Ahh, bugger. I was hoping the apps could talk directly to the SQL server itself. I'll look into your suggestion though! Thanks!
|
|
|
|
|
I think there is such a thing as wiring up events between sql server and c#. I have never pursued this info as I find the concept horrifying!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Yes, SQL is able to call code or COM objects, etc. It is NOT intended to be used as a push mechanism to multiple clients. Thats even stated in the docs. Its intended to be used as a notification mechanism for a single server process. More efficient then hitting up the database every second, but he's still going to need a server piece in which case he might as well "do it right" .
|
|
|
|
|
I have never actually read the docs, not something I would recommend to anyone, live updates of data changes from the server yech!
If you were running WCF could that act as the choke point monitoring all changes rather than the TCIP suggestion you put forward?
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Nah, WCF sucks. I will never use it again. It is easy to implement though. We have a couple of WCF components in my current project (not my idea!). WCF is slow (too much XML traffic) and has no push mechanism. I don't think WCF would scale too well either. The only thing that scales into 10's of thousands of connections per server is going to be TCP/IP (or UDP) using IOCPs. Not sure if the OP has to go that far though .
|
|
|
|
|
Gotcha. Yeah, I don't think polling the database server constantly is going to work very well with multiple clients . Since you probably don't want missed updates, I'd probably go with TCP/IP vs. UDP. Although UDP wouldn't necessarily be a bad thing here. TCP/IP is probably going to be easier to implement a reliable system with though. Your design would probably be that everybody connects to the TCP/IP IOCP server through a simple text or binary protocol you invent. When somebody updates something, you push the update out to all the clients. The TCP/IP server would be the only process writing stuff to the database in the background.
|
|
|
|
|
I am just wondering if there is a pattern for programming conditions which are not known by the programmer at programming time; i.e. the conditions are set by the user.
For example, the user may define a set IF conditions, and corresponding actions. If the IFs were finite, that would be easy. However, the user has a variable set of conditions/rules. A good example of this is a ERP-purchasing module application. The routing of a purchase order depends on approval level. The levels of approval are determined by the company policy. There could be any number of approval levels.
In other word
IF condition 1... then action 1
IF condition 2... then action 2
..
IF Condition n.... then action n
but N is unknown at programming time. So I can't use the the typical if-else block.
Any suggestions on how to handle this.
|
|
|
|
|
Is this the sort of thing you mean? User Defined Dynamic Workflows in Workflow Foundation 4?[^]
I'm almost certain that I've seen an article posted here about creating 1 to n dynamic workflows - I'll leave you to search for it.
I would also think it possibel to do this by giving the users a blotter on which they can describe a workflow which is stored in a database. You then create forms based on the steps they have stored. That was off the top of my head so feel free to poke hole sin it. The idea, not my head...
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
If I understood correctly you may use "not" !. I mean may be you shouldn't check all possibilities for user input. For example instead of checking this
string userInput; //Got this from user input sould be "c"
if(userInput == "a")
{}
else if(userInput == "b")
{}
else if(userInput == "c")
{//Correct}
You can use
if(userInput == "c")
{//Correct}
else
{}
|
|
|
|
|
I find myself wondering how this question could possibly reflect a real-world scenario.
The fact that there are "any number of approval levels" does not justify an assumption that the possible conditions are "infinite:" there is probably a fixed number of maximum approvals possible, or required. And, probably, a certain minimum of approvals required to even process the order.
That the set of all possible permutations of approvals would require a unique action for each permutation: also seems a dubious assumption.
And, isn't there some "hierarchy" involved here: a decision by upper-management to cancel/void/dis-approve takes precedence over other lower-level decision makers, which means you can deduce the action required without consideration of certain other levels ?
In the real world, "hierarchy" also "kicks-in," in financial transactions, dependent upon customer credit, and $ize of order, as well as customer history, or internal (or external credit agency) rating.
My guess is there is a finite, and well-defined, set of actions to be taken based on approvals of purchase order.
So, present an interface with CheckBoxes: logical analysis of which are Checked then can be mapped to a list of appropriate actions. Or, present a TreeView with CheckBoxes, where you handle "hierarchy" by activating, or de-activting, sub-nodes, depending on whether "parent" nodes are checked. Then iterate the TreeView (recursively), and generate a list of actions based on all Checked Nodes.
"The first principle is that you must not fool yourself, and you are the easiest person to fool." Richard Feynman
|
|
|
|
|
The answer to this depends on how flexible the user input and required response is supposed to be. It can go from simply holding a list of allowed values to embedding a scripting engine. To give any useful guidance we'll need to know more about what the user is expecting to be able to enter as conditions and actions.
|
|
|
|
|
SilimSayo wrote: I am just wondering if there is a pattern for programming conditions which are
not known by the programmer at programming time; i.e. the conditions are set by
the user.
That is not specific enough. There are a number of ways of dealing with that of which the specifics matter which way to implement it.
SilimSayo wrote: For example, the user may define a set IF conditions, and corresponding actions
As expressed that requires an interpreter idiom (which is a pattern.)
SilimSayo wrote: but N is unknown at programming time. So I can't use the the typical if-else
block.
That of course has nothing to do with the problem as you expressed it. If you have defined conditions/actions and ALL the user does is pick from that set then the solution is trivial - use a set with an appropriate definition block. This is a very, very simple form of interpreter.
However that doesn't solve it if the conditions/actions themselves are user defined.
|
|
|
|
|
I would consider a collection of Func<bool>, Action pairs. then simply foreach the collection and if the Func<bool> returns true invoke the Action.
building the collection is another matter and would really depend on what conditions you want the user to be able to define
Pedis ex oris
Quidquid latine dictum sit, altum sonatur
|
|
|
|
|
Please help! do I need to synchronize mysql to Access database. preferably via xml. I managed to get mysql database structure:
Table name="data">
<Field name="id" type="int(11)" null="NO" key="PRI" default="" autoincrement="false"/>
<Field name="data" type="varchar(255)" null="NO" key="" default="" autoincrement="false"/>
<Field name="data2" type="varchar(255)" null="NO" key="" default="" autoincrement="false"/>
</Table>
I do not know how to write the database access.When I need to add a column in MySQL to create and access databases, without losing the original data.I also needed to synchronize data that has changed. many thanks for your help
|
|
|
|
|
What do you mean "write the database access?"
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
MS Access does not read XML. You can create a MYSQL connection in ODBC, and you can link MS Access to any ODBC data source i.e. use linked tables. Linked tables don't store data so if you make a change in the data in Access, you would be changing data in MYSQL and vice-versa.
|
|
|
|
|
You could write an API as an application to sit in front of MySQL and then a macro or application to sit in front of the Access database to consume the XML, but it would be... interesting, not to mention the deadlocks you would probably get would be a nightmare to sort out.
|
|
|
|
|
hi
i try to reverse string on access in sql query and C# like this:
SQL = "SELECT StrReverse(Des) from MyTbl";
dsView = new DataSet();
adp = new OleDbDataAdapter(SQL, Main.Conn);
adp.Fill(dsView, "MyTbl");
adp.Dispose();
dataGridView1.DataSource = dsView.Tables["MyTbl"].DefaultView;
and i get this error: Undefined function 'StrReverse' in expression.
but if i run this query on access its works excellent
what can be the problem ?
|
|
|
|
|
StrReverse is a VBA function that is not available outside of Access. You can only use the supported SQL functions from outside of Access.
The list of what Access supports in SQL statements can be found here[^].
Basically, if you can use the function name in VB, you can't use it in SQL.
|
|
|
|
|
In addition to Dave Kreskowiak's answer. OleDb also has "predefined" keywords. Sometimes you'll need to change column names or change the SQL to pass around this.
Just for info.
(PS: I don't think that's the case here btw)
V.
|
|
|
|
|
hey.. can anyone tell me that how can i convert files(doc,pdf etc) to UDF(universal disk formate) using .net libraries.. if not then is there any third party software tht does so.. doc to udf conversion ? i have checked out but found plenty of third party softwares that convert udf to other formats not ..other formats to udf ????plz reply otherwise i will be fired.. lolx
|
|
|
|
|
That makes no sense. It's like asking how to convert a doc file to a zip file. Or like asking how to convert a stack of paper to a suitcase. The paper goes inside, it does not "become" the suitcase.
What do you really want? Put files together in an UDF file? Or convert an ISO to UDF perhaps?
|
|
|
|
|
hmm thanks.. iso to udf.. regards
|
|
|
|
|
Ok, I don't know of any .NET libraries that will help you with that.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
