|
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..
|
|
|
|
|
if this ur personnel reply then reply to his/her personnel mail id or build a forum by youself(that is basically not possible by you)
|
|
|
|
|
ok..! Thank u Dude..!thts the reply
|
|
|
|
|
i want to open a url from a webpart thats created using C# web control library, generally we use diagnost method but its not working in web control type so i need an alternative method
Plz help.
|
|
|
|
|
guys do you know how to make slid like this one.
Show Photo
thanks.
al hajjaj
|
|
|
|
|
Yes
only two letters away from being an asset
|
|
|
|
|
then, tell me how please!!!!
al hajjaj
|
|
|
|