Register Register Member Login Member Login Member Login Forgot Password ??
PHP , ASP , ASP.NET, VB.NET, C#, Java , jQuery , Android , iOS , Windows Phone
 

Registered : 109,038

HOME > .NET Framework > Forum > จะนำ dropdownlist ไปใส่ใน gridview เพื่อที่จะEdit ได้อย่างไรครับ


 

[.NET] จะนำ dropdownlist ไปใส่ใน gridview เพื่อที่จะEdit ได้อย่างไรครับ

 
Topic : 039561



โพสกระทู้ ( 40 )
บทความ ( 0 )



สถานะออฟไลน์



จะนำ dropdownlist ไปใส่ใน gridview ครับ
edit

Code (VB.NET)
view source
print?
01.<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="ztest.aspx.vb" Inherits="ztest" title="Untitled Page" %>
02.<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
03.    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="RESV_ID"
04.        DataSourceID="SqlDataSource1" EmptyDataText="There are no data records to display.">
05.        <Columns>
06.            <asp:CommandField ShowEditButton="True" />
07.            <asp:BoundField DataField="RESV_ID" HeaderText="RESV_ID" ReadOnly="True" SortExpression="RESV_ID" />
08.            <asp:BoundField DataField="ROOM_ID" HeaderText="ROOM_ID" SortExpression="ROOM_ID" />
09.            <asp:BoundField DataField="DATE_FROM" HeaderText="DATE_FROM" SortExpression="DATE_FROM" />
10.            <asp:BoundField DataField="DATE_TO" HeaderText="DATE_TO" SortExpression="DATE_TO" />
11.            <asp:BoundField DataField="DAY" HeaderText="DAY" SortExpression="DAY" />
12.            <asp:BoundField DataField="RESV_STTS" HeaderText="RESV_STTS" SortExpression="RESV_STTS" />
13.            <asp:BoundField DataField="DATE_RESV" HeaderText="DATE_RESV" SortExpression="DATE_RESV" />
14.            <asp:BoundField DataField="TOTALPRICE" HeaderText="TOTALPRICE" SortExpression="TOTALPRICE" />
15.            <asp:BoundField DataField="GUEST_NAME" HeaderText="GUEST_NAME" SortExpression="GUEST_NAME" />
16.            <asp:BoundField DataField="GUEST_LASTNAME" HeaderText="GUEST_LASTNAME" SortExpression="GUEST_LASTNAME" />
17.            <asp:BoundField DataField="GNDR" HeaderText="GNDR" SortExpression="GNDR" />
18.            <asp:BoundField DataField="IDEN" HeaderText="IDEN" SortExpression="IDEN" />
19.            <asp:BoundField DataField="NATN" HeaderText="NATN" SortExpression="NATN" />
20.            <asp:BoundField DataField="ADDR" HeaderText="ADDR" SortExpression="ADDR" />
21.            <asp:BoundField DataField="EMAIL" HeaderText="EMAIL" SortExpression="EMAIL" />
22.            <asp:BoundField DataField="PHONE" HeaderText="PHONE" SortExpression="PHONE" />
23.        </Columns>
24.    </asp:GridView>
25.    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString1 %>"
26.        DeleteCommand="DELETE FROM [RESV] WHERE [RESV_ID] = @RESV_ID" InsertCommand="INSERT INTO [RESV] ([ROOM_ID], [DATE_FROM], [DATE_TO], [DAY], [RESV_STTS], [DATE_RESV], [TOTALPRICE], [GUEST_NAME], [GUEST_LASTNAME], [GNDR], [IDEN], [NATN], [ADDR], [EMAIL], [PHONE]) VALUES (@ROOM_ID, @DATE_FROM, @DATE_TO, @DAY, @RESV_STTS, @DATE_RESV, @TOTALPRICE, @GUEST_NAME, @GUEST_LASTNAME, @GNDR, @IDEN, @NATN, @ADDR, @EMAIL, @PHONE)"
27.        ProviderName="<%$ ConnectionStrings:DatabaseConnectionString1.ProviderName %>"
28.        SelectCommand="SELECT [RESV_ID], [ROOM_ID], [DATE_FROM], [DATE_TO], [DAY], [RESV_STTS], [DATE_RESV], [TOTALPRICE], [GUEST_NAME], [GUEST_LASTNAME], [GNDR], [IDEN], [NATN], [ADDR], [EMAIL], [PHONE] FROM [RESV]"
29.        UpdateCommand="UPDATE [RESV] SET [ROOM_ID] = @ROOM_ID, [DATE_FROM] = @DATE_FROM, [DATE_TO] = @DATE_TO, [DAY] = @DAY, [RESV_STTS] = @RESV_STTS, [DATE_RESV] = @DATE_RESV, [TOTALPRICE] = @TOTALPRICE, [GUEST_NAME] = @GUEST_NAME, [GUEST_LASTNAME] = @GUEST_LASTNAME, [GNDR] = @GNDR, [IDEN] = @IDEN, [NATN] = @NATN, [ADDR] = @ADDR, [EMAIL] = @EMAIL, [PHONE] = @PHONE WHERE [RESV_ID] = @RESV_ID">
30.        <InsertParameters>
31.            <asp:Parameter Name="ROOM_ID" Type="Int32" />
32.            <asp:Parameter Name="DATE_FROM" Type="DateTime" />
33.            <asp:Parameter Name="DATE_TO" Type="DateTime" />
34.            <asp:Parameter Name="DAY" Type="Int32" />
35.            <asp:Parameter Name="RESV_STTS" Type="String" />
36.            <asp:Parameter Name="DATE_RESV" Type="DateTime" />
37.            <asp:Parameter Name="TOTALPRICE" Type="Decimal" />
38.            <asp:Parameter Name="GUEST_NAME" Type="String" />
39.            <asp:Parameter Name="GUEST_LASTNAME" Type="String" />
40.            <asp:Parameter Name="GNDR" Type="String" />
41.            <asp:Parameter Name="IDEN" Type="String" />
42.            <asp:Parameter Name="NATN" Type="String" />
43.            <asp:Parameter Name="ADDR" Type="String" />
44.            <asp:Parameter Name="EMAIL" Type="String" />
45.            <asp:Parameter Name="PHONE" Type="String" />
46.        </InsertParameters>
47.        <UpdateParameters>
48.            <asp:Parameter Name="ROOM_ID" Type="Int32" />
49.            <asp:Parameter Name="DATE_FROM" Type="DateTime" />
50.            <asp:Parameter Name="DATE_TO" Type="DateTime" />
51.            <asp:Parameter Name="DAY" Type="Int32" />
52.            <asp:Parameter Name="RESV_STTS" Type="String" />
53.            <asp:Parameter Name="DATE_RESV" Type="DateTime" />
54.            <asp:Parameter Name="TOTALPRICE" Type="Decimal" />
55.            <asp:Parameter Name="GUEST_NAME" Type="String" />
56.            <asp:Parameter Name="GUEST_LASTNAME" Type="String" />
57.            <asp:Parameter Name="GNDR" Type="String" />
58.            <asp:Parameter Name="IDEN" Type="String" />
59.            <asp:Parameter Name="NATN" Type="String" />
60.            <asp:Parameter Name="ADDR" Type="String" />
61.            <asp:Parameter Name="EMAIL" Type="String" />
62.            <asp:Parameter Name="PHONE" Type="String" />
63.            <asp:Parameter Name="RESV_ID" Type="Int32" />
64.        </UpdateParameters>
65.        <DeleteParameters>
66.            <asp:Parameter Name="RESV_ID" Type="Int32" />
67.        </DeleteParameters>
68.    </asp:SqlDataSource>
69.</asp:Content>

