|
Problems: Not the WS itself, error with password to access the DB.
|
|
|
|
|
|
Did you want to ask a question about code you're writing or did you just want to beg for code?
Begging for code isn't going to get you any where. This isn't a "code to order" site.
|
|
|
|
|
We are more than willing to help those that are stuck: but that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for us to do it all for you.
So we need you to do the work, and we will help you when you get stuck. That doesn't mean we will give you a step by step solution you can hand in!
Start by explaining where you are at the moment, and what the next step in the process is. Then tell us what you have tried to get that next step working, and what happened when you did.
If you are having problems getting started at all, then this may help: How to Write Code to Solve a Problem, A Beginner's Guide[^]
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
If I am researching a new technique or technology, something I like to do is look on Google to see what others have written about the topic. It's very rare that I can't find information supporting it. Sometimes, finding the answers you want is all about the keywords you use, so searching for k-medoids in C# really hit the spot. k-medoid clustering code c - Google Search[^]
|
|
|
|
|
But ... but ... you are here to do that research for me so I can play video games! 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I'm having trouble creating the 32-bit version of a registry key. In RegEdit I can see the 64-bit version of the key, but not the 32-bit version.
This is my code:
RegistryKey Key = RegistryKey.OpenBaseKey(RegistryHive.CurrentUser, RegistryView.Registry64);
RegistryKey WowKey = RegistryKey.OpenBaseKey(RegistryHive.CurrentUser, RegistryView.Registry32);
RegistryKey SubKey = Key.CreateSubKey(@"Software\Company Name\App Name");
RegistryKey WowSubKey = WowKey.CreateSubKey(@"Software\Company Name\App Name"); Where is the 32-bit version of the key supposed to show up in RegEdit?
I thought it's supposed to show up here:
HKEY_CURRENT_USER\SOFTWARE\Wow6432Node
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
You're creating a key with the 32-bit view, but that doesn't mean the keys you create end up under Wow6432Node. It's being created exactly where you told it to be created:
HKEY_CURRENT_USER\SOFTWARE\Company Name\App Name
The first line creates the key, then the second line tries to create the same key but it's already there, so it just returns a handle to the existing key. You now have two views, 64 and 32-bit, of the exact same key.
Change the names of the keys you're creating in the 32-bit version of the code and watch what happens.
EDIT:
It doesn't seem changing the view does anything. Both views read/write to the exact same key.
|
|
|
|
|
Thank you for your response.
It would appear that that's exactly what's happening.
I'm creating the keys in a 64-bit application, but the keys will be read by both 64 and 32-bit applications.
Are you saying that if the key I create off the 32-bit view base key has a different name, then it will do what I expect?
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
No, it'll just create the separate keys so you can see them both.
If you're going to write to anything under Wow6432Node, I think you have to build that into the path.
The real question is if you create the key under the normal path, "SOFTWARE\CompanyName\AppKey", is it still going to be readble by a 32-bit app on 64-bit Windows. I think that answer is yes.
|
|
|
|
|
I certainly thank you for the education. But I'm a little dismayed that it doesn't work the way I expected it to. It should open the 32-bit view if I specify so.
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
It's going to take a bit of homework, but I think Registry Reflection was removed from Windows, or at least disabled by default, in Windows 7. There's still may be a way to turn it back on and experiment with some true 64-bit and 32-bit apps. Leaving the build on AnyCPU would tend to add a variable to the experiments.
|
|
|
|
|
Reading data from xml file and load into datatable. i can not load data into List<t> because datatable has some dynamic column whose name is not known at compile time.
I have one List<t> and one datatable. _AllCommentsData is List<t> and dtData has datatable.
More or less _AllCommentsData has 10,000 to 20,000 data and dtData datatable has high volume of data. approx some dtData datatable has 70,00,000 data means 7 million data. when traversing in high volume of data and update one column value is taking long time. so guide me how to refactor or restructure the code as a result update one column value with high volume of data would take very less time. any work around exist to deal this situation?
i could join my datatable and List together and update field value but i could not do it because few column name is dynamic in datatable. so in LINQ select i can not mention their name and that is the reason i query datatable in loop and update data.
can i use Parallel.For() or AsParallel ? please guide me with some sample code which i can use to speed the data updation when there is high volume of data in data table. Thanks
My Sample Code which is taking long time for high volume of data.
foreach (var item in _AllCommentsData.Where(a => a.CommentType == "Only LI"))
{
if(item.Comments!="")
{
tmpData = dtData.AsEnumerable().Where(a => a.Field<string>("Section") == item.section
&& a.Field<string>("LineItem") == item.LineItem
&& (a.Field<int?>("EarningID") == null ? 0 : a.Field<int>("EarningID")) == item.EarningID);
if (tmpData != null && tmpData.Count() > 0)
{
tmpData.ForEach(x =>
{
x["LI_Comment"] = 1;
});
}
}
}
|
|
|
|
|
Have a look at my answer to your previous question: C# How to speed up for loop with large data iteration[^]
It's the same question - so it has the same solution, and the same caveats.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
It comes back to you refusing to learn SQL.
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
The project where i am working now it is based on xml repositories not db driven. so just for speed i can not change from file system to db. if possible see my posted code and guide how to refactor the code to enhance performance.
|
|
|
|
|
You didn't say where the "xml repositories" are located. The data can be local, on an intranet or an internet.
XML can be compressed to a fraction; how is it being transported?
Are you deserializing to entities ("typing") or working with it "raw"? Ergo, XML can be deserialized to a database.
You want to deal with everything except with what's needed (learning).
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
You have 7 million records in a XML file? That's beyond stupid, because you have to write the entire file any time even one data item has changed. Even using Access is preferable to that.
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
Again, most if this should be done by the database-server. A lot of the work and processing can be offloaded there, speeding everything up. Do a SQL query with your CommentType and item.Comments, and you loose an expensive in memory loop where the entire dataset is sent over the wire.
Bastard Programmer from Hell 
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
The project where i am working now it is based on xml repositories not db driven. so just for speed i can not change from file system to db. if possible see my posted code and guide how to refactor the code to enhance performance.
|
|
|
|
|
Mou_kol wrote: The project where i am working now it is based on xml repositories not db driven. so just for speed i can not change from file system to db. if possible see my posted code and guide how to refactor the code to enhance performance.
XML is meant as an exchange format, for imports and exports, not as a datastore.
Bastard Programmer from Hell
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Processing all that number of records into one datatable is just a bad idea. Firstly it will take a long time to extract from the XML and port into the datatable. And as more records are processed, the time taken will increase as the system need to re-allocate memory space. And once you have finished creating the datatable, what can you do with it? Trying to display that amount of data will take forever. You need to redesign your system so it can handle paging of data and only process <100 records at a time.
|
|
|
|
|
Hi,
I have Microsoft.SqlServer.Compact installed in Visual Studio 2019 (Nuget Package Manager). I have accidentally lost its toolbox. Where can I enable it again?
|
|
|
|
|
If you installed it with package manager, I would inspect it under package manager; and then update or reinstall. Or look under "Windows". Or under Tools. Or Data. Or, restart VS in "default mode". Reinstall VS. etc.
It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food
|
|
|
|
|
I have a checklistBox where i populate only name. But the valueMember is an id.
The user can select several name.
I have this code to read the checklistbox (only checked value) and extract the valuemember.
but i only get the item it is selected not all chechking
if (chkListClienteEmail.CheckedItems.Count != 0)
{
for (int i = 0; i <=;= chkListClienteEmail.CheckedItems.Count - 1; i++)
{
string s = chkListClienteEmail.SelectedValue.ToString();
more code...
}
}
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
