C# Discussion Boards - CodeProject

Re: Hiding content in an email message - Pls help

19-Oct-09 19:28

Pretty much impossible. Unless you hide it in an image or something, some sort of attached file that needs a third party program to extract the info.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

carlecomm20-Oct-09 21:07

carlecomm

20-Oct-09 21:07

Hi,

I think you can use a hidden img and set its src to some page that you have.

When the email is opened, the action can transfer the data to your web page.

In that page you can deal with the data and save it anywhere you want.

modified 27-May-14 5:27am.

[Solved]Customize calendar control

Ishqalways19-Oct-09 18:54

Ishqalways

19-Oct-09 18:54

Hi..

i would like to add a calendar in my windows application form.
i have added some dates as special in a table.
i would like to display that dates as bold or in different color when that particular month is selected.
can any one help me to customize the calendar??

should i need to create a user control???
If yes, which property i have to set to display the dates as bold??

thanks in advance

Re: Customize calendar control

Christian Graus19-Oct-09 18:58

Re: Customize calendar control

19-Oct-09 18:58

Ishqalways wrote:
should i need to create a user control???

I expect so.

Ishqalways wrote:
If yes, which property i have to set to display the dates as bold??

The Bold property on the label class would be a good guess.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Russ-T19-Oct-09 19:52

Russ-T

19-Oct-09 19:52

Ishqalways wrote:
i would like to display that dates as bold or in different color when that particular month is selected.
can any one help me to customize the calendar??

The standard MonthCalendar control has a property called BoldedDates. Just pass it an array of the DateTime's you need in bold and it'll take care of the rest.

Here's a link with some more info:
http://msdn.microsoft.com/en-us/library/system.windows.forms.monthcalendar.boldeddates.aspx[^]

Hope that helps! Smile | :)

How to set the image field data to some cell of Excel?

mctramp16819-Oct-09 15:25

mctramp168

19-Oct-09 15:25

There is a image field in the table, and I save the picture into this field, now I use below code, how to set the value of the Tables[0].Rows[0][0] to one cell of Excel sheet?

string strCon = "Data Source=0;Initial Catalog=dbtest;Persist Security Info=True;User ID=sa;Password=ok";
SqlDataAdapter m_da = new SqlDataAdapter("select fa from G_Control", strCon);
DataSet ds = new DataSet();
m_da.Fill(ds);

Thanks in advance!

Re: How to set the image field data to some cell of Excel?

mctramp16820-Oct-09 14:06

mctramp168

20-Oct-09 14:06

who can help me on it ?many thanks!

SharePoint Search in Document

W4Rl0CK4719-Oct-09 13:56

W4Rl0CK47

19-Oct-09 13:56

Hi,

Can anyone advise me on how to search within a SharePoint document?

I've seen several examples of how to use a keyword or SQL search but having tried the code out, I only seem to be able to match against metadata such as the document's title, and various columns, such as keywords (of course). I thought that SharePoint MOSS 2007 would allow me to search the content of a document if I wished. Am I mistaken? Can anyone suggest a way of searching within a SharePoint document?

Re: SharePoint Search in Document

Not Active19-Oct-09 14:32

Not Active

19-Oct-09 14:32

Bug Me Not wrote:
Can anyone suggest a way of searching within a SharePoint document?

The first thing I'd do is search within the SharePoint forum

only two letters away from being an asset

code behind

auriva19-Oct-09 13:45

auriva

19-Oct-09 13:45

Hi i m new in C#.i want to know how to write code behind the next and continue buttons.pls reply me soon.coz code project.com is a platform that guides everyone.
regards Smile | :)

Christian Graus19-Oct-09 14:15

19-Oct-09 14:15

We love to help people, but sometimes, it's not really possible. The term 'code behind' relates to ASP.NET, and this is not the ASP.NET forum. Are you writing a web site. What continue and next buttons are you talking about ? Are you using a specific control that includes these buttons ?

If you don't know that we need this sort of info, then you probably would do better to buy a book and read it, but odds are good you're at work, in a job you're incapable of doing, and posting here because you want us to fill the gaps for you. We can't do that, based on the info you provided.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

EliottA19-Oct-09 14:30

