|
jebin k wrote: all the Records in Table 1 and Table 2 will not be same.
That's a funny definition of "exact match". 
jebin k wrote: I need the nearest match from Table 2 for Table 1 record.
You can count how many of the fields that match with something like:
case when t1.Event=t2.Event then 1 else 0 end +<br />
case when t1.Venue=t2.Venue then 1 else 0 end +<br />
case when t1.Date=t2.Date then 1 else 0 end +<br />
case when t1.Cost=t2.Cost then 1 else 0 end
You can sort on the value using descending order to get the best matches first, and filter out only the matches that reaches a certain value.
You can use other values than 1 in each case if you want the fields to have different importance.
---
single minded; short sighted; long gone;
|
|
|
|
|
Sorry for the wrong word (Exact match) , Thanks for your advice.
|
|
|
|
|
What you could do is take the row from table one, load it into some variables,
Once you have your fields loaded up, you would iterate through table 2, and if the first column matches, look at the second column, and contiue for all columns, if one of them doesn't match, then break out out of the loop, and continue to the next row.
Once you find a row that has all columns matching, break out of the loop and return success.
Hope that helps
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
Field values will not be exactly same, 2 fields date and cost will be same but other two string columns will not be exactly same .
(Eg Dallas Cowboys vs Chicago bulls will be there in Table 1 Event Column where as Cowboys Vs Chicago bulls will be in Table2 Event Column and other columns will be same..
|
|
|
|
|
As you've been told, the general idea is to take your "search" record in table 1 and itterate through your "List" records in table 2 to look fgor a match. The fact that it is not an exact match is irrelevant. You must decide your algorythm for determining a match and use that within the itteration. The general process is the same!
|
|
|
|
|
how can i create inventory system with database??
plss help me..
|
|
|
|
|
That's a big vague. Start by defining what you want this inventory system to do.
|
|
|
|
|
Hi, I'm new to asp.net and C# and am having problems understanding how to create custom events. I have looked at various sites and the most basic examples that I have been able to find are far too complicated for novices.
The tutorials that I have found all seem to suggest that, to create custom events, I need to write delegates and event handlers to start with but they are unclear and not specific.
Also, some of the code I have downloaded is dated and does not work with VS2005 and what happened to starting with the basics?! I.e. right from scratch.
Does anyone know any sites/links that might be useful to me.
Specifically, I want to be able to have to separate controls (ascx) linked to a parent control. Where one of the child contols contains a textBox and a button to submit text which will make the said text appear in the label of the other child control.
Any help truly appreciated,
Dave
|
|
|
|
|
Here's quite a good article on the subject (skip down to the step-by-step bit)
http://www.ondotnet.com/pub/a/dotnet/2002/04/15/events.html[^]
Me: Can you see the "up" arrow?
User:Errr...ummm....no.
Me: Can you see an arrow that points upwards?
User: Oh yes, I see it now!
-Excerpt from a support call taken by me, 08/31/2007
|
|
|
|
|
Hi all,
I have Visio 2007 installed in my system. I would like to know how I can proceed in generating skeletal code from my Class diagrams designed in Visio.
Even I tried to do reverse engineering using Visio tool bar available in Visual studio 2005. But it resulted in blank Visio project.
Thanks in advance,
Regards,
Krishnaraj
|
|
|
|
|
Hello!
When using a virtual listview, is it possible get new items added to the top of the listview instead of the bottom?
|
|
|
|
|
Hi!
Of course it is. With a virtual LV you handle the collection of items yourself.
If you insert new items into your element collection at the beginning, then these elements should appear at the top of the LV as well (if you create the ListViewItems according to the order of your element collection, which usually is the case).
Regards,
mav
--
Black holes are the places where God divided by 0...
|
|
|
|
|
But then I guess you mean I have to store all elements in some list (with the newest items first) and clear the listview every time I want to update it.
|
|
|
|
|
You don't have to clear the LV on every update. When the LV is in virtual mode, you're getting notified every time the LV needs to show a ListViewItem.
In this event handler you create a ListViewItem and return it to the LV.
In order to be able to know which element to create a ListViewItem for, you get an index into the list of elements. If you insert elements at the beginning of your list (and set the VirtualListSize accordingly), you'll be able to see the results immediately.
Regards,
mav
--
Black holes are the places where God divided by 0...
|
|
|
|
|
Hi
I have spent the last few days surfing the net on WCF and on how to configure it, but I can't seem to find the correct solution.
I have made an application, that is used on internal lan (Client/Server). I would like to use the existing windows logon, and integrate with the local domain controller.
Additional I would like to have the option to enter an other windows logon, than the one the user is currently logged on with.
Security is not that big a concern, because all traffic is internal and the information is not very sensitive - but of cause it should not be ignored.
I would like to avoid having to setup SSL and manage certificates - It makes it harder to deploy, and if I have to purchase a certificate for every customer, it raises the price of the product.
How would you recommend setting up WCF in this scenario?
|
|
|
|
|
For a start, as it is internal, I would use NetTcpBinding. I'm not sure what else you want to know, but it's easy enough for you to get the windows user.
When it comes to using the user information, you can retrieve the users identity back like this:
WindowsIdentity id = ServiceSecurityContext.Current.WindowsIdentity; If you want to perform some impersionation with this value, you would just use:
using (id.Impersonate())
{
}
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hi Pete
Thank you for the speedy reply!
Is it really that simple? - I looked at message security configurations, that seemed far more complex.
E.g http://msdn2.microsoft.com/en-us/library/ms789011.aspx
Do you know how to specify the credentials on the client side, if entered manually?
|
|
|
|
|
Hi,
My code is
string connectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Documents and Settings\\venki\\My Documents\\Visual Studio 2005\\Projects\\CallCenterProject\\CallCenterProject\\new.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
SqlConnection conn = new SqlConnection();
conn.ConnectionString = connectionString;
SqlCommand cmd1 = new SqlCommand();
cmd1.Connection = conn;
cmd1.CommandText = "SELECT * FROM CustomerDetails WHERE OwnerId='" + label4.Text + "'";
cmd1.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd1;
DataSet DataSet2 = new DataSet();
da.Fill(DataSet2, "CustomerDetails");
ReportDocument rpt = new ReportDocument();
rpt.SetDataSource(DataSet2); crystalReportViewer2.ReportSource = rpt;
*****************************************************************************
I am getting an error at the above bolded statement.
Please Help Immediately..........
Priya
|
|
|
|
|
iet2000 wrote: Please Help Immediately..........
This is a volunteer only forum. We'll help when we can.
What error are you getting? Without this small but absolutely vital piece of information, there's absolutely nothing that we can do to help.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Pete O`Hanlon wrote: This is a volunteer only forum. We'll help when we can.
We expressed our urgency. Thats it....Persons who can understand the situation may give the reply immediately.... capabilties is not the issue here....We just want the solution to our problem...
No hard feelings
the error is " invalid report filepath".... at
ReportDocument rpt = new ReportDocument();
rpt.SetDataSource(DataSet2);
Regards
Priya
|
|
|
|
|
You have got to be freaking kidding me.
If you can't figure out what the problem is from that error message, you shouldn't be programming in the first place.
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
Your attitude stinks and it doesn't surprise me you received little help.
Plenty of hard feelings.
"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF
"This time yesterday, I still had 24 hours to meet the deadline I've just missed today."
|
|
|
|
|
Malcolm Smart wrote: Your attitude stinks and it doesn't surprise me you received little help.
Whatever it is.... We got plenty of help from most of the subscribers of this site......Because its not our attitude but the perception is stinking...
Dont get surprised....By the way its better if you get to know that this is not the platform to demoralise others....
If you want to respond to for any messages just see whats the problem regarding the subject not the way it is portrayed.
We least bothered about the replies for this message!!!!!!
Priya
|
|
|
|
|
I have created service using WCF named pipe binding. I want to check whether any of my end point for the service with particular address is in use or not? How I can do it?
e.g. I have configured the endpoint using address "net.pipe//localhost/Test/ABC". Now if client tries to connect to the same end point again I want to catch this situation.
Can any one suggest the idea or direct me towards some documentation on it.
Thanks
Krunal C
|
|
|
|
|
Hello there
I have a Listview on a form that gets data when a user types in a barcode and it checks the database and loads the productname,sellingprice in the listview
I have 2 similar questions:
How would I send the listviews sellingprices to a total variable using a loop ofcos and
how do i send the data from the listview to any other location like textbox,listbox etc
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
