Torna al Thread

Dim source2 As String = WebConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString Dim sql2 As String = "SELECT DATEDIFF (Day,Dal, Al) FROM Tab1 WHERE Codfisc = '" & Me.GridView1.SelectedRow.Cells(8).Text & "'" Dim conn2 As New SqlConnection(source2) conn2.Open() Dim cmd2 As New SqlCommand(sql2, conn2) cmd2.Parameters.AddWithValue("@Codfisc", Me.GridView1.SelectedRow.Cells(8).Text) cmd2.Parameters.AddWithValue("@Dal", TextBox2.Text) cmd2.Parameters.AddWithValue("@Al", TextBox3.Text) Dim dr2 As SqlDataReader dr2 = cmd2.ExecuteReader() While dr2.Read() TextBox4.Text = dr2("Day").ToString() End While conn2.Close()
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5