|
In addition to Dalek Dave answer I am suggesting you to read these article [ Link1[^] and Link2[^] ] for more information
|
|
|
|
|
Hallo
I have two tables, let's say one Customers and one Orders, joined by CustomerID.
I represented each one by a datatable of its own in a dataset, and I created a DataRelation.
I would like to use them as datasource for one single BindingSource: is it possible?
|
|
|
|
|
I suppose it depends on the control. DataGrid(View)s can do that sort of thing, but it's generally not a good thing to use. I prefer a TreeView.
What would you want the control to do?
|
|
|
|
|
Hallo, thanks for reply.
The control will display data from the bindingsource and permit editing.
I'm currently using a dgv, but I'm actually aiming to use a treeview to list data informations, and a form to edit each single entry.
My main question is still: could a bindingsource be bound to a couple of joined tables?
|
|
|
|
|
My main response is still: it depends on the control.
|
|
|
|
|
Hi Guys,
does anyone know of a way / programme to convert Powershell scripts into C# code?
i have a short script that i need to convert and it is proving pretty tricky!
Many Thanks,
Phil
|
|
|
|
|
Hi,
Maybe seeing the original Powershell script could help 
|
|
|
|
|
cls
$ErrorActionPreference = "SilentlyContinue"
$servers = Get-Content c:\Temp\servers.txt
foreach($srv in $servers)
{
try
{
$ID = New-Object System.Security.Principal.NTAccount("AccountName")
$SID = $ID.Translate([system.Security.Principal.SecurityIdentifier]).ToString()
$WMISDDL = "A;CI;CCWP;;;" + $SID
$WMISDDLPartialMatch = "A;\w*;\w+;;;" + $SID
$security = Get-WmiObject -ComputerName $srv -Namespace root -Class __SystemSecurity
$binarySD = @($null)
$result = $security.PsBase.InvokeMethod("GetSD",$binarySD)
write-host "`tConverting current permissions to SDDL format..."
$converter = new-object system.management.ManagementClass Win32_SecurityDescriptorHelper
$CurrentWMISDDL = $converter.BinarySDToSDDL($binarySD[0])
write-host "`tBuilding the new permissions..."
if (($CurrentWMISDDL.SDDL -match $WMISDDLPartialMatch) -and ($CurrentWMISDDL.SDDL -notmatch $WMISDDL))
{
$NewWMISDDL = $CurrentWMISDDL.SDDL -replace $WMISDDLPartialMatch, $WMISDDL
}
else
{
$NewWMISDDL = $CurrentWMISDDL.SDDL += "(" + $WMISDDL + ")"
}
# Convert SDDL back to Binary
write-host `t"Converting SDDL back into binary form..."
$WMIbinarySD = $converter.SDDLToBinarySD($NewWMISDDL)
$WMIconvertedPermissions = ,$WMIbinarySD.BinarySD
# Apply the changes
write-host "`tApplying changes..."
if($CurrentWMISDDL.SDDL.ToString().Contains($WMISDDL.ToString()))
{
write-host "`tCurrent WMI Permissions matches desired value..."
}
else
{
$result = $security.PsBase.InvokeMethod("SetSD",$WMIconvertedPermissions)
if($result='0'){write-host "`t`tApplied WMI Security complete."}
}
}
catch
{
Write-Host $Error[$Error.Count - 1].ToString()
}
}
Write-Host "`nFinished" -ForegroundColor DarkBlue
modified on Thursday, February 24, 2011 7:29 AM
|
|
|
|
|
Surround your code with <pre></pre> tags so it is readable.
I must get a clever new signature for 2011.
|
|
|
|
|
ok, i have done this now.
|
|
|
|
|
Philip Lane wrote: does anyone know of a way / programme to convert Powershell scripts into C# code?
Read a line of the script, and translate/convert it to C#. It's a manual proces where you interpret what the script should do, and write some code that does the same.
Philip Lane wrote: i have a short script that i need to convert and it is proving pretty tricky!
Can you point out where you're stuck with translating?
I are Troll 
|
|
|
|
|
the big problem is witht he casting. in PS it automatically decides what object type it needs to be but in C# it need to be specified. the code below compiles but line 11 errors saying - "Invalid parameter"
any help would be great thanks.
here is what i have so far:
InvokeMethodOptions imo = new InvokeMethodOptions();
imo.Timeout = new TimeSpan(0, 0, 0, 5);
NTAccount ID = new NTAccount(uName);
string SID = ID.Translate(typeof(SecurityIdentifier)).ToString();
string WMISDDL = "A;CI;CCWP;;;" + SID;
string WMISDDLPartialMatch = "A;\\w*;\\w+;;;" + SID;
ManagementClass security = new ManagementClass(new ManagementPath("\\\\" + server + "\\root\\Security:__SystemSecurity"));
object BinarySD = null;
ManagementBaseObject result = (ManagementBaseObject)security.InvokeMethod("GetSD", (ManagementBaseObject)BinarySD, imo);
ManagementClass converter = new ManagementClass("\\\\" + server + "\\root\\CIMV2:Win32_SecurityDescriptorHelper");
ManagementBaseObject CurrentWMISDDL = (ManagementBaseObject)converter.InvokeMethod("BinarySDToSDDL", (ManagementBaseObject) BinarySD, imo);
string NewWMISDDL;
if (CurrentWMISDDL.Properties["SDDL"].ToString() == WMISDDLPartialMatch && CurrentWMISDDL.Properties["SDDL"].ToString() != WMISDDL)
{
NewWMISDDL = CurrentWMISDDL.Properties["SDDL"].ToString().Replace(WMISDDLPartialMatch, WMISDDL);
}
else
{
NewWMISDDL = CurrentWMISDDL.Properties["SDDL"].ToString() + "(" + WMISDDL +")";
}
ManagementObject WMIBinarySD = (ManagementObject)converter.InvokeMethod("SDDLToBinarySD", new object[] { NewWMISDDL });
ManagementBaseObject WMIConvertedPerms = (ManagementBaseObject)WMIBinarySD.Properties["BinarySD"].Value;
if (CurrentWMISDDL.Properties["SDDL"].ToString().Contains(WMISDDL.ToString()))
{
Console.WriteLine("Current WMI permissions already match desired value.");
}
else
{
result = (ManagementObject)security.InvokeMethod("SetSD", new object[] { WMIConvertedPerms });
if ((Int32)result.GetPropertyValue("ReturnValue") == 0)
{
Console.WriteLine("Applied WMI security permissions.");
}
else
{
Console.WriteLine("Error applying permissions!");
}
}
}
catch (Exception exp)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine("Error: " + exp.Message.ToString());
Console.ResetColor();
}
Many Thanks,
Phil
|
|
|
|
|
That'd be this line;
ManagementBaseObject CurrentWMISDDL = (ManagementBaseObject)converter.InvokeMethod("BinarySDToSDDL", (ManagementBaseObject) BinarySD, imo);
Would that be the invocation of this[^] method? Seems to return an uint32 according to the documentation, taking two parameters.
Take care that you copy the correct version of all the references that the script is using.
I are Troll
|
|
|
|
|
tried that.. didn't work!
says it cant convert it, and other parts of the programme fail! 
|
|
|
|
|
Philip Lane wrote: tried that.. didn't work!
says it cant convert it
Compile-time or run-time?
Break up the statement into smaller pieces, so that you can check the assignment, the cast and the invoking of the function separately.
I are Troll
|
|
|
|
|
run-time.
i have tried what you suggested and it all looks fine!
|
|
|
|
|
Hi,
I am designing simple Calculator. And TextBox contains "300+500-10" values.
Kindly let me know, how may I calculate it from TextBox ? or Let me know another method.
Thank you
(Riaz)
|
|
|
|
|
Follow the link below:
http://www.codeproject.com/KB/recipes/MathieuMathParser.aspx?artkw=evaluate expression
Hope this will help.
|
|
|
|
|
Thanks for Helping friend
|
|
|
|
|
If you look above the text box when you enter a reply, there are two "link" widgets.
If you highlight your link, and press one of the widgets, it converts the link to a clickable link: easier for people to use, and looks better!
Your original:
http://www.codeproject.com/KB/recipes/MathieuMathParser.aspx
First "link"
An extensible math expression parser with plug-ins
Second "link[^]" (It gives a "new window/tab" option to the link)
An extensible math expression parser with plug-ins[^]
Much prettier!
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Digital man: "You are, in short, an idiot with the IQ of an ant and the intellectual capacity of a hose pipe."
|
|
|
|
|
Thanks for pointing it out.
Will use it next time. 
|
|
|
|
|
Welcome!
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Digital man: "You are, in short, an idiot with the IQ of an ant and the intellectual capacity of a hose pipe."
|
|
|
|
|
|
Hi,
I am trying to delete some nodes from an xml document. I am using LINQ to xml and want to stick to this approach. Here is my XML document:
<?xml version="1.0" encoding="utf-8"?>
<Project>
<Clips>
<Clip ID="1" Sequence="1">
<Name></Name>
<Description></Description>
<Location></Location>
<Duration></Duration>
<Images>
<Image ID="1">
<Name></Name>
<Description></Description>
<Location></Location>
<StartTime></StartTime>
<EndTime></EndTime>
</Image>
</Images>
</Clip>
<Clip ID="2" Sequence="1">
<Name>Bazingaaa</Name>
<Description>Masdljaslda</Description>
<Location>C:\Videos</Location>
<Duration>00:00:30</Duration>
<Images>
<Image ID="1">
<Name>Faheem</Name>
<Description>MyImage</Description>
<Location>C:\Images</Location>
<StartTime>00:00:00</StartTime>
<EndTime>00:00:10</EndTime>
</Image>
<Image ID="2">
<Name>Fawaz</Name>
<Description>MyImage</Description>
<Location>C:\Images</Location>
<StartTime>00:00:00</StartTime>
<EndTime>00:00:10</EndTime>
</Image>
</Images>
</Clip>
</Clips>
</Project>
I have to perform two cases. 1. Delete clip node based on ID. 2. Clear whole project root tag.
I am using the following code to delete nodes.
IEnumerable<XElement> clip = (from c in this.oProjectDoc.Element("Project").Element("Clips").Elements("Clip")
where c.Attribute("ID").Value.Equals(ID)
select c);
foreach (XElement xe in clip)
xe.Remove();
this.oProjectDoc.Save(this.oProjectPath.FullName);
Have tried this as well.
var q = from node in oProjectDoc.Root.DescendantsAndSelf("Clips")
let attr = node.Attribute("ID")
where attr != null && attr.Value == clipId
select node;
q.ToList().ForEach(x => x.Remove());
oProjectDoc.Save(this.oProjectPath.FullName);
Problem happens when i try to delete the last clip node or the clear the whole root "Project" tag. I get a lingering end node tag. Like:
</Clip>
Any solutions to that. Kindly please also tell me how can clear all my nodes from xml document. i.e. totally empty my xml document and start afresh without deleting the xml file.
Thanks in advance
Regards...
|
|
|
|
|
Instead of this:
var q = from node in oProjectDoc.Root.DescendantsAndSelf("Clips")
let attr = node.Attribute("ID")
where attr != null && attr.Value == clipId
select node;
q.ToList().ForEach(x => x.Remove());
Why can't you do this:
var q = (from node in oProjectDoc.Root.DescendantsAndSelf("Clips")
let attr = node.Attribute("ID")
where attr != null && attr.Value != clipId
select node);
oProjectDoc.Root.RemoveAll();
foreach(XElement element in q)
{
oProjectDoc.Root.Add(element);
}
".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
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
