why its not taking value of textarea ????

Question

0.00/5 (No votes)

See more:

hi

i m just inserting values...code is running without any error till end ...i have checked at different points. just its fail when i take value from textarea in 'req'.....and its not inserting in db as well. Table name is "RequestPay"....

ProjContext objCont = new ProjContext();
int item1 = int.Parse(dd_LeavDayFrom.SelectedItem.Value);
int item2 = int.Parse(dd_LeavMonthFrom.SelectedItem.Value);
int item3 = int.Parse(dd_LeavYearFrom.SelectedItem.Value);

int item4 = int.Parse(dd_Leav_dayTo.SelectedItem.Value);
int item5 = int.Parse(dd_Leav_MonTo.SelectedItem.Value);
int item6 = int.Parse(dd_Leav_YearTo.SelectedItem.Value);

DateTime dt = new DateTime(item3, item2, item1);
DateTime dt1 = new DateTime(item6, item5, item4);

RequestLeave req = new RequestLeave();
req.UName = txt_LeavEmpName.Text;
req.DateFrom = dt;
req.DateTo = dt1;
req.ReqReason = TextArea1.Text;

objCont.RequestLeaves.InsertOnSubmit(req);
objCont.SubmitChanges();
lbl_LeavSnt.Visible = true;

please anybody could help.... :(( :( :confused::confused:

[edit]"[code]" converted to code block, "ignore HTML..." option deselected - OriginalGriff[/edit]

Posted 29-Jan-11 5:13am

marileena

Updated 29-Jan-11 5:30am

OriginalGriff

v2

Add a Solution

Comments

OriginalGriff 29-Jan-11 11:32am

When you say "just its fail when i take value from textarea in 'req'." what do you mean?
Is there an error? If so, what is it?
If not, what does (or doesn't) happen?

Abhishek Sur 29-Jan-11 11:50am

Can you check weather TextArea1.Text has value?

What is the data type of ReqReason ? is it String ?

marileena 29-Jan-11 12:55pm

@OriginalGriff...there is not any error...thats what makes me rash. and it simply executes the next line i.e lbl_LeavSnt.Visible = true; but doesnot put values in db.
.
@Sur.....yeah have checked all. datatyp of ReqReason is varchar(50).

Abhishek Sur 29-Jan-11 14:49pm

@marileena You said when you step through the TextArea1.Text it shows the value, is it right?
For this can step through InsertOnSubmit or open Sql Server Profiler to see what Insert statement it creates ?

marileena 30-Jan-11 6:37am

@abhishek.....no i didnt say. i said...Only TextArea1.Text is not displaying information and InsertOnSubmit statement is not working...no error encountered but not putting values in db as well.:((

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**R. Giskard Reventlov** · Answer 1 · 2011-01-29T06:36:00

Are you populating the form without doing it inside:

if (!IsPostBack)
{
   // Populate forms fields.
}

Without the above construct (in the OnLoad event of the form or wherever it is you populate the form from) you will get the default state of the textbox when you click the button and postback to collect the form field values; presumably it is empty at that point.

Just a guess.

marileena · Answer 2 · 2011-01-29T06:58:00

Solution 2

what you suggest???

em working under button click event ...here should i write

C#

if(!IsPostBack)
{
}

is it you suggest??

Posted 29-Jan-11 6:58am

marileena

Updated 29-Jan-11 9:02am

v3

Comments

R. Giskard Reventlov 30-Jan-11 3:10am

Firstly, don't respond to an answer with an answer: use a comment. Secondly, re-read my answer: everything you need is in there.

marileena 30-Jan-11 6:38am

Ok...ll be careful next time:)