Re: Help: Can't format string using String.Format - C# Discussion Boards

Re: install sql server 2005

10-Aug-10 17:52

that isn't a C# question. You should try the Database forum instead.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Abhinav S10-Aug-10 18:07

Abhinav S

10-Aug-10 18:07

Have a look at the msdn website.
This is not a C# question anyway.

The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.

My latest tip/trick - Silverlight *.XCP files.

Visit the Hindi forum here.

Help: Can't format string using String.Format

roman_s10-Aug-10 9:17

roman_s

10-Aug-10 9:17

I cant seem to format my strAverageDensity which originally is in this example strAverageDensity = 30.000000123
using: string.Format("{0:0.00}", strAverageDensity);

need it to equal 30.00 in this case but 2 decimal places
instead its still strAverageDensity = 30.000000123

so this is the code:

EditSubCategory E = new EditSubCategory();

    SubCategory C = GlobalContextManager.Instance.Cache.GetSubCategory((int)R.Cells[0].Value);
    Category CC = GlobalContextManager.Instance.Cache.GetCategory(C.CategoryId);

  string strAverageDensity = Convert.ToString(GlobalContextManager.Instance.Conversions.ConvertMetricWeightToDefault(C.AverageDensity));

    E.ParentCategory = CC;
    E.Category = C.Name;
    E.IsActivated = C.IsEnabled;
    E.OriginalCategory = C.Name;

    strAverageDensity = string.Format("{0:0.00}", strAverageDensity);
    E.AverageDensity = strAverageDensity;

Ennis Ray Lynch, Jr.10-Aug-10 9:29

Ennis Ray Lynch, Jr.

10-Aug-10 9:29

strAverageDensity should be of type float or double and not string to take advantage of numeric format strings.

Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. I also do Android Programming as I find it a refreshing break from the MS.

"And they, since they Were not the one dead, turned to their affairs" -- Robert Frost

OriginalGriff10-Aug-10 9:32

OriginalGriff

10-Aug-10 9:32

Try:

strAverageDensity = string.Format("{0:0.00}", C.AverageDensity);

which I assume is a float / double. Strings do not use numeric formats!

Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.

Luc Pattyn10-Aug-10 9:34

10-Aug-10 9:34

you failed to show an essential line of source code. Now compare yours to this:

float f=30.01234f;
log(string.Format("{0:0.00}", f));
string s="30.01234";
log(string.Format("{0:0.00}", s));

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

ignrod10-Aug-10 9:42

ignrod

10-Aug-10 9:42

As has already been pointed out, this format string works with numeric types. Why don't you try?

double dAverageDensity = Double.Parse(strAverageDensity);
strAverageDensity = String.Format("{0:0.00}", dAverageDensity);

Martin shooster10-Aug-10 10:17

Martin shooster

10-Aug-10 10:17

hi dear friend.
i am a regular programmer,but i think D'Oh! | :doh:

this line of your program can be change
string strAverageDensity = Convert.ToString(GlobalContextManager.Instance.Conversions.ConvertMetricWeightToDefault(C.AverageDensity));

instead of Convert.ToString(...) use of System.Convert.ToString(...).

i hope success for you.

M.Shooster

PIEBALDconsult10-Aug-10 17:24

PIEBALDconsult

10-Aug-10 17:24

You could try Substring.... Blush | :O

Luc Pattyn10-Aug-10 17:51

10-Aug-10 17:51

substring is chopping strings, not rounding numbers.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

PIEBALDconsult11-Aug-10 3:09

PIEBALDconsult

11-Aug-10 3:09

He seems to want to round a string.

Luc Pattyn11-Aug-10 3:25

11-Aug-10 3:25

Yes it sure looks that way, although he never said it explicitly.
So he should parse and either round or format, as ignrod suggested.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Email - invalid remote certificate

PIEBALDconsult11-Aug-10 16:17

PIEBALDconsult

11-Aug-10 16:17

Luc Pattyn wrote:
he should parse and either round or format

I disagree. Big Grin | :-D

Running Fool10-Aug-10 8:13

Running Fool

10-Aug-10 8:13

I am writing a program to send email. When I send from my own email accounts everything works! When I send from my company email or any other emails from the company I get the error: “The remote certificate is invalid according to the validation procedure”
The code looks like this:

<br />
mailObj = new SmtpClient("smtp. MyCompany.com", 25);<br />
from = new MailAddress("xxxxxx@MyCompany.com", "Chris H");<br />
AuthInfo = new NetworkCredential(from.Address, "xxxxxxxxxxx");<br />
to = new MailAddress("xxxxxxxx@hotmail.com", "Chris H");<br />
MailMessage mail = new MailMessage(from, to);<br />
mail.Subject = "Testing";<br />
mail.Body = "Hello Everybody";<br />
<br />
mailObj.UseDefaultCredentials = false;<br />
mailObj.EnableSsl = true;<br />
mailObj.Credentials = AuthInfo;<br />
mailObj.Send(mail);<br />

