Problem DatagridView C # asp [closed]

1

Good morning, please help me:

I'm doing a datagridview where you can view it from the database. that in my datagridview has these columns as image: * Ticket

  • Days Missing.

  • Date

  • State

  • Visualize

Where it says visualize I want that when pressing click they go away those data that are in datagridview another web page with asp c # I would like you to help me please to make the insertion in my datagrid I use this code:

<asp:DataGrid ID="DtgConsultaIncidencia" runat="server" AllowPaging="True" AutoGenerateColumns="False" Font-Bold="False" 
              Font-Italic  ="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center"
              Width="100%" BorderColor="Gray" BorderWidth="1px" CellPadding="1" ItemStyle-Height="23px" BorderStyle="Double" CellSpacing="1" GridLines="None" AllowSorting="True" OnSelectedIndexChanged="DtgConsultaIncidencia_SelectedIndexChanged">
    <AlternatingItemStyle BackColor="#F8F8F8" Font-Bold="False" Font-Italic="False" Font-Names="Arial, Helvetica, sans-serif" Font-Overline="False" Font-Size="11px" Font-Strikeout="False" Font-Underline="False" VerticalAlign="Middle" Wrap="False" />
    <Columns>

        <asp:BoundColumn DataField="IdRegistroTareas" HeaderText="Ticket" ReadOnly="True">
            <HeaderStyle Width="8%" />

        </asp:BoundColumn>
        <asp:BoundColumn DataField="DiasFaltantes" HeaderText="Dias Falta." ReadOnly="True">
            <HeaderStyle Width="8%" />
        </asp:BoundColumn>
        <asp:BoundColumn DataField="ReportadoPor" HeaderText="Reportado Por" ReadOnly="True" Visible="False">
            <HeaderStyle Width="9%"/>
        </asp:BoundColumn>
        <asp:BoundColumn DataField="Fecharegistro" HeaderText="Fecha" ReadOnly="True" DataFormatString="{0:d}">
            <HeaderStyle Width="8%"/>
            <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" />
        </asp:BoundColumn>
        <asp:BoundColumn DataField="Agencia" HeaderText="Agencia" ReadOnly="True" Visible="False">
            <HeaderStyle Width="8%"/>
        </asp:BoundColumn>
        <asp:BoundColumn DataField="IdTarea" HeaderText="TipoIncidencia" ReadOnly="True">
            <HeaderStyle Width="12%"/>
            <ItemStyle Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Left" />
        </asp:BoundColumn>

        <asp:BoundColumn DataField="IdEstadoTarea" HeaderText="Estado" ReadOnly="True">
            <HeaderStyle Width="10%"/>
        </asp:BoundColumn>
        <asp:ButtonColumn CommandName="Visualizar" HeaderText="Visualizar" Text="--&gt;">
            <HeaderStyle Width="8%" />
        </asp:ButtonColumn>
    </Columns>
    <EditItemStyle BorderColor="Gray" BorderStyle="Double" BorderWidth="1px" />
    <FooterStyle BorderColor="Gray" BorderStyle="Double" BorderWidth="1px" />
    <HeaderStyle Height="25px" BackColor="WhiteSmoke" Font-Bold="True" Font-Italic="False" Font-Names="Arial, Helvetica, sans-serif" Font-Overline="False" Font-Size="11px" Font-Strikeout="False" Font-Underline="False" ForeColor="Black" HorizontalAlign="Center" VerticalAlign="Middle" BorderColor="Gray" BorderStyle="Double" BorderWidth="1px" />
    <ItemStyle Font-Bold="False" Font-Italic="False" Font-Names="Arial, Helvetica, sans-serif" Font-Overline="False" Font-Size="11px" Font-Strikeout="False" Font-Underline="False" VerticalAlign="Middle" BorderColor="Gray" BorderStyle="Double" BorderWidth="1px" />
    <PagerStyle BorderColor="Gray" BorderStyle="Double" BorderWidth="1px" />
    <SelectedItemStyle BorderColor="Gray" BorderStyle="Double" BorderWidth="1px" />
</asp:DataGrid>
SqlConnection conn = new SqlConnection();
            conn = new SqlConnection("server=172.16.1.124;    database=DBProAuxQP_QA;      user id=sa;                   password=SA123456789*;");
            conn.Open();
            string query = "SELECT * FROM TTareasIngreso ";
            SqlCommand cmd = new SqlCommand(query, conn);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);

            DtgConsultaIncidencia.DataSource = dt;

            DtgConsultaIncidencia.DataBind();

    
asked by PieroDev 08.03.2017 в 23:00
source

0 answers