I cant connect to sql server : I cant connect to sql server using vb.net.
Here is the code

Imports system.data.sqlclient
PUBLIC CLASS- customer typer
Dim connectionstring as string = "data source = wisdon; initial catalog = stock_management; user id = sa; password = managerz "

 Dim mycommand as new sqlcommand
Dim myconnection = new sqlcomma d (connectionstring)

PRIVATE SUB CUSTOMER_BT
dim sqlstr as string
Sqlstr = (" insert into customer_type(customer_type) value" - &"(' " & customertyper_txt.text & " ')
Mycommand = new sqlclient.sqlcommand (sqlstr, myconnection)

Mycommand.executeNonQuery ()

Myconnection.close


Customer_type is the button i am writing the code

Customertype_txt is the textbox