จากที่ดูๆมาจะใส่โค้ดนี้
<ItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server">
</asp:DropDownList>
</ItemTemplate>
ผมใส่ใว้ตรงไหนก็ ERROR



Tag : - - - -
Move To Hilight (Stock) 
Send To Friend.Bookmark.
Date : 2010-02-25 03:19:21 By : mubin View : 2024 Reply : 6
 

 

No. 1



โพสกระทู้ ( 373 )
บทความ ( 0 )



สถานะออฟไลน์


http://www.eggheadcafe.com/community/aspnet/2/84369/howtoadddropdownlistt.aspx

ลองตามนี้ครับ code คุณยังไม่ได้ add DropDownList Control ครับ
Date : 2010-02-25 08:13:28 By : numenoy
 

 

No. 2



โพสกระทู้ ( 40 )
บทความ ( 0 )



สถานะออฟไลน์


ได้ column ที่มี dropdownlist แล้วครับ
ขั้นตอนต่อไป เวลาจะ update ฟิวด์ RESV_STTS ในตาราง RESV จะต้องทำอย่างไรครับ
Code (VB.NET)
view source
print?
01.<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="ztest.aspx.vb" Inherits="ztest" title="Untitled Page" %>
02.<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
03.    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="RESV_ID"
04.        DataSourceID="SqlDataSource1" EmptyDataText="There are no data records to display.">
05.        <Columns>
06.            <asp:CommandField ShowEditButton="True" />
07.            <asp:BoundField DataField="RESV_ID" HeaderText="RESV_ID" ReadOnly="True" SortExpression="RESV_ID" />
08.            <asp:BoundField DataField="ROOM_ID" HeaderText="ROOM_ID" SortExpression="ROOM_ID" />
09.            <asp:BoundField DataField="DATE_FROM" HeaderText="DATE_FROM" SortExpression="DATE_FROM" />
10.            <asp:BoundField DataField="DATE_TO" HeaderText="DATE_TO" SortExpression="DATE_TO" />
11.            <asp:BoundField DataField="DAY" HeaderText="DAY" SortExpression="DAY" />
12.              <asp:BoundField DataField="RESV_STTS" HeaderText="RESV_STTS" SortExpression="RESV_STTS" />
13.                <asp:TemplateField HeaderText="RESV_STTS">
14.                    <ItemTemplate>
15.                        <asp:DropDownList ID="DropDownList1" runat="server">
16.                         <asp:ListItem Text="R" Value="R" />
17.                            <asp:ListItem Text="C" Value="C" />
18.                            <asp:ListItem Text="O" Value="O" />
19.                        </asp:DropDownList>
20.                    </ItemTemplate>
21.                </asp:TemplateField>
22. 
23. 
24.            <asp:BoundField DataField="DATE_RESV" HeaderText="DATE_RESV" SortExpression="DATE_RESV" />
25.            <asp:BoundField DataField="TOTALPRICE" HeaderText="TOTALPRICE" SortExpression="TOTALPRICE" />
26.            <asp:BoundField DataField="GUEST_NAME" HeaderText="GUEST_NAME" SortExpression="GUEST_NAME" />
27.            <asp:BoundField DataField="GUEST_LASTNAME" HeaderText="GUEST_LASTNAME" SortExpression="GUEST_LASTNAME" />
28.            <asp:BoundField DataField="GNDR" HeaderText="GNDR" SortExpression="GNDR" />
29.            <asp:BoundField DataField="IDEN" HeaderText="IDEN" SortExpression="IDEN" />
30.            <asp:BoundField DataField="NATN" HeaderText="NATN" SortExpression="NATN" />
31.            <asp:BoundField DataField="ADDR" HeaderText="ADDR" SortExpression="ADDR" />
32.            <asp:BoundField DataField="EMAIL" HeaderText="EMAIL" SortExpression="EMAIL" />
33.            <asp:BoundField DataField="PHONE" HeaderText="PHONE" SortExpression="PHONE" />
34.        </Columns>
35.    </asp:GridView>
36.    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString1 %>"
37.        DeleteCommand="DELETE FROM [RESV] WHERE [RESV_ID] = @RESV_ID" InsertCommand="INSERT INTO [RESV] ([ROOM_ID], [DATE_FROM], [DATE_TO], [DAY], [RESV_STTS], [DATE_RESV], [TOTALPRICE], [GUEST_NAME], [GUEST_LASTNAME], [GNDR], [IDEN], [NATN], [ADDR], [EMAIL], [PHONE]) VALUES (@ROOM_ID, @DATE_FROM, @DATE_TO, @DAY, @RESV_STTS, @DATE_RESV, @TOTALPRICE, @GUEST_NAME, @GUEST_LASTNAME, @GNDR, @IDEN, @NATN, @ADDR, @EMAIL, @PHONE)"
38.        ProviderName="<%$ ConnectionStrings:DatabaseConnectionString1.ProviderName %>"
39.        SelectCommand="SELECT [RESV_ID], [ROOM_ID], [DATE_FROM], [DATE_TO], [DAY], [RESV_STTS], [DATE_RESV], [TOTALPRICE], [GUEST_NAME], [GUEST_LASTNAME], [GNDR], [IDEN], [NATN], [ADDR], [EMAIL], [PHONE] FROM [RESV]"
40.        UpdateCommand="UPDATE [RESV] SET [ROOM_ID] = @ROOM_ID, [DATE_FROM] = @DATE_FROM, [DATE_TO] = @DATE_TO, [DAY] = @DAY, [RESV_STTS] = @RESV_STTS, [DATE_RESV] = @DATE_RESV, [TOTALPRICE] = @TOTALPRICE, [GUEST_NAME] = @GUEST_NAME, [GUEST_LASTNAME] = @GUEST_LASTNAME, [GNDR] = @GNDR, [IDEN] = @IDEN, [NATN] = @NATN, [ADDR] = @ADDR, [EMAIL] = @EMAIL, [PHONE] = @PHONE WHERE [RESV_ID] = @RESV_ID">
41.        <InsertParameters>
42.            <asp:Parameter Name="ROOM_ID" Type="Int32" />
43.            <asp:Parameter Name="DATE_FROM" Type="DateTime" />
44.            <asp:Parameter Name="DATE_TO" Type="DateTime" />
45.            <asp:Parameter Name="DAY" Type="Int32" />
46.            <asp:Parameter Name="RESV_STTS" Type="String" />
47.            <asp:Parameter Name="DATE_RESV" Type="DateTime" />
48.            <asp:Parameter Name="TOTALPRICE" Type="Decimal" />
49.            <asp:Parameter Name="GUEST_NAME" Type="String" />
50.            <asp:Parameter Name="GUEST_LASTNAME" Type="String" />
51.            <asp:Parameter Name="GNDR" Type="String" />
52.            <asp:Parameter Name="IDEN" Type="String" />
53.            <asp:Parameter Name="NATN" Type="String" />
54.            <asp:Parameter Name="ADDR" Type="String" />
55.            <asp:Parameter Name="EMAIL" Type="String" />
56.            <asp:Parameter Name="PHONE" Type="String" />
57.        </InsertParameters>
58.        <UpdateParameters>
59.            <asp:Parameter Name="ROOM_ID" Type="Int32" />
60.            <asp:Parameter Name="DATE_FROM" Type="DateTime" />
61.            <asp:Parameter Name="DATE_TO" Type="DateTime" />
62.            <asp:Parameter Name="DAY" Type="Int32" />
63.            <asp:Parameter Name="RESV_STTS" Type="String" />
64.            <asp:Parameter Name="DATE_RESV" Type="DateTime" />
65.            <asp:Parameter Name="TOTALPRICE" Type="Decimal" />
66.            <asp:Parameter Name="GUEST_NAME" Type="String" />
67.            <asp:Parameter Name="GUEST_LASTNAME" Type="String" />
68.            <asp:Parameter Name="GNDR" Type="String" />
69.            <asp:Parameter Name="IDEN" Type="String" />
70.            <asp:Parameter Name="NATN" Type="String" />
71.            <asp:Parameter Name="ADDR" Type="String" />
72.            <asp:Parameter Name="EMAIL" Type="String" />
73.            <asp:Parameter Name="PHONE" Type="String" />
74.            <asp:Parameter Name="RESV_ID" Type="Int32" />
75.        </UpdateParameters>
76.        <DeleteParameters>
77.            <asp:Parameter Name="RESV_ID" Type="Int32" />
78.        </DeleteParameters>
79.    </asp:SqlDataSource>
80.    <asp:DropDownList ID="DropDownList2" runat="server">
81.    </asp:DropDownList>
82.</asp:Content>
Date : 2010-02-25 16:03:28 By : mubin
 

 

