GridView .net訪問

標籤：style   class   code   tar   ext   com   

HTML code

 

1. <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowDeleting="GridView1_RowDeleting">  
2.     <Columns>   
3.         <asp:BoundField DataField="id" HeaderText="id" />  
4.         <asp:BoundField DataField="name" HeaderText="name" />  
5.         <asp:TemplateField ShowHeader="False">  
6.             <ItemTemplate>  
7.                 <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Delete"  
8.                     Text="刪除" OnClientClick=‘<%#  "if (!confirm(\"你確定要刪除" + Eval("name").ToString() + "嗎?\")) return false;"%>‘></asp:LinkButton>  
9.             </ItemTemplate>  
10.         </asp:TemplateField>  
11.     </Columns>  
12.  </asp:GridView>  

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowDeleting="GridView1_RowDeleting"> <Columns> <asp:BoundField DataField="id" HeaderText="id" /> <asp:BoundField DataField="name" HeaderText="name" /> <asp:TemplateField ShowHeader="False"> <ItemTemplate> <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Delete" Text="刪除" OnClientClick=‘<%# "if (!confirm(\"你確定要刪除" + Eval("name").ToString() + "嗎?\")) return false;"%>‘></asp:LinkButton> </ItemTemplate> </asp:TemplateField> </Columns></asp:GridView>


C# code

1. private void BindGridView()   
2. {   
3.     SqlConnection cn = new SqlConnection(@"server=.\SQLExpress;uid=sa;pwd=;database=Demo");   
4.     SqlDataAdapter da = new SqlDataAdapter("select id, name from yourtable", cn);   
5.     DataSet ds = new DataSet();   
6.     cn.Open();   
7.     da.Fill(ds);   
8.     cn.Close();   
9.     GridView1.DataSource = ds.Tables[0].DefaultView;   
10.     GridView1.DataKeyNames = new string[] { "id" };   
11.     GridView1.DataBind();   
12. }   
13.   
14. protected void Page_Load(object sender, EventArgs e)   
15. {   
16.     if (!IsPostBack)   
17.     {   
18.         BindGridView();   
19.     }   
20. }   
21.   
22. protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)   
23. {   
24.     string strSql = "delete from yourtable where id = @id";   
25.     SqlConnection cn = new SqlConnection(@"server=.\SQLExpress;uid=sa;pwd=;database=Demo");   
26.     SqlCommand cmd = new SqlCommand(strSql, cn);   
27.     cmd.Parameters.Add("@id", SqlDbType.VarChar, 11).Value = GridView1.DataKeys[e.RowIndex].Value.ToString();   
28.     cn.Open();   
29.     cmd.ExecuteNonQuery();   
30.     cn.Close();   
31.     BindGridView();   
32. }