|
|
|
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
string str = "Select * From Vendor Where(VendorID= '"+ DropDownList1.SelectedValue +"')";
OleDbCommand cmd = new OleDbCommand(str, conn);
OleDbDataReader dr=null;
conn.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
txtvendorname.Text = dr["VendorName"].ToString();
}
conn.Close();
}
hi i am getting data type mismatch error on executin this code.plz guide...
|
|
|
|
|
mylogics wrote: data type mismatch error
I have couple of suggestions -
1. Instead of the SELECT * FROM Vendor, use the columnames you need e.g. SELECT VENDOR_NAME,VENDOR_ID FROM Vendor.
2. Instead of dr[columnname] use dr.GetInt32(index) or dr.GetString(index).
See the example here[^].
|
|
|
|
|
the problem is not due to this.i have tried it.....
|
|
|
|
|
Can you put a try catch and find out the trace?
Also in which line you are getting that?
It would be good if you can provide the data types of your table columns as well.
modified on Saturday, August 29, 2009 7:46 AM
|
|
|
|
|
mylogics wrote: string str = "Select * From Vendor Where(VendorID= '"+ DropDownList1.SelectedValue +"')";
check whether VendorID is int or string,
if VendorID is int then use "DropDownList1.SelectedValue"
if VendorID is string then use '"DropDownList1.SelectedValue"'
|
|
|
|
|
actually m using access database n the vendorID datatype is autonumber
previously when the vendorID was text it was workin f9....
wat shud i do...
ERROR:DATATYPE MISMATCH IN CRITERIA EXPRESSION
|
|
|
|
|
You can try this -
string str = "Select * From Vendor Where(VendorID= "+ DropDownList1.SelectedValue +")";
|
|
|
|
|
then remove single quotes and try
|
|
|
|
|
it gives error while compiling.i think the problem is with dtatype of vendorID.previously when datatype was text it worked f9.
|
|
|
|
|
what is the error... what is the value you got in the dropdown selected value....
|
|
|
|
|
hii finally it worked when i removed single quotes.wat is the logic behind this....
|
|
|
|
|
it will render in back end as,
select * from table where id is '2'-- this is wrong because ''is for string......
so we have to mention as,
select * from table where id is 2
and for name field,
select name from table where name = 'xyz'-- this is correct
|
|
|
|
|
ok sir thnks i got u....
|
|
|
|
|
One small suggestion..The when you build a query string try to execute that in the DB first.
With quotes query would have given you the error in DB itself.
|
|
|
|
|
ok thnks...
|
|
|
|
|
i have list of nodes that have different order numbers,i want do this,but dont know how?!
i select node of treeview,when click move up button go up and if click move down go down,so i want get order number of up & down of my selected node?!
i found code its javascript but i want use code in asp.net form not javascript.
please help
|
|
|
|
|
|
Hi Friends
I got an requirement in using the menu control in horizontal orientation .the parent nodes has 20 child nodes so i need 5 in <td> and another 5 in another td can anyone help me out.To understand my question more clearly
check this link http://www.cricinfo.com/ in tht link mouse over to countries u will find 5 countries in one <td>
and other requirement is http://www.espnstar.com/football/premier-league/
football-->Barclayspremierleague-->Barclayspremierleague see they are 3 levels in the menu can any one tell me how to use it in menu control
Any Help is greatly appreciated
ThankYou
|
|
|
|
|
|
|
No prob..
|
|
|
|
|
|
Ths my personal reply to tht guy thts none of ur businee if its useful i will keep it..
|
|
|
|