ASP.NET

Crisis with a dynamically created drop down list

24-Mar-09 22:12

blakshmi wrote:
And by using web request and web response objects im calling that above web page and getting the response but my problem is im getting only the file type and the content but actually i want content.

Problem is not clear to me. Confused | :confused:

can you please be little bit clear Smile | :)

cheers,
Abhijit
CodeProject MVP

scar_face24-Mar-09 21:48

scar_face

24-Mar-09 21:48

Here's the deal!

I'm creating two drop down lists dynamically in a GridView control and populating the second dropdownlist(let's call it ddl2 from now on) on the basis of the selection on the first dropdownlist control. The crisis is that, for multiple rows on the gridview the ddl2 starts appending values to itself and therefore ends up having repeats of the data it should originally hold.

How do I stop this repeat from happening? My code is as below.

<asp:GridView ID="grd" runat="server" OnRowDataBound="grd_RowDataBound">   
  
    
  
<Columns>    
  
  
<asp:TemplateField HeaderText="names">   
  
    
  
  
<ItemTemplate>  
  
    
  
  
<asp:DropDownList ID="name" runat="server" OnSelectedIndexChanged="onSelectChangeddl"></asp:DropDownList>  
  
    
  
</ItemTemplate>  
  
    
  
</asp:TemplateField>  
  
    
  
<asp:TemplateField HeaderText="age">   
  
    
  
<ItemTemplate>  
  
    
  
<asp:DropDownList ID="age" runat="server" AutoPostBack="true">   
  
    
  
</asp:DropDownList>  
  
    
  
  
</ItemTemplate>  
  
    
  
</asp:TemplateField>  
  
</Columns>  
  
    
  
</asp:GridView>

In c# code, i am trying to change the values of the second drop down list based on the value selected in the first. I am doing this as below:

foreach (GridViewRow row in grd.Rows)   
{   
DropDownList ddl1 = (DropDownList)row.FindControl("name");   
DropDownList ddl = (DropDownList)row.FindControl("age");   
  
  
if (ddl.SelectedValue.ToString() != "---Select---")   
  
{   
  
}   
  
else  
  
    
  
{   
  
ddl.Items.Clear();   
  
}   
  
    
  
SqlCommand SPComm = new SqlCommand("someStoredProcedure", myConn);   
  
SPComm.CommandType = CommandType.StoredProcedure;   
  
SqlParameter param = SPComm.Parameters.Add("@something", SqlDbType.NVarChar, 50);   
  
param.Value = something;   
  
dr = SPComm.ExecuteReader();  //dr is sqlDataReader   
  
int i = 0;   
  
while (dr.Read())   
  
{   
  
ddl.Items.Insert(i, dr.GetString(0));   
  
}   
  
dr.Close();   
  
ddl.Items.Insert(0, "---Select---");   
  
}

In the above code, all the values in the second drop down list are getting duplicated based on the selected index changed event handler of the first drop down list.

Can anyone help me with this? Been trying all kinds of stuff with this since three weeks now! H-e-L-p!

scarface

increase the size of content page.

maheshsahini24-Mar-09 21:30

maheshsahini

24-Mar-09 21:30

hi,
In my website when m displaying my data in a datalist. the list is so long that it is overlapping with my footer. how can i increase the size of my content page, so that the footer always comes at the bottom of the page where the content page ends.

Re: increase the size of content page.

Abhijit Jana24-Mar-09 22:05

connection code problem..

24-Mar-09 22:05

maheshsahini wrote:
ow can i increase the size of my content page, so that the footer always comes at the bottom of the page where the content page ends.

I will suggest, use fix size DIV and place all other content inside the DIV. Smile | :)

cheers,
Abhijit
CodeProject MVP

yorockk24-Mar-09 21:29

24-Mar-09 21:29

following is the code:

Dim constr As String
constr = "Data Source=YOGESH\SQLEXPRESS;Initial Catalog=projdb;Integrated Security=True"
Dim conn As New SqlConnection(constr)
Dim cmd As New SqlCommand(constr, conn)
Dim rd As SqlDataReader
cmd.CommandText = "select * from employee where emp_name='txtname.text'"
conn.Open()

Try
rd = cmd.ExecuteReader()
GridView1.DataSource = rd
GridView1.DataBind()
Catch ex As Exception
MsgBox("exception occured:", MsgBoxStyle.Critical)
MsgBox.show(ex.Message, MsgBoxStyle.Critical)

End Try

basicallly iam tryin to fetch the details of the employee whose name is entered in the textbox of the form, from the database and display the same in a gridview
so after entering the name when i click the submit button an exception stating"exception occured" is gettin displayed..
plzzzzz suggest the changes..

Abhijit Jana24-Mar-09 21:58

24-Mar-09 21:58

yorockk wrote:
Dim rd As SqlDataReader
cmd.CommandText = "select * from employee where emp_name='txtname.text'"
conn.Open()

Try
rd = cmd.ExecuteReader()
GridView1.DataSource = rd
GridView1.DataBind()

Problem is here. Use Data Set as a source of GridView,which will be very easy for your to display.

Try something like this Wink | ;)

SqlDataAdapter da = new SqlDataAdapter(commandText, ConnectionString);
DataSet ds = new DataSet();
da.Fill(ds)
GridView1.DataSource=ds;

Note : This is C# syntax Smile | :)

cheers,
Abhijit
CodeProject MVP

yorockk24-Mar-09 22:51

24-Mar-09 22:51

me doin project in asp.net using V.B instead of C#
but still i implemented ur idea and made the changes accordingly..but still an exception is gettin occured..
so dis is the updated code:

