|
I am using textwriter to create a text document and writing information to it. I want to know if there is a way to format the text that I concatanate into the text that I send to the text document.
for instance: dr.writeline("Order Number" + (new ListItem(pr["ord_num"].ToString()));
I want to know if there is a way to make the text "Order Number" Bold so that it will stand out as a column.
|
|
|
|
|
That depends on what you use to view the text. There is no formatting of that kind for plain text.
---
b { font-weight: normal; }
|
|
|
|
|
I am using a TextWriter to create a text document that I am passing the information into. It would be nice to create a word document or excel document. I have not been able to find any information on creating those types of documents.
|
|
|
|
|
A simple TextWriter won't do what you want.
Have a look here. It's a library which should help you to generate a word document.
Another possibility would be to create a RTF document. Use the search function here on CodeProject. You should find at least one article about it.
|
|
|
|
|
If you write a word document, or a rich text document, or even a HTML document, you can make the text bold. HTML is probably easiest. A .txt file can't do that, it's plain text.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
A friend of mine point out to me to do it as an HTML, that is working much better than the text document.
Thanks to all
|
|
|
|
|
hi there,
i´m figuring out what´s the best way to check network services with c#?
i want to check if RDP and ICA Services are up on my servers. i tried
to just open a TcpClient and if it throws an exception on connect() i
guessed it´s unavailable. But thos didn´t work for me. it always throwed
the exception though the service was online. increasing timeout-values
didn´t work either.
i also tried connecting via System.Net.Socket but i gut the same results.
any ideas how i can check network services with c#?
best regards from .at
|
|
|
|
|
i am a newbie to c# and have a problem to which i have found no solution. in my search for controls that look like the ones in win xp and office 2003 i came across this website http://www.steepvalley.net/ that provides such controls for free. i immidiately downloaded the setup files to use in vs .net
however i am unable to use the controls. i tried to add com components to the toolbox however it gives an error that the dll is not a com component and thus cannot be added to the toolbox. these controls are really cool (from the pictures provided) and i would really like to use them...but sadly have no idea how. any help would be much appreciated.
Krishanu Nandy
"If absolute power corrupts absolutely, where does that leave God" -George Deacon
|
|
|
|
|
It seems those controls are not COM controls then, they are .NET controls. Try adding them to the toolbox manually by browsing for it.
Also note that in .NET framework version 2.0, Windows Forms has a complete set of menus and toolstrips that come with customizable looks, including the Office 2003 look.
Tech, life, family, faith: Give me a visit.
I'm currently blogging about: Who is Jewish, the Trivia Game!
Judah Himango
|
|
|
|
|
I have a text box and a list box. I want to be able to add whatever data a user types into the text box to the listbox items when he/she clicks the enter key on the keyboard. Can anyone help me out with ideas or sample code
?
Thank you.
Nana
|
|
|
|
|
this.textBox1.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.textBox1_KeyDown);
private void textBox1_KeyDown(object sender, System.Windows.Forms.KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Enter )
{
this.listBox1.Items.Add(this.textBox1.Text );
}
}
|
|
|
|
|
Thank you. But how and where do i fire this event. Please
Nana
|
|
|
|
|
You need not do anything to fire. When you press Enter key it will automatically get fired.
|
|
|
|
|
Sample project
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
namespace WindowsApplication1
{
///
/// Summary description for Form1.
///
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.ListBox listBox1;
///
/// Required designer variable.
///
private System.ComponentModel.Container components = null;
public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
//
// TODO: Add any constructor code after InitializeComponent call
//
}
///
/// Clean up any resources being used.
///
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows Form Designer generated code
///
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///
private void InitializeComponent()
{
this.textBox1 = new System.Windows.Forms.TextBox();
this.listBox1 = new System.Windows.Forms.ListBox();
this.SuspendLayout();
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(88, 32);
this.textBox1.Name = "textBox1";
this.textBox1.TabIndex = 0;
this.textBox1.Text = "textBox1";
this.textBox1.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.textBox1_KeyDown);
//
// listBox1
//
this.listBox1.Location = new System.Drawing.Point(72, 88);
this.listBox1.Name = "listBox1";
this.listBox1.Size = new System.Drawing.Size(120, 95);
this.listBox1.TabIndex = 1;
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(292, 266);
this.Controls.Add(this.listBox1);
this.Controls.Add(this.textBox1);
this.Name = "Form1";
this.Text = "Form1";
this.ResumeLayout(false);
}
#endregion
///
/// The main entry point for the application.
///
[STAThread]
static void Main()
{
Application.Run(new Form1());
}
private void textBox1_KeyDown(object sender, System.Windows.Forms.KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Enter )
{
this.listBox1.Items.Add(this.textBox1.Text );
}
}
}
}
|
|
|
|
|
thank you thank you thank you. it's working.
Nana
|
|
|
|
|
hi
i got this error...
what should i do?
'System.Windows.Forms.KeyEventArgs' does not contain a definition for 'KeyChar'
thanks
|
|
|
|
|
Checkout the example below and make sure u have included all the libraries.
Sample project
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
namespace WindowsApplication1
{
///
/// Summary description for Form1.
///
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.TextBox textBox1;
private System.Windows.Forms.ListBox listBox1;
///
/// Required designer variable.
///
private System.ComponentModel.Container components = null;
public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
//
// TODO: Add any constructor code after InitializeComponent call
//
}
///
/// Clean up any resources being used.
///
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows Form Designer generated code
///
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///
private void InitializeComponent()
{
this.textBox1 = new System.Windows.Forms.TextBox();
this.listBox1 = new System.Windows.Forms.ListBox();
this.SuspendLayout();
//
// textBox1
//
this.textBox1.Location = new System.Drawing.Point(88, 32);
this.textBox1.Name = "textBox1";
this.textBox1.TabIndex = 0;
this.textBox1.Text = "textBox1";
this.textBox1.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.textBox1_KeyDown);
//
// listBox1
//
this.listBox1.Location = new System.Drawing.Point(72, 88);
this.listBox1.Name = "listBox1";
this.listBox1.Size = new System.Drawing.Size(120, 95);
this.listBox1.TabIndex = 1;
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(292, 266);
this.Controls.Add(this.listBox1);
this.Controls.Add(this.textBox1);
this.Name = "Form1";
this.Text = "Form1";
this.ResumeLayout(false);
}
#endregion
///
/// The main entry point for the application.
///
[STAThread]
static void Main()
{
Application.Run(new Form1());
}
private void textBox1_KeyDown(object sender, System.Windows.Forms.KeyPressEventArgs e)
{
if (e.KeyChar == (char)Keys.Enter )
{
this.listBox1.Items.Add(this.textBox1.Text );
}
}
}
}
Nana
|
|
|
|
|
it should be 'System.Windows.Forms.KeyPressEventArgs' instead of 'System.Windows.Forms.KeyEventArgs'
Nana
|
|
|
|
|
yes that was the mistake =)
thanks, though i finally managed to solve b4 i saw this reply..
|
|
|
|
|
I have an MS Access table that I'm accessing from C# (via MSDE 2000). The primary key in the table is just an int column with identity set to "yes" and step set to '1'. So whenever I add a record Access automatically gives it a new primary key. Yay.
That works fine, but what I'd really like is to be able to retrieve the key that Access generates at the time that I insert the new record.
So right now my C# program just figures out the values for the non-primary keys and then sends an INSERT INTO command. Is there anyway to automatically retrieve the new ID that Access generates?
The only idea that I have so far is to create an additional column in the table called "isNew" or something. When the user submits the new record, the SQL statement could set the "isNew" column for that record to the user name. Then I could immediately send a SELECT to retrieve the ID WHERE isNew = 'user name'. Of course, then I'd also have to send yet another UPDATE to SET isNew = ''. So it's kind of a cumbersome solution, but at least it will work.
Anyone have anything better?
The ends can never justify the means. It is the means that determine the ends.
|
|
|
|
|
Get the most recently created id by running the query "select @@identidy" with the same database connection.
---
b { font-weight: normal; }
|
|
|
|
|
Thanks! I think that will work well. My only concern is that if two users simultaneously add records to the table, there could be trouble. But if I run the select query within a line or two of running the insert into query the chances of this happening are very low, right?
I would still like to have a full-proof method for future reference though. While I will only have a handful of users on this database at the same time, the program might conceivably need to be scaled up to over a 1,000 users.
Any idea what might work in that case?
The ends can never justify the means. It is the means that determine the ends.
|
|
|
|
|
Using identity column is not a good idea. There are many problems associated one being identity gap. I think you should implement your own increment procedure.
Have a table with the follwoing schema
CREATE TABLE dbo.Sequence
(
TableName varchar(30) NOT NULL,
NextVal int NOT NULL
)
LOCK DATAROWS
go
GetSequence should get you the id
CREATE PROCEDURE GetSequence (
@tbl varchar(30))
AS
DECLARE @nextval int
BEGIN
BEGIN TRAN
UPDATE Sequence
SET NextVal = NextVal + 1
WHERE TableName = @tbl
IF @@rowcount = 1
SELECT @nextval = NextVal
FROM Sequence
WHERE TableName = @tbl
COMMIT TRAN
SELECT @nextval
END
This will work even if there are 100 concurrent users
|
|
|
|
|
The @@identity method is absolutely safe. The value returned is the identity of the record last created within the same database session, e.g. with the same database connection.
If two users create a record each at exactly the same time, they still have separate database sessions, so the id returned to each user is the id of the record that that specific user created.
---
b { font-weight: normal; }
|
|
|
|
|
Hello,
I have a groupBox, and I want to add a HScrollBar, how can I implement the scrolling action if I have the controls within that groupBox, that are out of the groupBox's client area?
Thank you
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
