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="-->">
<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();