hi, I want to execute mutiple sql select queries in ms access using c#. As per my knowledge what we can do with sql server, is we can separate the queries using semi colon (;) like [select * from table1 ; select * from table2] and we can fill mutiple data tables within a dataset with the help of data adapter. is there any way we can do the same in ms access. we can not create stored procedures too in ms access so what is the way to populate multiple data tables in one go, by sending / executing multiple queries in ms access.
Not sure if this is the right place, but I didn't see any more appropriate place, so...
Is it possible to validate attributes with xsd?
For example (a slightly contrived example, but you'll get the idea):
<host ipAddr="" hostName="" />
Does not make any sense to have both ipAddr and hostname specified.
A google search seems to indicate that you might not be able to do this, but it seems like Visual Studio does it on XSD itself. If I specify xs:element with both ref and name, it'll tell me ref is not allowed.
I looked at the link for union... looks kinda dumb imo... not you, I mean, the union command itself. Its just a more verbose / messier form of regex minus the regex. In the example, it makes your XML take either "54" or small, medium or large. But in the process, it adds ugly namespaces to your XML. Would be cleaner using the regex pattern. Ugh... from what I see, Microsoft has no intention of adding XSD 1.1 support to .NET. Assert would have done it. Oh well... guess I'll have to make the 3 params optional and validate it in the C#. Equally ugly.
Kinda weird that XSD manages to do it on itself. Is that like hardcoded in the validator or something?
If you put:
<xs:element name="blah" ref="blah2" />
Visual Studio will bitch at you that 'ref' cannot be present.
Maybe it is the example that is stupid, but I have never used union myself so I cannot offer anything better.
I guess it is XSD.exe that bitches about a mix of the attributes name and ref, not the schema itself.
But I get what you mean.
It would be nice if Microsoft supported this in the next .Net version. I have had cases where I wanted to check if a value where between min and max directly in the schema.
MS doesn't support XSLT 2.0 or XPATH 2.0 either and doesn't seem to have an official implementation plan.
We have couple of projects (1 win forms and 1 web form) written in VB.Net. We would like to get those converted into C#. We would be using VS 2012 Professional for BUILD. I am already googling for such tools but would also like to take community's opinion/recommendation on any such highly recommended tools with highest precision/accuracy in converting code from VB.Net to C#. I am good with free and paid tools. Your pointers/suggestions will be highly appreciated.
Wrong forum - this belongs in the ASP.net one please.
Also please format your code when you do post there (highlight it and click "code" just above the message text area. The other thing you could do is to just include the relevant markup please. It is unlikely that people are going to spend time reading a large-ish lump of code even to find the relevant bits. If you do both these things, you are much more likely to get help.
The amount of energy necessary to refute bullsh*t is an order of magnitude bigger than to produce it.