|
if this is an SQL database i think you should use SQL...
try adding a where clause to your query so it just returns the matching records...
I'm brazilian and english (well, human languages in general) aren't my best skill, so, sorry by my english. (if you want we can speak in C# or VB.Net =p)
|
|
|
|
|
Thanks for the reply guys!
I have two sql tables, bank and store transactions. Unmatched data are datas/transactions that didn't match. example :
table A
A B C D E
100 10 11/11/2011 10:20:00 12
102 11 12/12/2012 10:23:00 12
103 12 12/13/2012 10:50:00 12
105 51 12/12/2012 10:22:00 12
106 55 12/15/2012 10:55:00 12
table B
A B C D E
100 10 11/11/2011 13:20:00 12
102 11 12/12/2012 13:22:00 12
103 12 12/13/2012 13:50:00 12
105 51 12/12/2012 13:22:00 12
106 52 12/15/2012 13:55:00 12
I need to make a program that will show the unmatched record in column B. My project has about 300thou data's and also I need to adjust the time ' table A is in MT and Table B is in ET.
I'm not good in explanation so if it's still too vague feel free to ask for more information...
l.scott249@yahoo.com
|
|
|
|
|
In addition, if the records mismatched then show it. if they matched then ignore.
|
|
|
|
|
(i'm from Brazil, so MT and ET aren't so familiar to me, but I've searched...)
between ET and MT there are 2 hours of difference, so, you can add 2 hours to your time in ET to convert it to time in MT (if this is really necessary, please, verify) so, you can use the following select to get only the records that didn't match:
SELECT A.*, B.*
FROM A
INNER JOIN B
ON A.A = B.A
WHERE (A.B <> B.B
OR A.C <> B.C
OR DATEADD(hour, 2, A.D) <> B.D
OR A.E <> B.E)
as you can see, it's very simple, but i'm making a lot of assumptions here, i'm assuming that your tables have a relation (foreign key constraint), that the field "A" on the two tables is the id of the transaction, that table B uses time in MT and that you care about any differences
also, about times in different time zones, watch daylight saving time, this depends on the state that the time is saved, as a general warning, would be much better if your date and time were stored in UTC(so you don't need to care about time zones and DST) and in yyyy-MM-dd format.
if this didn't solve your problem, please, let me know, so i can try to help you again.
I'm brazilian and english (well, human languages in general) aren't my best skill, so, sorry by my english. (if you want we can speak in C# or VB.Net =p)
|
|
|
|
|
Thanks a lot, Sorry about the time confusion. I'll try this and I'll let you know if it works.
|
|
|
|
|
Is it possible not to write a code in SQl and instead do it visual studio? Also, the unmatched data output needs to be in PDF file and also in charts. Any idea on this?
|
|
|
|
|
yes, it's possible to write this code in C#, although, i can't think of a situation were you would like to bring all the data in the table to your application to do this, but if you really want, i suggest to take a read on the article that PIEBALDconsult indicated on this answer: http://www.codeproject.com/Messages/4250500/Re-finding-unmatched-record-data-in-two-sql-tables.aspx[^]
also, about PDF and charts, i can't help you on this, but are various articles in this site about this, i've made a rapid search: http://www.codeproject.com/search.aspx?q=write+pdf+tag%3aC%23&doctypeid=1%3b2%3b3&sort=ratingdesc[^]
i think this one is worthy a read: Gios PDF .NET library[^]
I'm brazilian and english (well, human languages in general) aren't my best skill, so, sorry by my english. (if you want we can speak in C# or VB.Net =p)
|
|
|
|
|
Thank you so much!You Rock! if you were here in US,I'd be taking you to lunch lol!
|
|
|
|
|
I don't think that would work. Surely an outer join is necessary?
Something like this:
SELECT A.*, B.*
FROM A
FULL OUTER JOIN B
ON A.A = B.A AND <OTHERS>
WHERE A.A IS NULL OR B.A IS NULL
|
|
|
|
|
the inner join is to take the correspondingly registries, that have the same key, in the "where" is where the actual matching is performed, verifing what fields of the table doesn't match. the id must always match, else, how do you know what transaction corresponds to what?
in your query you take the registries that don't have pair in the other table, what the op seems do seek is the registries that have pair, but with different values.
I'm brazilian and english (well, human languages in general) aren't my best skill, so, sorry by my english. (if you want we can speak in C# or VB.Net =p)
|
|
|
|
|
I was reading an article a few minutes ago here on CP that discussed how to host a Form designer. I do not have any particular use for it right now but I was curious. So I got it up and running, it works well and as expected. I began looking around on MSDN for the various things I could do with it, such as the various Service interfaces for the designer. Now I have run into a bit of an issue with one of these services.
I was looking for a way to be notified when a control has been added (via the IToolboxService I created). The only thing I can find, which may be the incorrect method and someone please tell me if so, is the IDesignerEventService. It has events like "ActiveDesignerChanged" and "DesignerCreated". So I figured I could hook the "DesignerCreated" event up and remove the IToolboxService when that event is fired. Here is how I did it:
IDesignerEventService evt = designSurface.GetService(typeof(IDesignerEventService)) as IDesignerEventService;
if (evt != null)
evt.DesignerCreated += new DesignerEventHandler(evt_DesignerCreated);
However, "evt" ALWAYS has a 'null' value, therefore never being able to receive the desired event. Anyone have an idea why this is happening? I have hooked up other events with no problem but this one is being a PITA. 
Thanks in advance!
------------------
SOLUTION:
As far as receiving events, I went with Pete's advice and I implemented "IComponentChangeEvent". In order to load/save the form design I was able to "decipher" the article I was reading. This is the article on MSDN. I am close to completing my little test that I have been working on in order to learn more about the subject.  Thanks again!
djj55: Nice but may have a permission problem
Pete O'Hanlon: He has my permission to run it.
modified 14-May-12 19:46pm.
|
|
|
|
|
OK, a couple of things here. First of all, you really should get the design service from IDesignerHost service. Basically, this is responsible for the lifetime management of designers, so is the appropriate place to get an instance of a designer from.
Now, onto the point of what you are trying to do. You actually need IComponentChangeService if you want to find when a component has been added or removed to the designer surface. Have a look at this[^].
|
|
|
|
|
Thank you for the information. That is what I was looking for. I appreciate it!
How about key press events on the designer? I have gone to Google for this as well, though with no luck.
EDIT:
Nevermind, I figured it out. I simply handled the "KeyDown" even of the application form and it works perfectly. Thank you for your help!
djj55: Nice but may have a permission problem
Pete O'Hanlon: He has my permission to run it.
modified 14-May-12 13:05pm.
|
|
|
|
|
Excellent. Congratulations on this. The VS object model is a bit of a bitch to work with.
|
|
|
|
|
Yeah, that has become quite apparent in the past few weeks for me. I've been messing with a lot of it out of curiosity. Haha.
djj55: Nice but may have a permission problem
Pete O'Hanlon: He has my permission to run it.
|
|
|
|
|
One more question. Do you have anything I can read which can help me out with saving the form's layout to a file for later use? I am trying to figure out how to save it and re-open it.
djj55: Nice but may have a permission problem
Pete O'Hanlon: He has my permission to run it.
|
|
|
|
|
I don't I'm afraid. I come into this from the other side - from automating Visual Studio.
|
|
|
|
|
Alright, I will do some more digging elsewhere. I figured out I need to use a DesignerLoader. However, I am not sure how to implement it, as it is an abstract base class that you must derive from in order to provide functionality. I found a code sample but the code seems really unorganized to me. And the article (not here on CP) does not explain it very well.
djj55: Nice but may have a permission problem
Pete O'Hanlon: He has my permission to run it.
|
|
|
|
|
I have a database design for logging errors including program name, method name, all parameters passed to the method, and all parameters passed in a database call.
We are using CommonLogging for some of our log calls that will bind to log4net for the log functions. I have read tutorials and documentation indicating I can pass individual fields that are custom to the program. But they are all for a flat logging record, not deep for posting parameters.
What I'd like to do is configure log4net to call a custom logger passing my parameters to it, and doing the database writes.
Does anyone know if this is possible with the log4net configuration or not?
|
|
|
|
|
i have .jar file that contains costomized sha 256 code , now i need to use the same code on sql server, after googling i found that i need to write a code in
c# clr and call .jar file from it and then call clr proc from sql server
|
|
|
|
|
If you need to provide interop between .NET and Java, I find that ikvm[^] is the best way to achieve this.
|
|
|
|
|
Looks interesting. Worth a mention in Free Tools?
Peter
Software rusts. Simon Stephenson, ca 1994.
|
|
|
|
|
|
I want to run some url and don't want to popup.
Below code is calling default2.aspx but do not execute javascript which is in the default2.aspx.
url = "http://localhost:56286/PIS_INTERFACE/default2.aspx";
URLReq = (HttpWebRequest)WebRequest.Create(url);
URLRes = (HttpWebResponse)URLReq.GetResponse();
Below code is default2.aspx.
<script type="text/javascript">
alert("default2.aspx");
</script>
</body>
hi
My english is a little.
anyway, nice to meet you~~
and give me your advice anytime~
|
|
|
|
|
What exactly you are trying to achieve
============================================
The grass is always greener on the other side of the fence
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
