Click here to Skip to main content
15,902,775 members
Home / Discussions / C#
   

C#

 
QuestionPDF to HTML conversion Pin
cincy15-Apr-08 1:06
cincy15-Apr-08 1:06 
GeneralRe: PDF to HTML conversion Pin
Christian Graus15-Apr-08 1:21
protectorChristian Graus15-Apr-08 1:21 
QuestionCaramel - code generator: Anyone interested in joining? Pin
Roger Alsing15-Apr-08 1:01
Roger Alsing15-Apr-08 1:01 
GeneralC# SQL date issue Pin
AJ du Plessis15-Apr-08 0:42
AJ du Plessis15-Apr-08 0:42 
GeneralRe: C# SQL date issue Pin
Christian Graus15-Apr-08 1:01
protectorChristian Graus15-Apr-08 1:01 
GeneralRe: C# SQL date issue Pin
Harvey Saayman15-Apr-08 1:14
Harvey Saayman15-Apr-08 1:14 
GeneralRe: C# SQL date issue Pin
J4amieC15-Apr-08 1:19
J4amieC15-Apr-08 1:19 
GeneralRe: C# SQL date issue Pin
Harvey Saayman15-Apr-08 22:26
Harvey Saayman15-Apr-08 22:26 
Hey J4amieC,

thanx alot, that seems to be working!

now id like to run a different scenario by you also about dates and times. in my communication application i get data from an external device, a fingerprint scanner to be exact. now it send me the dateTime in a string and there is nothing i can do about that.

so currently when i add it to the dataBase i do this...

<sqlcommand insertcommand="new" sqlcommand(="sp_InsertIntoAccessPunches" ,="" newsqlconn);<br="" mode="hold" />insertCommand.CommandType = CommandType.StoredProcedure;

insertCommand.Parameters.Add("@dateTime", SqlDbType.DateTime);
insertCommand.Parameters["@dateTime"].Value = DateTime.Parse(dateTime); //dateTime is the string

insertCommand.Parameters.AddWithValue("@empNo", empNo);

insertCommand.Parameters.AddWithValue("@TerminalID", terminalID);

cmd.ExecuteNonQuery();


what do you think?

thanx

Harvey Saayman - South Africa
Junior Developer
.Net, C#, SQL
think BIG and kick ASS
you.suck = (you.passion != Programming)

General[Message Deleted] Pin
sarilee15-Apr-08 0:02
sarilee15-Apr-08 0:02 
GeneralRe: combobox in datagrid Pin
Christian Graus15-Apr-08 0:14
protectorChristian Graus15-Apr-08 0:14 
GeneralRe: combobox in datagrid Pin
sarilee15-Apr-08 0:48
sarilee15-Apr-08 0:48 
GeneralRe: combobox in datagrid Pin
Christian Graus15-Apr-08 0:50
protectorChristian Graus15-Apr-08 0:50 
GeneralRe: combobox in datagrid Pin
sarilee15-Apr-08 1:15
sarilee15-Apr-08 1:15 
Generaltemplates in datagrid Pin
sarilee14-Apr-08 23:45
sarilee14-Apr-08 23:45 
GeneralRe: templates in datagrid Pin
Christian Graus14-Apr-08 23:53
protectorChristian Graus14-Apr-08 23:53 
GeneralStreamWriter Pin
George_George14-Apr-08 23:44
George_George14-Apr-08 23:44 
GeneralRe: StreamWriter Pin
N a v a n e e t h15-Apr-08 0:25
N a v a n e e t h15-Apr-08 0:25 
GeneralRe: StreamWriter Pin
George_George15-Apr-08 2:55
George_George15-Apr-08 2:55 
GeneralRe: StreamWriter Pin
N a v a n e e t h15-Apr-08 20:36
N a v a n e e t h15-Apr-08 20:36 
GeneralRe: StreamWriter Pin
George_George16-Apr-08 0:05
George_George16-Apr-08 0:05 
GeneralRe: StreamWriter Pin
N a v a n e e t h16-Apr-08 2:00
N a v a n e e t h16-Apr-08 2:00 
GeneralRe: StreamWriter Pin
George_George16-Apr-08 2:22
George_George16-Apr-08 2:22 
GeneralRe: StreamWriter Pin
N a v a n e e t h16-Apr-08 3:01
N a v a n e e t h16-Apr-08 3:01 
GeneralRe: StreamWriter Pin
George_George16-Apr-08 3:42
George_George16-Apr-08 3:42 
GeneralRe: StreamWriter Pin
Gareth H15-Apr-08 0:26
Gareth H15-Apr-08 0:26 

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.