Dim constr As String
constr = "Data Source=YOGESH\SQLEXPRESS;Initial Catalog=projdb;Integrated Security=True"
Dim conn As New SqlConnection(constr)
Dim cmd As New SqlCommand(constr, conn)
cmd.CommandText = "select * from employee where emp_name='txtname.text'"
Dim da As New SqlDataAdapter(cmd.CommandText, constr)
Dim ds As New Data.DataSet()
conn.Open()
Try

da.Fill(ds)
GridView1.DataSource = ds
Catch ex As Exception
MsgBox("exception occured")
End Try

plzzz suggest the changes for V.B code..
thanx for ur reply.. Smile | :)

Abhijit Jana24-Mar-09 23:12

24-Mar-09 23:12

Here is my 6 line of Sample Code.

SqlConnection con = new SqlConnection("Data Source=ServerName;Initial Catalog=DBNAME;User ID=sa; password=Password@123");
       SqlDataAdapter da = new SqlDataAdapter("select * from TableName", con);
       DataSet ds = new DataSet();
       da.Fill(ds);
       GridView1.DataSource = ds;
       GridView1.DataBind();

And its working fine. Smile | :)

Just Change the Bold section and try to run. And I will suggest you to read some books on ADO.NET, you need to learn some basic of it and also about Connection Less and Connection oriented mode of ADO.NET.

Cheers !!

cheers,
Abhijit
CodeProject MVP

yorockk25-Mar-09 3:45

25-Mar-09 3:45

abhijit,
thanx for the reply..
i will surely refer online ebooks on ado.net Smile | :)

Greg Chelstowski25-Mar-09 1:28

Greg Chelstowski

25-Mar-09 1:28

I do not get why people have not caught that sooner, but your SQLString will never take txtname's text into consideration, just the actual string 'txtname.text'.
I'm not at all proficient with vb, but i'm pretty sure, if you wanted to pass user input data as part of your where clause you would have to do:

cmd.CommandText = "select * from employee where emp_name='"+txtname.text+"'"

I do suggest you use parameterized queries or stored procedures instead to avoid sql injection.
Otherwise, if somebody puts "0--;delete from employee" or something of that sort, you're screwed.

To use parameters in your queries, set the command first and then add the parameters, like so:

cmd.CommandText = "select * from employee where emp_name=@empname";
cmd.Parameters.Add("@empname", SqlDbType.NVarChar,50).Value = txtname.text;

I still do advise using stored procedures.

Regards,
Greg

var question = (_2b || !(_2b));

yorockk25-Mar-09 3:43

25-Mar-09 3:43

hey greg ,thanx a lot for the corrections suggested.
i did the corrections and now my code is working fine. Smile | :)

yorockk25-Mar-09 3:48

25-Mar-09 3:48

In mah case an exception was gettin occured "The datatypes text and varchar are not compatible in the equal to operator"
the where condition in the query was
where emp_name='"+txtname.text+"'
so i change the datatype of emp_name from text to varchar(MAX)in the database table.. Smile | :)

paging in datalist

maheshsahini24-Mar-09 21:27

maheshsahini

24-Mar-09 21:27

hi,
i am using datalist to display my data, bt the problem is i am not able to do paging in it. i checked it on google bt the code was nt clear . so can some one please help???

Re: paging in datalist

Abhijit Jana24-Mar-09 22:02

24-Mar-09 22:02

maheshsahini wrote:
i checked it on google bt the code was nt clear . so can some one please help???

is it.
I have searched and got first link Paging in DataList[^]
and Rest Are[^]

cheers,
Abhijit
CodeProject MVP

Re: paging in datalist

vinodkrebc24-Mar-09 23:42

vinodkrebc

24-Mar-09 23:42

I think you might have written some javascript on client end to validate and it all the time gets false and stop the client to do postback because the postback method is also javascript

postback in asp.net

viit.projectgroup24-Mar-09 21:08

viit.projectgroup

24-Mar-09 21:08

i have the current senario........
i have designed a masterpage in asp.net. When referencing it in the content page using

asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

the post back is not working .
please help

thanks
viit.projectgroup

Re: postback in asp.net

Abhijit Jana24-Mar-09 21:59

want to Display Upper Case Letters in Text Box while Pressing Lower Case Letters ?

24-Mar-09 21:59

viit.projectgroup wrote:
the post back is not working .

What do you mean by post back is not working ?

cheers,
Abhijit
CodeProject MVP

Re: postback in asp.net

kumar_k50824-Mar-09 23:20

kumar_k508

24-Mar-09 23:20

What is the exact problem...?

pramod251724-Mar-09 20:44

pramod2517

24-Mar-09 20:44

want to Display Upper Case Letters in Text Box while Pressing Lower Case Letters, I tried with

Private Sub Text1_KeyPress(KeyAscii As Integer)

If KeyAscii >= 65 And KeyAscii <= 122 Then

Text1.Text = UCase(Text1.text)

End If

End Sub

but it is printing in reverse , is there any other mothods.

Re: want to Display Upper Case Letters in Text Box while Pressing Lower Case Letters ?

Abhijit Jana24-Mar-09 22:06

Re: want to Display Upper Case Letters in Text Box while Pressing Lower Case Letters ?

24-Mar-09 22:06

pramod2517 wrote:
want to Display Upper Case Letters in Text Box while Pressing Lower Case Letters, I tried with

Private Sub Text1_KeyPress(KeyAscii As Integer)

If KeyAscii >= 65 And KeyAscii <= 122 Then

Text1.Text = UCase(Text1.text)

End If

End Sub

I am sure that your are not doing it in ASP.NET. Roll eyes | :rolleyes:

cheers,
Abhijit
CodeProject MVP

pramod251724-Mar-09 23:12

pramod2517

24-Mar-09 23:12

iam writing code in windows application

Re: want to Display Upper Case Letters in Text Box while Pressing Lower Case Letters ?

Abhijit Jana24-Mar-09 23:19