Re: how to insert empty values from text boxes to database - ASP.NET Discussion Boards

how to insert empty values from text boxes to database

developerit28-Mar-10 23:13

28-Mar-10 23:13

iam using asp.net with c#.and sql server

table fields are

customername nvarchar
monitors decimal
printers decimal
scanners decimal

some times customers will take only printers , so at that time the textboxes is empty so while saving and updating it is giving errors

Input string was not in a correct format

please give example which helps me.

Re: how to insert empty values from text boxes to database

Vimalsoft(Pty) Ltd28-Mar-10 23:15

Vimalsoft(Pty) Ltd

28-Mar-10 23:15

Why don't you trap for that. if your table field does not allow nulls then you cant insert a null.what you can do is to trap for that and have the reserved word that you will use if the textbox is empty.

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Re: how to insert empty values from text boxes to database

Amit Patel198528-Mar-10 23:16

Amit Patel1985

28-Mar-10 23:16

Hi,
What kind og error it is giving can you give details here..

Thanks ,
Amit Patel

Re: how to insert empty values from text boxes to database

R. Giskard Reventlov28-Mar-10 23:27

R. Giskard Reventlov

28-Mar-10 23:27

You should set a default value of 0 (zero) for the monitors, scanners and printers fields such that when you go to pass the data to the database all of the items have a valid value (zero should be a valid count for items denoting that whilst they may have 1 scanner, they have no printers or monitors).

me, me, me

"The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!"
Larry Niven

Re: how to insert empty values from text boxes to database

Arun Jacob29-Mar-10 0:10

Arun Jacob

29-Mar-10 0:10

developerit wrote:

some times customers will take only printers , so at that time the textboxes is empty so while saving and updating it is giving errors

Input string was not in a correct format

Which line of code is causing the error?Can u paste that line of code here?

Arun Jacob
http://codepronet.blogspot.com/

Re: how to insert empty values from text boxes to database

developerit29-Mar-10 2:49

developerit

29-Mar-10 2:49

printer.computer,scanner lines are giving error

Re: how to insert empty values from text boxes to database

Sneha Bisht29-Mar-10 3:04

Sneha Bisht

29-Mar-10 3:04

try this
in your table set default value of printer, scanner.. parameter is 0

or use in code
if(txt_printer=="")
{
printer =0;
}
else
{
printer =txt_printer.Text;
}

same for scanner . & .........

Re: how to insert empty values from text boxes to database

R. Giskard Reventlov29-Mar-10 3:32

R. Giskard Reventlov

29-Mar-10 3:32

If you are going to do it like that, do it this way:

