|
hi all can anyone help me with detailed help or any aricles link that teaches functions that wil sort and filter a simple database in access format.. i have already make my application to navigate to next, previous, first,last. and also able to update, delete and add new entries..
this is actually my sch project and i really it to know how to sort and filter the database.. i will really yr help
|
|
|
|
|
You can use OleDb to query the database and get all the rows. Once you have all the rows you can do every thing you nead with them : sorting and filtering (with a dataview) and adding, removing and updating rows through the datatable.
Search cp for articles relating all i've mentioned.
protected internal static readonly ... and I wish the list could continue ...
|
|
|
|
|
ic wht u mean .. can u give me more detailed help as in example because im very new in c# .. really appreciate yr help
|
|
|
|
|
Hi,
I am installing some COM components with my C# application but what really happens is that every time on startup it tries to relocate the components and perhaps register them. How can i set the installer to register those components only once.
Regards,
Wasif Ehsan.
|
|
|
|
|
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
|
|
|
|