C# Discussion Boards - CodeProject

Re: table in RTF text object in crystal report.

iamalik13-Nov-09 17:45

iamalik

13-Nov-09 17:45

Thanks for your reply.

Is there any way, through which I can display tables in RTF text object?

Re: table in RTF text object in crystal report.

Dave Kreskowiak13-Nov-09 17:48

Dave Kreskowiak

13-Nov-09 17:48

Use a monospaced font and create the tables using ASCII characters.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Re: table in RTF text object in crystal report.

iamalik13-Nov-09 17:52

iamalik

13-Nov-09 17:52

Thanks again Dave,

that is good solution, but I will take to much efforts. Actually I need some quick solution.

Re: table in RTF text object in crystal report.

Dave Kreskowiak14-Nov-09 1:19

Dave Kreskowiak

14-Nov-09 1:19

You're only other solution is to NOT use Crystal Reports and use some other reporting package.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

Timer Control Not working in proper Interval + Sourabh Das

Dot Net Jantu12-Nov-09 19:32

Dot Net Jantu

12-Nov-09 19:32

Hi Guys,
I have dragged and droped a timer control "tmrGetMappingXML" from the Common Controls Tab in Tool Box. The issue that I am mentioning also appears for the Timer Control present in the Components Tab in tool box.

In the form Load i have written:

tmrGetMappingXML.Interval = 3600; //1 Hour = 3600 Seconds
tmrGetMappingXML.Enabled = True;
tmrGetMappingXML.Start();

The timer interval is also set in the design time to 3600 seconds.

But the Tick event of the timer fires continuously every second. Fed up.

Please suggest.

Regards,
Sourabh

Thanks and Regards,

Re: Timer Control Not working in proper Interval + Sourabh Das [modified]

0x3c012-Nov-09 19:52

0x3c0

12-Nov-09 19:52

Dot Net Jantu wrote:
tmrGetMappingXML.Interval = 3600; //1 Hour = 3600 Seconds

The Interval property is given in milliseconds. You need to multiply your number by 1,000

OSDev

modified on Friday, November 13, 2009 8:39 AM

Re: Timer Control Not working in proper Interval + Sourabh Das

Dot Net Jantu12-Nov-09 20:00

Dot Net Jantu

12-Nov-09 20:00

Thanks for that hint.. solved.

problem solved...

1 Sec = 1000
1 hour = 3600000

Thanks and Regards,

Re: Timer Control Not working in proper Interval + Sourabh Das

Luc Pattyn13-Nov-09 0:55

Luc Pattyn

13-Nov-09 0:55

0x3c0 wrote:
The Interval property is given in ~~ticks~~ (milliseconds)

In Windows a tick is a tenth of a microsecond.

Smile | :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Re: Timer Control Not working in proper Interval + Sourabh Das

0x3c013-Nov-09 2:40

0x3c0

13-Nov-09 2:40

That'll teach me to skim read MSDN. Fixed.

OSDev

Access a .cs file in an aspx file (ridiculously basic question) in Visual Studio

alexgrab12-Nov-09 17:41

alexgrab

12-Nov-09 17:41

Basically I've got 2 files, an .aspx file and a .cs file that holds a class.
I put the 2 files in a folder and opened the folder in Visual Studio, which opens the folder as a project.
The .cs file has a class in it.
the .aspx file references the .cs file, and that line has an error.

The line is
"Product saleProduct = new Product("Kitchen Garbage", 49.99M);"
And Product is the name of the class in the .cs file.

The error for this line is basically not recognizing "product" or not seeing the product class in the .cs file. I'm not sure how to get the .aspx page to see the .cs file/class.

This is an example from a book that I'm studying, and I had to download the files from the book's website.
I'm just not familiar with Visual Studio.

Re: Access a .cs file in an aspx file (ridiculously basic question) in Visual Studio

Shameel12-Nov-09 22:21

Shameel

12-Nov-09 22:21

Put the Product class in the .cs file in a namespace and import that namespace in the .aspx (or .aspx.cs as the case may be).

How to write a article in Codeproject.com

santhosh30912-Nov-09 17:11

santhosh309

12-Nov-09 17:11

Hello Friends,
How to write a article in Codeproject.com

Re: How to write a article in Codeproject.com

N a v a n e e t h12-Nov-09 17:23

N a v a n e e t h

12-Nov-09 17:23

Looks like you are new to CodeProject. Welcome!

To write an article, take a look at this[^] page. You have posted your message on a wrong forum. Please read the guidelines before you do any posts.

Best wishes,
Navaneeth

Re: How to write a article in Codeproject.com

Shameel12-Nov-09 22:22

Shameel

12-Nov-09 22:22

This is a wrong forum to post such a question.

How to retrive emails,attachments from exchange server using C#.NET

santhosh30912-Nov-09 17:10

santhosh309

12-Nov-09 17:10

Hi,
How to retrive emails,attachments from exchange server using C#.NET?

Re: How to retrive emails,attachments from exchange server using C#.NET

N a v a n e e t h12-Nov-09 17:21

