|
|
Hi,
I have some problem with using variables, I am making a form in C#?asp.net .
Now in my web application form I am having two controls on web page (dropdown, button); depending on the selection in the dropdown I have changed some value in a integer variable.
PROBLEM: the variable retains this value until the event ends.
after that I am using this value to do some processing; it is here that I find that the int value has changed back to 0(its default value). How can I prevent this as I need the value of the int?
I have tried my code both by declaring the int variable as global to that form and also by declaring it inside that particular event.
can someone please help me?
thank You
|
|
|
|
|
Do you have a check of PostBack in the Page_Load?
If not then add that in for Form_Load.
Declare the variable at class level.
Then initialize the variable under if(!Page.IsPostBack).
|
|
|
|
|
Hi Everybody
i want to know how we will do paging and sorting in gridview in asp.net2.0 with c#.plz help
me soon.
thanks®ards
vivek sachan
|
|
|
|
|
|
|
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
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
