Click here to Skip to main content
16,007,610 members
Home / Discussions / C#
   

C#

 
GeneralRe: Rich text background colour/selection Pin
mav.northwind29-Jun-05 19:57
mav.northwind29-Jun-05 19:57 
GeneralRe: Rich text background colour/selection Pin
IJay29-Jun-05 22:18
IJay29-Jun-05 22:18 
GeneralRe: Rich text background colour/selection Pin
IJay29-Jun-05 23:43
IJay29-Jun-05 23:43 
GeneralMy TcpListener doesn't works Pin
Alex Cutovoi28-Jun-05 3:27
Alex Cutovoi28-Jun-05 3:27 
GeneralRe: My TcpListener doesn't works Pin
User 665828-Jun-05 5:30
User 665828-Jun-05 5:30 
GeneralDate Insertion in mySQL Database Pin
Jassim Rahma28-Jun-05 2:56
Jassim Rahma28-Jun-05 2:56 
GeneralRe: Date Insertion in mySQL Database Pin
Colin Angus Mackay28-Jun-05 3:53
Colin Angus Mackay28-Jun-05 3:53 
GeneralRe: Date Insertion in mySQL Database Pin
metalsandman28-Jun-05 4:03
metalsandman28-Jun-05 4:03 
hi.

i had some problems with insertion & update of date in sql, and i solved it by using parameters to a command, but u have to be carefull because the character that shows the command that there is a parameter differs from server to server.
for example: (C#)
- to a sql server u would have something like this:

SqlCommand command = new SqlCommand("insert into mytable values (...,@date,...)");
SqlParameter parameter = new SqlParameter("@date", DateTime.Now);
command.Parameters.Add(parameter);
command.ExecuteNonQuery();

the parameter here is: "@date"

- to an oracle server the parameter characther is ":" and u would have something like this: ":date".

and if this doesn't help, u could try to use a stored procedure Smile | :)

best regards.
MetalSandman.
GeneralRe: Date Insertion in mySQL Database Pin
Colin Angus Mackay28-Jun-05 4:52
Colin Angus Mackay28-Jun-05 4:52 
General,Date Insertion in mySQL Database Pin
Jassim Rahma28-Jun-05 2:52
Jassim Rahma28-Jun-05 2:52 
GeneralRe: ,Date Insertion in mySQL Database Pin
Colin Angus Mackay28-Jun-05 3:46
Colin Angus Mackay28-Jun-05 3:46 
GeneralRe: ,Date Insertion in mySQL Database Pin
Dave Kreskowiak28-Jun-05 4:38
mveDave Kreskowiak28-Jun-05 4:38 
Questionhow to create a file as hidden? Pin
Green Fuze28-Jun-05 0:58
Green Fuze28-Jun-05 0:58 
AnswerRe: how to create a file as hidden? Pin
Hesham Amin28-Jun-05 1:52
Hesham Amin28-Jun-05 1:52 
GeneralRe: how to create a file as hidden? Pin
Green Fuze28-Jun-05 3:58
Green Fuze28-Jun-05 3:58 
GeneralGenerate an Image using ByteCode/HexaView Pin
MDKrishan27-Jun-05 21:29
MDKrishan27-Jun-05 21:29 
GeneralGenerate an Image using ByteCode/HexaView Pin
MDKrishan27-Jun-05 21:25
MDKrishan27-Jun-05 21:25 
GeneralDataAdapter.Fill Problems Pin
metalsandman27-Jun-05 21:20
metalsandman27-Jun-05 21:20 
GeneralRe: DataAdapter.Fill Problems Pin
Piovra_27-Jun-05 21:38
Piovra_27-Jun-05 21:38 
GeneralRe: DataAdapter.Fill Problems Pin
metalsandman27-Jun-05 23:44
metalsandman27-Jun-05 23:44 
GeneralRe: DataAdapter.Fill Problems Pin
Dave Kreskowiak28-Jun-05 4:34
mveDave Kreskowiak28-Jun-05 4:34 
GeneralRe: DataAdapter.Fill Problems Pin
metalsandman28-Jun-05 4:43
metalsandman28-Jun-05 4:43 
GeneralManipulate cells in datagrid Pin
Piovra_27-Jun-05 20:27
Piovra_27-Jun-05 20:27 
GeneralRe: Manipulate cells in datagrid Pin
sreejith ss nair28-Jun-05 0:02
sreejith ss nair28-Jun-05 0:02 
Generalexport excell file to SQL SERVER Pin
dabuskol27-Jun-05 19:58
dabuskol27-Jun-05 19:58 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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