<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="MFLv1.aspx.cs" Inherits="Project_SAR.MFL1" %> อันนี้ใช้ได้
<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="MFlv2.aspx.cs" Inherits="Project_SAR.MFlv2" %> ใช้ไม่ได้ ทั้งที่เหมือนกันเป๊ะ
<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="M2FV2.aspx.cs" Inherits="Project_SAR.MFL1" %> <asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server"> </asp:Content> <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server"> <br /> <br /><br /> <br /> <br /> <br /> <asp:GridView ID="GridView1" runat="server" style="width: 100%;" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Vertical" AutoGenerateColumns="False" onrowcommand="GridView1_RowCommand"> <AlternatingRowStyle BackColor="#DCDCDC" /> <Columns> <asp:TemplateField HeaderText="Group ID"> <EditItemTemplate> <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="GrpID" runat="server" Text='<%# Bind("A1GRID") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Group Name in Eng"> <EditItemTemplate> <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="GrpnameE" runat="server" Text='<%# Bind("A1NMEN") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Description Eng"> <EditItemTemplate> <asp:TextBox ID="TextBox5" runat="server"></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="GrpDesE" runat="server" Text='<%# Bind("A1DESE") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Group Name in Thai"> <EditItemTemplate> <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="GrpnameT" runat="server" Text='<%# Bind("A1NMTH") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Description Thai"> <EditItemTemplate> <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox> </EditItemTemplate> <ItemTemplate> <asp:Label ID="GrpDesT" runat="server" Text='<%# Bind("A1DEST") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField> <ItemTemplate> <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="false" CommandArgument='<%# Bind("A2GRID") %><%# Bind("A2TYID") %>' CommandName="Edit" Text="Edit"></asp:LinkButton> <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="false" CommandArgument='<%# Bind("A2GRID") %><%# Bind("A2TYID") %>' CommandName="Delete" Text="Delete"></asp:LinkButton> </ItemTemplate> <HeaderTemplate><asp:LinkButton ID="LinkButton3" runat="server" CausesValidation="false" CommandArgument="Insert" CommandName="Insert" Text="Insert"></asp:LinkButton></HeaderTemplate> <ItemStyle Width="80px" /> </asp:TemplateField> </Columns> <FooterStyle BackColor="#CCCCCC" ForeColor="Black" /> <HeaderStyle BackColor="Blue" Font-Bold="True" ForeColor="White" Height="30" /> <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" /> <RowStyle BackColor="#EEEEEE" ForeColor="Black" HorizontalAlign="Center" Height="20" Font-Size="12" /> <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" /> <SortedAscendingCellStyle BackColor="#F1F1F1" /> <SortedAscendingHeaderStyle BackColor="#0000A9" /> <SortedDescendingCellStyle BackColor="White" /> <SortedDescendingHeaderStyle BackColor="#000065" /> </asp:GridView> </asp:Content>
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.OleDb; using System.Web.Configuration; namespace Project_SAR { public partial class MFL1 : System.Web.UI.Page { string StrConAS400 = WebConfigurationManager.ConnectionStrings["SMCAS400"].ConnectionString; protected void Page_Load(object sender, EventArgs e) { if (Session["LEVEL"] == null || Session["ID"] == null) { Response.Redirect("dEFAULT.ASPX"); } Dataread(); } protected void Dataread() { string SqlTmp; OleDbConnection ConAS400 = new OleDbConnection (StrConAS400); ConAS400.Open(); SqlTmp = "Select * from SMCDTA.CLPACGR where A1STAT <> 'D'"; OleDbCommand Comm = new OleDbCommand(); OleDbDataReader Dr; //ใช้อ่านข้อมูล Comm.Connection = ConAS400; Comm.CommandType = CommandType.Text; Comm.CommandText = SqlTmp; //ต้องจำ Dr = Comm.ExecuteReader(); // เปิดอ่านอย่างเดียว if (Dr.HasRows) { DataTable Dt = new DataTable(); Dt.Load(Dr); GridView1.DataSource = Dt; GridView1.DataBind(); Dr.Close(); Dr = null; } } protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { string ID = Session["GRID"].ToString(); string LV = Session["LEVEL"].ToString(); int level = Convert.ToInt32(LV); if (e.CommandName == "Edit") { Session["GRPID"] = Convert.ToString(e.CommandArgument); Session["Command"] = Convert.ToString(e.CommandName); Session["GID"] = ID; Session["ULV"] = level; Response.Redirect("Master1Edit.aspx"); } else if (e.CommandName == "Delete") { Session["GID"] = ID; Session["GRPID"] = Convert.ToString(e.CommandArgument); Session["Command"] = Convert.ToString(e.CommandName); Session["ULV"] = level; Response.Redirect("Master1Edit.aspx"); } else if (e.CommandName == "Insert") { Session["GID"] = ID; Session["Command"] = Convert.ToString(e.CommandName); Session["ULV"] = level; Response.Redirect("Master1Edit.aspx"); } } } }
<asp:TemplateField ShowHeader="False"> <HeaderTemplate> <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Insert" Text="Insert" CommandArgument="Insert"></asp:LinkButton> </HeaderTemplate> <ItemTemplate> <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit" CommandArgument='<%# Bind("A2TYID") %>'></asp:LinkButton> <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Delete" Text="Delete" CommandArgument='<%# Bind("A2GRID") %><%# Bind("A2TYID") %>'></asp:LinkButton> </ItemTemplate> </asp:TemplateField>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
