[Problem] VB.NET with datatables

[Problem] VB.NET with datatables

n1c0t0pn1c0t0p Posts: 3Questions: 0Answers: 0
edited July 2014 in Free community support

Hello to everyone!

I am using a template from themeforest.com, and have your plugin.

the theme is Avant.

in your datatables, i need to use the data from SQL and input with the vb.net

and this is the result:


The datatable doest count the rows of information i have. Can anyone explain to me this problem?



div class="tab-container tab-success">

    <div class="container tab-pane" id="apolice">
        <div class="row">
          <div class="col-md-12">
                    <div class="table-responsive collapse in panel panel-sky">
                        <br />
                        <table cellpadding="0" cellspacing="0" border="0" class="table table-striped table-bordered datatables" id="example">
                                                            <th>Data de Inicio</th>
                                                            <th>Data Termo</th>
                                                            <th>Número de Apólice</th>
                                  If SQL.Connect Then
                                      Cmd = New SqlCommand("SELECT * FROM vwClientes_Apolices_Completo WHERE contacto_id=" & contacto_id.ToString & " ORDER BY data_inicio", CDSI.SQLServer)
                                      Rs = Cmd.ExecuteReader()

                                      If Rs.HasRows Then
                                          While Rs.Read()
                                              If Not IsDBNull(Rs.Item("apolice_id")) Then
                                                  Me.FXdata_inicio.Text = String.Format("{0:yyyy/MM/dd}", Rs.Item("data_inicio"))
                                                  Me.FXdata_termo.Text = String.Format("{0:yyyy/MM/dd}", Rs.Item("data_termo"))
                                                  Me.FXnum_apolice.Text = Rs.Item("apolice_no").ToString
                                                  Me.FXtipo.Text = Rs.Item("tipo").ToString
                                                  Me.FXseguradora.Text = Rs.Item("seguradora").ToString
                                                  Me.FXramo.Text = Rs.Item("ramo").ToString
                                                  Me.FXrisco.Text = Rs.Item("risco").ToString
                                                  Me.FXpremio.Text = String.Format("{0:0,0.00€}", Rs.Item("premio_total"))


                                                            <td><asp:Label ID="FXdata_inicio" runat="server" Text=""></asp:Label></td>
                                                            <td><asp:Label ID="FXdata_termo" runat="server" Text=""></asp:Label></td>
                                                            <td><asp:Label ID="FXnum_apolice" runat="server" Text=""></asp:Label></td>                                                              
                                                            <td><asp:Label ID="FXtipo" runat="server" Text=""></asp:Label></td>
                                                            <td><asp:Label ID="FXseguradora" runat="server" Text=""></asp:Label></td>
                                                            <td><asp:Label ID="FXramo" runat="server" Text=""></asp:Label></td>
                                                            <td><asp:Label ID="FXrisco" runat="server" Text=""></asp:Label></td>
                                                            <td><asp:Label ID="FXpremio" runat="server" Text=""></asp:Label></td>
                                              End If
                                          End While
                                      End If
                                  End If

                                  If Not Rs.IsClosed Then Rs.Close()


Best Regards,

Pedro Cruz


This discussion has been closed.