Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > retrive preselected value in second drop down list from the first drop down list

Reply
Thread Tools

retrive preselected value in second drop down list from the first drop down list

 
 
weiwei
Guest
Posts: n/a
 
      01-05-2007
Hi
here is my scenario, I create a drop down list in itemtemplate.(that
drop down is created from db), after user
click edit command, my ideal plan is have another drop down list in
edititemtemplate with preselected value from
the previous drop down list, so far I can only achieved with the
regular drop down list in edititemtemplate with no preselected value
from previous one. anyone can help me.
thanks in advance. below is my current sample code.

<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<script language="VB" runat="server">

Dim objConnection As SqlConnection
Dim myDataReader As SqlDataReader

Sub Page_Load(Sender As Object, E As EventArgs)
' Set up our connection.
objConnection = New SqlConnection("Data Source=sql;Initial
Catalog=pub;User Id=xxx;Password=xxxxx;")

LoadDataFromDB

If Not IsPostBack Then
DataBindGrid
End If

End Sub

Sub LoadDataFromDB()
Dim objCommand As SqlCommand

' Create new command object passing it our SQL query and
telling it which connection to use.
objCommand = New SqlCommand("SELECT * FROM Educationtraining
WHERE Username = 'weifon888';", objConnection)

' Open the connection, execute the command, and close the connection.
objConnection.Open()
myDataReader =
objCommand.ExecuteReader(System.Data.CommandBehavi or.CloseConnection)
End Sub

Sub DataBindGrid()
DBEditDataGrid.DataSource = myDataReader
DBEditDataGrid.DataBind
End Sub


'----------------------------------------------------------------------------------------------
Sub DBEditDataGrid_Edit(Sender As Object, E As
DataGridCommandEventArgs)
DBEditDataGrid.EditItemIndex = E.Item.ItemIndex
DataBindGrid
End Sub

Sub DBEditDataGrid_Cancel(Sender As Object, E As
DataGridCommandEventArgs)
DBEditDataGrid.EditItemIndex = -1
DataBindGrid
End Sub

Sub DBEditDataGrid_Update(ByVal Sender As Object, ByVal E As
DataGridCommandEventArgs)
' Since the textboxes are autogenerated we don't know their
names, but we do know their positions.
Dim Tempdroplist As DropDownList
Dim Tempdropvalue As String

Dim strUser As String = E.Item.Cells(0).Text
Dim certother As TextBox = E.Item.Cells(1).Controls(0)
Dim strcertother = Replace(certother.Text, "'", "`")

Tempdroplist = E.Item.FindControl("teachercert")
Tempdropvalue = Tempdroplist.SelectedItem.Value

Response.Write(strUser)
Response.Write(strcertother)
Response.Write(Tempdropvalue)


' Update the appropriate record in our database.
Dim objCommand As SqlCommand
Dim strSQLQuery As String

' Build our update command.
strSQLQuery = "UPDATE Educationtraining SET Certother = '" &
strcertother & "' WHERE Username = 'johndoe'"

' Create new command object passing it our SQL query and
telling it which connection to use.
objCommand = New SqlCommand(strSQLQuery, objConnection)

' Close our open DataReader
myDataReader.Close()

Try
' Execute the command
objConnection.Open()
objCommand.ExecuteNonQuery()
objConnection.Close()

Catch Ex As Exception

Finally
objConnection.Close()
End Try


' Refresh our copy of the data
LoadDataFromDB()

' Reset our current edit item and rebind the grid
DBEditDataGrid.EditItemIndex = -1
DataBindGrid()
End Sub

</script>

<html>
<head>
<title>Modify User Profile</title>
<script language="javascript" type="text/javascript">
window.history.forward(1);
</Script>
</head>
<body>

<form id="Form1" runat="server">

<aspataGrid id="DBEditDataGrid" runat="server"
BorderWidth = "1px" CellSpacing = "2" CellPadding = "2"
HeaderStyle-Font-Bold = "True"

OnEditCommand = "DBEditDataGrid_Edit"
OnCancelCommand = "DBEditDataGrid_Cancel"
OnUpdateCommand = "DBEditDataGrid_Update"

AutoGenerateColumns = "False"
>

<Columns>
<asp:BoundColumn HeaderText="Username" DataField="Username"
ReadOnly="True" />
<asp:BoundColumn HeaderText="Cert Other" DataField="Certother"
/>

<asp:TemplateColumn FooterText="test" HeaderText="dropdown">
<EditItemTemplate>
&nbsp;

<aspropDownList ID="teachercert" runat="server">

<asp:ListItem>Yes</asp:ListItem>
<asp:ListItem>No</asp:ListItem>
</aspropDownList>
&nbsp;&nbsp;
</EditItemTemplate>


<ItemTemplate>
&nbsp;&nbsp;&nbsp;
<aspropDownList ID="DropDownList1" runat="server"
DataSourceID="SqlDataSource1"
DataTextField="Teachercert"
DataValueField="Teachercert" Enabled="False" AutoPostBack="True">
</aspropDownList><asp:SqlDataSource
ID="SqlDataSource1" runat="server" ConnectionString="<%$
ConnectionStrings:testConnectionString %>"
SelectCommand="SELECT [Teachercert] FROM
[EducationTraining]"></asp:SqlDataSource>
</ItemTemplate>
</asp:TemplateColumn>


<asp:EditCommandColumn
HeaderText = "Edit"
EditText = "Edit &amp; Continue"
CancelText = "Cancel"
UpdateText = "Update &amp; Continue"
/>

</Columns>
<HeaderStyle Font-Bold="True" />
</aspataGrid>

</form>
</body>
</html>

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to retrive first 10 items from hash in ruby? Vikas Gholap Ruby 10 02-13-2009 04:37 PM
Enable second drop down after first drop down is selected teser3@hotmail.com Javascript 0 01-28-2009 12:59 AM
Auto Drop down a Drop Down List xxbmichae1@supergambler.com Javascript 5 11-23-2005 01:35 AM
DropDownList - Preselected. Adam Knight ASP .Net 2 09-08-2005 06:41 AM
How to retrive checkbox value form Me.Request("...") dee ASP .Net 0 05-02-2005 08:11 PM



Advertisments