ASP.NET

Re: Problem with DropDownList

29-Aug-09 3:55

You are using it inside Gridview ?

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Abhijit Jana29-Aug-09 3:53

Re: Problem with DropDownList

29-Aug-09 3:53

When did you create those Dynamic control. You have to create the dynamic control before page_load(), other wise that control will not be able to maintain viewstate and Postback datra, cause LoadViewState() and LoadPostbackData() called juts before page_load().

IF you created control before page_load,

Try to do this in

Page_Load()

if( ! Page.IsPostBack)

   {

      // Bind Data With Dropdownlist
   }

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

nagendrathecoder29-Aug-09 3:57

nagendrathecoder

29-Aug-09 3:57

i am creating it inseide a GridView

SiteMapPath

KhandelwalA29-Aug-09 2:18

KhandelwalA

29-Aug-09 2:18

Is it possible to generate Sitemappath through the database..........if yes then how.......is it relaed to something CustomizeSiteProvider...........plz guide me a bit......... Smile | :)

Re: SiteMapPath

Arindam Sinha29-Aug-09 2:22

29-Aug-09 2:22

Did you look at this[^]?

Regards,
Arindam Sinha
MyBlog - http://arindamsinha.wordpress.com/
Please give your feedback on this answer.

Re: SiteMapPath

Arindam Sinha29-Aug-09 2:24

29-Aug-09 2:24

This one [^]might be helpful too. Smile | :)

Regards,
Arindam Sinha
MyBlog - http://arindamsinha.wordpress.com/
Please give your feedback on this answer.

Re: SiteMapPath

Abhijit Jana29-Aug-09 3:45

Re: problems with variables

29-Aug-09 3:45

Please check this article,
Navigation using dynamic SiteMapPath file[^]

This will help you Big Grin | :-D

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

problems with variables

shankbond29-Aug-09 1:42

shankbond

29-Aug-09 1:42

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

Arindam Sinha29-Aug-09 2:01

sorting and paging in gridview in asp.net2.0 with c#

29-Aug-09 2:01

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).

Regards,
Arindam Sinha
MyBlog - http://arindamsinha.wordpress.com/
Please give your feedback on this answer.

rummer29-Aug-09 1:35

rummer

29-Aug-09 1:35

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&regards

vivek sachan

Re: sorting and paging in gridview in asp.net2.0 with c#

padmanabhan N29-Aug-09 1:40

Re: sorting and paging in gridview in asp.net2.0 with c#

29-Aug-09 1:40

refer : GridView all in one[^]

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

Abhijit Jana29-Aug-09 1:43

29-Aug-09 1:43

rummer wrote:
i want to know how we will do paging and sorting in gridview in asp.net2.0 with c#.plz help

Here is one Complete Example,
GridView Examples for ASP.NET 2.0: Paging and Sorting the GridView's Data[^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

error:datatype mismatch

mylogics29-Aug-09 1:20

29-Aug-09 1:20

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...

Arindam Sinha29-Aug-09 1:26

29-Aug-09 1:26

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[^].

Regards,
Arindam Sinha
MyBlog - http://arindamsinha.wordpress.com/
Please give your feedback on this answer.

mylogics29-Aug-09 1:35

Re: error:datatype mismatch [modified]

29-Aug-09 1:35

the problem is not due to this.i have tried it..... Frown | :(

Arindam Sinha29-Aug-09 1:38

29-Aug-09 1:38

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.

Regards,
Arindam Sinha
MyBlog - http://arindamsinha.wordpress.com/
Please give your feedback on this answer.

modified on Saturday, August 29, 2009 7:46 AM

padmanabhan N29-Aug-09 1:38

29-Aug-09 1:38

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"'

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

mylogics29-Aug-09 1:44

29-Aug-09 1:44

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

Arindam Sinha29-Aug-09 1:49

29-Aug-09 1:49

You can try this -

string str = "Select * From Vendor Where(VendorID= "+ DropDownList1.SelectedValue +")";

Regards,
Arindam Sinha
MyBlog - http://arindamsinha.wordpress.com/
Please give your feedback on this answer.

padmanabhan N29-Aug-09 1:49

29-Aug-09 1:49

then remove single quotes and try

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

mylogics29-Aug-09 1:53

29-Aug-09 1:53

it gives error while compiling.i think the problem is with dtatype of vendorID.previously when datatype was text it worked f9.

padmanabhan N29-Aug-09 1:54

29-Aug-09 1:54

what is the error... what is the value you got in the dropdown selected value....

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

mylogics29-Aug-09 1:59

29-Aug-09 1:59

hii finally it worked when i removed single quotes.wat is the logic behind this....

padmanabhan N29-Aug-09 2:03

29-Aug-09 2:03

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

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

mylogics29-Aug-09 2:06