|
Hi All,
Greetings.I've to create a class file.Here i've added the coding what i've written.But its showing the error.Can any one tell me is this class correct and how to call in my .cs file.
public int AddEmployee(string employeeID,string employeeName,string Designation,string Machinetowork,string dateofbirth,string address,string city,string state,string zip,string phoneNo,string MobileNo,string email)
{
SqlConnection conn = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand("insert into Employee Values(@EmployeeID,@EmployeeName,@Designation,@MachineToWork,@DateOfBirth,@Address,@City,@State,@Zip,@PhoneNumber,@MobileNumber,@Email)",conn);
cmd.Parameters.Add("@EmployeeID",employeeID);
cmd.Parameters.Add("@EmployeeName",employeeName);
cmd.Parameters.Add("@Designation",Designation);
cmd.Parameters.Add("@MachineToWork",Machinetowork);
cmd.Parameters.Add("@DateOfBirth",dateofbirth);
cmd.Parameters.Add("@Address",address);
cmd.Parameters.Add("@City",city);
cmd.Parameters.Add("@State",state);
cmd.Parameters.Add("@Zip",zip);
cmd.Parameters.Add("@PhoneNumber",phoneNo);
cmd.Parameters.Add("@MobileNumber",MobileNo);
cmd.Parameters.Add("@Email",email);
int err=1;
conn.Open();
{
cmd.ExecuteNonQuery();
}
conn.Close();
return err;
}
Babu
|
|
|
|
|
ChennaiBabu wrote: But its showing the error
Standard Question #1: What is the error?
ChennaiBabu wrote: Can any one tell me is this class correct and how to call in my .cs file.
You have not shown a class, you have shown a single method.
You do not call a .cs file you intantiate classes then call the methods in the class
Might I suggest that you read a beginners book on C# because I get the feeling that if I attempt to answer you it will turn in to a very long thread that could easily be resolved if you just read some introductory information in C#
|
|
|
|
|
Colin Angus Mackay wrote: Standard Question #1: What is the error?
No, that is standard question #2.
Standard question #1 is:
What do you mean by "not working"?
---
b { font-weight: normal; }
|
|
|
|
|
|
If you use my standard questions, please use the right ones.
Here is a complete list of my standard questions:
Standard question #1:
What do you mean by "not working"?
Standard question #2:
What error message do you get?
Standard question #3:
What does your code look like?
Standard question #4:
No, "nothing" never happens. Exactly what is happening?
Standard question #5:
No, that is not the code you are using. It can't produce that result. What does the code you are using look like?
---
b { font-weight: normal; }
|
|
|
|
|
Guffa wrote: If you use my standard questions, please use the right ones.
No problems - I'll copy them onto a postit note for future reference. 
|
|
|
|
|
Hi,
I have made an installer for a windows application. But there is a problem, when i click the icon on the desktop or in start-menu, the application appears to re-install itself ( a progress bar runs fast once or twice) & (here comes the problem) it executes the Custom Action that i have set for the Commit event. It happens every time when i click the icon.
I am also using some COM components ( there names start with AxInterop. & Interop., I suspect they are COM components), is that problem due to these components? Moreover, the persons who are using the computer on which i install my app, they say that they had to re-register their COM components every day after my use.
Please give me some link, help, guidance. I am posting this message for the second time...
Regards,
Wasif Ehsan.
|
|
|
|
|
The applicatin reinstals because you have alterated it's root directory and or the binary files, so, the smart and wise Windows Installer reinstals your application. In order to avoid runnting the custom action over and over put a condition to find out weather is a fresh install or a repair - I can't remeber what was the condition.
protected internal static readonly ... and I wish the list could continue ...
|
|
|
|
|
Hi,
I have created an installer for my C# desktop application. I want my application to startup after it has successfully installed. I dont want to use Custom Actions. How can i do that?
Regards,
Wasif Ehsan.
|
|
|
|
|
I'm afraid there is no way to startup after it installed but write some code in install script.
|
|
|
|
|
Is there a way to monitor the information sent to a specific USB channel and mimic it?
I love to program!
|
|
|
|
|
The short answer is no.
The long answer is yes, but with extreme difficulty. Requiring something like kernel-level debugging techniques to intercept/shadow calls to the USB driver. AFAIK, there is no way to monitor the serial bus directly.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
hi, i built a PVR a few years ago and its running the latest version of GBPVR, and im not exactly pleased with its support for multiple cards (particularly the softwares ability to change channels, theres no effient way to use 1 device to change the channels of the tv, its long and complicated, but its not easy...) in any case, is there a way that i can capture input from a tv tuner card and save it as an Mpeg?
|
|
|
|
|
kb1ibh wrote: in any case, is there a way that i can capture input from a tv tuner card and save it as an Mpeg?
You can try playing with GraphEdit, then use DirectShow.NET. I have not done this myself, but would love to...
kb1ibh wrote: im not exactly pleased with its support for multiple cards
From messageboards, it appears BeyondTV has the best multiple tuner support, but thats not free 
|
|
|
|
|
Hi,
Is it possible to declare an enum-type at runtime???
/Besinci
|
|
|
|
|
Sure. CodeDom or Reflection.Emit?
Logifusion[^]
If not entertaining, write your Congressman.
|
|
|
|
|
Do you have some code sample pls
/thx
|
|
|
|
|
Sure:
CodeTypeDeclaration ctd = new CodeTypeDeclaration("MyEnum");
ctd.IsEnum = true;
ctd.Members.Add(new CodeMemberField("int", "Value1"));
ctd.Members.Add(new CodeMemberField("int", "Value2"));
CodeNamespace cn = new CodeNamespace("MyNamespace");
cn.Types.Add(ctd);
CSharpCodeProvider prov = new CSharpCodeProvider();
ICodeCompiler comp = prov.CreateCompiler();
CodeCompileUnit ccu = new CodeCompileUnit();
ccu.Namespaces.Add(cn);
ccu.ReferencedAssemblies.Add("System.dll");
CompilerParameters cp = new CompilerParameters();
cp.OutputAssembly = "MyAssembly.dll";
cp.ReferencedAssemblies.Add("System.dll");
cp.GenerateExecutable = false;
CompilerResults cr = comp.CompileAssemblyFromDom(cp, ccu);
if (cr.Errors.Count > 0)
throw new Exception("Compile Errors!");
Assembly asm = cr.CompiledAssembly;
Type t = asm.GetType("MyNamespace.MyEnum", true, false);
foreach (string s in Enum.GetNames(t))
Console.WriteLine(s);
Logifusion[^]
If not entertaining, write your Congressman.
|
|
|
|
|
I use this code:
try
{
panelImage = new Bitmap(panelFileName);
}
catch (ArgumentException)
{
MessageBox.Show("FILE NOT FOUND:\r\n\r\n" + panelFileName);
Application.Exit();
}
and it catches the error of the file not existing, but it does not exit the application. What am I doing wrong?
Thanks
|
|
|
|
|
Are you executing this code in the constructor of your main form? In this case Application.Exit won't have an effect as Application.Run wasn't called yet.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
Application.Run() was called in program.cs, but this is in the constructor of the form it ran, so this is the problem. Thanks
|
|
|
|
|
Don't fail inside of a constructor. It isn't good practice. Move failure prone code outside of the constructor and call it seperately to initilize the class. Also, Application.Exit is a bad way to exit your application. Any error that requires an exit should bubble up till it can be handled gracefully allow the application to then exit via normal channels.
A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."
-- Stephen Crane
|
|
|
|
|
Problem is that during construction of your form, Application.Run(..) isn't executed yet as where are in the state of creating the form object that gets passed into. So you cannot exit what isn't running yet.
So either move the code into an event handler for the forms Load event as suggested by the others or even put the check for crucial files inside the main method before you call Application.Run(..). Additionally I suggest using File.Exists which is much nicer than catching exceptions.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
Ah, ok... the Load handler... I forgot all about that and didn't pick that up in the other posts ( I must have been to tired ).
Also, I was trying to find the File.Exists thing, but couldn't so appreciate that one too. Now I can do that before he exception. Only reason I used that was that was the only exception thrown by the Bitmap().
Patrick
Appreciate all the help and feedback guys. The learning curve is steep.
|
|
|
|
|
I had a similar problem using VS2005. I presume your program keeps running until an error is evoked because of the missing file?
I moved the try/finally block out of the initialize program section into the MainForm_Load section and then it worked as it was supposed to.
Glen Harvy
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