No. 3



โพสกระทู้ ( 15 )
บทความ ( 0 )



สถานะออฟไลน์


อันนี้เป็นการอัพเดททุกแถวใน gridview นะค่ะ

ลองเอาไปปรับใช้ดูได้

For i = 0 To GVSearch.Rows.Count - 1
Dim myDateLabel1 As DropDownList = CType(GVSearch.Rows(i).FindControl("ddlstatus"), DropDownList)
Try
SqlDataSourceStatus.UpdateParameters("doc_status").DefaultValue = myDateLabel1.SelectedValue.ToString
SqlDataSourceStatus.Update()
Catch ex As Exception
lbError.Text = "เกิดข้อผิดพลาด " + ex.Message
Exit Sub
End Try
Next
Date : 2010-02-26 14:59:07 By : JuB_JanG
 

 

No. 4



โพสกระทู้ ( 40 )
บทความ ( 0 )



สถานะออฟไลน์


จะต้องเอาไปวางไว้ตรงไหนครับ
Date : 2010-02-27 14:44:19 By : mubin
 

 

No. 5



โพสกระทู้ ( 74,059 )
บทความ ( 838 )

สมาชิกที่ใส่เสื้อไทยครีเอท

สถานะออฟไลน์
Twitter Facebook

Code (VB.NET)
view source
print?
001.<%@ Page Language="VB" %>
002.<%@ import Namespace="System.Data" %>
003.<%@ import Namespace="System.Data.OleDb" %>
004.<script runat="server">
005.    Dim objConn As OleDbConnection
006.    Dim objCmd As OleDbCommand
007.    Dim strSQL As String
008. 
009.    Sub Page_Load(sender As Object, e As EventArgs)
010.           Dim strConnString As String
011.           strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& _
012.           Server.MapPath("database/mydatabase2.mdb")&";"
013.           objConn = New OleDbConnection(strConnString)
014.           objConn.Open()
015. 
016.           IF Not Page.IsPostBack() Then   
017.            BindData()
018.           End IF
019.    End Sub
020. 
021.    Sub BindData()    
022.       strSQL = "SELECT * FROM customer"
023. 
024.       Dim dtReader As OleDbDataReader
025.       objCmd = New OleDbCommand(strSQL, objConn)
026.       dtReader = objCmd.ExecuteReader()
027. 
028.       '*** BindData to GridView ***'
029.       myGridView.DataSource = dtReader
030.       myGridView.DataBind()
031. 
032.       dtReader.Close()
033.       dtReader = Nothing
034. 
035.    End Sub
036. 
037.    Sub Page_UnLoad()
038.       objConn.Close()
039.       objConn = Nothing
040.    End Sub
041. 
042.    Function DataTableCountryCode() As DataTable
043.        Dim strConnString As String
044.        Dim dtAdapter As OleDbDataAdapter
045.        Dim dt As New DataTable
046.               
047.        strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& _
048.        Server.MapPath("database/mydatabase2.mdb")&";"
049.        objConn = New OleDbConnection(strConnString)
050.        objConn.Open()
051. 
052.        Dim strSQL As String       
053.        strSQL = "SELECT * FROM country"
054. 
055.        dtAdapter = New OleDbDataAdapter(strSQL, objConn)
056.        dtAdapter.Fill(dt)
057. 
058.        dtAdapter = Nothing
059. 
060.        Return dt
061. 
062.    End Function
063. 
064.    Sub modEditCommand(sender As Object, e As GridViewEditEventArgs)
065.        myGridView.EditIndex = e.NewEditIndex
066.        myGridView.ShowFooter = False
067.        BindData()
068.    End Sub
069. 
070.    Sub modCancelCommand(sender As Object, e As GridViewCancelEditEventArgs)
071.        myGridView.EditIndex = -1
072.        myGridView.ShowFooter = True
073.        BindData()
074.    End Sub
075. 
076.    Sub modDeleteCommand(sender As Object, e As GridViewDeleteEventArgs)
077.        strSQL = "DELETE FROM customer WHERE CustomerID = '" & myGridView.DataKeys.Item(e.RowIndex).Value & "'"
078.        objCmd = New OleDbCommand(strSQL, objConn)
079.        objCmd.ExecuteNonQuery()
080. 
081.        myGridView.EditIndex = -1
082.        BindData()
083.    End Sub
084. 
085. 
086.    Sub myGridView_RowCommand(source As Object, e As GridViewCommandEventArgs)
087.        If e.CommandName = "Add" Then
088.            '*** CustomerID ***'
089.            Dim txtCustomerID As TextBox = CType(myGridView.FooterRow.FindControl("txtAddCustomerID"), TextBox)
090.            '*** Name ***'
091.            Dim txtName As TextBox = CType(myGridView.FooterRow.FindControl("txtAddName"), TextBox)
092.            '*** Email ***'
093.            Dim txtEmail As TextBox = CType(myGridView.FooterRow.FindControl("txtAddEmail"), TextBox)
094.            '*** CountryCode ***'
095.            Dim ddlCountryCode As DropDownList = CType(myGridView.FooterRow.FindControl("ddlAddCountryCode"), DropDownList)
096.            '*** Budget ***'
097.            Dim txtBudget As TextBox = CType(myGridView.FooterRow.FindControl("txtAddBudget"), TextBox)
098.            '*** Used ***'
099.            Dim txtUsed As TextBox = CType(myGridView.FooterRow.FindControl("txtAddUsed"), TextBox)
100. 
101.            strSQL = "INSERT INTO customer (CustomerID,Name,Email,CountryCode,Budget,Used) " & _
102.            " VALUES ('" & txtCustomerID.Text & "','" & txtName.Text & "','" & txtEmail.Text & "' " & _
103.            " ,'" & ddlCountryCode.SelectedItem.Value & "','" & txtBudget.Text & "','" & txtUsed.Text & "') "
104.            objCmd = New OleDbCommand(strSQL, objConn)
105.            objCmd.ExecuteNonQuery()
106. 
107.            BindData()
108.        End If
109.    End Sub
110.     
111.    Sub myGridView_RowDataBound(source As Object, e As GridViewRowEventArgs)
112.             
113.            '*** Footer ***'
114.            IF e.Row.RowType = DataControlRowType.Footer Then
115. 
116.                '*** CountryCode ***'
117.                Dim ddlCountryCode As DropDownList = CType(e.Row.FindControl("ddlAddCountryCode"), DropDownList)
118.                IF Not IsNothing(ddlCountryCode) Then
119.                    With ddlCountryCode
120.                        .DataSource = DataTableCountryCode
121.                        .DataTextField = "CountryName"
122.                        .DataValueField = "CountryCode"
123.                        .DataBind()
124.                    End With                       
125.                End IF
126. 
127.            End IF
128. 
129.            '*** Edit ***'
130.            IF e.Row.RowType = DataControlRowType.DataRow Then
131. 
132.                '*** CustomerID ***'
133.                Dim txtCustomerID As TextBox = CType(e.Row.FindControl("txtEditCustomerID"), TextBox)
134.                IF Not IsNothing(txtCustomerID) Then
135.                    txtCustomerID.Text = e.Row.DataItem("CustomerID")
136.                End IF
137.                '*** Name ***'
138.                Dim txtName As TextBox = CType(e.Row.FindControl("txtEditName"), TextBox)
139.                IF Not IsNothing(txtName) Then
140.                    txtName.Text = e.Row.DataItem("Name")
141.                End IF
142.                '*** Email ***'
143.                Dim txtEmail As TextBox = CType(e.Row.FindControl("txtEditEmail"), TextBox)
144.                IF Not IsNothing(txtEmail) Then
145.                    txtEmail.Text = e.Row.DataItem("Email")
146.                End IF
147.                '*** CountryCode ***'
148.                Dim ddlCountryCode As DropDownList = CType(e.Row.FindControl("ddlEditCountryCode"), DropDownList)
149.                IF Not IsNothing(ddlCountryCode) Then
150.                    With ddlCountryCode
151.                        .DataSource = DataTableCountryCode
152.                        .DataTextField = "CountryName"
153.                        .DataValueField = "CountryCode"
154.                        .DataBind()                    
155.                    End With                       
156.                    ddlCountryCode.SelectedIndex = ddlCountryCode.Items.IndexOf(ddlCountryCode.Items.FindByValue(e.Row.DataItem("CountryCode")))
157.                End IF
158.                '*** Budget ***'
159.                Dim txtBudget As TextBox = CType(e.Row.FindControl("txtEditBudget"), TextBox)
160.                IF Not IsNothing(txtBudget) Then
161.                    txtBudget.Text = e.Row.DataItem("Budget")
162.                End IF
163.                '*** Used ***'
164.                Dim txtUsed As TextBox = CType(e.Row.FindControl("txtEditUsed"), TextBox)
165.                IF Not IsNothing(txtUsed) Then
166.                    txtUsed.Text = e.Row.DataItem("Used")
167.                End IF
168. 
169.            End IF
170. 
171.    End Sub
172. 
173.    Sub modUpdateCommand(s As Object, e As GridViewUpdateEventArgs)
174. 
175.        '*** CustomerID ***'
176.        Dim txtCustomerID As TextBox = CType(myGridView.Rows(e.RowIndex).FindControl("txtEditCustomerID"), TextBox)
177.        '*** Name ***'
178.        Dim txtName As TextBox = CType(myGridView.Rows(e.RowIndex).FindControl("txtEditName"), TextBox)
179.        '*** Email ***'
180.        Dim txtEmail As TextBox = CType(myGridView.Rows(e.RowIndex).FindControl("txtEditEmail"), TextBox)
181.        '*** CountryCode ***'
182.        Dim ddlCountryCode As DropDownList = CType(myGridView.Rows(e.RowIndex).FindControl("ddlEditCountryCode"), DropDownList)
183.        '*** Budget ***'
184.        Dim txtBudget As TextBox = CType(myGridView.Rows(e.RowIndex).FindControl("txtEditBudget"), TextBox)
185.        '*** Used ***'
186.        Dim txtUsed As TextBox = CType(myGridView.Rows(e.RowIndex).FindControl("txtEditUsed"), TextBox)
187. 
188.        strSQL = "UPDATE customer SET CustomerID = '" & txtCustomerID.Text & "' " & _
189.        " ,Name = '" & txtName.Text & "' " & _
190.        " ,Email = '" & txtEmail.Text & "' " & _
191.        " ,CountryCode = '" & ddlCountryCode.SelectedItem.Value & "' " & _
192.        " ,Budget = '" & txtBudget.Text & "' " & _
193.        " ,Used = '" & txtUsed.Text & "' " & _
194.        " WHERE CustomerID = '" & myGridView.DataKeys.Item(e.RowIndex).Value & "'"
195.        objCmd = New OleDbCommand(strSQL, objConn)
196.        objCmd.ExecuteNonQuery()
197. 
198.        myGridView.EditIndex = -1
199.        myGridView.ShowFooter = True
200.        BindData()
201.    End Sub
202. 
203.</script>
204.<html>
205.<head>
206.    <title>ThaiCreate.Com ASP.NET - GridView</title>
207.</head>
208.<body>
209.<form id="form1" runat="server">
210.<asp:GridView id="myGridView" runat="server" AutoGenerateColumns="False"
211.    ShowFooter="True"
212.    DataKeyNames="CustomerID"
213.    OnRowEditing="modEditCommand"
214.    OnRowCancelingEdit="modCancelCommand"
215.    OnRowDeleting="modDeleteCommand"
216.    OnRowUpdating="modUpdateCommand"
217.    OnRowCommand="myGridView_RowCommand"
218.    OnRowDataBound="myGridView_RowDataBound">
219. 
220.    <Columns>
221. 
222.    <asp:TemplateField HeaderText="CustomerID">
223.        <ItemTemplate>
224.            <asp:Label id="lblCustomerID" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.CustomerID") %>'></asp:Label>
225.        </ItemTemplate>
226.        <EditItemTemplate>
227.            <asp:TextBox id="txtEditCustomerID" size="5" runat="server"></asp:TextBox>
228.        </EditItemTemplate>
229.        <FooterTemplate>
230.            <asp:TextBox id="txtAddCustomerID" size="5" runat="server"></asp:TextBox>
231.        </FooterTemplate>
232.    </asp:TemplateField>
233. 
234.    <asp:TemplateField HeaderText="Name">
235.        <ItemTemplate>
236.            <asp:Label id="lblName" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Name") %>'></asp:Label>
237.        </ItemTemplate>
238.        <EditItemTemplate>
239.            <asp:TextBox id="txtEditName" size="10" runat="server"></asp:TextBox>
240.        </EditItemTemplate>
241.        <FooterTemplate>
242.            <asp:TextBox id="txtAddName" size="10" runat="server"></asp:TextBox>
243.        </FooterTemplate>
244.    </asp:TemplateField>
245. 
246.    <asp:TemplateField HeaderText="Email">
247.        <ItemTemplate>
248.            <asp:Label id="lblEmail" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Email") %>'></asp:Label>
249.        </ItemTemplate>
250.        <EditItemTemplate>
251.            <asp:TextBox id="txtEditEmail" size="20" runat="server"></asp:TextBox>
252.        </EditItemTemplate>
253.        <FooterTemplate>
254.            <asp:TextBox id="txtAddEmail" size="20" runat="server"></asp:TextBox>
255.        </FooterTemplate>
256.    </asp:TemplateField>
257. 
258.    <asp:TemplateField HeaderText="CountryCode">
259.        <ItemTemplate>
260.            <asp:Label id="lblCountryCode" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.CountryCode") %>'></asp:Label>
261.        </ItemTemplate>
262.        <EditItemTemplate>
263.            <asp:DropDownList id="ddlEditCountryCode" runat="server"></asp:DropDownList>
264.        </EditItemTemplate>
265.        <FooterTemplate>
266.            <asp:DropDownList id="ddlAddCountryCode" runat="server"></asp:DropDownList>
267.        </FooterTemplate>
268.    </asp:TemplateField>
269. 
270.    <asp:TemplateField HeaderText="Budget">
271.        <ItemTemplate>
272.            <asp:Label id="lblBudget" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Budget") %>'></asp:Label>
273.        </ItemTemplate>
274.        <EditItemTemplate>
275.            <asp:TextBox id="txtEditBudget" size="6" runat="server"></asp:TextBox>
276.        </EditItemTemplate>
277.        <FooterTemplate>
278.            <asp:TextBox id="txtAddBudget" size="6" runat="server"></asp:TextBox>
279.        </FooterTemplate>
280.    </asp:TemplateField>
281. 
282.    <asp:TemplateField HeaderText="Used">
283.        <ItemTemplate>
284.            <asp:Label id="lblUsed" runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Used") %>'></asp:Label>
285.        </ItemTemplate>
286.        <EditItemTemplate>
287.            <asp:TextBox id="txtEditUsed" size="6" runat="server"></asp:TextBox>
288.        </EditItemTemplate>
289.        <FooterTemplate>
290.            <asp:TextBox id="txtAddUsed" size="6" runat="server"></asp:TextBox>
291.            <asp:Button id="btnAdd" runat="server" Text="Add" CommandName="Add"></asp:Button>
292.        </FooterTemplate>
293.    </asp:TemplateField>
294. 
295.    <asp:CommandField ShowEditButton="True" CancelText="Cancel" DeleteText="Delete" EditText="Edit" UpdateText="Update" HeaderText="Modify"  />
296.    <asp:CommandField ShowDeleteButton="True" HeaderText="Delete" />
297.     
298.    </Columns>
299.</asp:GridView>
300.</form>
301.</body>
302.</html>
Date : 2010-09-10 15:17:23 By : webmaster
 

 

