StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POasp.net oracle database 3 tier cannot convert string to datetime
primarykey
Id
12670017
data
AcceptedAnswerId
0
AnswerCount
3
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-10-01T08:45:41.343
FavoriteCount
0
LastActivityDate
2012-10-03T22:17:39.367
LastEditDate
LastEditorUserId
0
OwnerUserId
1084949
ParentId
0
PostTypeId
1
Score
0
ViewCount
932
LastEditorDisplayName
text
Body
I'm working in Asp.net C# 3 tier with oracle database. I create a function for Read and Delete and it is working but for the insert and update I’m getting error of converting string to datetime. Here is the Business layer code: <pre><code> public void InsertSurvey(string SURV_NAME, DateTime SURV_STARTDATE, DateTime S_ENDDATE) { try { string str = "select max(SURV_ID) as max_SURV_ID from SURVEY"; int maxVal = (_dbAccess.returnint32(str)); string SURV_ID = Convert.ToString(maxVal); if (string.IsNullOrEmpty(SURV_ID)) { maxVal = 1; } else { maxVal++; } string strInsert = "SET IDENTITY_INSERT SURVEY ON insert into SURVEY(SURV_ID,SURV_NAME,SURV_STARTDATE,S_ENDDATE) values('" + maxVal + "','" + SURV_NAME + "','" + SURV_STARTDATE + "','" + S_ENDDATE + "') SET IDENTITY_INSERT SURVEY OFF"; _dbAccess.executeQuery(strInsert); } catch (Exception ex) { throw ex; } } </code></pre> And here is the Submit code from the page code behind for the insert form: <pre><code> public partial class Survey_insert_survey : System.Web.UI.Page { BusSurvey _objSurvey = new BusSurvey(); protected void btnSubmit_Click(object sender, EventArgs e) { _objSurvey.InsertSurvey(txtSURV_NAME.Text, txtSURV_STARTDATE.Text, txtS_ENDDATE.Text); //If records successfully entered then redirect to feedback page Response.Redirect("view-survey.aspx"); } } </code></pre> This the error Im getteing: <img src="https://i.stack.imgur.com/NSevW.png" alt="enter image description here"> Hope I get help 
Tags
<c#><asp.net><oracle>
Title
asp.net oracle database 3 tier cannot convert string to datetime
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USuser1084949
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
3. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.