mobile number or land line number enter or optional using asp.net?

Question

0.00/5 (No votes)

See more:

Dear All,

I created one web page and that page contain name, title, description and mobile number or landline number

here once enter name , title, description, and mobile number or landline number after entering these store in database table and

enter only name, title, description, not enter mobile or landline number here i want optional mobile number or landline and store in database table please reply me any examples or logic please reply me

Posted 20-Apr-14 23:06pm

member258

Updated 20-Apr-14 23:13pm

v2

Add a Solution

Comments

OriginalGriff 21-Apr-14 5:21am

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
Use the "Improve question" widget to edit your question and provide better information.

1 solution

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)

Siva Hyderabad · Answer 1 · 2014-04-20T23:17:00

Solution 1

try this...

C#

objLiftingEntryPL.Mobileno = txtmobile.Text.Trim() == "" ? null : txtmobile.Text.Trim();

observe above line...If you enter mobile number it takes the Mobile Number from user other wise it stores the NULL value in your datebase..similarily write above line as same as 
"TxtLandNumber" ...

Posted 20-Apr-14 23:17pm

Siva Hyderabad

Updated 20-Apr-14 23:21pm

v2

Comments

member258 21-Apr-14 5:24am

here error comming : objLiftingEntryPL this is what please reply me

Siva Hyderabad 21-Apr-14 5:29am

first send me your button click logic

Siva Hyderabad 21-Apr-14 6:01am

if condition
String strInsert = "insert into ProductDetailsTable(Categories,CategoriesType,Title,Description,Price,State,City,ContactName,ContactEmail,ContactMobile,ContactPhoto,ContactedViaEmail,ContactedViaMobile,DateAdded) values('" + lblEducation.Text + "','" + ddlCategoryType.Text + "','" + txtTitle.Text + "','" + txtDescription.Text + "','" + txtPrice.Text + "','" + ddlState.SelectedItem.Text + "','" + ddlCity.SelectedItem.Text + "','" + txtContactName.Text + "','" + txtContactEmail.Text + "','" + txtContactMobile.Text.Trim() == "" ? null : txtContactMobile.Text.Trim(); +"','" + strimage + "','" + txtContactedViaEmail.Text + "','" + txtContactedViaMobile.Text.Trim() == "" ? null : txtContactedViaMobile.Text.Trim(); +"','" + lblDateTime.Text + "')";

You just changed this line

Siva Hyderabad 21-Apr-14 6:01am

else condition

String strInsert = "insert into ProductDetailsTable(Categories,CategoriesType,Title,Description,Price,State,City,ContactName,ContactEmail,ContactMobile,ContactPhoto,ContactedViaEmail,ContactedViaMobile,DateAdded)values('" + lblEducation.Text + "','" + ddlCategoryType.Text + "','" + txtTitle.Text + "','" + txtDescription.Text + "','" + txtPrice.Text + "','" + ddlState.SelectedItem.Text + "','" + ddlCity.SelectedItem.Text + "','" + txtContactName.Text + "','" + txtContactEmail.Text + "','" + txtContactMobile.Text.Trim() == "" ? null : txtContactMobile.Text.Trim(); +"','" + strimage + "','" + txtContactedViaEmail.Text + "','" + txtContactedViaMobile.Text.Trim() == "" ? null : txtContactedViaMobile.Text.Trim(); +"','" + lblDateTime.Text + "')";

Siva Hyderabad 21-Apr-14 6:45am

you just copy above two lines

member258 21-Apr-14 6:46am

what two lines siva

Siva Hyderabad 21-Apr-14 6:48am

replace this

