|
I have a Sales Table with the following fields:
CustCode, ProdCode, Units, Price, Value
I fetch this data in a datatable with all fields.
now I want to make a dataview on that datatable with the following fields
ProdCode, Sum(Units) as units, Price, Sum(Value) As Value
means it contains data on product level.
is it possible to make a dataview with this grouping functionality.
Bye
|
|
|
|
|
|
If you need to use a public message board for your personal mail correspondance, at least include a line that explains why...
---
b { font-weight: normal; }
|
|
|
|
|
Looks like he should have asked in the SQL forum, and you need to learn how to hit the 'reply' button.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
At run time, In crystal viewer, I can export a report as pdf file easily.But I do not want to do it by user. And do not want to use crystal viewer.
I would like to make a conversion of a crystal report file to pdf file behind User interface. When a user want to view report, I only want to display the stored data in pdf file.How could I do it in C#?
Hopefully,
May Thu San
|
|
|
|
|
hi,
Simple dont show the form to the user just export the report pdf file into %temp% folder and show the pdf file to the user.
good luck
Where there is a will,there is a way.
|
|
|
|
|
hi i'm new to C# and currently working on a windows project that connects to a web service that returns an xml string.
eg
<name>PaulaM
<title>Mrs
<initials>N/A
<surname>Smith
<telephone>0215512955
<cellno>
<physaddr1>BOX 29 Emerlo
my problem is i must get the data from the xml string and save it into a database.i searched on google to find a good article or samples that does that but have not succeeded.could any of you recommend an artilcle or an example of how i can solve my problem.
thank you
regards paula
|
|
|
|
|
First of all in case your posting XML fragments you should either check the "Ignore HTML tags in this message (good for code snippets)" box beneath the message window or replace opening brackets with <.
Now to your question. To retrieve information from your XML fragment use the XmlDocument class. Take a look at its MSDN topic and you should find much information how to use it along with some examples. After you have the info build a datbase query and execute it.
"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
|
|
|
|
|
See here[^] maybe it is some helpful to you
|
|
|
|
|
I would like to make a conversion of a crystal report file to pdf (adobe acrobat reader) file. How could I do it in C#?
Hopefully,
May Thu San
|
|
|
|
|
Easiest way - there are printer drivers that print to PDF. Then, you just print your report.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
use crviewer control export or expoertodisk...option...
ReportDocument.ExportToDisk( ExportFormatType.PortableDocFormat, FileName);
Where there is a will,there is a way.
|
|
|
|
|
HI
I have written a function(ReadByte)that read a file in class library.
and make a add refrence to window application.
i place a button control and a progressBar on the form and
at the button click event i call ReadByte function
now i want that progressBar should be progressed as file is reading .
How can i do this
|
|
|
|
|
If you're reading one byte at a time, your progress bar will work, at the cost of the operation being slow.
You can call Application.DoEvents to make your form repaint, or put the byte reading code in another thread to your UI.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
sir
i want to know how the progress bar will progress while it is in window appl.
how can i kow how many bytes are read.
is there any ParameterizedThread function or like this in c#1.1
|
|
|
|
|
i think the easy way is fire event from reading loop and catch in the progressbar form and change the indicator according to that.
i customised the EventArgs with TotBytes and TotRead.
it is working for me.
good luck
Where there is a will,there is a way.
|
|
|
|
|
that is the problem how can i read loop in class library that notify me what is the status
|
|
|
|
|
You can create a delegate which calls out of the class library on every iteration.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
If i want to convert system date to int , what should i do and also if i try to convert the int to the datetime i should get the same date as before
ItsMe
|
|
|
|
|
Are you expecting to use a standard int conversion, such as one returned from a C++ API, or do you want to make your own ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
any thing is fine but it must work in c#
if i give system.datetime.now i must be able to convert to integer and again back to datetime.
Thanks and Regards
Madhu
|
|
|
|
|
Well, you realisitically need to invent some way of representing it then. Do you need the time, or just the date. An int is 16 bit, so 0x00000000, you could use one byte for month, one for day and two for year. Or, you could set a base date, and store the date as days from that date. There's all sorts of options.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
You can not convert DateTime object to Int32 but yes you can convert it to Double using ToOADate() method. To generate DateTime object from Double you can use DateTime.FromOADate() method...
For Example
Double d = DateTime.Now.ToOADate();<br />
...<br />
DateTime.FromOADate(d);
Hope this helps you out...
|
|
|
|
|
i want to be converted to int only
Thanks and Regards
Madhu
|
|
|
|
|
Then you need to decide what representation you want to use. THe old 32bit datetime format from C only supports the range 1970 to ~2038(?). If you need a larger range you'll have to loose some precision at the seconds end of the values.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