No. 6



โพสกระทู้ ( 74,059 )
บทความ ( 838 )

สมาชิกที่ใส่เสื้อไทยครีเอท

สถานะออฟไลน์
Twitter Facebook

Go to : ASP.NET GridView Control - DropDownList in GridView
Date : 2010-09-10 17:42:02 By : webmaster
 

   

ค้นหาข้อมูล
   
 

แสดงความคิดเห็น
Re : จะนำ dropdownlist ไปใส่ใน gridview เพื่อที่จะEdit ได้อย่างไรครับ
 
 
รายละเอียด
 
ตัวหนา ตัวเอียง ตัวขีดเส้นใต้ ตัวมีขีดกลาง| ตัวเรืองแสง ตัวมีเงา ตัวอักษรวิ่ง| จัดย่อหน้าอิสระ จัดย่อหน้าชิดซ้าย จัดย่อหน้ากึ่งกลาง จัดย่อหน้าชิดขวา| เส้นขวาง| ขนาดตัวอักษร แบบตัวอักษร
ใส่แฟลช ใส่รูป ใส่ไฮเปอร์ลิ้งค์ ใส่อีเมล์ ใส่ลิ้งค์ FTP| ใส่แถวของตาราง ใส่คอลัมน์ตาราง| ตัวยก ตัวห้อย ตัวพิมพ์ดีด| ใส่โค้ด ใส่การอ้างถึงคำพูด| ใส่ลีสต์
smiley for :lol: smiley for :ken: smiley for :D smiley for :) smiley for ;) smiley for :eek: smiley for :geek: smiley for :roll: smiley for :erm: smiley for :cool: smiley for :blank: smiley for :idea: smiley for :ehh: smiley for :aargh: smiley for :evil:
Insert PHP Code
Insert ASP Code
 Insert VB.NET Code Insert C#.NET Code Insert JavaScript Code Insert C#.NET Code
