|
i am creating it inseide a GridView
|
|
|
|
|
Is it possible to generate Sitemappath through the database..........if yes then how.......is it relaed to something CustomizeSiteProvider...........plz guide me a bit.........
|
|
|
|
|
|
|
|
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...
|
|
|
|