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(object sender, System.EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source=----;Initial
Catalog=---; User ID=---; Password=----");
SqlCommand cmd = new SqlCommand("prSVOFFRDATA", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@CITY", SqlDbType.VarChar,20));
cmd.Parameters["@CITY"].Value = DDL4.SelectedItem.Value;
cmd.Parameters.Add(new SqlParameter("@DISTR", SqlDbType.VarChar,20));
cmd.Parameters["@DISTR"].Value = DistrTB.Text.Trim();
cmd.Parameters.Add(new SqlParameter("@PHONE", SqlDbType.Char,1));
if(PhoneCB.Checked)
{
cmd.Parameters["@PHONE"].Value = "Y";
}
else
{
cmd.Parameters["@PHONE"].Value = "N";
}
cmd.Parameters.Add(new SqlParameter("@FURN", SqlDbType.Char,1));
if(FurnCB.Checked)
{
cmd.Parameters["@FURN"].Value = "Y";
}
else
{
cmd.Parameters["@FURN"].Value = "N";
}
cmd.Parameters.Add(new SqlParameter("@HTR", SqlDbType.Char,1));
if(HtrCB.Checked)
{
cmd.Parameters["@HTR"].Value = "Y";
}
else
{
cmd.Parameters["@HTR"].Value = "N";
}
cmd.Parameters.Add(new SqlParameter("@ESTTYPEID", SqlDbType.TinyInt));
cmd.Parameters["@ESTTYPEID"].Value = DDL2.SelectedItem.Value;
cmd.Parameters.Add(new SqlParameter("@TYPEOFFERID", SqlDbType.TinyInt));
cmd.Parameters["@TYPEOFFERID"].Value = DDL1.SelectedItem.Value;
cmd.Parameters.Add(new SqlParameter("@TYPECONSTRID", SqlDbType.TinyInt));
cmd.Parameters["@TYPECONSTRID"].Value = DDL3.SelectedItem.Value;
cmd.Parameters.Add(new SqlParameter("@USRNAM", SqlDbType.VarChar,20));
cmd.Parameters["@USRNAM"].Value = Session["usrName"].ToString();
cmd.Parameters.Add(new SqlParameter("@PRICE", SqlDbType.Int));
cmd.Parameters["@PRICE"].Value = PriceTB.Text.Trim();
cmd.Parameters.Add(new SqlParameter("@ROOMS", SqlDbType.Int));
cmd.Parameters["@ROOMS"].Value = RoomsTB.Text.Trim();
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.Trim();
cmd.Parameters.Add(new SqlParameter("@PIC", SqlDbType.VarChar,55));
cmd.Parameters["@PIC"].Value = PicTB.Text.Trim();
cmd.Parameters.Add(new SqlParameter("@DESCR", SqlDbType.VarChar,255));
cmd.Parameters["@DESCR"].Value = DescrTB.Text.Trim();
cmd.Connection.Open();
cmd.ExecuteNonQuery();
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 1219
What datatype do you use in your database for the checkbox values like
phone, furn and htr?
"Viktor Popov" <vi****@yahoo.com> wrote in message
news:Ow**************@TK2MSFTNGP09.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(object sender, System.EventArgs e) { SqlConnection conn = new SqlConnection("Data Source=----;Initial Catalog=---; User ID=---; Password=----"); SqlCommand cmd = new SqlCommand("prSVOFFRDATA", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@CITY", SqlDbType.VarChar,20)); cmd.Parameters["@CITY"].Value = DDL4.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@DISTR", SqlDbType.VarChar,20)); cmd.Parameters["@DISTR"].Value = DistrTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@PHONE", SqlDbType.Char,1)); if(PhoneCB.Checked) { cmd.Parameters["@PHONE"].Value = "Y"; } else { cmd.Parameters["@PHONE"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@FURN", SqlDbType.Char,1)); if(FurnCB.Checked) { cmd.Parameters["@FURN"].Value = "Y"; } else { cmd.Parameters["@FURN"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@HTR", SqlDbType.Char,1)); if(HtrCB.Checked) { cmd.Parameters["@HTR"].Value = "Y"; } else { cmd.Parameters["@HTR"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@ESTTYPEID", SqlDbType.TinyInt)); cmd.Parameters["@ESTTYPEID"].Value = DDL2.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPEOFFERID", SqlDbType.TinyInt)); cmd.Parameters["@TYPEOFFERID"].Value = DDL1.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPECONSTRID", SqlDbType.TinyInt)); cmd.Parameters["@TYPECONSTRID"].Value = DDL3.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@USRNAM", SqlDbType.VarChar,20)); cmd.Parameters["@USRNAM"].Value = Session["usrName"].ToString(); cmd.Parameters.Add(new SqlParameter("@PRICE", SqlDbType.Int)); cmd.Parameters["@PRICE"].Value = PriceTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@ROOMS", SqlDbType.Int)); cmd.Parameters["@ROOMS"].Value = RoomsTB.Text.Trim(); 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.Trim(); cmd.Parameters.Add(new SqlParameter("@PIC", SqlDbType.VarChar,55)); cmd.Parameters["@PIC"].Value = PicTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@DESCR", SqlDbType.VarChar,255)); cmd.Parameters["@DESCR"].Value = DescrTB.Text.Trim(); cmd.Connection.Open(); cmd.ExecuteNonQuery(); 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(EstHeating 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.Text.Trim();
instead try
Convert.ToInt32(txtSomething.Text.Trim());
Thanks.
Dharmesh
"Viktor Popov" <vi****@yahoo.com> wrote in message
news:up**************@TK2MSFTNGP12.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(EstHeating 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.TinyInt));
cmd.Parameters["@ESTTYPEID"].Value = DDL2.SelectedItem.Value;
cmd.Parameters.Add(new SqlParameter("@TYPEOFFERID", SqlDbType.TinyInt));
cmd.Parameters["@TYPEOFFERID"].Value = DDL1.SelectedItem.Value;
cmd.Parameters.Add(new SqlParameter("@TYPECONSTRID", SqlDbType.TinyInt));
"Viktor Popov" <vi****@yahoo.com> wrote in message
news:Ow**************@TK2MSFTNGP09.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(object sender, System.EventArgs e) { SqlConnection conn = new SqlConnection("Data Source=----;Initial Catalog=---; User ID=---; Password=----"); SqlCommand cmd = new SqlCommand("prSVOFFRDATA", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@CITY", SqlDbType.VarChar,20)); cmd.Parameters["@CITY"].Value = DDL4.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@DISTR", SqlDbType.VarChar,20)); cmd.Parameters["@DISTR"].Value = DistrTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@PHONE", SqlDbType.Char,1)); if(PhoneCB.Checked) { cmd.Parameters["@PHONE"].Value = "Y"; } else { cmd.Parameters["@PHONE"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@FURN", SqlDbType.Char,1)); if(FurnCB.Checked) { cmd.Parameters["@FURN"].Value = "Y"; } else { cmd.Parameters["@FURN"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@HTR", SqlDbType.Char,1)); if(HtrCB.Checked) { cmd.Parameters["@HTR"].Value = "Y"; } else { cmd.Parameters["@HTR"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@ESTTYPEID", SqlDbType.TinyInt)); cmd.Parameters["@ESTTYPEID"].Value = DDL2.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPEOFFERID", SqlDbType.TinyInt)); cmd.Parameters["@TYPEOFFERID"].Value = DDL1.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPECONSTRID", SqlDbType.TinyInt)); cmd.Parameters["@TYPECONSTRID"].Value = DDL3.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@USRNAM", SqlDbType.VarChar,20)); cmd.Parameters["@USRNAM"].Value = Session["usrName"].ToString(); cmd.Parameters.Add(new SqlParameter("@PRICE", SqlDbType.Int)); cmd.Parameters["@PRICE"].Value = PriceTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@ROOMS", SqlDbType.Int)); cmd.Parameters["@ROOMS"].Value = RoomsTB.Text.Trim(); 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.Trim(); cmd.Parameters.Add(new SqlParameter("@PIC", SqlDbType.VarChar,55)); cmd.Parameters["@PIC"].Value = PicTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@DESCR", SqlDbType.VarChar,255)); cmd.Parameters["@DESCR"].Value = DescrTB.Text.Trim(); cmd.Connection.Open(); cmd.ExecuteNonQuery(); 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.nyc.gerbercapital.com> wrote in message
news:eE**************@TK2MSFTNGP09.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.TinyInt)); cmd.Parameters["@ESTTYPEID"].Value = DDL2.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPEOFFERID", SqlDbType.TinyInt)); cmd.Parameters["@TYPEOFFERID"].Value = DDL1.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPECONSTRID", SqlDbType.TinyInt)); "Viktor Popov" <vi****@yahoo.com> wrote in message news:Ow**************@TK2MSFTNGP09.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(object sender, System.EventArgs e) { SqlConnection conn = new SqlConnection("Data Source=----;Initial Catalog=---; User ID=---; Password=----"); SqlCommand cmd = new SqlCommand("prSVOFFRDATA", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@CITY", SqlDbType.VarChar,20)); cmd.Parameters["@CITY"].Value = DDL4.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@DISTR", SqlDbType.VarChar,20)); cmd.Parameters["@DISTR"].Value = DistrTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@PHONE", SqlDbType.Char,1)); if(PhoneCB.Checked) { cmd.Parameters["@PHONE"].Value = "Y"; } else { cmd.Parameters["@PHONE"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@FURN", SqlDbType.Char,1)); if(FurnCB.Checked) { cmd.Parameters["@FURN"].Value = "Y"; } else { cmd.Parameters["@FURN"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@HTR", SqlDbType.Char,1)); if(HtrCB.Checked) { cmd.Parameters["@HTR"].Value = "Y"; } else { cmd.Parameters["@HTR"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@ESTTYPEID", SqlDbType.TinyInt)); cmd.Parameters["@ESTTYPEID"].Value = DDL2.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPEOFFERID", SqlDbType.TinyInt)); cmd.Parameters["@TYPEOFFERID"].Value = DDL1.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPECONSTRID",
SqlDbType.TinyInt)); cmd.Parameters["@TYPECONSTRID"].Value = DDL3.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@USRNAM", SqlDbType.VarChar,20)); cmd.Parameters["@USRNAM"].Value = Session["usrName"].ToString(); cmd.Parameters.Add(new SqlParameter("@PRICE", SqlDbType.Int)); cmd.Parameters["@PRICE"].Value = PriceTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@ROOMS", SqlDbType.Int)); cmd.Parameters["@ROOMS"].Value = RoomsTB.Text.Trim(); 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.Trim(); cmd.Parameters.Add(new SqlParameter("@PIC", SqlDbType.VarChar,55)); cmd.Parameters["@PIC"].Value = PicTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@DESCR", SqlDbType.VarChar,255)); cmd.Parameters["@DESCR"].Value = DescrTB.Text.Trim(); cmd.Connection.Open(); cmd.ExecuteNonQuery(); 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******@atlassoft.com> wrote in message
news:uH**************@TK2MSFTNGP12.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.Text.Trim();
instead try Convert.ToInt32(txtSomething.Text.Trim());
Thanks.
Dharmesh
"Viktor Popov" <vi****@yahoo.com> wrote in message news:up**************@TK2MSFTNGP12.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(EstHeating 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["@TYPEOFFERID"].Value = ctype(ddl1.selecteditem.value,
integer)
or you can use the index of the selected value:
cmd.Parameters["@TYPEOFFERID"].Value = ddl1.selectedindex + 1 ' +1
because it starts at 0
"Viktor Popov" <vi****@yahoo.com> wrote in message
news:ON**************@TK2MSFTNGP11.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.nyc.gerbercapital.com> wrote in message news:eE**************@TK2MSFTNGP09.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.TinyInt)); cmd.Parameters["@ESTTYPEID"].Value = DDL2.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPEOFFERID", SqlDbType.TinyInt)); cmd.Parameters["@TYPEOFFERID"].Value = DDL1.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPECONSTRID",
SqlDbType.TinyInt));
"Viktor Popov" <vi****@yahoo.com> wrote in message news:Ow**************@TK2MSFTNGP09.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(object sender, System.EventArgs e) { SqlConnection conn = new SqlConnection("Data Source=----;Initial Catalog=---; User ID=---; Password=----"); SqlCommand cmd = new SqlCommand("prSVOFFRDATA", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@CITY", SqlDbType.VarChar,20)); cmd.Parameters["@CITY"].Value = DDL4.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@DISTR", SqlDbType.VarChar,20)); cmd.Parameters["@DISTR"].Value = DistrTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@PHONE", SqlDbType.Char,1)); if(PhoneCB.Checked) { cmd.Parameters["@PHONE"].Value = "Y"; } else { cmd.Parameters["@PHONE"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@FURN", SqlDbType.Char,1)); if(FurnCB.Checked) { cmd.Parameters["@FURN"].Value = "Y"; } else { cmd.Parameters["@FURN"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@HTR", SqlDbType.Char,1)); if(HtrCB.Checked) { cmd.Parameters["@HTR"].Value = "Y"; } else { cmd.Parameters["@HTR"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@ESTTYPEID", SqlDbType.TinyInt)); cmd.Parameters["@ESTTYPEID"].Value = DDL2.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPEOFFERID",
SqlDbType.TinyInt)); cmd.Parameters["@TYPEOFFERID"].Value = DDL1.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPECONSTRID", SqlDbType.TinyInt)); cmd.Parameters["@TYPECONSTRID"].Value = DDL3.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@USRNAM", SqlDbType.VarChar,20)); cmd.Parameters["@USRNAM"].Value = Session["usrName"].ToString(); cmd.Parameters.Add(new SqlParameter("@PRICE", SqlDbType.Int)); cmd.Parameters["@PRICE"].Value = PriceTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@ROOMS", SqlDbType.Int)); cmd.Parameters["@ROOMS"].Value = RoomsTB.Text.Trim(); 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.Trim(); cmd.Parameters.Add(new SqlParameter("@PIC", SqlDbType.VarChar,55)); cmd.Parameters["@PIC"].Value = PicTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@DESCR", SqlDbType.VarChar,255)); cmd.Parameters["@DESCR"].Value = DescrTB.Text.Trim(); cmd.Connection.Open(); cmd.ExecuteNonQuery(); 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.nyc.gerbercapital.com> wrote in message
news:%2****************@tk2msftngp13.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["@TYPEOFFERID"].Value = ctype(ddl1.selecteditem.value, integer)
or you can use the index of the selected value:
cmd.Parameters["@TYPEOFFERID"].Value = ddl1.selectedindex + 1 ' +1 because it starts at 0 "Viktor Popov" <vi****@yahoo.com> wrote in message news:ON**************@TK2MSFTNGP11.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.nyc.gerbercapital.com> wrote in message news:eE**************@TK2MSFTNGP09.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.TinyInt)); cmd.Parameters["@ESTTYPEID"].Value = DDL2.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPEOFFERID",
SqlDbType.TinyInt)); cmd.Parameters["@TYPEOFFERID"].Value = DDL1.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPECONSTRID", SqlDbType.TinyInt));
"Viktor Popov" <vi****@yahoo.com> wrote in message news:Ow**************@TK2MSFTNGP09.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(object sender, System.EventArgs e) > { > SqlConnection conn = new SqlConnection("Data Source=----;Initial > Catalog=---; User ID=---; Password=----"); > SqlCommand cmd = new SqlCommand("prSVOFFRDATA", conn); > cmd.CommandType = CommandType.StoredProcedure; > cmd.Parameters.Add(new SqlParameter("@CITY", SqlDbType.VarChar,20)); > cmd.Parameters["@CITY"].Value = DDL4.SelectedItem.Value; > cmd.Parameters.Add(new SqlParameter("@DISTR",
SqlDbType.VarChar,20)); > cmd.Parameters["@DISTR"].Value = DistrTB.Text.Trim(); > cmd.Parameters.Add(new SqlParameter("@PHONE", SqlDbType.Char,1)); > if(PhoneCB.Checked) > { > cmd.Parameters["@PHONE"].Value = "Y"; > } > else > { > cmd.Parameters["@PHONE"].Value = "N"; > } > cmd.Parameters.Add(new SqlParameter("@FURN", SqlDbType.Char,1)); > if(FurnCB.Checked) > { > cmd.Parameters["@FURN"].Value = "Y"; > } > else > { > cmd.Parameters["@FURN"].Value = "N"; > } > cmd.Parameters.Add(new SqlParameter("@HTR", SqlDbType.Char,1)); > if(HtrCB.Checked) > { > cmd.Parameters["@HTR"].Value = "Y"; > } > else > { > cmd.Parameters["@HTR"].Value = "N"; > } > cmd.Parameters.Add(new SqlParameter("@ESTTYPEID",
SqlDbType.TinyInt)); > cmd.Parameters["@ESTTYPEID"].Value = DDL2.SelectedItem.Value; > cmd.Parameters.Add(new SqlParameter("@TYPEOFFERID", SqlDbType.TinyInt)); > cmd.Parameters["@TYPEOFFERID"].Value = DDL1.SelectedItem.Value; > cmd.Parameters.Add(new SqlParameter("@TYPECONSTRID", SqlDbType.TinyInt)); > cmd.Parameters["@TYPECONSTRID"].Value = DDL3.SelectedItem.Value; > cmd.Parameters.Add(new SqlParameter("@USRNAM",
SqlDbType.VarChar,20)); > cmd.Parameters["@USRNAM"].Value = Session["usrName"].ToString(); > cmd.Parameters.Add(new SqlParameter("@PRICE", SqlDbType.Int)); > cmd.Parameters["@PRICE"].Value = PriceTB.Text.Trim(); > cmd.Parameters.Add(new SqlParameter("@ROOMS", SqlDbType.Int)); > cmd.Parameters["@ROOMS"].Value = RoomsTB.Text.Trim(); > 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.Trim(); > cmd.Parameters.Add(new SqlParameter("@PIC", SqlDbType.VarChar,55)); > cmd.Parameters["@PIC"].Value = PicTB.Text.Trim(); > cmd.Parameters.Add(new SqlParameter("@DESCR",
SqlDbType.VarChar,255)); > cmd.Parameters["@DESCR"].Value = DescrTB.Text.Trim(); > cmd.Connection.Open(); > cmd.ExecuteNonQuery(); > 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.nyc.gerbercapital.com> wrote in message
news:%2****************@tk2msftngp13.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["@TYPEOFFERID"].Value = ctype(ddl1.selecteditem.value, integer)
or you can use the index of the selected value:
cmd.Parameters["@TYPEOFFERID"].Value = ddl1.selectedindex + 1 ' +1 because it starts at 0 "Viktor Popov" <vi****@yahoo.com> wrote in message news:ON**************@TK2MSFTNGP11.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.nyc.gerbercapital.com> wrote in message news:eE**************@TK2MSFTNGP09.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.TinyInt)); cmd.Parameters["@ESTTYPEID"].Value = DDL2.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPEOFFERID",
SqlDbType.TinyInt)); cmd.Parameters["@TYPEOFFERID"].Value = DDL1.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPECONSTRID", SqlDbType.TinyInt));
"Viktor Popov" <vi****@yahoo.com> wrote in message news:Ow**************@TK2MSFTNGP09.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(object sender, System.EventArgs e) > { > SqlConnection conn = new SqlConnection("Data Source=----;Initial > Catalog=---; User ID=---; Password=----"); > SqlCommand cmd = new SqlCommand("prSVOFFRDATA", conn); > cmd.CommandType = CommandType.StoredProcedure; > cmd.Parameters.Add(new SqlParameter("@CITY", SqlDbType.VarChar,20)); > cmd.Parameters["@CITY"].Value = DDL4.SelectedItem.Value; > cmd.Parameters.Add(new SqlParameter("@DISTR",
SqlDbType.VarChar,20)); > cmd.Parameters["@DISTR"].Value = DistrTB.Text.Trim(); > cmd.Parameters.Add(new SqlParameter("@PHONE", SqlDbType.Char,1)); > if(PhoneCB.Checked) > { > cmd.Parameters["@PHONE"].Value = "Y"; > } > else > { > cmd.Parameters["@PHONE"].Value = "N"; > } > cmd.Parameters.Add(new SqlParameter("@FURN", SqlDbType.Char,1)); > if(FurnCB.Checked) > { > cmd.Parameters["@FURN"].Value = "Y"; > } > else > { > cmd.Parameters["@FURN"].Value = "N"; > } > cmd.Parameters.Add(new SqlParameter("@HTR", SqlDbType.Char,1)); > if(HtrCB.Checked) > { > cmd.Parameters["@HTR"].Value = "Y"; > } > else > { > cmd.Parameters["@HTR"].Value = "N"; > } > cmd.Parameters.Add(new SqlParameter("@ESTTYPEID",
SqlDbType.TinyInt)); > cmd.Parameters["@ESTTYPEID"].Value = DDL2.SelectedItem.Value; > cmd.Parameters.Add(new SqlParameter("@TYPEOFFERID", SqlDbType.TinyInt)); > cmd.Parameters["@TYPEOFFERID"].Value = DDL1.SelectedItem.Value; > cmd.Parameters.Add(new SqlParameter("@TYPECONSTRID", SqlDbType.TinyInt)); > cmd.Parameters["@TYPECONSTRID"].Value = DDL3.SelectedItem.Value; > cmd.Parameters.Add(new SqlParameter("@USRNAM",
SqlDbType.VarChar,20)); > cmd.Parameters["@USRNAM"].Value = Session["usrName"].ToString(); > cmd.Parameters.Add(new SqlParameter("@PRICE", SqlDbType.Int)); > cmd.Parameters["@PRICE"].Value = PriceTB.Text.Trim(); > cmd.Parameters.Add(new SqlParameter("@ROOMS", SqlDbType.Int)); > cmd.Parameters["@ROOMS"].Value = RoomsTB.Text.Trim(); > 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.Trim(); > cmd.Parameters.Add(new SqlParameter("@PIC", SqlDbType.VarChar,55)); > cmd.Parameters["@PIC"].Value = PicTB.Text.Trim(); > cmd.Parameters.Add(new SqlParameter("@DESCR",
SqlDbType.VarChar,255)); > cmd.Parameters["@DESCR"].Value = DescrTB.Text.Trim(); > cmd.Connection.Open(); > cmd.ExecuteNonQuery(); > 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.
The code is like this now but the problem is the same:
private void Button2_Click(object sender, System.EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source=BLEK;Initial
Catalog=Estate; User ID=blek; Password=banderas");
SqlCommand cmd = new SqlCommand("prSVOFFRDATA", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@CITY", SqlDbType.VarChar,20));
cmd.Parameters["@CITY"].Value = DDL4.SelectedItem.Text;
cmd.Parameters.Add(new SqlParameter("@DISTR", SqlDbType.VarChar,20));
cmd.Parameters["@DISTR"].Value = DistrTB.Text.Trim();
cmd.Parameters.Add(new SqlParameter("@PHONE", SqlDbType.Char,1));
if(PhoneCB.Checked)
{
cmd.Parameters["@PHONE"].Value = "Y";
}
else
{
cmd.Parameters["@PHONE"].Value = "N";
}
cmd.Parameters.Add(new SqlParameter("@FURN", SqlDbType.Char,1));
if(FurnCB.Checked)
{
cmd.Parameters["@FURN"].Value = "Y";
}
else
{
cmd.Parameters["@FURN"].Value = "N";
}
cmd.Parameters.Add(new SqlParameter("@HTR", SqlDbType.Char,1));
if(HtrCB.Checked)
{
cmd.Parameters["@HTR"].Value = "Y";
}
else
{
cmd.Parameters["@HTR"].Value = "N";
}
cmd.Parameters.Add(new SqlParameter("@ESTTYPEID", SqlDbType.TinyInt));
cmd.Parameters["@ESTTYPEID"].Value = Int32.Parse(DDL2.SelectedItem.Value);
cmd.Parameters.Add(new SqlParameter("@TYPEOFFERID", SqlDbType.TinyInt));
cmd.Parameters["@TYPEOFFERID"].Value = Int32.Parse(DDL1.SelectedItem.Value);
cmd.Parameters.Add(new SqlParameter("@TYPECONSTRID", SqlDbType.TinyInt));
cmd.Parameters["@TYPECONSTRID"].Value =
Int32.Parse(DDL3.SelectedItem.Value);
cmd.Parameters.Add(new SqlParameter("@USRNAM", SqlDbType.VarChar,20));
cmd.Parameters["@USRNAM"].Value = Session["usrName"].ToString();
cmd.Parameters.Add(new SqlParameter("@PRICE", SqlDbType.Int));
cmd.Parameters["@PRICE"].Value = Int32.Parse(PriceTB.Text.Trim());
cmd.Parameters.Add(new SqlParameter("@ROOMS", SqlDbType.Int));
cmd.Parameters["@ROOMS"].Value = Int32.Parse(RoomsTB.Text.Trim());
cmd.Parameters.Add(new SqlParameter("@SqMeters", SqlDbType.Int));
cmd.Parameters["@SqMeters"].Value = Int32.Parse(SQMetersTB.Text.Trim());
cmd.Parameters.Add(new SqlParameter("@Floors", SqlDbType.Int));
cmd.Parameters["@Floors"].Value = Int32.Parse(FloorsTB.Text.Trim());
cmd.Parameters.Add(new SqlParameter("@PIC", SqlDbType.VarChar,55));
cmd.Parameters["@PIC"].Value = PicTB.Text.Trim();
cmd.Parameters.Add(new SqlParameter("@DESCR", SqlDbType.VarChar,255));
cmd.Parameters["@DESCR"].Value = DescrTB.Text.Trim();
cmd.Connection.Open();
cmd.ExecuteNonQuery();
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.
Thanks for the reply!
The code is like this now, but the problem is the same:
private void Button2_Click(object sender, System.EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source=BLEK;Initial
Catalog=Estate; User ID=blek; Password=banderas");
SqlCommand cmd = new SqlCommand("prSVOFFRDATA", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@CITY", SqlDbType.VarChar,20));
cmd.Parameters["@CITY"].Value = DDL4.SelectedItem.Text;
cmd.Parameters.Add(new SqlParameter("@DISTR", SqlDbType.VarChar,20));
cmd.Parameters["@DISTR"].Value = DistrTB.Text.Trim();
cmd.Parameters.Add(new SqlParameter("@PHONE", SqlDbType.Char,1));
if(PhoneCB.Checked)
{
cmd.Parameters["@PHONE"].Value = "Y";
}
else
{
cmd.Parameters["@PHONE"].Value = "N";
}
cmd.Parameters.Add(new SqlParameter("@FURN", SqlDbType.Char,1));
if(FurnCB.Checked)
{
cmd.Parameters["@FURN"].Value = "Y";
}
else
{
cmd.Parameters["@FURN"].Value = "N";
}
cmd.Parameters.Add(new SqlParameter("@HTR", SqlDbType.Char,1));
if(HtrCB.Checked)
{
cmd.Parameters["@HTR"].Value = "Y";
}
else
{
cmd.Parameters["@HTR"].Value = "N";
}
cmd.Parameters.Add(new SqlParameter("@ESTTYPEID", SqlDbType.TinyInt));
cmd.Parameters["@ESTTYPEID"].Value = DDL2.SelectedItem.Value;
cmd.Parameters.Add(new SqlParameter("@TYPEOFFERID", SqlDbType.TinyInt));
cmd.Parameters["@TYPEOFFERID"].Value = DDL1.SelectedItem.Value;
cmd.Parameters.Add(new SqlParameter("@TYPECONSTRID", SqlDbType.TinyInt));
cmd.Parameters["@TYPECONSTRID"].Value = DDL3.SelectedItem.Value;
cmd.Parameters.Add(new SqlParameter("@USRNAM", SqlDbType.VarChar,20));
cmd.Parameters["@USRNAM"].Value = Session["usrName"].ToString();
cmd.Parameters.Add(new SqlParameter("@PRICE", SqlDbType.Int));
cmd.Parameters["@PRICE"].Value = Int32.Parse(PriceTB.Text.Trim());
cmd.Parameters.Add(new SqlParameter("@ROOMS", SqlDbType.Int));
cmd.Parameters["@ROOMS"].Value = Int32.Parse(RoomsTB.Text.Trim());
cmd.Parameters.Add(new SqlParameter("@SqMeters", SqlDbType.Int));
cmd.Parameters["@SqMeters"].Value = Int32.Parse(SQMetersTB.Text.Trim());
cmd.Parameters.Add(new SqlParameter("@Floors", SqlDbType.Int));
cmd.Parameters["@Floors"].Value = Int32.Parse(FloorsTB.Text.Trim());
cmd.Parameters.Add(new SqlParameter("@PIC", SqlDbType.VarChar,55));
cmd.Parameters["@PIC"].Value = PicTB.Text.Trim();
cmd.Parameters.Add(new SqlParameter("@DESCR", SqlDbType.VarChar,255));
cmd.Parameters["@DESCR"].Value = DescrTB.Text.Trim();
cmd.Connection.Open();
cmd.ExecuteNonQuery();
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.
Viktor,
Check all the datatypes in the database with the datatypes of the same
columns you are using in your code. There should be a mismatch. Or there
will be a mismatch between datatypes in your database and the datatype used
in stored procedure. Just check it carefully.
Dharmesh
"Viktor Popov" <vi****@yahoo.com> wrote in message
news:Ow**************@TK2MSFTNGP09.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(object sender, System.EventArgs e) { SqlConnection conn = new SqlConnection("Data Source=----;Initial Catalog=---; User ID=---; Password=----"); SqlCommand cmd = new SqlCommand("prSVOFFRDATA", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@CITY", SqlDbType.VarChar,20)); cmd.Parameters["@CITY"].Value = DDL4.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@DISTR", SqlDbType.VarChar,20)); cmd.Parameters["@DISTR"].Value = DistrTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@PHONE", SqlDbType.Char,1)); if(PhoneCB.Checked) { cmd.Parameters["@PHONE"].Value = "Y"; } else { cmd.Parameters["@PHONE"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@FURN", SqlDbType.Char,1)); if(FurnCB.Checked) { cmd.Parameters["@FURN"].Value = "Y"; } else { cmd.Parameters["@FURN"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@HTR", SqlDbType.Char,1)); if(HtrCB.Checked) { cmd.Parameters["@HTR"].Value = "Y"; } else { cmd.Parameters["@HTR"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@ESTTYPEID", SqlDbType.TinyInt)); cmd.Parameters["@ESTTYPEID"].Value = DDL2.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPEOFFERID", SqlDbType.TinyInt)); cmd.Parameters["@TYPEOFFERID"].Value = DDL1.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPECONSTRID", SqlDbType.TinyInt)); cmd.Parameters["@TYPECONSTRID"].Value = DDL3.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@USRNAM", SqlDbType.VarChar,20)); cmd.Parameters["@USRNAM"].Value = Session["usrName"].ToString(); cmd.Parameters.Add(new SqlParameter("@PRICE", SqlDbType.Int)); cmd.Parameters["@PRICE"].Value = PriceTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@ROOMS", SqlDbType.Int)); cmd.Parameters["@ROOMS"].Value = RoomsTB.Text.Trim(); 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.Trim(); cmd.Parameters.Add(new SqlParameter("@PIC", SqlDbType.VarChar,55)); cmd.Parameters["@PIC"].Value = PicTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@DESCR", SqlDbType.VarChar,255)); cmd.Parameters["@DESCR"].Value = DescrTB.Text.Trim(); cmd.Connection.Open(); cmd.ExecuteNonQuery(); 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.
What is your exact error?
Maybe your error is in the stored procedure?
Can you copy and paste the code from the stored procedure?
"Viktor Popov" <vi****@yahoo.com> wrote in message
news:us**************@TK2MSFTNGP11.phx.gbl... Thanks for the reply! The code is like this now, but the problem is the same:
private void Button2_Click(object sender, System.EventArgs e) { SqlConnection conn = new SqlConnection("Data Source=BLEK;Initial Catalog=Estate; User ID=blek; Password=banderas"); SqlCommand cmd = new SqlCommand("prSVOFFRDATA", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@CITY", SqlDbType.VarChar,20)); cmd.Parameters["@CITY"].Value = DDL4.SelectedItem.Text; cmd.Parameters.Add(new SqlParameter("@DISTR", SqlDbType.VarChar,20)); cmd.Parameters["@DISTR"].Value = DistrTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@PHONE", SqlDbType.Char,1)); if(PhoneCB.Checked) { cmd.Parameters["@PHONE"].Value = "Y"; } else { cmd.Parameters["@PHONE"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@FURN", SqlDbType.Char,1)); if(FurnCB.Checked) { cmd.Parameters["@FURN"].Value = "Y"; } else { cmd.Parameters["@FURN"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@HTR", SqlDbType.Char,1)); if(HtrCB.Checked) { cmd.Parameters["@HTR"].Value = "Y"; } else { cmd.Parameters["@HTR"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@ESTTYPEID", SqlDbType.TinyInt)); cmd.Parameters["@ESTTYPEID"].Value = DDL2.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPEOFFERID", SqlDbType.TinyInt)); cmd.Parameters["@TYPEOFFERID"].Value = DDL1.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPECONSTRID", SqlDbType.TinyInt)); cmd.Parameters["@TYPECONSTRID"].Value = DDL3.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@USRNAM", SqlDbType.VarChar,20)); cmd.Parameters["@USRNAM"].Value = Session["usrName"].ToString(); cmd.Parameters.Add(new SqlParameter("@PRICE", SqlDbType.Int)); cmd.Parameters["@PRICE"].Value = Int32.Parse(PriceTB.Text.Trim()); cmd.Parameters.Add(new SqlParameter("@ROOMS", SqlDbType.Int)); cmd.Parameters["@ROOMS"].Value = Int32.Parse(RoomsTB.Text.Trim()); cmd.Parameters.Add(new SqlParameter("@SqMeters", SqlDbType.Int)); cmd.Parameters["@SqMeters"].Value = Int32.Parse(SQMetersTB.Text.Trim()); cmd.Parameters.Add(new SqlParameter("@Floors", SqlDbType.Int)); cmd.Parameters["@Floors"].Value = Int32.Parse(FloorsTB.Text.Trim()); cmd.Parameters.Add(new SqlParameter("@PIC", SqlDbType.VarChar,55)); cmd.Parameters["@PIC"].Value = PicTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@DESCR", SqlDbType.VarChar,255)); cmd.Parameters["@DESCR"].Value = DescrTB.Text.Trim(); cmd.Connection.Open(); cmd.ExecuteNonQuery(); 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.
Yes here it is:
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'prSVOFFRDATA' AND type = 'P')
DROP PROCEDURE prSVOFFRDATA
GO
CREATE PROCEDURE prSVOFFRDATA
@CITY VARCHAR(20),
@DISTR VARCHAR(20),
@PHONE CHAR(1),
@FURN CHAR(1),
@HTR CHAR(1),
@EstTypeID TINYINT,
@TypeOfferID TINYINT,
@TypeConstrID TINYINT,
@USRNAM INT,
@Price INT,
@Rooms INT,
@SqMeters INT,
@Floors INT,
@PIC VARCHAR(55),
@DESCR VARCHAR(255)
AS
DECLARE @ADVDAT SMALLDATETIME, @IDENT INT, @USERID INT
SELECT @USERID=U.USERID FROM BLEK.USERS U WHERE U.USERNAME=@USRNAM
SELECT @ADVDAT = GETDATE()
INSERT INTO
BLEK.Estates(EstCity,EstDistr,EstPhone,EstFurn,Est Heating,AdDate,EstTypeID,T
ypeOfferID,TypeConstrID)
VALUES(@CITY,@DISTR,@PHONE,@FURN,@HTR,@ADVDAT,@Est TypeID,@TypeOfferID,@TypeC
onstrID)
SELECT @IDENT = SCOPE_IDENTITY()
INSERT INTO BLEK.Offers(EstateID,UserID,Price,Rooms,SqMeters,F loors)
VALUES(@IDENT,@USERID,@Price,@Rooms,@SqMeters,@Flo ors)
IF (@PIC IS NOT NULL)
INSERT INTO BLEK.Pictures(EstateID,PICEST) VALUES(@IDENT,@PIC)
IF (@DESCR IS NOT NULL)
INSERT INTO BLEK.Descriptions(EstateID,Descr) VALUES(@IDENT,@DESCR)
"Reva Baum" <re**@revaws.nyc.gerbercapital.com> wrote in message
news:OI**************@TK2MSFTNGP12.phx.gbl... What is your exact error? Maybe your error is in the stored procedure? Can you copy and paste the code from the stored procedure?
"Viktor Popov" <vi****@yahoo.com> wrote in message news:us**************@TK2MSFTNGP11.phx.gbl... Thanks for the reply! The code is like this now, but the problem is the same:
private void Button2_Click(object sender, System.EventArgs e) { SqlConnection conn = new SqlConnection("Data Source=BLEK;Initial Catalog=Estate; User ID=blek; Password=banderas"); SqlCommand cmd = new SqlCommand("prSVOFFRDATA", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@CITY", SqlDbType.VarChar,20)); cmd.Parameters["@CITY"].Value = DDL4.SelectedItem.Text; cmd.Parameters.Add(new SqlParameter("@DISTR", SqlDbType.VarChar,20)); cmd.Parameters["@DISTR"].Value = DistrTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@PHONE", SqlDbType.Char,1)); if(PhoneCB.Checked) { cmd.Parameters["@PHONE"].Value = "Y"; } else { cmd.Parameters["@PHONE"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@FURN", SqlDbType.Char,1)); if(FurnCB.Checked) { cmd.Parameters["@FURN"].Value = "Y"; } else { cmd.Parameters["@FURN"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@HTR", SqlDbType.Char,1)); if(HtrCB.Checked) { cmd.Parameters["@HTR"].Value = "Y"; } else { cmd.Parameters["@HTR"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@ESTTYPEID", SqlDbType.TinyInt)); cmd.Parameters["@ESTTYPEID"].Value = DDL2.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPEOFFERID", SqlDbType.TinyInt)); cmd.Parameters["@TYPEOFFERID"].Value = DDL1.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPECONSTRID",
SqlDbType.TinyInt)); cmd.Parameters["@TYPECONSTRID"].Value = DDL3.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@USRNAM", SqlDbType.VarChar,20)); cmd.Parameters["@USRNAM"].Value = Session["usrName"].ToString(); cmd.Parameters.Add(new SqlParameter("@PRICE", SqlDbType.Int)); cmd.Parameters["@PRICE"].Value = Int32.Parse(PriceTB.Text.Trim()); cmd.Parameters.Add(new SqlParameter("@ROOMS", SqlDbType.Int)); cmd.Parameters["@ROOMS"].Value = Int32.Parse(RoomsTB.Text.Trim()); cmd.Parameters.Add(new SqlParameter("@SqMeters", SqlDbType.Int)); cmd.Parameters["@SqMeters"].Value = Int32.Parse(SQMetersTB.Text.Trim()); cmd.Parameters.Add(new SqlParameter("@Floors", SqlDbType.Int)); cmd.Parameters["@Floors"].Value = Int32.Parse(FloorsTB.Text.Trim()); cmd.Parameters.Add(new SqlParameter("@PIC", SqlDbType.VarChar,55)); cmd.Parameters["@PIC"].Value = PicTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@DESCR", SqlDbType.VarChar,255)); cmd.Parameters["@DESCR"].Value = DescrTB.Text.Trim(); cmd.Connection.Open(); cmd.ExecuteNonQuery(); 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've done it. It was an type mismatch betwenn stored procedure parameters
and theparameters from the webform.
Thank you Dharmesh & Reva Baum!
---
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 think i see it - finally!
@USRNAM INT
in your stored procedure should be @USERNAM VARCHAR(20)
because that's how it is in your code:
cmd.Parameters.Add(new SqlParameter("@USRNAM", SqlDbType.VarChar,20));
"Viktor Popov" <vi****@yahoo.com> wrote in message
news:um**************@TK2MSFTNGP11.phx.gbl... Yes here it is:
IF EXISTS (SELECT name FROM sysobjects WHERE name = 'prSVOFFRDATA' AND type = 'P') DROP PROCEDURE prSVOFFRDATA GO
CREATE PROCEDURE prSVOFFRDATA @CITY VARCHAR(20), @DISTR VARCHAR(20), @PHONE CHAR(1), @FURN CHAR(1), @HTR CHAR(1), @EstTypeID TINYINT, @TypeOfferID TINYINT, @TypeConstrID TINYINT, @USRNAM INT, @Price INT, @Rooms INT, @SqMeters INT, @Floors INT, @PIC VARCHAR(55), @DESCR VARCHAR(255) AS DECLARE @ADVDAT SMALLDATETIME, @IDENT INT, @USERID INT SELECT @USERID=U.USERID FROM BLEK.USERS U WHERE U.USERNAME=@USRNAM SELECT @ADVDAT = GETDATE() INSERT INTO
BLEK.Estates(EstCity,EstDistr,EstPhone,EstFurn,Est Heating,AdDate,EstTypeID,T ypeOfferID,TypeConstrID)
VALUES(@CITY,@DISTR,@PHONE,@FURN,@HTR,@ADVDAT,@Est TypeID,@TypeOfferID,@TypeC onstrID) SELECT @IDENT = SCOPE_IDENTITY() INSERT INTO BLEK.Offers(EstateID,UserID,Price,Rooms,SqMeters,F loors) VALUES(@IDENT,@USERID,@Price,@Rooms,@SqMeters,@Flo ors) IF (@PIC IS NOT NULL) INSERT INTO BLEK.Pictures(EstateID,PICEST) VALUES(@IDENT,@PIC) IF (@DESCR IS NOT NULL) INSERT INTO BLEK.Descriptions(EstateID,Descr) VALUES(@IDENT,@DESCR)
"Reva Baum" <re**@revaws.nyc.gerbercapital.com> wrote in message news:OI**************@TK2MSFTNGP12.phx.gbl... What is your exact error? Maybe your error is in the stored procedure? Can you copy and paste the code from the stored procedure?
"Viktor Popov" <vi****@yahoo.com> wrote in message news:us**************@TK2MSFTNGP11.phx.gbl... Thanks for the reply! The code is like this now, but the problem is the same:
private void Button2_Click(object sender, System.EventArgs e) { SqlConnection conn = new SqlConnection("Data Source=BLEK;Initial Catalog=Estate; User ID=blek; Password=banderas"); SqlCommand cmd = new SqlCommand("prSVOFFRDATA", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@CITY", SqlDbType.VarChar,20)); cmd.Parameters["@CITY"].Value = DDL4.SelectedItem.Text; cmd.Parameters.Add(new SqlParameter("@DISTR", SqlDbType.VarChar,20)); cmd.Parameters["@DISTR"].Value = DistrTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@PHONE", SqlDbType.Char,1)); if(PhoneCB.Checked) { cmd.Parameters["@PHONE"].Value = "Y"; } else { cmd.Parameters["@PHONE"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@FURN", SqlDbType.Char,1)); if(FurnCB.Checked) { cmd.Parameters["@FURN"].Value = "Y"; } else { cmd.Parameters["@FURN"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@HTR", SqlDbType.Char,1)); if(HtrCB.Checked) { cmd.Parameters["@HTR"].Value = "Y"; } else { cmd.Parameters["@HTR"].Value = "N"; } cmd.Parameters.Add(new SqlParameter("@ESTTYPEID", SqlDbType.TinyInt)); cmd.Parameters["@ESTTYPEID"].Value = DDL2.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPEOFFERID",
SqlDbType.TinyInt)); cmd.Parameters["@TYPEOFFERID"].Value = DDL1.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@TYPECONSTRID", SqlDbType.TinyInt)); cmd.Parameters["@TYPECONSTRID"].Value = DDL3.SelectedItem.Value; cmd.Parameters.Add(new SqlParameter("@USRNAM", SqlDbType.VarChar,20)); cmd.Parameters["@USRNAM"].Value = Session["usrName"].ToString(); cmd.Parameters.Add(new SqlParameter("@PRICE", SqlDbType.Int)); cmd.Parameters["@PRICE"].Value = Int32.Parse(PriceTB.Text.Trim()); cmd.Parameters.Add(new SqlParameter("@ROOMS", SqlDbType.Int)); cmd.Parameters["@ROOMS"].Value = Int32.Parse(RoomsTB.Text.Trim()); cmd.Parameters.Add(new SqlParameter("@SqMeters", SqlDbType.Int)); cmd.Parameters["@SqMeters"].Value =
Int32.Parse(SQMetersTB.Text.Trim()); cmd.Parameters.Add(new SqlParameter("@Floors", SqlDbType.Int)); cmd.Parameters["@Floors"].Value = Int32.Parse(FloorsTB.Text.Trim()); cmd.Parameters.Add(new SqlParameter("@PIC", SqlDbType.VarChar,55)); cmd.Parameters["@PIC"].Value = PicTB.Text.Trim(); cmd.Parameters.Add(new SqlParameter("@DESCR", SqlDbType.VarChar,255)); cmd.Parameters["@DESCR"].Value = DescrTB.Text.Trim(); cmd.Connection.Open(); cmd.ExecuteNonQuery(); 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...
|
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...
|
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...
|
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...
|
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...
| |
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...
|
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...
|
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...
|
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...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
| |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
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...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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...
| |