.NET (Core and Framework)

Dear folks.

I am writing a program for connecting sql server database, and populating data from table using a stored procedure. it is working fine when I use the app.config file's data source as the server name, but when I use the server's ip address and port, it is not working. 

it is showing error, stored procedure not found.

My app config's connection string is as below.

<connectionStrings>  
      <clear />  
      <add name="CONNECTION_FLOR"
       providerName="Microsoft.Data.SqlClient"
       connectionString="Data Source=172.142.1.100,1433;User ID=redacted;Password=redacted;Initial Catalog=tempdb;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False" />  
      </connectionStrings>

But when I use Data Source by name as Data Source=(localdb)\SubdivprojV13; it is working all good. The problem is with ip address and port. I checked the connection, connection is opening. But showing error as stored procedure not found.


please check my code snippet.

Public Class Form1
    Dim connection As New SqlConnection(ConfigurationManager.ConnectionStrings("CONNECTION_FLOR").ConnectionString)
    Private Sub BTN_DISPLAY_Click(sender As Object, e As EventArgs) Handles BTN_DISPLAY.Click
        Dim cmd As New SqlCommand With {
            .Connection = connection,
            .CommandType = CommandType.StoredProcedure,
            .CommandText = "SP_DISPLAY"
        }
        cmd.Connection.Open()
        lbl_CONN.Text = "Connected"
        lbl_CONN.ForeColor = Color.Green

        Dim dt As DataTable = New DataTable()
        dt.Load(cmd.ExecuteReader)
        DataGridView1.DataSource = dt
        DataGridView1.Update()

        If connection.State = ConnectionState.Open Then
            connection.Close()
            lbl_CONN.Text = "DisConnected"
            lbl_CONN.ForeColor = Color.Red
        End If
    End Sub
End Class

Any help is highly appreciated. Thanks in advance,.

using (SQLiteCommand cmd =      conn.CreateCommand())
         {
          try
         {
    
         cmd.CommandText = @"SELECT * FROM.  customer WHERE lastname = @setName";
    
        cmd.Parameters.AddWithValue("@setName", txt_name.Text);
    
        da_Customer = new SQLiteDataAdapter(cmd.CommandText, conn);
         dt_Customer = new DataTable();
        da_Customer.Fill(dt_Customer);
        dgv_customer.DataSource = dt_Customer;
        }
         catch (Exception ex)
       {
        MessageBox.Show(ex.Message);
         }
         }