|
Hi all,
Please I am trying to generate income statement and balance sheet with data from sql using C#. Is there an easy way to go about this, as gridview does not give me the report in the right format. Many thanks.
|
|
|
|
|
Pull the SQL data, iterate the result set and build a custom HTML output and push to a webbrowser control or write out to file as HTML or via a pdf writer.
Just one option!
|
|
|
|
|
dondrey wrote: Is there an easy way to go about this
In general - no.
If you can pull data, regardless of the business use, and display it any way you want then that is easy because there are no restrictions.
Once you add restrictions then your output must conform to those restrictions. The more restrictions the more involved it becomes (not necessarily more complex but complexity could enter into it as well.)
This is why software specifically for reporting exists. Such software isn't necessarily easier than doing it yourself but with more complex reports and with an increasing number of different types of reports learning such a system is probably a good idea. Whether you need it however depends on your (business) current and future needs.
|
|
|
|
|
Actually my task is create a structure to the mails, store those mails into a file(like pst file) i dont have any idea about this. if anybody know this. please help me
i am getting mails from mail server but i dont know. how to create a Structure and how to create file (like pst file)using c#.net
Saikumar
|
|
|
|
|
Since this is a single user app, look at creating a SqlCE database - it is built in to .NET so it needs no special installation, and it can provide all the structure you will probably need.
Ideological Purity is no substitute for being able to stick your thumb down a pipe to stop the water
|
|
|
|
|
OriginalGriff wrote: SqlCE database - it is built in to .NET
Ummm, no it's not. SQL Server Express Edition is installed with Visual Studio.
If you write an application with it you have to install SQLCE on the client machine seperately from the .NET Framework.
|
|
|
|
|
Your manager has asked you to do this? If so you should tell him that you need help since you've not done this before. Never ceases to amaze me when managers hand out work without knowing whether or not the recipient can actually do the work!
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
Error 2 No overload for 'HookManager_MouseClick' matches delegate 'System.Windows.Forms.MouseEventHandler'
|
|
|
|
|
So why are you not asking whoever wrote the "HookManager" library about this??
|
|
|
|
|
Hai there guys...i'm new here in c# development so I really hope to get some pointers here and there.
So basically what I'm working now is to insert and display the data in dataGridView. I've already done one and it works fine but i wanna refine it. Currently when the application is run it will display all the data that had been stored in the database which can make it confusing for user when they inserted new data, then when they wanna check their data, they have to scroll all the way to find their data that had just been inputted.
So now what i wanna do is to adjust the application so that every time the user run the application, the dataGridView will display an empty view of the table which they can insert their data peacefully without needing to worry about other people data.
(all this using a single table.)
so any idea guys??because i don't even know how to start...
|
|
|
|
|
shahrulnizam wrote: they can insert their data peacefully without needing to worry about other people data.
In your database table create a field for the user ID. Then set the BindingSource.Filter property to the current userID, so that the DataGridView displays only the records pertaining to the current user. While adding the new row, using DataGridView.RowsAdded event set the userID filed of the new row to the current userID
|
|
|
|
|
where to set the bindingSource.filter??it's not at the properties window..
|
|
|
|
|
|
Hi All,
I have done lot of java work for more than 8 years. But I am new to C#. I am writting a client to the Simple Application. For that Client I need to add header..
Here is the scenario...
Server SIde code is written in Java and exposed as Web service.
Client SIde is Written in .Net/C#. I need to access that webservice.. And I am sucessful. Now I need to add a header so I can pass *ID* 122344*/ID* through soap Header. Can some one suggest me , How to do that.. I have been strugulling on this for more than 3 days..Any help really appreciated.
|
|
|
|
|
If you derive a class from your web service reference, you can override the method GetWebRequest . At this point, you can add your own headers through the Request object.
|
|
|
|
|
Hi Folks,
Does anyone have a good starting point for information on reading RF signals using C#? I have an electric smoker (ie. BBQ Pit) that has an RF remote that displays different temperatures and I would like to write an application that would allow me to control the remote functions from my PC instead of from the remote.
I'm sure I would need to purchase an RF Receiver such as this one[^] which I will if I can figure out that this is possible!
|
|
|
|
|
I don't have a guide to point you at, but he first thing you need to find out is what frequency the transmitter on the smoke is using. Then you can make sure you get a RF transceiver that can handle it.
The next thing is determining if there is any protocol that is being used to transfer application-level data, if any.
After that, determine the format of the data coming from the smoker so you can get the correct temperature. Then what are the commands you send back to the smoker to do what and what is the format of those commands??
If you can't find documentation on any of this stuff, you're going to find it extremely difficult to do this from your code.
|
|
|
|
|
Thanks for the info Dave!
I search for the FCC ID on fcc.org and found a lot of information about the module and its communication methods. The handheld remote unit contains a 433 Mhz transceiver - is there something more specific than that I should try and find out related to the frequency, or should any 433 Mhz transceiver be able to communicate with it (depending on the protocol as you mentioned)?
As you said, I'm sure it will be extremely difficult to figure this out without any documentation - but I think if I can get a transceiver and get the communication going between the two then I can figure out the functions (again, there is a lot of info on the FCC site).
Do you know sort of what the process would be for communicating with the transmitter on the smoker would be? I guess I would ideally have a USB transceiver so once it was installed I guess you would just use the USB API to communicate with it as a HID, right? (I know that is oversimplifying what could be a painful process) Is there a process of "pairing" devices a la bluetooth or do these types of things work more off of just responding to any frequency that matches what it's looking for?
|
|
|
|
|
lydonbergin wrote: The handheld remote unit contains a 433 Mhz transceiver - is there something
more specific than that I should try and find out related to the frequency, or
should any 433 Mhz transceiver be able to communicate with it (depending on the
protocol as you mentioned)?
Not really. You just need to make sure the transceiver you get supports that range.
lydonbergin wrote: but I think if I can get a transceiver and get the communication going between
the two then I can figure out the functions
The problem with "figuring out the functions" is that they are application (software) specific, not radio specific. One possible method would be to try and listen to the remote to see what it's sending. You're probably going to get a bunch of bytes, but no idea what they mean.
lydonbergin wrote: Do you know sort of what the process would be for communicating with the
transmitter on the smoker would be? I guess I would ideally have a USB
transceiver so once it was installed I guess you would just use the USB API to
communicate with it as a HID, right?
Hehe. You are putting WAY too much thought into this part. Chances are really good that the transceiver will show up as a serial port on your PC. You don't need any USB garbage to talk to it. Just normal serial communications in the System.Io.Ports namespace.
lydonbergin wrote: (I know that is oversimplifying what could be a painful process) Is there a
process of "pairing" devices a la bluetooth or do these types of things work
more off of just responding to any frequency that matches what it's looking for?
Neither. You should just get data if there's anything coming over the air, no matter what the source is just so long as it's on a frequency the transceiver is listening to. There is no pairing or anything like that.
|
|
|
|
|
I can't thank you enough Dave - this information has been VERY informative.
|
|
|
|
|
Or, if you're adventurous enough and know some basic electronics, you can build your own system from scratch. Have a look at a Fez Panda[^] and the .NET Micro Framework.
|
|
|
|
|
If you want to control the BBQ you will need a transmitter not a receiver. A trasceiver if two way communication is required.
It may be easier to get a second remote and use your PCs parallel or serial port to control an interface to the keyswitches on the remote rather than trying to identify what code does what.
You will also need to watch your max permitted power and the risk of RF interference as that remote contol is not a Primary allocation for that part of the RF spectrum
|
|
|
|
|
greldak wrote: It may be easier to get a second remote and use your PCs parallel or serial port to control an interface to the keyswitches on the remote rather than trying to identify what code does what.
Do this. Seriously. That remote is the exact frequency radio with the exact kind of modulation you need, and already knows how to speak any and all protocols you'll need. Even if all you do is grab the radio guts from it, its probably the cheapest compatible radio you'll be able to find.
Even a simple start like keywitches will be a fun little project, is easily doable with C#, and, perhaps most importantly, you'll have something basic up and working in a few weeks. Then you can decide whether to have your fun writing control code, or climbing learning curves as you peel the onion of how the remote talks to the device.
For the keyswitch control itself, you could use either parallel port or USB (I'm thinking FTDI serial chip in bit bang mode) without too much difficulty. For USB, consider checking out smileymicros or sparkfun for a simple packaging of that FTDI chip.
We can program with only 1's, but if all you've got are zeros, you've got nothing.
|
|
|
|
|
It's all about documentation.
Once, you found out the correct frequencies, you can buy the correct transceiver for your case. Usually RF transceivers suppliers have drivers and ready to go libraries to use them. So before you purchase one, contact the manufacturer or try to find in their website if they have documentation and libraries you can download.
Ideally you'd want ready to go .net libraries, but COM libraries would be just as easy, you just add it as reference to your project and VS will build a nice wrapper for you.
As a last resort you can P/Invoke[^] if the supplied libraries are of some other unmanaged kind.
Now, the hardest thing to do will be to talk to the smoker. There are two approaches:
1 - Contact the smoker manufacturer and ask them for documentation. Ask what commands the smoker expects and what output it produces.
2 - Reverse Engineering: In this case it's not so difficult if you just want to receive information, because you can observe what the smoker transmits while you mess with it and from there, deduce the results. Often this doesn't give much trouble, but that is not always true. The hardest would be to control the smoker, however, you could also observe the commands issued by the remote and reproduce them with your transmitter.
The second approach will take time and effort, however it is possible to do it.
As a first exercise you should get acquainted with the workings of the RF protocol. I find the best way to do it buy playing with it. All you'll need to do is some googling at first, then setup the transceiver on your pc and use the remote to get the first contacts.
But it is very important that you research the transceiver manufacturer and their support before you buy them, so it's the best fit for you.
"To alcohol! The cause of, and solution to, all of life's problems" - Homer Simpson
|
|
|
|
|
Fabio Franco wrote: 1 - Contact the smoker manufacturer and ask them for documentation. Ask what
commands the smoker expects and what output it produces.
Then sell them the resultant program you write.
|
|
|
|