EliottA

19-Oct-09 14:30

+5 for saying 'odd's are', we don't need another thread like in the VB forum...

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

Christian Graus19-Oct-09 15:35

19-Oct-09 15:35

I am trying very hard to be nice, and to be helpful. I see he's not responding. I bet he just asks the same question the same way in a week from now Frown | :(

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Luc Pattyn19-Oct-09 16:19

Luc Pattyn

19-Oct-09 16:19

No no, he just ran off to the nearest book store.

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

Local announcement (Antwerp region): Lange Wapper? 59.24% waren verstandig genoeg om NEEN te stemmen; bye bye viaduct.

No value given for one or more required parameters.

Pete O'Hanlon19-Oct-09 22:35

Pete O'Hanlon

19-Oct-09 22:35

Assuming you have placed the buttons on your form, double click them and the appropriate event handlers are created in the code. You can now enter code into these handlers to cope with them.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

Kevin Marois19-Oct-09 13:12

Kevin Marois

19-Oct-09 13:12

I'm really stuck here. I have been Googling this all day and no luck.

I'm working in a C# WinForms app that reads data from Excel into a DataSet. Here's the SQL:

string Query = "SELECT [TPMA Run Date],[Buyer],[Item],[PO Number],[PO Line],[PO Due Date],[Date Required]," +
                "[New Date],[Status Comment],[Status Code],[Prior Week New Date],[Prior Week Status]," +
                "[Prior Week Status Code],[SEQNUM] FROM [Current MRP Action Messages$]";

If I change it to this, it works fine:

string Query = "SELECT * FROM [Current MRP Action Messages$]";

Here's my conn string:

ConnectionString = @"provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileName + ";Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1\"";

The Excel file has column headers in the first row.

Anyone know what's wring here?

Everything makes sense in someone's mind

Re: No value given for one or more required parameters.

Luc Pattyn19-Oct-09 13:41

Luc Pattyn

19-Oct-09 13:41

Hi,

I haven't done this with Excel but here are my thoughts anyway:

- if "SELECT * ..." works fine, then your connectionstring, DB path, etc. are fine;
- so the problem must be in one or several of the field names

Hence: start with one field, then add them one by one until it fails; fix that, and keep adding till done.

BTW: I would never choose complex field names with spaces, dollars, etc; it only complicates matters. However escaping them would solve everything, I am not absolutely sure square brackets is the right way, I found at least one web page claiming backquotes should be used. Once more, experiment with a single column first.

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

Local announcement (Antwerp region): Lange Wapper? 59.24% waren verstandig genoeg om NEEN te stemmen; bye bye viaduct.

Re: No value given for one or more required parameters.

_Maxxx_20-Oct-09 19:12

_Maxxx_

20-Oct-09 19:12

I really have no idea with excel, but:

If the Select * works fine, then examine the datarow(s) returned and find the name(s) of the columns returned - that will show you what names of columns you need to use in your select statement.

Try reducing the first Select to just returning one column - if that works add the next column and keep going until it breaks.

My suspicion is that the excel data provider is not using the first row for column names, hence it can't find them in your first query - so you need to find out how to tell it to treat the first row as names of columns.

Good Luck

Max

___________________________________________
.\\axxx
(That's an 'M')

Windows application

or or19-Oct-09 11:34

or or

19-Oct-09 11:34

I wrote a windows application witch should run always - from turning on the computer until it goes off. When I try to shut down the computer sometimes it doesn't turn off. My OS is Windows-XP.
(I have some threads but all of them are background threads.)

Eddy Vluggen19-Oct-09 11:54

Eddy Vluggen

19-Oct-09 11:54

You're cancelling the FormClosing[^] event? Take a look at the CloseReason; you might want to allow the closing of the form when the CloseReason is CloseReason.WindowsShutDown Smile | :)

I are Troll Smile | :)

or or19-Oct-09 20:24

or or

19-Oct-09 20:24

Thanks, you're right I did cancel the close.

Not Active19-Oct-09 13:15

Not Active

19-Oct-09 13:15

If you want an application to run from start to end like this you should use a Windows service, not a Windows form application, then you won't have this issue.

only two letters away from being an asset