String strInsert = "insert into ProductDetailsTable(Categories,CategoriesType,Title,Description,Price,State,City,ContactName,ContactEmail,ContactMobile,ContactPhoto,ContactedViaEmail,ContactedViaMobile,DateAdded) values('" + lblEducation.Text + "','" + ddlCategoryType.Text + "','" + txtTitle.Text + "','" + txtDescription.Text + "','" + txtPrice.Text + "','" + ddlState.SelectedItem.Text + "','" + ddlCity.SelectedItem.Text + "','" + txtContactName.Text + "','" + txtContactEmail.Text + "','" + txtContactMobile.Text.Trim() == "" ? null : txtContactMobile.Text.Trim(); +"','" + strimage + "','" + txtContactedViaEmail.Text + "','" + txtContactedViaMobile.Text.Trim() == "" ? null : txtContactedViaMobile.Text.Trim(); +"','" + lblDateTime.Text + "')";

and

String strInsert = "insert into ProductDetailsTable(Categories,CategoriesType,Title,Description,Price,State,City,ContactName,ContactEmail,ContactMobile,ContactPhoto,ContactedViaEmail,ContactedViaMobile,DateAdded)values('" + lblEducation.Text + "','" + ddlCategoryType.Text + "','" + txtTitle.Text + "','" + txtDescription.Text + "','" + txtPrice.Text + "','" + ddlState.SelectedItem.Text + "','" + ddlCity.SelectedItem.Text + "','" + txtContactName.Text + "','" + txtContactEmail.Text + "','" + txtContactMobile.Text.Trim() == "" ? null : txtContactMobile.Text.Trim(); +"','" + strimage + "','" + txtContactedViaEmail.Text + "','" + txtContactedViaMobile.Text.Trim() == "" ? null : txtContactedViaMobile.Text.Trim(); +"','" + lblDateTime.Text + "')";

Siva Hyderabad 21-Apr-14 6:48am

these are insert query lines

Siva Hyderabad 21-Apr-14 6:56am

wait

Siva Hyderabad 21-Apr-14 7:02am

else condition insert statement here..
String strInsert = "insert into ProductDetailsTable(Categories,C
ProductDetailsTable(Categories,CategoriesType,Title,Description,Price,State,City,ContactName,ContactEmail,ContactMobile,ContactPhoto,ContactedViaEmail,ContactedViaMobile,DateAdded)values('" + lblEducation.Text + "','" + ddlCategoryType.Text + "','" + txtTitle.Text + "','" + txtDescription.Text + "','" + txtPrice.Text + "','" + ddlState.SelectedItem.Text + "','" + ddlCity.SelectedItem.Text + "','" + txtContactName.Text + "','" + txtContactEmail.Text + "','" + txtContactMobile.Text.Trim() == "" ? null : txtContactMobile.Text.Trim(); +"','" + txtContactedViaEmail.Text + "','" + txtContactedViaMobile.Text.Trim() == "" ? null : txtContactedViaMobile.Text.Trim(); +"','" + lblDateTime.Text + "')";

Siva Hyderabad 21-Apr-14 7:09am

what happend...is there any error palagiri

Siva Hyderabad 21-Apr-14 7:00am

if condition insert statement here..I modified error here
String strInsert = "insert into
ProductDetailsTable(Categories,CategoriesType,Title,Description,Price,State,City,ContactName,ContactEmail,ContactMobile,ContactPhoto,ContactedViaEmail,ContactedViaMobile,DateAdded)values('" + lblEducation.Text + "','" + ddlCategoryType.Text + "','" + txtTitle.Text + "','" + txtDescription.Text + "','" + txtPrice.Text + "','" + ddlState.SelectedItem.Text + "','" + ddlCity.SelectedItem.Text + "','" + txtContactName.Text + "','" + txtContactEmail.Text + "','" + txtContactMobile.Text.Trim() == "" ? null : txtContactMobile.Text.Trim(); +"','" + txtContactedViaEmail.Text + "','" + txtContactedViaMobile.Text.Trim() == "" ? null : txtContactedViaMobile.Text.Trim(); +"','" + lblDateTime.Text + "')";

member258 21-Apr-14 7:59am

siva is not coming output

Vikas Parmar 25-Jul-14 2:22am

But how to insert null value in INT ??