N a v a n e e t h

12-Nov-09 17:21

Read about WebDav[^]. MS exchange server supports webdav and can respond to webdav requests. You need to form a XML format request and send that to server. Work with HttpWebRequest and HttpWebResponse classes.

Best wishes,
Navaneeth

Need Help Updating a MS Access database.

erburrell12-Nov-09 16:22

erburrell

12-Nov-09 16:22

I am brand new to both C# and Database coding.

I am using the following code as an update Command, and there seems to be an issue with it. At run time, I use the update command here to add a new record to the data base, and getthe error following the code.

Code:

//Declare a reusable update command with parameters.
dataAdapter.UpdateCommand = connection.CreateCommand();
dataAdapter.UpdateCommand.CommandText =
"update EventData " +
"set EventType = ?, UnitNo = ?, Start = ?, End = ?, Derate = ?, Trip = ?, Comments = ? " +
"where ID = ?";
dataAdapter.UpdateCommand.Parameters.Add("EventType", OleDbType.Char, 0, "EventType");
dataAdapter.UpdateCommand.Parameters.Add("UnitNo", OleDbType.Integer, 0, "UnitNo");
dataAdapter.UpdateCommand.Parameters.Add("Start", OleDbType.Date, 0, "Start");
dataAdapter.UpdateCommand.Parameters.Add("End", OleDbType.Date, 0, "End");
dataAdapter.UpdateCommand.Parameters.Add("Derate", OleDbType.Decimal, 0, "Derate");
dataAdapter.UpdateCommand.Parameters.Add("Trip", OleDbType.Boolean, 0, "Trip");
dataAdapter.UpdateCommand.Parameters.Add("Comments", OleDbType.Char, 0, "Comments");
dataAdapter.UpdateCommand.Parameters.Add("ID", OleDbType.Integer, 0, "ID");

Error:

Syntax Error in INSERT INTO statement

Thanks for the help!

Re: Need Help Updating a MS Access database.

Eddy Vluggen12-Nov-09 22:21

Eddy Vluggen

12-Nov-09 22:21

erburrell wrote:
At run time, I use the update command here to add a new record to the data base, and getthe error following the code.

Use the INSERT command to add items to a table; UPDATE doesn't add a new record, instead it's used to update an existing record.

I are Troll Suspicious | :suss:

Re: Need Help Updating a MS Access database.

Shameel12-Nov-09 22:26

Shameel

12-Nov-09 22:26

There's no INSERT INTO in your statement, how do you get that error ?

Besides that, you have to use the actual parameter names instead of a question mark.

SQL

update EventData 
set EventType = @EventType, UnitNo = @UnitNo ....
where ID = @ID

Dropping multiple tables?

Emmet_Brown12-Nov-09 14:07

Emmet_Brown

12-Nov-09 14:07

Hi again

I want to drop multiple tables from my database starting with the same name.

I've tried this:

SQLcommand = "DROP TABLE WHERE TABLE LIKE = 'a" + identity + "%'";
            SqlCeCommand sucuk = new SqlCeCommand(SQLcommand, conn);
            sucuk.ExecuteNonQuery();

but it didn't work

My tables start with an "a", and follows by an identity number, then a "year"
I want to drop all the tables with the same identity, what can be the suitable solution can anybody help me please Frown | :(

Re: Dropping multiple tables?

Luc Pattyn12-Nov-09 14:17

Luc Pattyn

12-Nov-09 14:17

Hi,

why don't you look it up in the documentation? just type SQL and the keywords into Google.

e.g. DROP TABLE in SQL[^], as you can see there is no WHERE clause.

However in MySQL one can do "SHOW TABLES LIKE 'a%'"

Smile | :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Re: Dropping multiple tables?

Emmet_Brown12-Nov-09 14:27

Emmet_Brown

12-Nov-09 14:27

ahah yeah you're right I've tried it and a few guys like me tried this WHERE clause

I couldn't find a proper syntax for C# to drop multiple tables

How can I use this "SHOW" ?

Re: Dropping multiple tables?

Luc Pattyn12-Nov-09 15:09

Luc Pattyn

12-Nov-09 15:09

Emmet_Brown wrote:
I couldn't find a proper syntax for C# to drop multiple tables

There is no direct relation to C#, whatever programming language you choose, in the end you are sending strings of SQL commands.

Emmet_Brown wrote:
How can I use this "SHOW" ?

I have already told you its all in the documentation, i.e. one Google search away.
I suggest you get your act together.

Smile | :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Re: Dropping multiple tables?

Vikram A Punathambekar12-Nov-09 20:48

Vikram A Punathambekar

12-Nov-09 20:48

You can query sysobjects to find out which tables match your pattern. Then you have to issue a DROP TABLE command for each of them.

As pointed out, this belongs more to the Database forum.

Cheers,
Vikram. (Cracked not one CCC, but two!)

Re: Dropping multiple tables?

PIEBALDconsult12-Nov-09 15:15

PIEBALDconsult

12-Nov-09 15:15

Take it to the General Database forum.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.