stored procedure

[Yoshitha]

Hi
i've created one table and one stroed procedure to insert data into that
table.
i've created table like this

table Name=QA_QAuthor

EmailId Varchar primarykey.
Pwd varchar
Comments varchar allows null values
paypalacc varchar allows null values
rateperqueston numeric allows null values
Skills varchar
Stroed Procedure
CREATE PROCEDURE QA_Insert_QA
@email varchar(50),
@pwd varchar(50),
@comments varchar(50),
@paypal varchar(50),
@RPQ numeric,
@skills varchar(50)
AS
insert into QA_QuestionAuth ors

values(@email,@ pwd,@comments,@ paypal,

@RPQ,@skills)
GO

am calling this stroed procedure in

asp.net like this


Dim cmdQAinsert As New OleDbCommand
cmdQAinsert.Con nection = MyConn
cmdQAinsert.Tra nsaction = t
cmdQAinsert.Com mandType = commandType.Sto redProcedure
cmdQAinsert.Com mandText = "QA_Insert_ QA"

Dim comments As New OleDb.OleDbPara meter
comments.OleDbT ype = OleDbType.VarCh ar
comments.Direct ion = ParameterDirect ion.Input
comments.Value = Trim(txtComment s.Text)

Dim email1 As New OleDb.OleDbPara meter
email1.OleDbTyp e = OleDbType.VarCh ar
email1.Directio n = ParameterDirect ion.Input
email1.Value = Trim(txtEmail.T ext)

Dim pwd As New OleDb.OleDbPara meter
pwd.OleDbType = OleDbType.VarCh ar
pwd.Direction = ParameterDirect ion.Input
pwd.Value = pwdgen.pwdgen.R andomString()

Dim PayPalAcc As New OleDb.OleDbPara meter
PayPalAcc.OleDb Type = OleDbType.VarCh ar
PayPalAcc.Direc tion = ParameterDirect ion.Input
PayPalAcc.Value = Trim(txtPayPalA cc.Text)

Dim RatePerQues As New
OleDb.OleDbPara meter
RatePerQues.Ole DbType = OleDbType.VarCh ar
RatePerQues.Dir ection = ParameterDirect ion.Input
RatePerQues.Val ue =
Trim(txtRatePer Question.Text)

Dim skills As New OleDb.OleDbPara meter
skills.OleDbTyp e = OleDbType.Varia nt
skills.Directio n = ParameterDirect ion.Input
skills.Value = Trim(ddlSkills. SelectedValue)

cmdQAinsert.Par ameters.Add(ema il1)
cmdQAinsert.Par ameters.Add(pwd )
cmdQAinsert.Par ameters.Add(com ments)
cmdQAinsert.Par ameters.Add(Pay PalAcc)
cmdQAinsert.Par ameters.Add(Rat ePerQues
)
cmdQAinsert.Par ameters.Add(ski lls)
res = cmdQAinsert.Exe cuteNonQuery()
-----
----

if i entering data for all fields

then it is not giving any exception ,

the data is storing in backend table.
but when i enter data for few fields

and when am trying to run the

application then it is rising the following exception

"Input String is not in a correct format"

why am getting this error.
in the table i set allow null for 3

fields and for these 3 fields if i wont specify any data then it is giving
that exception if i specify data for these fields then am not getting any
errors.

can u tell how to solve this problem?

Thanx in advance
Yoshitha

[sara]

Hi Yoshitha
if u let say a textbox empty and in ur procedure u parse it to integer or
float or any thing other than string this execption apper
to do that make a condation that when there is null entry u pass to ur
procedure 0 for int not null
Hope this help:)

"Yoshitha" wrote:

Hi
i've created one table and one stroed procedure to insert data into that
table.
i've created table like this

table Name=QA_QAuthor

EmailId Varchar primarykey.
Pwd varchar
Comments varchar allows null values
paypalacc varchar allows null values
rateperqueston numeric allows null values
Skills varchar
Stroed Procedure
CREATE PROCEDURE QA_Insert_QA
@email varchar(50),
@pwd varchar(50),
@comments varchar(50),
@paypal varchar(50),
@RPQ numeric,
@skills varchar(50)
AS
insert into QA_QuestionAuth ors

values(@email,@ pwd,@comments,@ paypal,

@RPQ,@skills)
GO

am calling this stroed procedure in

asp.net like this


Dim cmdQAinsert As New OleDbCommand
cmdQAinsert.Con nection = MyConn
cmdQAinsert.Tra nsaction = t
cmdQAinsert.Com mandType = commandType.Sto redProcedure
cmdQAinsert.Com mandText = "QA_Insert_ QA"

Dim comments As New OleDb.OleDbPara meter
comments.OleDbT ype = OleDbType.VarCh ar
comments.Direct ion = ParameterDirect ion.Input
comments.Value = Trim(txtComment s.Text)

Dim email1 As New OleDb.OleDbPara meter
email1.OleDbTyp e = OleDbType.VarCh ar
email1.Directio n = ParameterDirect ion.Input
email1.Value = Trim(txtEmail.T ext)

Dim pwd As New OleDb.OleDbPara meter
pwd.OleDbType = OleDbType.VarCh ar
pwd.Direction = ParameterDirect ion.Input
pwd.Value = pwdgen.pwdgen.R andomString()

Dim PayPalAcc As New OleDb.OleDbPara meter
PayPalAcc.OleDb Type = OleDbType.VarCh ar
PayPalAcc.Direc tion = ParameterDirect ion.Input
PayPalAcc.Value = Trim(txtPayPalA cc.Text)

Dim RatePerQues As New
OleDb.OleDbPara meter
RatePerQues.Ole DbType = OleDbType.VarCh ar
RatePerQues.Dir ection = ParameterDirect ion.Input
RatePerQues.Val ue =
Trim(txtRatePer Question.Text)

Dim skills As New OleDb.OleDbPara meter
skills.OleDbTyp e = OleDbType.Varia nt
skills.Directio n = ParameterDirect ion.Input
skills.Value = Trim(ddlSkills. SelectedValue)

cmdQAinsert.Par ameters.Add(ema il1)
cmdQAinsert.Par ameters.Add(pwd )
cmdQAinsert.Par ameters.Add(com ments)
cmdQAinsert.Par ameters.Add(Pay PalAcc)
cmdQAinsert.Par ameters.Add(Rat ePerQues
)
cmdQAinsert.Par ameters.Add(ski lls)
res = cmdQAinsert.Exe cuteNonQuery()
-----
----

if i entering data for all fields

then it is not giving any exception ,

the data is storing in backend table.
but when i enter data for few fields

and when am trying to run the

application then it is rising the following exception

"Input String is not in a correct format"

why am getting this error.
in the table i set allow null for 3

fields and for these 3 fields if i wont specify any data then it is giving
that exception if i specify data for these fields then am not getting any
errors.

can u tell how to solve this problem?

Thanx in advance
Yoshitha