Hi,
I'm trying to execute stored procedure and I collect its parameters from
WebForm. There is an error: Error converting data type varchar to int.
What could be the problem? Thanks! Here it is the code:
private void Button2_Click(o bject sender, System.EventArg s e)
{
SqlConnection conn = new SqlConnection(" Data Source=----;Initial
Catalog=---; User ID=---; Password=----");
SqlCommand cmd = new SqlCommand("prS VOFFRDATA", conn);
cmd.CommandType = CommandType.Sto redProcedure;
cmd.Parameters. Add(new SqlParameter("@ CITY", SqlDbType.VarCh ar,20));
cmd.Parameters["@CITY"].Value = DDL4.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ DISTR", SqlDbType.VarCh ar,20));
cmd.Parameters["@DISTR"].Value = DistrTB.Text.Tr im();
cmd.Parameters. Add(new SqlParameter("@ PHONE", SqlDbType.Char, 1));
if(PhoneCB.Chec ked)
{
cmd.Parameters["@PHONE"].Value = "Y";
}
else
{
cmd.Parameters["@PHONE"].Value = "N";
}
cmd.Parameters. Add(new SqlParameter("@ FURN", SqlDbType.Char, 1));
if(FurnCB.Check ed)
{
cmd.Parameters["@FURN"].Value = "Y";
}
else
{
cmd.Parameters["@FURN"].Value = "N";
}
cmd.Parameters. Add(new SqlParameter("@ HTR", SqlDbType.Char, 1));
if(HtrCB.Checke d)
{
cmd.Parameters["@HTR"].Value = "Y";
}
else
{
cmd.Parameters["@HTR"].Value = "N";
}
cmd.Parameters. Add(new SqlParameter("@ ESTTYPEID", SqlDbType.TinyI nt));
cmd.Parameters["@ESTTYPEID "].Value = DDL2.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ TYPEOFFERID", SqlDbType.TinyI nt));
cmd.Parameters["@TYPEOFFER ID"].Value = DDL1.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ TYPECONSTRID", SqlDbType.TinyI nt));
cmd.Parameters["@TYPECONST RID"].Value = DDL3.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ USRNAM", SqlDbType.VarCh ar,20));
cmd.Parameters["@USRNAM"].Value = Session["usrName"].ToString();
cmd.Parameters. Add(new SqlParameter("@ PRICE", SqlDbType.Int)) ;
cmd.Parameters["@PRICE"].Value = PriceTB.Text.Tr im();
cmd.Parameters. Add(new SqlParameter("@ ROOMS", SqlDbType.Int)) ;
cmd.Parameters["@ROOMS"].Value = RoomsTB.Text.Tr im();
cmd.Parameters. Add(new SqlParameter("@ SqMeters", SqlDbType.Int)) ;
cmd.Parameters["@SqMeters"].Value = SQMetersTB.Text .Trim();
cmd.Parameters. Add(new SqlParameter("@ Floors", SqlDbType.Int)) ;
cmd.Parameters["@Floors"].Value = FloorsTB.Text.T rim();
cmd.Parameters. Add(new SqlParameter("@ PIC", SqlDbType.VarCh ar,55));
cmd.Parameters["@PIC"].Value = PicTB.Text.Trim ();
cmd.Parameters. Add(new SqlParameter("@ DESCR", SqlDbType.VarCh ar,255));
cmd.Parameters["@DESCR"].Value = DescrTB.Text.Tr im();
cmd.Connection. Open();
cmd.ExecuteNonQ uery();
conn.Close();
}
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ( http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a. 16  1234 
What datatype do you use in your database for the checkbox values like
phone, furn and htr?
"Viktor Popov" <vi****@yahoo.c om> wrote in message
news:Ow******** ******@TK2MSFTN GP09.phx.gbl... Hi,
I'm trying to execute stored procedure and I collect its parameters from
WebForm. There is an error: Error converting data type varchar to int.
What could be the problem? Thanks! Here it is the code:
private void Button2_Click(o bject sender, System.EventArg s e)
{
SqlConnection conn = new SqlConnection(" Data Source=----;Initial
Catalog=---; User ID=---; Password=----");
SqlCommand cmd = new SqlCommand("prS VOFFRDATA", conn);
cmd.CommandType = CommandType.Sto redProcedure;
cmd.Parameters. Add(new SqlParameter("@ CITY", SqlDbType.VarCh ar,20));
cmd.Parameters["@CITY"].Value = DDL4.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ DISTR", SqlDbType.VarCh ar,20));
cmd.Parameters["@DISTR"].Value = DistrTB.Text.Tr im();
cmd.Parameters. Add(new SqlParameter("@ PHONE", SqlDbType.Char, 1));
if(PhoneCB.Chec ked)
{
cmd.Parameters["@PHONE"].Value = "Y";
}
else
{
cmd.Parameters["@PHONE"].Value = "N";
}
cmd.Parameters. Add(new SqlParameter("@ FURN", SqlDbType.Char, 1));
if(FurnCB.Check ed)
{
cmd.Parameters["@FURN"].Value = "Y";
}
else
{
cmd.Parameters["@FURN"].Value = "N";
}
cmd.Parameters. Add(new SqlParameter("@ HTR", SqlDbType.Char, 1));
if(HtrCB.Checke d)
{
cmd.Parameters["@HTR"].Value = "Y";
}
else
{
cmd.Parameters["@HTR"].Value = "N";
}
cmd.Parameters. Add(new SqlParameter("@ ESTTYPEID", SqlDbType.TinyI nt));
cmd.Parameters["@ESTTYPEID "].Value = DDL2.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ TYPEOFFERID", SqlDbType.TinyI nt));
cmd.Parameters["@TYPEOFFER ID"].Value = DDL1.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ TYPECONSTRID", SqlDbType.TinyI nt));
cmd.Parameters["@TYPECONST RID"].Value = DDL3.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ USRNAM", SqlDbType.VarCh ar,20));
cmd.Parameters["@USRNAM"].Value = Session["usrName"].ToString();
cmd.Parameters. Add(new SqlParameter("@ PRICE", SqlDbType.Int)) ;
cmd.Parameters["@PRICE"].Value = PriceTB.Text.Tr im();
cmd.Parameters. Add(new SqlParameter("@ ROOMS", SqlDbType.Int)) ;
cmd.Parameters["@ROOMS"].Value = RoomsTB.Text.Tr im();
cmd.Parameters. Add(new SqlParameter("@ SqMeters", SqlDbType.Int)) ;
cmd.Parameters["@SqMeters"].Value = SQMetersTB.Text .Trim();
cmd.Parameters. Add(new SqlParameter("@ Floors", SqlDbType.Int)) ;
cmd.Parameters["@Floors"].Value = FloorsTB.Text.T rim();
cmd.Parameters. Add(new SqlParameter("@ PIC", SqlDbType.VarCh ar,55));
cmd.Parameters["@PIC"].Value = PicTB.Text.Trim ();
cmd.Parameters. Add(new SqlParameter("@ DESCR", SqlDbType.VarCh ar,255));
cmd.Parameters["@DESCR"].Value = DescrTB.Text.Tr im();
cmd.Connection. Open();
cmd.ExecuteNonQ uery();
conn.Close();
}
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.
Hi,
Thanks for the reply!
I use :
EstPhone CHAR(1) NOT NULL CHECK(EstPhone IN('Y','N')),
EstFurn CHAR(1) NOT NULL CHECK(EstFurn IN('Y','N')),
EstHeating CHAR(1) NOT NULL CHECK(EstHeatin g IN('Y','N')),
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ( http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.
I see at places you have used the parameter's datatype SqlDbType.Int. But
when you are putting the value you say
cmd.Parameter["ParamName"].Value = txtSomething.Te xt.Trim();
instead try
Convert.ToInt32 (txtSomething.T ext.Trim());
Thanks.
Dharmesh
"Viktor Popov" <vi****@yahoo.c om> wrote in message
news:up******** ******@TK2MSFTN GP12.phx.gbl... Hi,
Thanks for the reply!
I use :
EstPhone CHAR(1) NOT NULL CHECK(EstPhone IN('Y','N')),
EstFurn CHAR(1) NOT NULL CHECK(EstFurn IN('Y','N')),
EstHeating CHAR(1) NOT NULL CHECK(EstHeatin g IN('Y','N')),
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.
Is there a reason that your dropdownlist value is being returned as a tiny
int? Isn't a dropdownlist value a string/varchar?
your code:
cmd.Parameters. Add(new SqlParameter("@ ESTTYPEID", SqlDbType.TinyI nt));
cmd.Parameters["@ESTTYPEID "].Value = DDL2.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ TYPEOFFERID", SqlDbType.TinyI nt));
cmd.Parameters["@TYPEOFFER ID"].Value = DDL1.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ TYPECONSTRID", SqlDbType.TinyI nt));
"Viktor Popov" <vi****@yahoo.c om> wrote in message
news:Ow******** ******@TK2MSFTN GP09.phx.gbl... Hi,
I'm trying to execute stored procedure and I collect its parameters from
WebForm. There is an error: Error converting data type varchar to int.
What could be the problem? Thanks! Here it is the code:
private void Button2_Click(o bject sender, System.EventArg s e)
{
SqlConnection conn = new SqlConnection(" Data Source=----;Initial
Catalog=---; User ID=---; Password=----");
SqlCommand cmd = new SqlCommand("prS VOFFRDATA", conn);
cmd.CommandType = CommandType.Sto redProcedure;
cmd.Parameters. Add(new SqlParameter("@ CITY", SqlDbType.VarCh ar,20));
cmd.Parameters["@CITY"].Value = DDL4.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ DISTR", SqlDbType.VarCh ar,20));
cmd.Parameters["@DISTR"].Value = DistrTB.Text.Tr im();
cmd.Parameters. Add(new SqlParameter("@ PHONE", SqlDbType.Char, 1));
if(PhoneCB.Chec ked)
{
cmd.Parameters["@PHONE"].Value = "Y";
}
else
{
cmd.Parameters["@PHONE"].Value = "N";
}
cmd.Parameters. Add(new SqlParameter("@ FURN", SqlDbType.Char, 1));
if(FurnCB.Check ed)
{
cmd.Parameters["@FURN"].Value = "Y";
}
else
{
cmd.Parameters["@FURN"].Value = "N";
}
cmd.Parameters. Add(new SqlParameter("@ HTR", SqlDbType.Char, 1));
if(HtrCB.Checke d)
{
cmd.Parameters["@HTR"].Value = "Y";
}
else
{
cmd.Parameters["@HTR"].Value = "N";
}
cmd.Parameters. Add(new SqlParameter("@ ESTTYPEID", SqlDbType.TinyI nt));
cmd.Parameters["@ESTTYPEID "].Value = DDL2.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ TYPEOFFERID", SqlDbType.TinyI nt));
cmd.Parameters["@TYPEOFFER ID"].Value = DDL1.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ TYPECONSTRID", SqlDbType.TinyI nt));
cmd.Parameters["@TYPECONST RID"].Value = DDL3.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ USRNAM", SqlDbType.VarCh ar,20));
cmd.Parameters["@USRNAM"].Value = Session["usrName"].ToString();
cmd.Parameters. Add(new SqlParameter("@ PRICE", SqlDbType.Int)) ;
cmd.Parameters["@PRICE"].Value = PriceTB.Text.Tr im();
cmd.Parameters. Add(new SqlParameter("@ ROOMS", SqlDbType.Int)) ;
cmd.Parameters["@ROOMS"].Value = RoomsTB.Text.Tr im();
cmd.Parameters. Add(new SqlParameter("@ SqMeters", SqlDbType.Int)) ;
cmd.Parameters["@SqMeters"].Value = SQMetersTB.Text .Trim();
cmd.Parameters. Add(new SqlParameter("@ Floors", SqlDbType.Int)) ;
cmd.Parameters["@Floors"].Value = FloorsTB.Text.T rim();
cmd.Parameters. Add(new SqlParameter("@ PIC", SqlDbType.VarCh ar,55));
cmd.Parameters["@PIC"].Value = PicTB.Text.Trim ();
cmd.Parameters. Add(new SqlParameter("@ DESCR", SqlDbType.VarCh ar,255));
cmd.Parameters["@DESCR"].Value = DescrTB.Text.Tr im();
cmd.Connection. Open();
cmd.ExecuteNonQ uery();
conn.Close();
}
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.
Hi again,
I use tinyint because I input these values as a tinyint in the tables.
I have table:
Est_Type
=============== =
EstTypeId EstType
1 house
2 apartment
3 farm
...............
So I'd like to take from the DropDownList the Value which is EstTypeID Not
the Text and then input it in the table using the stored procedure..
"Reva Baum" <re**@revaws.ny c.gerbercapital .com> wrote in message
news:eE******** ******@TK2MSFTN GP09.phx.gbl... Is there a reason that your dropdownlist value is being returned as a tiny
int? Isn't a dropdownlist value a string/varchar?
your code:
cmd.Parameters. Add(new SqlParameter("@ ESTTYPEID", SqlDbType.TinyI nt));
cmd.Parameters["@ESTTYPEID "].Value = DDL2.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ TYPEOFFERID", SqlDbType.TinyI nt));
cmd.Parameters["@TYPEOFFER ID"].Value = DDL1.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ TYPECONSTRID", SqlDbType.TinyI nt));
"Viktor Popov" <vi****@yahoo.c om> wrote in message
news:Ow******** ******@TK2MSFTN GP09.phx.gbl... Hi,
I'm trying to execute stored procedure and I collect its parameters from
WebForm. There is an error: Error converting data type varchar to int.
What could be the problem? Thanks! Here it is the code:
private void Button2_Click(o bject sender, System.EventArg s e)
{
SqlConnection conn = new SqlConnection(" Data Source=----;Initial
Catalog=---; User ID=---; Password=----");
SqlCommand cmd = new SqlCommand("prS VOFFRDATA", conn);
cmd.CommandType = CommandType.Sto redProcedure;
cmd.Parameters. Add(new SqlParameter("@ CITY", SqlDbType.VarCh ar,20));
cmd.Parameters["@CITY"].Value = DDL4.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ DISTR", SqlDbType.VarCh ar,20));
cmd.Parameters["@DISTR"].Value = DistrTB.Text.Tr im();
cmd.Parameters. Add(new SqlParameter("@ PHONE", SqlDbType.Char, 1));
if(PhoneCB.Chec ked)
{
cmd.Parameters["@PHONE"].Value = "Y";
}
else
{
cmd.Parameters["@PHONE"].Value = "N";
}
cmd.Parameters. Add(new SqlParameter("@ FURN", SqlDbType.Char, 1));
if(FurnCB.Check ed)
{
cmd.Parameters["@FURN"].Value = "Y";
}
else
{
cmd.Parameters["@FURN"].Value = "N";
}
cmd.Parameters. Add(new SqlParameter("@ HTR", SqlDbType.Char, 1));
if(HtrCB.Checke d)
{
cmd.Parameters["@HTR"].Value = "Y";
}
else
{
cmd.Parameters["@HTR"].Value = "N";
}
cmd.Parameters. Add(new SqlParameter("@ ESTTYPEID", SqlDbType.TinyI nt));
cmd.Parameters["@ESTTYPEID "].Value = DDL2.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ TYPEOFFERID", SqlDbType.TinyI nt));
cmd.Parameters["@TYPEOFFER ID"].Value = DDL1.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ TYPECONSTRID",
SqlDbType.TinyI nt)); cmd.Parameters["@TYPECONST RID"].Value = DDL3.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ USRNAM", SqlDbType.VarCh ar,20));
cmd.Parameters["@USRNAM"].Value = Session["usrName"].ToString();
cmd.Parameters. Add(new SqlParameter("@ PRICE", SqlDbType.Int)) ;
cmd.Parameters["@PRICE"].Value = PriceTB.Text.Tr im();
cmd.Parameters. Add(new SqlParameter("@ ROOMS", SqlDbType.Int)) ;
cmd.Parameters["@ROOMS"].Value = RoomsTB.Text.Tr im();
cmd.Parameters. Add(new SqlParameter("@ SqMeters", SqlDbType.Int)) ;
cmd.Parameters["@SqMeters"].Value = SQMetersTB.Text .Trim();
cmd.Parameters. Add(new SqlParameter("@ Floors", SqlDbType.Int)) ;
cmd.Parameters["@Floors"].Value = FloorsTB.Text.T rim();
cmd.Parameters. Add(new SqlParameter("@ PIC", SqlDbType.VarCh ar,55));
cmd.Parameters["@PIC"].Value = PicTB.Text.Trim ();
cmd.Parameters. Add(new SqlParameter("@ DESCR", SqlDbType.VarCh ar,255));
cmd.Parameters["@DESCR"].Value = DescrTB.Text.Tr im();
cmd.Connection. Open();
cmd.ExecuteNonQ uery();
conn.Close();
}
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ( http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.
I have corrected that but the error is the same
Thanks
"Dharmesh" <dh******@atlas soft.com> wrote in message
news:uH******** ******@TK2MSFTN GP12.phx.gbl... I see at places you have used the parameter's datatype SqlDbType.Int. But
when you are putting the value you say
cmd.Parameter["ParamName"].Value = txtSomething.Te xt.Trim();
instead try
Convert.ToInt32 (txtSomething.T ext.Trim());
Thanks.
Dharmesh
"Viktor Popov" <vi****@yahoo.c om> wrote in message
news:up******** ******@TK2MSFTN GP12.phx.gbl... Hi,
Thanks for the reply!
I use :
EstPhone CHAR(1) NOT NULL CHECK(EstPhone IN('Y','N')),
EstFurn CHAR(1) NOT NULL CHECK(EstFurn IN('Y','N')),
EstHeating CHAR(1) NOT NULL CHECK(EstHeatin g IN('Y','N')),
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ( http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.
hi,
I think that even though there are numbers in the dropdownlist, you still
need to cast the values to an int.
something like this:
cmd.Parameters["@TYPEOFFER ID"].Value = ctype(ddl1.sele cteditem.value,
integer)
or you can use the index of the selected value:
cmd.Parameters["@TYPEOFFER ID"].Value = ddl1.selectedin dex + 1 ' +1
because it starts at 0
"Viktor Popov" <vi****@yahoo.c om> wrote in message
news:ON******** ******@TK2MSFTN GP11.phx.gbl... Hi again,
I use tinyint because I input these values as a tinyint in the tables.
I have table:
Est_Type
=============== =
EstTypeId EstType
1 house
2 apartment
3 farm
..............
So I'd like to take from the DropDownList the Value which is EstTypeID
Not the Text and then input it in the table using the stored procedure..
"Reva Baum" <re**@revaws.ny c.gerbercapital .com> wrote in message
news:eE******** ******@TK2MSFTN GP09.phx.gbl... Is there a reason that your dropdownlist value is being returned as a
tiny int? Isn't a dropdownlist value a string/varchar?
your code:
cmd.Parameters. Add(new SqlParameter("@ ESTTYPEID", SqlDbType.TinyI nt));
cmd.Parameters["@ESTTYPEID "].Value = DDL2.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ TYPEOFFERID", SqlDbType.TinyI nt));
cmd.Parameters["@TYPEOFFER ID"].Value = DDL1.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ TYPECONSTRID",
SqlDbType.TinyI nt));
"Viktor Popov" <vi****@yahoo.c om> wrote in message
news:Ow******** ******@TK2MSFTN GP09.phx.gbl... Hi,
I'm trying to execute stored procedure and I collect its parameters
from WebForm. There is an error: Error converting data type varchar to int.
What could be the problem? Thanks! Here it is the code:
private void Button2_Click(o bject sender, System.EventArg s e)
{
SqlConnection conn = new SqlConnection(" Data Source=----;Initial
Catalog=---; User ID=---; Password=----");
SqlCommand cmd = new SqlCommand("prS VOFFRDATA", conn);
cmd.CommandType = CommandType.Sto redProcedure;
cmd.Parameters. Add(new SqlParameter("@ CITY", SqlDbType.VarCh ar,20));
cmd.Parameters["@CITY"].Value = DDL4.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ DISTR", SqlDbType.VarCh ar,20));
cmd.Parameters["@DISTR"].Value = DistrTB.Text.Tr im();
cmd.Parameters. Add(new SqlParameter("@ PHONE", SqlDbType.Char, 1));
if(PhoneCB.Chec ked)
{
cmd.Parameters["@PHONE"].Value = "Y";
}
else
{
cmd.Parameters["@PHONE"].Value = "N";
}
cmd.Parameters. Add(new SqlParameter("@ FURN", SqlDbType.Char, 1));
if(FurnCB.Check ed)
{
cmd.Parameters["@FURN"].Value = "Y";
}
else
{
cmd.Parameters["@FURN"].Value = "N";
}
cmd.Parameters. Add(new SqlParameter("@ HTR", SqlDbType.Char, 1));
if(HtrCB.Checke d)
{
cmd.Parameters["@HTR"].Value = "Y";
}
else
{
cmd.Parameters["@HTR"].Value = "N";
}
cmd.Parameters. Add(new SqlParameter("@ ESTTYPEID", SqlDbType.TinyI nt));
cmd.Parameters["@ESTTYPEID "].Value = DDL2.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ TYPEOFFERID",
SqlDbType.TinyI nt)); cmd.Parameters["@TYPEOFFER ID"].Value = DDL1.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ TYPECONSTRID",
SqlDbType.TinyI nt)); cmd.Parameters["@TYPECONST RID"].Value = DDL3.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ USRNAM", SqlDbType.VarCh ar,20));
cmd.Parameters["@USRNAM"].Value = Session["usrName"].ToString();
cmd.Parameters. Add(new SqlParameter("@ PRICE", SqlDbType.Int)) ;
cmd.Parameters["@PRICE"].Value = PriceTB.Text.Tr im();
cmd.Parameters. Add(new SqlParameter("@ ROOMS", SqlDbType.Int)) ;
cmd.Parameters["@ROOMS"].Value = RoomsTB.Text.Tr im();
cmd.Parameters. Add(new SqlParameter("@ SqMeters", SqlDbType.Int)) ;
cmd.Parameters["@SqMeters"].Value = SQMetersTB.Text .Trim();
cmd.Parameters. Add(new SqlParameter("@ Floors", SqlDbType.Int)) ;
cmd.Parameters["@Floors"].Value = FloorsTB.Text.T rim();
cmd.Parameters. Add(new SqlParameter("@ PIC", SqlDbType.VarCh ar,55));
cmd.Parameters["@PIC"].Value = PicTB.Text.Trim ();
cmd.Parameters. Add(new SqlParameter("@ DESCR", SqlDbType.VarCh ar,255));
cmd.Parameters["@DESCR"].Value = DescrTB.Text.Tr im();
cmd.Connection. Open();
cmd.ExecuteNonQ uery();
conn.Close();
}
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.
Actually - I just tried it out, and you're right. You don't need to cast it
into an integer. Sorry.
"Reva Baum" <re**@revaws.ny c.gerbercapital .com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. .. hi,
I think that even though there are numbers in the dropdownlist, you still
need to cast the values to an int.
something like this:
cmd.Parameters["@TYPEOFFER ID"].Value = ctype(ddl1.sele cteditem.value,
integer)
or you can use the index of the selected value:
cmd.Parameters["@TYPEOFFER ID"].Value = ddl1.selectedin dex + 1 ' +1
because it starts at 0
"Viktor Popov" <vi****@yahoo.c om> wrote in message
news:ON******** ******@TK2MSFTN GP11.phx.gbl... Hi again,
I use tinyint because I input these values as a tinyint in the tables.
I have table:
Est_Type
=============== =
EstTypeId EstType
1 house
2 apartment
3 farm
..............
So I'd like to take from the DropDownList the Value which is EstTypeID
Not the Text and then input it in the table using the stored procedure..
"Reva Baum" <re**@revaws.ny c.gerbercapital .com> wrote in message
news:eE******** ******@TK2MSFTN GP09.phx.gbl... Is there a reason that your dropdownlist value is being returned as a tiny int? Isn't a dropdownlist value a string/varchar?
your code:
cmd.Parameters. Add(new SqlParameter("@ ESTTYPEID", SqlDbType.TinyI nt));
cmd.Parameters["@ESTTYPEID "].Value = DDL2.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ TYPEOFFERID",
SqlDbType.TinyI nt)); cmd.Parameters["@TYPEOFFER ID"].Value = DDL1.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ TYPECONSTRID", SqlDbType.TinyI nt));
"Viktor Popov" <vi****@yahoo.c om> wrote in message
news:Ow******** ******@TK2MSFTN GP09.phx.gbl...
> Hi,
> I'm trying to execute stored procedure and I collect its parameters from > WebForm. There is an error: Error converting data type varchar to
int. >
>
>
> What could be the problem? Thanks! Here it is the code:
>
> private void Button2_Click(o bject sender, System.EventArg s e)
> {
> SqlConnection conn = new SqlConnection(" Data Source=----;Initial
> Catalog=---; User ID=---; Password=----");
> SqlCommand cmd = new SqlCommand("prS VOFFRDATA", conn);
> cmd.CommandType = CommandType.Sto redProcedure;
> cmd.Parameters. Add(new SqlParameter("@ CITY", SqlDbType.VarCh ar,20));
> cmd.Parameters["@CITY"].Value = DDL4.SelectedIt em.Value;
> cmd.Parameters. Add(new SqlParameter("@ DISTR",
SqlDbType.VarCh ar,20)); > cmd.Parameters["@DISTR"].Value = DistrTB.Text.Tr im();
> cmd.Parameters. Add(new SqlParameter("@ PHONE", SqlDbType.Char, 1));
> if(PhoneCB.Chec ked)
> {
> cmd.Parameters["@PHONE"].Value = "Y";
> }
> else
> {
> cmd.Parameters["@PHONE"].Value = "N";
> }
> cmd.Parameters. Add(new SqlParameter("@ FURN", SqlDbType.Char, 1));
> if(FurnCB.Check ed)
> {
> cmd.Parameters["@FURN"].Value = "Y";
> }
> else
> {
> cmd.Parameters["@FURN"].Value = "N";
> }
> cmd.Parameters. Add(new SqlParameter("@ HTR", SqlDbType.Char, 1));
> if(HtrCB.Checke d)
> {
> cmd.Parameters["@HTR"].Value = "Y";
> }
> else
> {
> cmd.Parameters["@HTR"].Value = "N";
> }
> cmd.Parameters. Add(new SqlParameter("@ ESTTYPEID",
SqlDbType.TinyI nt)); > cmd.Parameters["@ESTTYPEID "].Value = DDL2.SelectedIt em.Value;
> cmd.Parameters. Add(new SqlParameter("@ TYPEOFFERID", SqlDbType.TinyI nt)); > cmd.Parameters["@TYPEOFFER ID"].Value = DDL1.SelectedIt em.Value;
> cmd.Parameters. Add(new SqlParameter("@ TYPECONSTRID",
SqlDbType.TinyI nt)); > cmd.Parameters["@TYPECONST RID"].Value = DDL3.SelectedIt em.Value;
> cmd.Parameters. Add(new SqlParameter("@ USRNAM",
SqlDbType.VarCh ar,20)); > cmd.Parameters["@USRNAM"].Value = Session["usrName"].ToString();
> cmd.Parameters. Add(new SqlParameter("@ PRICE", SqlDbType.Int)) ;
> cmd.Parameters["@PRICE"].Value = PriceTB.Text.Tr im();
> cmd.Parameters. Add(new SqlParameter("@ ROOMS", SqlDbType.Int)) ;
> cmd.Parameters["@ROOMS"].Value = RoomsTB.Text.Tr im();
> cmd.Parameters. Add(new SqlParameter("@ SqMeters", SqlDbType.Int)) ;
> cmd.Parameters["@SqMeters"].Value = SQMetersTB.Text .Trim();
> cmd.Parameters. Add(new SqlParameter("@ Floors", SqlDbType.Int)) ;
> cmd.Parameters["@Floors"].Value = FloorsTB.Text.T rim();
> cmd.Parameters. Add(new SqlParameter("@ PIC", SqlDbType.VarCh ar,55));
> cmd.Parameters["@PIC"].Value = PicTB.Text.Trim ();
> cmd.Parameters. Add(new SqlParameter("@ DESCR",
SqlDbType.VarCh ar,255)); > cmd.Parameters["@DESCR"].Value = DescrTB.Text.Tr im();
> cmd.Connection. Open();
> cmd.ExecuteNonQ uery();
> conn.Close();
> }
>
>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.
>
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.
Actually - I just tried it out, and you're right. You don't need to cast it
into an integer. Sorry.
"Reva Baum" <re**@revaws.ny c.gerbercapital .com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. .. hi,
I think that even though there are numbers in the dropdownlist, you still
need to cast the values to an int.
something like this:
cmd.Parameters["@TYPEOFFER ID"].Value = ctype(ddl1.sele cteditem.value,
integer)
or you can use the index of the selected value:
cmd.Parameters["@TYPEOFFER ID"].Value = ddl1.selectedin dex + 1 ' +1
because it starts at 0
"Viktor Popov" <vi****@yahoo.c om> wrote in message
news:ON******** ******@TK2MSFTN GP11.phx.gbl... Hi again,
I use tinyint because I input these values as a tinyint in the tables.
I have table:
Est_Type
=============== =
EstTypeId EstType
1 house
2 apartment
3 farm
..............
So I'd like to take from the DropDownList the Value which is EstTypeID
Not the Text and then input it in the table using the stored procedure..
"Reva Baum" <re**@revaws.ny c.gerbercapital .com> wrote in message
news:eE******** ******@TK2MSFTN GP09.phx.gbl... Is there a reason that your dropdownlist value is being returned as a tiny int? Isn't a dropdownlist value a string/varchar?
your code:
cmd.Parameters. Add(new SqlParameter("@ ESTTYPEID", SqlDbType.TinyI nt));
cmd.Parameters["@ESTTYPEID "].Value = DDL2.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ TYPEOFFERID",
SqlDbType.TinyI nt)); cmd.Parameters["@TYPEOFFER ID"].Value = DDL1.SelectedIt em.Value;
cmd.Parameters. Add(new SqlParameter("@ TYPECONSTRID", SqlDbType.TinyI nt));
"Viktor Popov" <vi****@yahoo.c om> wrote in message
news:Ow******** ******@TK2MSFTN GP09.phx.gbl...
> Hi,
> I'm trying to execute stored procedure and I collect its parameters from > WebForm. There is an error: Error converting data type varchar to
int. >
>
>
> What could be the problem? Thanks! Here it is the code:
>
> private void Button2_Click(o bject sender, System.EventArg s e)
> {
> SqlConnection conn = new SqlConnection(" Data Source=----;Initial
> Catalog=---; User ID=---; Password=----");
> SqlCommand cmd = new SqlCommand("prS VOFFRDATA", conn);
> cmd.CommandType = CommandType.Sto redProcedure;
> cmd.Parameters. Add(new SqlParameter("@ CITY", SqlDbType.VarCh ar,20));
> cmd.Parameters["@CITY"].Value = DDL4.SelectedIt em.Value;
> cmd.Parameters. Add(new SqlParameter("@ DISTR",
SqlDbType.VarCh ar,20)); > cmd.Parameters["@DISTR"].Value = DistrTB.Text.Tr im();
> cmd.Parameters. Add(new SqlParameter("@ PHONE", SqlDbType.Char, 1));
> if(PhoneCB.Chec ked)
> {
> cmd.Parameters["@PHONE"].Value = "Y";
> }
> else
> {
> cmd.Parameters["@PHONE"].Value = "N";
> }
> cmd.Parameters. Add(new SqlParameter("@ FURN", SqlDbType.Char, 1));
> if(FurnCB.Check ed)
> {
> cmd.Parameters["@FURN"].Value = "Y";
> }
> else
> {
> cmd.Parameters["@FURN"].Value = "N";
> }
> cmd.Parameters. Add(new SqlParameter("@ HTR", SqlDbType.Char, 1));
> if(HtrCB.Checke d)
> {
> cmd.Parameters["@HTR"].Value = "Y";
> }
> else
> {
> cmd.Parameters["@HTR"].Value = "N";
> }
> cmd.Parameters. Add(new SqlParameter("@ ESTTYPEID",
SqlDbType.TinyI nt)); > cmd.Parameters["@ESTTYPEID "].Value = DDL2.SelectedIt em.Value;
> cmd.Parameters. Add(new SqlParameter("@ TYPEOFFERID", SqlDbType.TinyI nt)); > cmd.Parameters["@TYPEOFFER ID"].Value = DDL1.SelectedIt em.Value;
> cmd.Parameters. Add(new SqlParameter("@ TYPECONSTRID",
SqlDbType.TinyI nt)); > cmd.Parameters["@TYPECONST RID"].Value = DDL3.SelectedIt em.Value;
> cmd.Parameters. Add(new SqlParameter("@ USRNAM",
SqlDbType.VarCh ar,20)); > cmd.Parameters["@USRNAM"].Value = Session["usrName"].ToString();
> cmd.Parameters. Add(new SqlParameter("@ PRICE", SqlDbType.Int)) ;
> cmd.Parameters["@PRICE"].Value = PriceTB.Text.Tr im();
> cmd.Parameters. Add(new SqlParameter("@ ROOMS", SqlDbType.Int)) ;
> cmd.Parameters["@ROOMS"].Value = RoomsTB.Text.Tr im();
> cmd.Parameters. Add(new SqlParameter("@ SqMeters", SqlDbType.Int)) ;
> cmd.Parameters["@SqMeters"].Value = SQMetersTB.Text .Trim();
> cmd.Parameters. Add(new SqlParameter("@ Floors", SqlDbType.Int)) ;
> cmd.Parameters["@Floors"].Value = FloorsTB.Text.T rim();
> cmd.Parameters. Add(new SqlParameter("@ PIC", SqlDbType.VarCh ar,55));
> cmd.Parameters["@PIC"].Value = PicTB.Text.Trim ();
> cmd.Parameters. Add(new SqlParameter("@ DESCR",
SqlDbType.VarCh ar,255)); > cmd.Parameters["@DESCR"].Value = DescrTB.Text.Tr im();
> cmd.Connection. Open();
> cmd.ExecuteNonQ uery();
> conn.Close();
> }
>
>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.
>
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.729 / Virus Database: 484 - Release Date: 27.7.2004 a.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Thelma Lubkin |
last post by:
I use code extensively; I probably overuse it. But I've been using
error trapping very sparingly, and now I've been trapped by that.
A form that works for me on the system I'm using, apparently runs into
problems on the system where it will actually be used, and since I
used so little error-trapping it dies very ungracefully.
I will of course try to fix whatever is causing the error and add
error-trapping to the functions where the...
|
by: wana |
last post by:
I was reading through original source code of ping for some insight
and was confused by unusual code.
Entire listing available at:
http://www.ping127001.com/pingpage/ping.html
#include #include #include
#include #include #include #include
#include #include #include #include #include
|
by: __frank__ |
last post by:
The following code use a macro and a label.
I would to change it and use instead
a more readable function and avoid the label.
The macro DAQmxFailed checks for the return code
of the various functions:
DAQmxCreateTask()
DAQmxStartTask()
DAQmxReadAnalogScalarF64()
|
by: Aaron Queenan |
last post by:
When I build a C++ library to .NET using the managed C++ compiler, I get the
following error message:
Linking...
LINK : error LNK2020: unresolved token (0A000005) _CrtDbgReport
LINK : error LNK2020: unresolved token (0A000007) memset
LINK : error LNK2020: unresolved token (0A000008) free
LINK : error LNK2020: unresolved token (0A00000A) atexit
LINK : error LNK2020: unresolved token (0A000028) wcscpy
LINK : error LNK2020: unresolved...
|
by: mike_li |
last post by:
On Window 2000 Professional Server
DB2 UDB
Level:
DB2 code release "SQL07029" with level identifie
"030A0105" and informational tokens "DB2 v7.1.0.98", "n040510" and
"WR21337".
In the db2diag.log,
----------------------------------------------------
2005-12-20-10.05.43.278000 Instance:MC Node:000
| | |
by: dbuchanan |
last post by:
Hello,
>From time to time my vb2005 form disappears and is replaced by the
following errors. Rebuilding the application never helps. However the
errors never affects the operation of my application that I notice, but
it is very anoying.
To get rid of the errors I must close the form, close the application
and then reopen it.
|
by: Jens Jensen |
last post by:
Hello all,
I need some design advice for my web service.
I' have written a web service that exposes a function that takes some
parameters
and return an xml.
|
by: Pool |
last post by:
I tried to connect DB2 (Sitting in Unix server at my client location) using Db2 connect V8. I am getting the following error message. I tried all the possible options BUt the error is same.. See each type belpw
Standard connection failed.
|
by: walve_wei |
last post by:
<1>use the D3D control panel, enable the debug DLL and maximum
validation,for D3D control panel ,you need to install the directx sdk.
<2>Start up the debug monitor (<MSVC install directory>\Common7\Tools
\Bin\winnt\Dbmon.Exe).
<3>If you use the tooltip in native code,then run the program,show the
tooltip,then exit the program,
the Dbmon.exe will report serious direct3d9 memleak in xp and vista
os.but If I use the wpf tooltip in c#,it is...
|
by: sanctus |
last post by:
I have a Matlab code which works fine in windows. Now I installed Xubuntu (because this way I have admin rights(=root) which I don't have on windows) and want to use the same code.
To be able to use the C-code you have to compile it from Matlab comand line with the comand mex myfile.c where before with mex -setup you define which compiler to use, the only choice I had was gcc (version 4.something).
Now if I compile I get the following...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