I have noticed that in our Outlook account settings - More Settings - Outgoing server we need to check the My outgoing server (SMTP) requires authentication and "Use same settings as my incoming mail server"

This would make me think my program should be able to get the authentication info need from the incoming mail server but how??

Any words of wisdom would be appreciated.

Matt Meyer10-Aug-10 9:13

Matt Meyer

10-Aug-10 9:13

The error has to due with the certificate not being valid. This is normally just due to being signed by a non-trusted CA, but it could also be expired, incorrectly used, etc. There is a callback method you can hook into, System.Net.ServicePointManager.ServerCertificateValidationCallback, that lets you extend the certificate validation procedure. You can create a delegate and process the certificate after the system does its own validation procedure to, as an example, permit an untrusted CA to authorize certificates.

Here's the MSDN references for them:
http://msdn.microsoft.com/en-us/library/system.net.servicepointmanager.servercertificatevalidationcallback.aspx[^]

http://msdn.microsoft.com/en-us/library/system.net.security.remotecertificatevalidationcallback.aspx[^]

Once upon a time, I wrote up a small tutorial about it. I can try to dig it up if you need any more assistance.

DaveyM6910-Aug-10 11:22

DaveyM69

10-Aug-10 11:22

To confirm what Matt has said above, the company I work for has several domains but we use just the one certificate for IMAP SSL so the certificate fails on anything but the domain the cert is for. I use the RemoteCertificateValidationCallback delegate to examine any policy errors and disregard RemoteCertificateNameMismatch.

Check what yours is failing on and disregard if appropriate.

Dave

If this helped, please vote & accept answer!

Binging is like googling, it just feels dirtier.
Please take your VB.NET out of our nice case sensitive forum.(Pete O'Hanlon)

BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

Running Fool10-Aug-10 11:39

Running Fool

10-Aug-10 11:39

I don’t see how to implement RemoteCertificateValidationCallback into my code. Our email is hosted by an outside company that is not very helpful so I don’t have access to their resources. All I have access to is my little program to help our salesmen respond to leads. This program would be run on the salesman’s PC while out of the office not on the ‘email server’. This may be the perfect response but I need a bit more guidance to see how to implement it.

DaveyM6910-Aug-10 12:12

DaveyM69

10-Aug-10 12:12

If i recall correctly (I don't have the code here at home) all you need to do is add this before you enable SSL

ServicePointManager.ServerCertificateValidationCallback = new RemoteCertificateValidationCallback(ValidateServerCertificate);

and set up the method

private bool ValidateServerCertificate(object sender, X509Certificate certificate, X509Chain chain, SslPolicyErrors sslPolicyErrors)
{
    bool result = true;
    // Examine sslPolicyErrors here and set result accordingly.
    return result;
}

You'll need these usings if not already present

using System.Net;
using System.Net.Security;
using System.Security.Cryptography.X509Certificates;

Dave

If this helped, please vote & accept answer!

Binging is like googling, it just feels dirtier.
Please take your VB.NET out of our nice case sensitive forum.(Pete O'Hanlon)

BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

Merging two datatables

norjali10-Aug-10 6:28

norjali

10-Aug-10 6:28

Hello again

im trying to merge two datatables as such

Table 1

row1 0 x x
row2 0 x x
row3 x 0 0

Table 2

row1 x 0 0
row2 x 0 0
row3 0 x x

merge them to

final table

row1 0 0 0
row2 0 0 0
row3 0 0 0

is there a way to do it (using merge?).i wont be able to use foreach or for loop (i think)as some of the rows are not in order ?

Ennis Ray Lynch, Jr.10-Aug-10 6:38

Ennis Ray Lynch, Jr.

10-Aug-10 6:38

I like SQL for this using the UNION statement is that is an option.

norjali10-Aug-10 6:48

norjali

10-Aug-10 6:48

any samples?

Ennis Ray Lynch, Jr.10-Aug-10 8:33

Ennis Ray Lynch, Jr.

10-Aug-10 8:33

SELECT 
    customerName,
    createDate
FROM
   customer
WHERE 
   createDate BETWEEN '2009-10-01' AND '2009-10-31'
UNION 
SELECT
    employeeName,
    hireDate
FROM
    employee
WHERE
   hireDate BETWEEN '2009-10-01' AND '2009-10-31'