Search:

Hi guys, I have some issues, saving a HTML content into Excel format. I just populate a StringBuilder and then display it into a WebControl Panel, juzt like this:


resultados.Controls.Add(new...

Hi guys,

I want to update this datatable into my DB but the table in the DB that I use, it doesn't use Primary Key and I really don't need it. Therefore I get this Exception error...

My Query is something like this


string queryString = "SELECT xValue, yValue, specType, s.specIndex FROM (verspec s INNER JOIN verspecdata sd on s.specIndex = sd.specIndex) WHERE (productNumber...

Hi Pr0's,

I have a problem trying to implement the same example from this link:

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommandbuilder.aspx

But instead of Sql I use...

Yes, it works perfectly!

Thank you very much.

Hi guys,

I need show an exception with a MessageBox but it take place in one project which mustn't use Form libraries. Maybe something like this.



public static void Main()
{
...

Hi guys,

I found this asignment operator "&=" and I don't know what it does means.

Any idea?

thank you.

Hey guys,

How I can open a specific Rootpath in folderBrowserDialog1 when it only accept SpecialFolder Enum.

For example if I want to my Rootpath start from "C:\ProgramA\lib\v1.5\examples\".
...

Hi guys,

I am facing this trouble.

I have associated some extension to my Application and they work good. The problem comes when I go to one of this files, right click on it, open with, select...

Hello guys,

Do you know why I get an error message when I try to get one value from a specific column when the datatype of this value is 'tinyint'?

If I change it to 'int' I dont get any error....

Hello guys,

I want to wait a certain time but it wont be always integer values, but decimals also.

For example I want to wait half second and in my program it's used like 0.5.

Do you have...

If I want to put that in a String, how you think it should be?



int x = 23;
string queryString = @"CASE WHEN (" + x + @" > 0)
THEN UPDATE person SET...

Really? how is that possible? so if (x > 0) I should handle it like

CASE x
WHEN 0 then do nothing
ELSE then DELETE from Person where index = 1
END

Hi guys,

how can I send an IF statement by T-SQL?

Lets suppose that I want to insert something, for example;



int n_count = 5;
string querytosend = @"if (" + n_count + " > 0)

You were right... I only need the '@' character.

Thank you very much.

Oh, I see... thank you.

but for example I target the point which I want into the new line, afterwards if I simply press ENTER the string at the next line wont be red anymore and it wont belong anymore to the previous line....

How I can split the following string in two or more lines?



string test = "its something unpredictable but in the end is right. I hope you had the time of your life.";

which set of buttons...

Hi guys,

I want to send this transaction but I got an error.



string cmdString = @"IF (5 > 0) SELECT dbIndex FROM VerCommonHeader WHERE productNumber = 'XyX' AND internalSerialNumber =...

Hi guys,

I have now several hours trying to find out how Transact-Sql works.. it doesn't seems too hard but the problem is that I can't find where I should write the code. I use SQLyog and when I...

Hi guys,

I have now several hours trying to find out how Transact-Sql works.. it doesn't seems too hard but the problem is that I can't find where I should write the code. I use SQLyog and when I...

solved

I found a way to do this



DateTime lastTime = DateTime.Now;
string x = lastTime.ToString("u").Replace("Z", "");


but I need to do this in 1 step because I send this time by parameters, i,e:

Hello guys,

I get this time from DateTime.Now "6/12/2009 11:45:28 AM" and I need to convert it ISO 8601 which is the one that SQL accepts "2009-12-06 11:45:28".

What can I do?

By the way I have already restart the computer several times and this keep happening.