|
Yeah, that's what I use too. Or .Start() and .Stop()
|
|
|
|
|
Hello,
I have created an excel spreadsheet file using the ole database engine. I have it populating the file without a problem. I am now trying to insert a blank lines into the file to make the transition look better. The way I am currently doing it is
string InsertStatement;
InsertStatement = "Insert into [tabname$] (";
for(int i = 0; i < ExcelColumns; i++)
{
InsertStatement += "null";
if(i < ExcelColumns-1)
InsertStatement += ",";
}
InsertStatement += ")";
then I put that into a oledbcommand and my connection to the excel file. The the rest of it works fine. But the blank line does not.
Any help would be greatly appreciated.
|
|
|
|
|
Hi!
We can write something on the console window using Console.WriteLine. I want to write something on console in some color like Red or blue. How can i do so ?
Imtiaz
|
|
|
|
|
|
And since .Net 2 you can just use the handy properties in the Console class:
Console.BackgroundColor<br />
Console.ForegroundColor
Then just set them to Color.Red for example, background will obviously change the background colour, and Foreground will change the text colour.
My current favourite word is: Nipple!
-SK Genius
|
|
|
|
|
hi,
i want to create a backup server by using C# and MS-Sql. but dont know how i start. plz tell me complete process. if source code is available then send me that plz.
regards
tanoli
|
|
|
|
|
The complete process is that you define exactly what your program will do, then you do some reading to work out the best way to do those things, then you write the code.
What do you want to achieve exactly ? Although, this is the wrong place to ask 'how do I write this program and please send me source code'. We usually help people who have a specific problem they want help with. I'm not sure how I could answer your question in the context of a forum reply.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Sure. Why not? Although you will need to send my company a cheque for £450 and I will send it to you as soon as your cheque clears and the money appears in our bank account.
|
|
|
|
|
I can not find this information about something I'm trying to do in a richtextbox.
Basically I want to set the horizontal alignment to the right, THEN print some text.. put in a couple blank lines and set the Hortizontal alignment to the center.. I am wanting the colors to be different. Basically I want the alignment of different for different sections. All I see is selection alignment when actually I want to set the alignment of the current position and then print text..
A format like this:
Myname
Address <-- Size 8 Font
City, State, ZIP <-- All this is set to RIGHT
Social Security Number
Childs Name <-- (Color red and size 14 Font) <-- SET TO CENTER
Start Date: 00/00/0000
Paid in (year): $923423 <-- ALL THIS SET TO LEFT
and some more information....
How would I do this since I'm print then setting the alignment or if I print then try to set it how do I select only certain things?
Also is there a page break for richtextboxs for printing purposes?
|
|
|
|
|
|
Not exactly the answer to your question, but if add a document to your application you can replace your RichTextBox with a PrintPreviewControl, you can do any sort of layout you wish. Simultaneously, you can go from printPreview to real printing and it will keep the layout.
The drawing tools will allow you to just plain go crazy with elaborate formatting/shading/lines, etc, if you've a notion to.
At least that's how I do it.
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein
"How do you find out if you're unwanted if everyone you try to ask tells you to go away?" - Balboos HaGadol
|
|
|
|
|
I will have to check that out... I haven't done much with PrintPreviewControl. I'll have to research some more information about it.. thanks.
|
|
|
|
|
I was wondering.. what do you mean add a document? I still have to take the information and write it to a document? Do I do that then load the document in the printpreviewcontrol and then do editing?
|
|
|
|
|
Without going into the whole document interface thing in any detail:
You need to add a printDOcument object to your application. You write to it through its Graphics object.
Now, if you create a printPreviewControl (or dialog), it allows you (check the properties) to add a document (which is in its select list if you click the blank box). What this connection does is tell the preview which document to look at [you could use the same printPreview for multiple documents by changing that assignment at RT).
Anyway, you need to explore this, and some examples, but basically, you can write to the document anywhere, in any order, with various pens (thickness, linestyle, color, ...), brushes, fonts, lines, shapes. After a break-in period, you can do shading, too. Also, add graphics.
Much "richer" than the rich text box: downside? You can't type into it on the screen - it's a display method, and WYSIWYG print method. If you need to have the user type directly into the box, you're out of luck, unless you work-around (ex: enter name in simple text-box, and update the printPreview either as they go along, when the box loses focus, or when the press an update button.
I don't know your final needs, so I suggested a print/display oriented item rather than an editbox type item.
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein
"How do you find out if you're unwanted if everyone you try to ask tells you to go away?" - Balboos HaGadol
|
|
|
|
|
I get how to do some of the things now.. I just don't understand how to right align the words. I know how to left align the words but thats because they go from left to right.. How do I right align the words and make them go right to left? Does that make any sence?
e.Graphics.DrawString("Jacob Dixon", Tfont, Tbrush, rightalign, yPosition);
that sets the beginning of the text to where the right margin is.. well here is the rest for the right margins:
float rightalign = e.MarginBounds.Right;
Now how to I convert the drawstring to print right to left and not left to right like normal?
|
|
|
|
|
Ok I have figured that one out.. There is not much information out there about what I am looking for. Do you know where I can read up on some of this?
Now I'm looking for, I have a foreach statement for each of the children in the database. Now for each child I want it to print to a different page... What is is suppose to do is print out a end of year report for the parents of how much they paid that year.. now I have the settings and it prints the information, but how do I tell it to start printing on the next page for each child?
|
|
|
|
|
Multiple pages is (at first) tricky, although in reality it's simple.
You can do this by generating the page, but then, just before you leave the you set the graphics::HasMorePages member to true . Set it to false when the last page is printed. You'll then find your printPreview now contains all the pages.
and
since this is for printing, and not simply display, you may wish to use the printPreview dialog, which has all sorts of neat buttons and stuff built right in, making paging easy when checking your work.
Obvious reminder: when you want to center text, use arithmetic similar to that used to right justify, except divide the amount by two. A really important key idea, expanding upon your learning to right-justify, is to set up a page as much as possible by calculated values. If you do this correctly, you (or your user) can change fonts, and so on, and the page still works.
I learned to use the classes, once I got started, by browsing their members looking for interesting things and looking at how code was generated for me by the IDE.
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein
"How do you find out if you're unwanted if everyone you try to ask tells you to go away?" - Balboos HaGadol
|
|
|
|
|
Hi All,
One high level question from a .NET newbie I'm creating a C# WPF solution with two projects, one handling the presentation and one data layer creating a DataLayer .dll that the presentation references.
On start up I need to run something (a method?) that creates two datasets from XML files (that bit is all coded and working including XML validation) that are available app wide.
Whats the best way of doing this? is it something that should be done in the app code behind (that is currently in the presentation layer, is that even the right place?)
The datasets are going to used in some file recursion methods in the datalayer (which is also all coded and working) I just don't know the best place/method to initiate this loading of the lookups which I want to do only once at the app start up.
I was orginally building these in the main window code behind file but that means they are (as far as I can tell with me basic coding skills) unavailable to the data layer which needs them. Obviously added a reference to the presentation layer from the data layer is no go since that creates a reference loop.
I'm sure the answer is simple i'm just a bit stuck at the moment.
Thanks,
James.
|
|
|
|
|
The obvious way to do this, is to make the datasets properties inside your data layer. Then lazy initialise them. That means, you have this:
private DataSet _thedataset;
private DataSet TheDataSet
{
get
{
if (_thedataset == null)
{
// initialise
}
return _thedataset;
}
}
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
HAHA! ITS YOU AGAIN!
Hi fella,
Hope your well. You know I just cracked it about 30 seconds before you mail came through. Although what i Did is slightly different. Would love your feedback on what I did ...
Created a method in my BuildLoopUps class thus:
public static void CreateLookups()
{
DataSet dsInstruments = BuildLookups.LoadXmlFile(@"LookUpXML\instrument_lookup.xml");
DataSet dsExtensions = BuildLookups.LoadXmlFile(@"LookUpXML\ext_look_up.xml");
}
With these properties at the top:
public static DataSet dsInstruments;
public static DataSet dsExtensions;
Then in my FileInformation class I can:
foreach(string _fileExt in BuildLookups.dsExtensions)
{
}
What are the operational differences between these two ways of doing it? That is of course assuming that my way does in fact work!
Thanks,
James.
|
|
|
|
|
Ahh, i forgot to say that this:
BuildLookups.CreateLookups();
is the line directly above the InitializeComponent(); which is doing the actual kick off of the build process ...
|
|
|
|
|
oh man ... i'm back to your original advice about Dictionaries ... I can't "foreach" over a dataset can I ... DOH!
|
|
|
|
|
You can foreach over the tables in a dataset. You just need to specific foreach (datatable tbl in dataset.Tables).
The main difference is, doing it in a static constructor will do it when the app starts, my way won't do it until the first time you use it, and if it takes a while to build, that's the toss up. Have the app start faster, or have it quicker the first time you ask it to do something.
Lazy initialisation works best when it's a resource that takes time or space and isn't used every time the program runs, then you don't pay the price for it, until you need it.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Christian Graus wrote: Have the app start faster, or have it quicker the first time you ask it to do something.
Maybe we can slow down the speed of light and have both?
led mike
|
|
|
|
|
Gotcha! That does make a stack of sense ... it takes about 1-3 seconds foreach (geddit? har har) to import these two look ups and they are core to the functionality so are needed every time the app runs.
|
|
|
|