|
The assemblies are found in C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies. When you add a reference, go to the "Browse" tab, and select them from that place.
|
|
|
|
|
which license you are having for your VS2010 ?All libraries are not supplies with express edition.You need to get an ultimate or professional license for all the libraries and features.
|
|
|
|
|
VS2010 Professional is what it says, but it's the Academic license. Surely Microsoft isn't cheating students! 
Will Rogers never met me.
|
|
|
|
|
I don't even know where it came from or what it's good for. I dereference it.
|
|
|
|
|
Greeting Gurus,
I have been battling for a while with getting some of the properties of running processes and was hoping for a little assistance.
If I build
Process[] processlist = Process.GetProcesses();
foreach(Process p in processlist)
{
Console.WriteLine("Process: {0} ID: {1}", p.ProcessName, p.Id);
}
Console.ReadLine();
then I get a list of all processes, but if I try
Process[] processlist = Process.GetProcesses();
foreach(Process p in processlist)
{
Console.WriteLine("P: {0} ID: {1} FN: {2} ST: {3}", p.ProcessName, p.Id, p.MainModule.FileName, p.StartTime);
}
Console.ReadLine();I get a Win32Exception unhandled error when the enumeration hits the "System" process PID 4. The error is:-
System.ComponentModel.Win32Exception was unhandled
Message="Unable to enumerate the process modules."
Source="System"
ErrorCode=-2147467259
NativeErrorCode=-2147467259
but I can't find any references as to what to do about it.
I would like to keep it in the list of processes if possible, i.e. not just skip it in order to continue the enumeration.
Could someone advise please?
|
|
|
|
|
You need to filter out the "System" and "Idle" processes, as you won't have permission to access their modulenames. Try something like this:-
Process[] processlist = Process.GetProcesses();
foreach (Process p in processlist)
{
if (p.ProcessName == "System" || p.ProcessName == "Idle")
{
textBox1.Text += string.Format("P: {0} ID: {1}\n", p.ProcessName, p.Id);
}
else
{
textBox1.Text += string.Format("P: {0} ID: {1} FN: {2} ST: {3}\n", p.ProcessName, p.Id, p.MainModule.FileName, p.StartTime);
}
}
When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman
|
|
|
|
|
Hi Wayne,
Thanks for that. Interesting though that if I use WMI as a "proxy" running...
ManagementObjectSearcher searcher = new ManagementObjectSearcher("root\\CIMV2", "SELECT * FROM Win32_Process");
foreach (ManagementObject queryObj in searcher.Get())
{
string[] argList = new string[] { string.Empty, string.Empty };
int returnVal = Convert.ToInt32(queryObj.InvokeMethod("GetOwner", argList));
if (returnVal == 0)
{
string owner = argList[1] + "\\" + argList[0];
Console.WriteLine("Name: {0} Owner: {1}", queryObj["Name"], owner);
}
}
It tells me "Name: System Owner: NT AUTHORITY\SYSTEM" and then goes on to list a whole bunch of other NT AUTHORITY\SYSTEM processes. Interesting too that "Idle" doesn't show up in the list.
What are your thoughts?
|
|
|
|
|
I would guess that accessing the Process.MainModule property for that process is throwing the exception, something that should be checked for in your code (accessing that property can throw three possible exceptions).
Mark Salsbery
![Java | [Coffee]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/coffee.gif)
|
|
|
|
|
Hello everyone,
Do you know how to simulate in C#, a VB6 Activex EXE Standalone application which exposes a com visible object (IDispatch wrapper class) already instanced in the 'activex exe like' c# application? The clients accessing it via creatobject / getobject will always get a reference on this object.
This does not seem to be so straight forward as I experimented in vb.net. Is it related to .net interop ?
If I understand well, the best way will be to expose a .NET Remoting object (application life time) then creating a COM interop class library which will be used like a tunnel between the two communication solutions. Is it the only solution ?
Any inputs you could share for this are really welcome ?
Thank you so much in advance.
|
|
|
|
|
|
Meanwhile I found a hack, not the real solution I want.
I created my own TabControl, and replaced the TabPages property, such that my own TabPages property will be linked to my editor:
public class MyTabControl : TabControl
{
public MyTabControl() : base() { }
[Editor(typeof(MyTabPageCollectionEditor), typeof(System.Drawing.Design.UITypeEditor))]
public new TabPageCollection TabPages
{
get { return base.TabPages; }
}
}
But that means that I'd have to replace all TabControls with MyTabControl...
I'd really prefer a solution like the one described at StackOverflow.
Perhaps you can provide some further ideas.
|
|
|
|
|
Hi all
When creating COM dll from C# i get TLB file.
All enums in the file get a prefix of the enum name
is therea way to remove the prefix?
public enum OPTIONS
{
Zoom = -1,
FitWindow,
FitWidth,
FitHeight,
Actual
}
OPTIONS
{
OPTIONS_Zoom = -1,
OPTIONS_FitWindow = 0,
OPTIONS_FitWidth = 1,
OPTIONS_FitHeight = 2,
OPTIONS_Actual = 3
};
Have a nice Day
|
|
|
|
|
There is, but you're not going to be keen on how much work it is. Anyway, if you want to do this you need to follow the steps in this[^] blog.
|
|
|
|
|
Thanks - i red this before
I was hoping for an easier way... 
Have a nice Day
|
|
|
|
|
liqnit wrote: I was hoping for an easier way...
Nope. Sorry.
|
|
|
|
|
I can confirm that that procedure is as easy as it gets.
|
|
|
|
|
|
Im a java developer, new in C#. Im developing a program using C# that saves records of consultations made at a cancer specialised clinic. The user selects a vaccine name, patient, etc. name from records retrived from database and has to get respective ids and use them to update the consultation table in the same database as foreign keys. This is the code that I have, please let me know what I am doing wrong
private void btnSubmit_Click(object sender, EventArgs e)
{
DataSet dataSet = new DataSet();
DataSet vdataSet = new DataSet();
DataSet udataSet = new DataSet();
OleDbCommand cmd = conn.CreateCommand();
OleDbCommand cmdd = conn.CreateCommand();
OleDbCommand com = conn.CreateCommand();
OleDbCommand dbc = conn.CreateCommand();
TextBox patID = new TextBox();
TextBox vacID = new TextBox();
TextBox useID = new TextBox();
patID.Visible = false;
vacID.Visible = false;
useID.Visible = false;
cmd.CommandText = "SELECT patientID FROM patient WHERE fName = '" + cbPatient.GetItemText(cbPatient.SelectedItem) + "'";
cmdd.CommandText = "SELECT vaccineID FROM vaccine WHERE vName = '" + listVaccine.GetItemText(listVaccine.SelectedItem) + "'";
com.CommandText = "SELECT userID FROM userDetails WHERE username = '" + cbUserName.GetItemText(cbUserName.SelectedItem) + "'";
dbc.CommandText = "INSERT INTO Consultation (date, patientID, vaccineID, userID, diagnosis) VALUES ('" + DateTime.Now.ToString() + "', " + patID.Text + ", " + vacID.Text + ", " + useID.Text + ", '" + cbDiagnosis.SelectedItem + "')";
conn.Open();
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(cmd);
OleDbDataAdapter vdataAdapter = new OleDbDataAdapter(cmdd);
OleDbDataAdapter udataAdapter = new OleDbDataAdapter(com);
OleDbDataAdapter da = new OleDbDataAdapter(dbc);
dataAdapter.Fill(dataSet);
vdataAdapter.Fill(vdataSet);
udataAdapter.Fill(udataSet);
patID.Text = dataSet.Tables[0].Rows[0].ItemArray[0].ToString();
vacID.Text = vdataSet.Tables[0].Rows[0].ItemArray[0].ToString();
useID.Text = udataSet.Tables[0].Rows[0].ItemArray[0].ToString();
MessageBox.Show(patID.Text);
MessageBox.Show(vacID.Text);
MessageBox.Show(useID.Text);
dbc.ExecuteNonQuery();
conn.Close();
MessageBox.Show("Entry added!");
}
|
|
|
|
|
1. Please use <pre> tags round your code, and indentation in it, so that it is readable.
2. Please explain what problem you are having with the above code.
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
|
That looks like it should work (assuming that that insert statement matches the schema of the table you're trying to put stuff into), though having retrieved the three tables you probably want to set them as DataSource on something. What problem are you having?
You should use parameterised queries though, as they're better in several ways and avoid the possibility of a SQL injection attack (which would appear to be present here).
|
|
|
|
|
Print your SQL string before you use them.
You need to expect that exceptions will occur and you must provide a mechanism for dealing with them in some way.
I doubt that you are correctly constructing the value for 'date'.
|
|
|
|
|
Is any Linked Open data projects in C#, ASP.Net available for learning RDF/XML?
|
|
|
|
|
Don't just post the same question in Q&A and the forums - pick one and stick to it.
Ideological Purity is no substitute for being able to stick your thumb down a pipe to stop the water
|
|
|
|
|
I need to change the location of where a database file is located in a C#.net 2008 desktop application, but I am hacing problems. When stepping through the code, I find that I need to change a 'settings.settings' file. Bascially I need to be able to access the properties in some kind of a designer and I jhave not be able to do that. Would you have an idea of where I can obtain the directions to access the settings.settings file?
|
|
|
|
|
Assuming that you are using Visual Studio then use your mouse to right-click on the project name and select Properties. This will open a project properties tab and the settings selector is half way down on the left. Select the relevant item and edit as required.
Alternatively check the Properties folder in your project directory and you will find the file there. It's an XML file that you can edit with your favourite editor.
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
