Database

"Data Source = https://sbbMedical.com\localhost; Initial Catalog = sbbmhcom_medihealth;Integrated Security=False;User Id= '" & UserIdTextBox.Text & "'; Password= '" &PasswordTextBox.Text &"'"

"Data Source =VUYISWA\SQLEXPRESS; Database= sbbmhcom_medihealth;Integrated Security=False;User Id= '" & UserIdTextBox.Text & "'; Password= '" &PasswordTextBox.Text &"'"

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <appSettings>

    <add key ="MyCon" value ="User id= UserIdTextBox.Text;
    Password=PasswordTextBox.Text;Data Source =mark.internet-webhosting.com\SQLEXPRESS;Trusted_Connection=Yes; Database=sbbmhcom_TESTDB"></add>
    
      </appSettings>

</configuration>

Dim str As String = System.Configuration.ConfigurationManager.AppSettings("MyCon")
            'open connection
             myConnection.ConnectionString = (str)
            myConnection.Open()

Case When size1 is null then 'S' else
   Case when size2 is null then 's1' else
      Case when size3 is null then 's2'
end end end as Size

CREATE PROC sp_MyProc (@ItemID AS INT)
AS
BEGIN
   SELECT *
   FROM   myTable
   WHERE  ItemID=isNull(@ItemID,ItemID)
END

SELECT *
FROM   myTable
WHERE  @ItemID IS NULL OR ItemId = @ItemId

IF @ItemID IS NULL 
BEGIN
   SELECT * FROM myTable; 
END
ELSE
BEGIN
   DECLARE @like NVARCHAR(6) 
   SET @like = '%' + CAST(@ItemID AS NVARCHAR(5))
   SELECT * FROM MyTable WHERE ItemID LIKE %like; 
END