Insert Java Code
Insert Android Code
Insert Objective-C Code
Insert XML Code
Insert SQL Code
Insert Code
เพื่อความเรียบร้อยของข้อความ ควรจัดรูปแบบให้พอดีกับขนาดของหน้าจอ เพื่อง่ายต่อการอ่านและสบายตา และตรวจสอบภาษาไทยให้ถูกต้อง

อัพโหลดแทรกรูปภาพ

Notice

เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ
อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง

   
  เพื่อความปลอดภัยและการตรวจสอบ กระทู้ที่แทรกไฟล์อัพโหลดไฟล์จากที่อื่น อาจจะถูกลบทิ้ง
 
โดย
อีเมล์
บวกค่าให้ถูก
<= ตัวเลขฮินดูอารบิก เช่น 123 (หรือล็อกอินเข้าระบบสมาชิกเพื่อไม่ต้องกรอก)





ThaiCreate.Com Logo
© www.ThaiCreate.Com. 2003-2025 All Rights Reserved.
ไทยครีเอทบริการ จัดทำดูแลแก้ไข Web Application ทุกรูปแบบ (PHP, .Net Application, VB.Net, C#)
[Conditions Privacy Statement] ติดต่อโฆษณา 081-987-6107 อัตราราคา คลิกที่นี่