|
hi all,
I am new to Print data using C#.Can any body tell me how to print data Row in a Database Table using C#?.
I want to Print that data like report view.
Thanks in advance..
|
|
|
|
|
You should consider using a third-party component that can do this for you, since such components implement advanced print styles and output formats. These are relatively inexpensive most times and will probably cost you less to buy than what would be required to develop a component even close to what you'd buy. Most are also royalty free.
If you want to do this yourself, then you need to read the documentation[^] for the PrintDocument class and all linked topics. A good object-oriented design would be to extend PrintDocument with your own class, define a property that accepts, for example, a DataTable, then override OnPrintPage to enumerate each row and print the data using the PrintPageEventArgs passed to the method. A very basic example follows:
public class DataPrintDocument : PrintDocument
{
DataTable table;
Font font;
int rowsPerPage = 0;
int margin = 4;
DataRow currentRow;
public DataPrintDocument() : this(null)
{
}
public DataPrintDocument(DataTable table)
{
this.table = table;
font = new Font("Arial", 10f);
}
public Font Font
{
get { return font; }
set { font = value; }
}
protected override void OnPrintPage(PrintPageEventArgs e)
{
base.OnPrintPage(e);
Graphics g = e.Graphics;
if (rowsPerPage == 0)
{
SizeF fontSize = g.MeasureString("CAPS", font);
rowsPerPage = e.MarginBounds.Height - (fontSize.Height + margin);
}
if (table == null || table.Rows.Count == 0)
g.DrawString("No data to print.", font, Brushes.Black, e.MarginBounds.Location);
else
{
int row = 0;
foreach (currentRow in table.Rows)
{
if (row++ > rowsPerPage) break;
}
}
}
}This should be enough to get you started, but I highl recommend a third-party solution that will save you lots of development time and at a relatively low cost. Some of those third-party component houses even advertise here on CodeProject, like ActiveReports from Data Dynamics that I see while typing this reply! 
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
Hi,
I am new to C#.
I am writing a file manipulation application and I need to know the extended file properties - those that you can see in Win XP when you right click on column header in detailed explorer view: duration, bit rate, dimension, etc.
What do I need to use in C# to get those values?
Thanks,
lil dracula
|
|
|
|
|
This is not functionality easily exposed to .NET, since it's implementation is done in COM. There are "shortcuts" to doing it that may meet your requirements. See http://www.codeproject.com/csharp/ShellID3TagReader.asp[^] for an example. This is a crude way of doing it, however, since you're relying on data provided by the shell that is specific to folders and prone to breaking if new column providers are added.
The best way is to not rely on column providers and instead read the data yourself using the OLE storage functions (which you'll have to P/Invoke) and IPropertySetStorage and IPropertyStorage interfaces. You should be familiar with COM and COM interop with .NET. Read Interoperating with UnmanagedCode[^] if not, then read about Structured Storage[^] in the Platform SDK, especially about the two COM interfaces I mentioned above.
Different file types are handled by different persistence handlers that provide a way to get properties about the file based on what file it is. The default provider stores the extended information - on NTFS only - in an alternate data stream. For Office documents, this information is stored in the documents themselves and the persistence handler for those file types knows how to extract is and expose it in the same way as others. For supported media files, ID3 tag information or other metadata is extracted by other persistence handlers. This is the only sure way - short of knowing how to read extended information from all the different file types yourself, which would be very difficult (especially with proprietary formats) - of getting extended file information.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
Thanks for that great info!
It is terrific that there are people like you that helps out the community!
|
|
|
|
|
I have noticed that I can drag and drop an executable into a C# .NET
Visual Studio "Solution". How would I go about using an executable I dropped into my solution?
Lets just say all I need to do is feed an executable some text from standard
in. Has anyone done something like this yet?
|
|
|
|
|
When you drag and drop a file into a project or solution, you're just copying the file to the project or solution directory (as if you did it in Windows Explorer) and adding a reference to it in the project or solution file. Nothing more than that.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
ahsoh...
I see now. Ok, so I get at this via Systems.Diagnostics.Process then right?
I hope I can redirect a stream of ascii characters to and from this exe. This shouldn't be brain-surgery I imagine.
What datatype should I use to store the contents of an email? (I will need to later pump this email through my exe's standard in)
Thanks for your input btw.
|
|
|
|
|
No process is started when you drag an executable - or any file - to the Solution Explorer. You're simply dragging and dropping a file. Again, there is no process created.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
I don't think you're following me. I was tallking about doing something like this:
using System;
using System.Diagnostics;
using System.ComponentModel;
MyProcess myProcess = new MyProcess();
Process.Start("IExplore.exe", "www.northwindtraders.com");
Any tips on what data structure I should use to hold me email prior to redirecting my executables standard in?
|
|
|
|
|
No, I'm afraid you're not making any sense. Your subject is "[VS .NET] Drag & Drop into Solution Explorer?" which has nothing to do with what you're asking now. When you drag and drop a file into the Solution Explorer you merely copy the file.
Now you're asking something entirely different. You don't need to add the process to your solution to run it using Process.Start. You only need to reference the correct path of the executable or just the name if the parent directory of the executable is in the PATH environment variable.
You don't use "data structure"s to redirect standard in. If you want to know how to do this, you should read the documentation[^] for ProcessStartInfo.RedirectStandardInput in the .NET Framework SDK. I will tell you, though, that Internet Explorer is a GUI application that does not output to standard output or error, or read from standard input.
And what does this have to do with emailing anything?
Please try to be clear. Your original post only said that you copied a file to your solution, which - as I've stated - is nothing more than copying the file to the solution or project directory. You DO NOT need to add an executable to your project.
For example, the following source - compiled with "csc.exe /t:exe sourcefile.cs" - starts Calc.exe. You don't even need a VS.NET project for it - just use the C# command-line compilers in %WINDIR%\Microsoft.NET\Framework\v1.1.4322 (or whatever version directory is installed for whatever version of .NET you have installed):
using System;
using System.Diagnostics;
class Example
{
static void Main()
{
Process.Start("calc.exe");
}
}No project, no copying calc.exe to a solution or project - just simply starting a program that exists in a directory reference in the PATH environment variable.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
Hi,
I was wondering if anyone has figured out how to get the new Windows XP-stype ballon-tip to appear in a Tray icon type application written in C#?
The NotifyIcon object doesn't have any properties or methods to allow for that and I just can't figure out how to do it.
Does anyone have any ideas?
Thanks.
|
|
|
|
|
|
|
I am a new programmer! I have a little experiences of C# language. Can you give me some advice to learns this language well.
Thank you very much
Hello Informatics World
|
|
|
|
|
Hi,
You can learn c# 2.0 as it will be release any sooner probably this year.
Learn the C# features - e.g generics.
Learn how to use OOP + Design Patterns (Singleton) in C#.
Learn .NET Coding Best Pratices when you coding C#. Well there is a tool called FxCop. It will help you to analyze your code. It is quite useful.
Best to learn to walk before running.
Hope it helps. Cheers.
Regards,
Chua Wen Ching
Visit us at http://www.necoders.com
|
|
|
|
|
Hi,
Is it possible to wrap a dll A into another dll B, so I just need to distribute the dll B, but not the dll A? And how are there differences in
the following cases ?
1. the dll A is written in VC++, and the wrapping dll B is written in C#
2. the dll A is written in C#, and the wrapping dll B is written in C#
My concern is that I don't want others to get the original dll B when I distribute
the program. So can other people reverse engineer the wrapped dll and get the original dll out ?
Many thanks
|
|
|
|
|
No, that's not possible.
Something like this can only be done with static libraries that are linked with an executable.
With dlls you don't get code copied or linked directly, but only references to external functions.
That's the whole point of using dlls.
mav
|
|
|
|
|
Maybe you can buy an enterprise version of obfuscation and then obfuscate your assembly. It might confuse the crackers when reverse engineering your assembly.
And i don't think you achieve with what you want.
Cheers.
Regards,
Chua Wen Ching
Visit us at http://www.necoders.com
|
|
|
|
|
There is a messy way of embedded B.dll in A.dll as an embedded resources, extracting it using Assembly.GetManifestResourceStream, and then loading it into the AppDomain using several different methods depending on how you extract it or to where you extract it...but that's just dumb.
Why? For one, it creates a servicing hastle. Now you have to patch both by virtue of patching A.dll. Also, anyone else can extract it using outside code.
If you're worry about disassembly or decompilation, then you picked the wrong language. .NET languages and Java both compile to intermediate code (.NET to Intermediate Language (IL), and Java to bytecode). Even if you obfuscate it some can deobfuscate it just as easily.
If you truly want to hide an implementation, then you'll need to put that functionality into a native DLL (which still isn't impossible decompile, though extremely difficult expecially when optimized) and use P/Invoke or COM interop, which you can read more about in Interoperating with Unmanaged Code[^] in the .NET Framework SDK.
This posting is provided "AS IS" with no warranties, and confers no rights.
Software Design Engineer
Developer Division Sustained Engineering
Microsoft
[My Articles] [My Blog]
|
|
|
|
|
Hi , I am trying to liken the ListView to a dataGrid..
Lets say we have a dataTable and a ListView..
In order to simulate dataGrid , we would like to known how many colums do we have , before binding the items into the ListView , I create the columns...
<br />
for ( int j =0 ;j<dTable.Columns.Count;j++)<br />
{ <br />
this.listView1.Columns.Add(dTable.Columns[j].ColumnName,-1,HorizontalAlignment.Center);<br />
}
Then , I consider to bind each dataRow into the ListView with the corresponding columns..
<br />
for ( int i = 0 ; i<dTable.Rows.Count;i++)<br />
{<br />
this.listView1.Items.Add(dTable.Rows[i][0].ToString());<br />
for ( int j =0 ;j<dTable.Columns.Count;j++)<br />
{ this.listView1.Items[i].SubItems.Add(dTable.Rows[i][dTable.Columns[j].ColumnName].ToString());<br />
}<br />
}<br />
Do you have any idea what I am doing wrong ?
|
|
|
|
|
You're adding the column name over and over again ?
It would help if you said what is actually GOING wrong. Why are you using a listview if you want a datagrid ?
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
Thanks for the reply ,
May be because of the style of the text , you cant see right , I only add the columns to the listView in the first loop, then I add values to those columns..
well it seems like , the values are ok , by this code..But I guess , I made the ListView nervous , treating like a dataGrid.May be you are right, I was just looking for fun , and develop some UI skills...
<br />
StringBuilder s = new StringBuilder();<br />
foreach (ListViewItem li in this.listView1.Items)<br />
{<br />
s.Append(li.Text);<br />
for(int k =0;k<this.listView1.Items[li.Index].SubItems.Count;k++)<br />
{<br />
s.Append(this.listView1.Items[li.Index].SubItems[k].Text);<br />
s.Append("-");<br />
}<br />
s.Append("\n");<br />
s.Append("------------------------");<br />
s.Append("\n");<br />
}<br />
<br />
MessageBox.Show(s.ToString());<br />
|
|
|
|
|
ok , At last I found the reason, ColumnHeader Collection can not be work with listView(or I cant do it)
<br />
ColumnHeader [] h = new ColumnHeader[ColumnCount];<br />
<br />
for (int i=0;i<ColumnCount;i++)<br />
{<br />
<br />
h[i].Text=dTable.Columns[i].ColumnName;<br />
<br />
}<br />
this.listView1.Columns.AddRange(h);<br />
After I declare ColumnHeader one by one , it works fine..
Do you see any syntax or algorithm errors in Column Header Collection that I created?
|
|
|
|
|
it's not a collection, its an array as you have created it using array syntax.
Anger is the most impotent of passions. It effects nothing it goes about, and hurts the one who is possessed by it more than the one against whom it is directed.
Carl Sandburg
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