int printer = (string.IsNullOrEmpty(txtPrinter.Text) ? 0 : Convert.ToInt32(txtPrinter.Text);

Apply the appropriate conversion to txtPrinter.Text.

me, me, me

"The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!"
Larry Niven

pass javascript variable to javascript function

Abdul Rahman Hamidy28-Mar-10 22:43

Abdul Rahman Hamidy

28-Mar-10 22:43

Dear All,
i have following code

function displayControlName(src,pText)
    {
        var msg2Display = document.getElementById('spMsg');
        msg2Display.innerHTML += '<input type = "button" value="'+src+'" onclick="return displayMsg(src,pText)"/><br>';
        return false;    
    }
    function displayMsg(src,pText) 
    {   
        alert(src + ' you are here');
        return false;
    }

I am looking to pass "src" and "pText" javascript variable to a function called "displayMsg", but I have tried different ways to pass the variables from first method "displayControlName" as i have tried
displayMsg(src,pText), displayMsg('+src+','+pText+') and a little more but none worked for me.

any ideas how to pass the variable name src and pText to the javascript function displayMsg from method displayControlName and I am trying to pass it in this statement onclick = "return displayMsg(src,pText)"?

Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan

Re: pass javascript variable to javascript function

Vimalsoft(Pty) Ltd28-Mar-10 23:05

Vimalsoft(Pty) Ltd

28-Mar-10 23:05

this will be the correct way

displayMsg(src,pText);

and i see you have done it but the question is that these parameters have you declared them anywhere ? show u the part you tried to execute and show us where you declare the parameters to pass to the function.

Re: pass javascript variable to javascript function

Abdul Rahman Hamidy28-Mar-10 23:17

Abdul Rahman Hamidy

28-Mar-10 23:17

those variables are as the function args and I am sending only text value to these args
as you see
the function requires two args

function displayControlName(src,pText)

and I am only printing that two variables passed to function.
here I am passing var to that function

menuLink.Attributes["onclick"] = "return displayControlName('" + item.Text + "','" + item.Parent.Text + "');";

both item.Text and item.Parent.Text are there but the

onclick="return displayMsg(src,pText);"

doesent work.

Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan

Re: pass javascript variable to javascript function

Vimalsoft(Pty) Ltd28-Mar-10 23:27

Vimalsoft(Pty) Ltd

28-Mar-10 23:27

Look at Prakash , that is exactly what you need to do. your variables are not recognized, they are treated as string.

Re: pass javascript variable to javascript function

PSK_28-Mar-10 23:19

PSK_

28-Mar-10 23:19

You are adding the input control in the spMsg control like following

msg2Display.innerHTML += '<input type = "button" value="'+src+'" onclick="return displayMsg(src,pText)"/><br>';

When the onclick event will be attached on the input button the “scr” will be unknown.

try this

 function displayControlName(src, pText) {
    var msg2Display = document.getElementById('spMsg');
    msg2Display.innerHTML += '<input type = "button" value="'
    + src + '" onclick="'
    + "return displayMsg('"
    + src + "','"
    + pText + "')"
    + '"/><br>';
    return false;
}

WWW, WCF, WWF, WPF, WFC .... WTF

Re: pass javascript variable to javascript function

Abdul Rahman Hamidy28-Mar-10 23:26

Abdul Rahman Hamidy

28-Mar-10 23:26

thanks, your print the following but no event is attached with the button
ButtonpTextValue')"/>

Button mean the HTML control button and pTextValue mean the value which is in the pText Variable
it means it prints one button control with other text in the screen while no event is attached with the button control.

Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan

Re: pass javascript variable to javascript function

PSK_29-Mar-10 0:03

PSK_

29-Mar-10 0:03

I tried to simulate this problem at my side and it worked for me, can you share some more information regarding this.

WWW, WCF, WWF, WPF, WFC .... WTF

Re: pass javascript variable to javascript function

Abdul Rahman Hamidy29-Mar-10 0:13

Abdul Rahman Hamidy

29-Mar-10 0:13

thank you very much and really thanks alot. It did work with only minor change while calling the javascript method.

Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan

allow user to manage pop3 account in our website ? [modified]

keyur satyadev28-Mar-10 21:06

keyur satyadev

28-Mar-10 21:06

hi all,

we need to integrate email client in our asp.net web application.
in which user can manage POP3 account from our web application.
i go through Google but yet not getting the exact idea that how to implement the same.

let me know if anyone have any idea or suggestion or details that how to allow user to create
his POP3 email account.

also if he specify yahoo email or gmail email then that mail also should be shown at our website.

let me know if anyone have any idea....

Regards
Keyur Satyadev

modified on Monday, March 29, 2010 2:47 AM

Re: allow user to manage pop3 account in our website ?

Arun Jacob28-Mar-10 23:52

Arun Jacob

28-Mar-10 23:52

keyur satyadev wrote:
let me know if anyone have any idea or suggestion or details that how to allow user to create
his POP3 email account.

You can start with this Article,
POP3 Client as a C# Class[^]

Arun Jacob
http://codepronet.blogspot.com/

how to develop a web page with the help of AD rotator control

sowjanya328-Mar-10 20:17

sowjanya3

28-Mar-10 20:17

Should we declare any directive or name space to use AD rotator control?

Re: how to develop a web page with the help of AD rotator control

PSK_28-Mar-10 20:33

PSK_

28-Mar-10 20:33

AdRotator class is present in System.Web.UI.WebControls namespace, by default you get this in you toolbar. To use this you don’t need to declare any directive.

You can find many online examples of AdRotator implementation in Google.

WWW, WCF, WWF, WPF, WFC .... WTF

Re: how to develop a web page with the help of AD rotator control

Gaurav Dudeja India28-Mar-10 20:47

Gaurav Dudeja India

28-Mar-10 20:47

you just simply drag n drop ad rotator control from toolbar and use it in source file no need to declare any directive

how to use form view

sowjanya328-Mar-10 20:14

sowjanya3

28-Mar-10 20:14

can we use form view control to display a image? for me neither image or AD rotator control is working

Re: how to use form view

PSK_28-Mar-10 20:26

PSK_

28-Mar-10 20:26

Form view control is basically used for defining templates for insert/edit/display of database fields, It can’t be used to display image.

WWW, WCF, WWF, WPF, WFC .... WTF

Templates

Mike65432128-Mar-10 10:09

Mike654321

28-Mar-10 10:09

sorry if this is the wrong forum to post this in...please direct me to the correct one if I'm in error

fairly new to c# asp.net web development...want to know if anyone has a couple of url links that i can go to, to download some free web site templates for c#...i don't really have a css design eye...if they are also seo friendly, that's a bonus too.

thanks

Re: Templates

Not Active28-Mar-10 10:30

Not Active

28-Mar-10 10:30

You are not really looking for a template, which would give you a set of predefined pages, operations and structure. Themes or skins are what can be used to give a look and feel to a site, usually though use of CSS.

I know the language. I've read a book. - _Madmatt

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.