|
If the columns in common between the tables have unique values, you can define them as foreign keys with the ON UPDATE CASCADE constraint (assuming the database supports foreign keys - I know SQLite only recently added support for them). When you update the column in the table being referenced, it will automatically update the column in the other table. I'm not certain if it works the other way around, but I think it does.
DybsThe shout of progress is not "Eureka!" it's "Strange... that's not what i expected". - peterchen
|
|
|
|
|
Hi,
I want to run some processes on a remote PC using WMI and C#. One of the PC runs XP SP3 and the other PC runs XP SP2. But I keep getting "access denied" errors. some of the errors are:
1. Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
2."error Logon failure:the user has not been granted the requested logon type at this computer."
Both computers are workgroup computers.i have tried the following with no avail.
I use a login with administrative privileges. In addition I have enabled this account to be remote enabled using
dcomcnfg >DCOM Config >Windows Management Instrumentation > properties on the remote computer.
From security options, I changed "Network access:Sharing and security options for local accounts"
to "Classic: Local users authenticate as themselves." on the remote computer
Disabled the fire wall
Note that code works fine on local host.
Can anybody help?
Here is the code I am using
using System;
using System.Collections.Generic;
using System.Text;
using System.Management;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
string userName = "sara";
string password = "titina";
string domain = null;
string machineName = "192.168.12.20";
ConnectionOptions options = new ConnectionOptions();
if (domain != null)
{
options.Username = domain + "\\" + userName;
}
options.Username = userName;
options.Password = password;
options.Impersonation = ImpersonationLevel.Impersonate;
options.Authentication = AuthenticationLevel.Packet;
options.EnablePrivileges = true;
ManagementScope connectScope = new ManagementScope();
connectScope.Path = new ManagementPath(@"\\" + machineName + @"\root\CIMV2");
connectScope.Options = options;
try
{
connectScope.Connect();
}
catch (ManagementException e)
{
Console.WriteLine("An Error Occurred: " + e.Message.ToString());
}
catch (AccessViolationException ee)
{
string processName = "notepad.exe";
Console.WriteLine("Creating Process: " + processName);
Console.WriteLine(process.CreateProcess(processName));
Console.WriteLine("Killing Process: " + processName);
Console.WriteLine("Process Terminated");
Console.ReadLine();
}
}
}
}
|
|
|
|
|
Hi !
For
> connectScope.Path = new ManagementPath(@"\\" + machineName + @"\root\CIMV2");
there is at my computer the same errormessage poping up in the line
> connectScope.Connect();
When I change the entry
> string machineName = "192.168.12.20";
to the real alpha machine name (not IP-Address !), it works.
Best regards,
Gerrit
|
|
|
|
|
Thank for the reply. I tried your suggestion still, It says
"The RPC Server is unavailable".
|
|
|
|
|
hi.....
i want a progress bar while loading the page in windows application C#.
plz give me the code.
|
|
|
|
|
hi there is a one toolkit available in the ajax cotrol tool kit that is progess tool so first try yourself to use this tool ....
after that i will give you code...
If You Get your answer then please Rating me...
Thanks..
"Are You Ready"
DX-ARMY
|
|
|
|
|
I written the code :
this.progressBar1.Location = new System.Drawing.Point(88, 232);
this.progressBar1.Name = "progressBar1";
this.progressBar1.TabIndex = 0;
this.progressBar1.Maximum = 10000;
this.progressBar1.Minimum = 1;
this.progressBar1.Step = 1;
for (int i = progressBar1.Minimum; i <= progressBar1.Maximum; i++)
{
progressBar1.PerformStep();
}
I write this code in pageload it go infinite loop.
plz help me.........
|
|
|
|
|
dear donto get upset read following link i am sure it will help you
<a href="http://www.beansoftware.com/ASP.NET-Tutorials/ProgressBar-User-Control.aspx">http://www.beansoftware.com/ASP.NET-Tutorials/ProgressBar-User-Control.aspx</a>[<a href="http://www.beansoftware.com/ASP.NET-Tutorials/ProgressBar-User-Control.aspx" target="_blank" title="New Window">^</a>]
If You Get your answer then please Rating me...
Thanks..
"Are You Ready"
DX-ARMY
|
|
|
|
|
hi.........
i have written code in windows application as follows
app.config
<connectinsring>
<add name="Employee.Properties.Settings.EmpdetailsConnectionString"
="" connectionstring="Data Source=SPARK1\SQLEXPRESS;Initial Catalog=Empdetails;Integrated Security=True;Pooling=False" providername="System.Data.SqlClient">
program.cs
string conString = ConfigurationManager.ConnectionStrings["Employee.Properties.Settings.EmpdetailsConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(conString);
but it gives error like
1. The name ConfigurationManager Des not exist.
pls help me.......
|
|
|
|
|
Now this is a properly worded question, you have givens us some code, and told us what is wrong. You still need to add the <pre> tags though.
1) You need to reference the System.Configuration dll in your project. (Right click "References", "Add Reference", select the ".Net" tab then select System.Configuration in the list and OK it.
2) Add using System.Configuration; to the top of the file containing your class.Dalek Dave: There are many words that some find offensive, Homosexuality, Alcoholism, Religion, Visual Basic, Manchester United, Butter.
|
|
|
|
|
Thanks a lot.......
this will run but their is an another error is
1.a field initializer can not reference the non static field ,method,property,"EmpDetails.form.conString"
code is:
string conString = ConfigurationManager.ConnectionStrings["Employee.Properties.Settings.EmpdetailsConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(conString);
|
|
|
|
|
Hi,
I suggest you move the assignments (conString and con) to the Form's Load handler.
|
|
|
|
|
hi.......
I have display datagridview.Pls give me the code of ,when i insert the record into database at that time displaying updated datgridview.
|
|
|
|
|
jadhavshubhangi wrote: me the code of
We are not here to do you job for you, just to help if you have a question. Also this is, I assume a repost.Dalek Dave: There are many words that some find offensive, Homosexuality, Alcoholism, Religion, Visual Basic, Manchester United, Butter.
|
|
|
|
|
make a one function in which the data table or data set is bind into the grid view....
after updation call the function immediately... then you will get your updated grid view..
If You Get your answer then please Rating me...
Thanks..
"Are You Ready"
DX-ARMY
|
|
|
|
|
hi........
the code is
con.ConnectionString = "Data Source=SPARK1\\SQLEXPRESS;Initial Catalog=Empdetails;Integrated security=true";
con.Open();
//int p = Convert.ToInt32(dataGridView1.SelectedRows);
String s = "Select * from Empdetails where EmpId=";
SqlCommand cmd = new SqlCommand(s, con);
SqlDataReader dr = cmd.ExecuteReader();
//dataGridView1.DataSource = dr;
//GridView1.DataBind();
while (dr.Read())
{
txtempid.Text = dr.GetInt32(0).ToString();
txtname.Text = dr.GetValue(1).ToString();
txtaddress.Text = dr.GetValue(2).ToString();
combodes.Text = dr.GetValue(3).ToString();
txtphno.Text = dr.GetInt32(4).ToString();
}
dr.Close();
cmd.ExecuteNonQuery();
con.Close();
}
|
|
|
|
|
a) You've posted code, but not formatted it. in <pre> tags
b) You haven't said what is or is not happening that needs to be fixed.Dalek Dave: There are many words that some find offensive, Homosexuality, Alcoholism, Religion, Visual Basic, Manchester United, Butter.
|
|
|
|
|
hi.........
the code is
con.ConnectionString = "Data Source=SPARK1\\SQLEXPRESS;Initial Catalog=Empdetails;Integrated security=true";
con.Open();
//int p = Convert.ToInt32(dataGridView1.SelectedRows);
String s = "Select * from Empdetails where EmpId=";
SqlCommand cmd = new SqlCommand(s, con);
SqlDataReader dr = cmd.ExecuteReader();
//dataGridView1.DataSource = dr;
//GridView1.DataBind();
while (dr.Read())
{
txtempid.Text = dr.GetInt32(0).ToString();
txtname.Text = dr.GetValue(1).ToString();
txtaddress.Text = dr.GetValue(2).ToString();
combodes.Text = dr.GetValue(3).ToString();
txtphno.Text = dr.GetInt32(4).ToString();
}
dr.Close();
cmd.ExecuteNonQuery();
con.Close();
|
|
|
|
|
Congratulations! You win the prize for posting the most useless post of the day!
Exactly the same as the post you were criticised for, but missing one closing curly bracket!
Well done - and thanks for listening! You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace
C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy
|
|
|
|
|
you may not be the smartest guy in town, but at least you are consistent.
|
|
|
|
|
"A foolish consistency is the hobgoblin of little minds" - R W Emerson.
I think it applies quite well to this questioner. Judging by his other posts, he is trying to punch well above his programming weight...You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace
C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy
|
|
|
|
|
You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace
C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy
|
|
|
|
|
Hi guyz.
I am writing a parental control system. This is a C#.NET executable ParentalController.exe and is started as System.Diagnostics.Process.Start. The app is working fine but i don't want the children to stop the ParentalController.exe from Task Manager. I have tried a solution in which another app (guard.exe) is guarding the ParentalController.exe but i dont like this solution theoritically because a clever child can stop both the executables. So i am looking for a solution in which the child just cannot stop the application and its guardian from Task Manager. However the administrator (Parent) can stop both executables.
I hope i have explained the problem properly. Please help me.
Thanks
|
|
|
|
|
If the ParentalController.exe is run under an Admin account, and the children are logged on as Users, they can't kill that process using Task Manager, right?
|
|
|
|
|
Thanks calla !
I am going to try your solution. But how to make a process run under admin account
|
|
|
|