Click here to Skip to main content
15,907,281 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: difference between .Net DLLs and Non.Net DLLs Pin
N a v a n e e t h4-Dec-07 18:17
N a v a n e e t h4-Dec-07 18:17 
GeneralRe: difference between .Net DLLs and Non.Net DLLs Pin
rockz...4-Dec-07 18:29
rockz...4-Dec-07 18:29 
GeneralValidation Controls Problem?? [modified] Pin
Vanamaindia4-Dec-07 17:31
Vanamaindia4-Dec-07 17:31 
GeneralMove from TextBox to another textbox Pin
TeeLeong4-Dec-07 17:20
TeeLeong4-Dec-07 17:20 
GeneralRe: Move from TextBox to another textbox Pin
Christian Graus4-Dec-07 18:13
protectorChristian Graus4-Dec-07 18:13 
Generalmenu on the click of grid view row Pin
Piyush Vardhan Singh4-Dec-07 16:43
Piyush Vardhan Singh4-Dec-07 16:43 
GeneralRe: menu on the click of grid view row Pin
ReactiveX4-Dec-07 18:54
ReactiveX4-Dec-07 18:54 
GeneralInsert date into oracle Pin
kjosh4-Dec-07 11:05
kjosh4-Dec-07 11:05 
Hi,
I tried to upfate the date field of table from .net. I have tried like the below:

Database db = DatabaseFactory.CreateDatabase();
using (DbConnection connection = db.CreateConnection())
{
connection.Open();

DbTransaction transaction = connection.BeginTransaction(IsolationLevel.Serializable);
//DateTime dt = Convert.To(TextBox1.Text);
string s = "Update table1 set update_dttm = To_Date('" + DateTime.Now.ToShortDateString() +
"','dd/mm/yyyy')";
DbCommand pcmd = db.GetSqlStringCommand(s);
db.ExecuteNonQuery(pcmd, transaction);
transaction.Commit();
}
When I execute the string in s in Oracle it is working fine. But from .net I am not getting any error. It is executing continuously.
Whats wrong in my code.

Thanks in advance
GeneralRe: Insert date into oracle Pin
Venkatesh Mookkan4-Dec-07 16:20
Venkatesh Mookkan4-Dec-07 16:20 
GeneralRe: Insert date into oracle Pin
kjosh5-Dec-07 4:04
kjosh5-Dec-07 4:04 
GeneralReport viewer Pin
Aptiva Dave4-Dec-07 10:32
Aptiva Dave4-Dec-07 10:32 
GeneralRe: Report viewer Pin
ReactiveX4-Dec-07 19:02
ReactiveX4-Dec-07 19:02 
GeneralRe: Report viewer Pin
Aptiva Dave5-Dec-07 3:16
Aptiva Dave5-Dec-07 3:16 
Questionhow to upload a sqlserver database Pin
M.V4-Dec-07 8:09
M.V4-Dec-07 8:09 
AnswerRe: how to upload a sqlserver database Pin
pmarfleet4-Dec-07 8:26
pmarfleet4-Dec-07 8:26 
AnswerRe: how to upload a sqlserver database Pin
Fred_Smith4-Dec-07 8:34
Fred_Smith4-Dec-07 8:34 
QuestionHow to have different pages use the same master but different VB files? Pin
Jordanwb4-Dec-07 7:45
Jordanwb4-Dec-07 7:45 
AnswerRe: How to have different pages use the same master but different VB files? Pin
Guffa4-Dec-07 14:27
Guffa4-Dec-07 14:27 
QuestionHow do I read cnnection string from web config file Pin
Tomic4-Dec-07 3:14
Tomic4-Dec-07 3:14 
AnswerRe: How do I read cnnection string from web config file Pin
pmarfleet4-Dec-07 8:24
pmarfleet4-Dec-07 8:24 
AnswerRe: How do I read cnnection string from web config file Pin
Sunil Wise4-Dec-07 19:45
professionalSunil Wise4-Dec-07 19:45 
Generalcrystal report error in asp.net Pin
Member 41706454-Dec-07 2:53
Member 41706454-Dec-07 2:53 
GeneralRe: crystal report error in asp.net Pin
Vasudevan Deepak Kumar4-Dec-07 18:20
Vasudevan Deepak Kumar4-Dec-07 18:20 
GeneralBinding Drop down from another page. Pin
Lijo Rajan4-Dec-07 2:48
Lijo Rajan4-Dec-07 2:48 
GeneralRe: Binding Drop down from another page. Pin
ReactiveX4-Dec-07 2:54
ReactiveX4-Dec-07 2:54 

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.