Click here to Skip to main content
15,920,005 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionTrace Browser Back Button Click? Pin
Md Arif20-Aug-07 16:08
Md Arif20-Aug-07 16:08 
AnswerRe: Trace Browser Back Button Click? Pin
Michael Sync20-Aug-07 17:51
Michael Sync20-Aug-07 17:51 
QuestionProblem occurs when running ASP.NET application on Windows Server 2003 Pin
vuthaianh20-Aug-07 15:45
vuthaianh20-Aug-07 15:45 
AnswerRe: Problem occurs when running ASP.NET application on Windows Server 2003 Pin
Michael Sync20-Aug-07 16:03
Michael Sync20-Aug-07 16:03 
QuestionInsert Command for decimal Pin
williammcq20-Aug-07 13:22
williammcq20-Aug-07 13:22 
AnswerRe: Insert Command for decimal Pin
Michael Sync20-Aug-07 15:10
Michael Sync20-Aug-07 15:10 
GeneralRe: Insert Command for decimal Pin
williammcq20-Aug-07 16:33
williammcq20-Aug-07 16:33 
GeneralRe: Insert Command for decimal Pin
Michael Sync20-Aug-07 17:00
Michael Sync20-Aug-07 17:00 
williammcq wrote:

VPODS.InsertCommandType = SqlDataSourceCommandType.Text


Why "SqlDataSourceCommandType"? Your database is MS Access??


williammcq wrote:
I have setup a insert command that includes a dollar value like so:

VPODS.InsertCommandType = SqlDataSourceCommandType.Text
VPODS.InsertCommand = "INSERT INTO [VPO] ([OrderDate], [Project], [Supplies], [NoExceed])VALUES (@OrderDate, @Project, @Supplies, @NoExceed)"

VPODS.InsertParameters.Add("OrderDate", Now())
VPODS.InsertParameters.Add("Project", Project)
VPODS.InsertParameters.Add("Supplies", TypeCode.Boolean, Supplies)
VPODS.InsertParameters.Add("NoExceed", TypeCode.Decimal, NoExceed)

rowsAffected = VPODS.Insert()

It is posting to an Access DB and the NoExceed file is of DataType Dollar.



Why don't you use OleDb ff your database is MS Access?

OleDbType.Currency


Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. Smile | :)

GeneralRe: Insert Command for decimal Pin
williammcq20-Aug-07 17:15
williammcq20-Aug-07 17:15 
GeneralRe: Insert Command for decimal Pin
williammcq20-Aug-07 18:33
williammcq20-Aug-07 18:33 
GeneralRe: Insert Command for decimal Pin
Michael Sync20-Aug-07 19:57
Michael Sync20-Aug-07 19:57 
GeneralRe: Insert Command for decimal Pin
williammcq22-Aug-07 8:47
williammcq22-Aug-07 8:47 
QuestionSaving my menus Pin
2hdass20-Aug-07 10:08
2hdass20-Aug-07 10:08 
AnswerRe: Saving my menus Pin
Christian Graus20-Aug-07 10:57
protectorChristian Graus20-Aug-07 10:57 
GeneralRe: Saving my menus Pin
2hdass21-Aug-07 3:36
2hdass21-Aug-07 3:36 
QuestionSharing multimedia files over IIS Pin
juli Paris20-Aug-07 8:22
juli Paris20-Aug-07 8:22 
AnswerRe: Sharing multimedia files over IIS Pin
Rama Krishna Vavilala20-Aug-07 11:17
Rama Krishna Vavilala20-Aug-07 11:17 
QuestionRe: Sharing multimedia files over IIS Pin
juli Paris21-Aug-07 0:19
juli Paris21-Aug-07 0:19 
QuestionAdd menu like winApplication Menu.... Pin
mostafa_h20-Aug-07 8:06
mostafa_h20-Aug-07 8:06 
QuestionSql Server 2005 required? Pin
Richard Jones20-Aug-07 7:57
Richard Jones20-Aug-07 7:57 
Questionglobal database connection Pin
PaulaM20-Aug-07 5:47
PaulaM20-Aug-07 5:47 
AnswerRe: global database connection Pin
Eduard Keilholz20-Aug-07 6:01
Eduard Keilholz20-Aug-07 6:01 
QuestionPassing VB variables to Javascript code Pin
beish120-Aug-07 5:00
beish120-Aug-07 5:00 
AnswerRe: Passing VB variables to Javascript code Pin
peacefulmember20-Aug-07 6:06
peacefulmember20-Aug-07 6:06 
GeneralRe: Passing VB variables to Javascript code Pin
beish120-Aug-07 6:44
beish120-Aug-07 6:44 

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.