ASP.NET

<br />
Imports System.Data<br />
Imports System.Data.SqlClient<br />
Imports System.Configuration<br />
Partial Class _Default<br />
    Inherits System.Web.UI.Page<br />
<br />
    <br />
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load<br />
        Dim MyConnection As SqlConnection<br />
        Dim cmd As SqlCommand<br />
        MyConnection = New SqlConnection()<br />
        MyConnection.ConnectionString = ConfigurationManager.ConnectionStrings("Local_DB").ConnectionString<br />
        MyConnection.Open()<br />
        cmd = New SqlCommand("Select * from empl", MyConnection)<br />
        GridView1.DataSource = cmd.ExecuteReader()<br />
        GridView1.DataBind()<br />
        MyConnection.Close()<br />
    End Sub<br />
    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click<br />
        Dim MyConnection As SqlConnection<br />
        Dim cmd As SqlCommand<br />
        MyConnection = New SqlConnection()<br />
        MyConnection.ConnectionString = ConfigurationManager.ConnectionStrings("Local_DB").ConnectionString<br />
        MyConnection.Open()<br />
        'Dim MySQL As String = "Insert into NewEmp (fname, LName, Address, City, State, Postalcode, Phone, Email) Values (@Firstname, @LastName, @Address, @City, @State, @Postalcode, @Phone, @Email)"<br />
<br />
        Dim MySQL As String = "Insert into empl (name1) Values (@name1)"<br />
        cmd = New SqlCommand(MySQL, MyConnection)<br />
        cmd.Parameters.Add(New SqlParameter("@name1", SqlDbType.VarChar, 11))<br />
        cmd.Parameters("@name1").Value = TextBox1.Text<br />
        cmd.ExecuteNonQuery()<br />
        MyConnection.Close()<br />
<br />
    End Sub<br />
<br />
End Class<br />
<br />

amistry_petlad wrote:

SqlDbType.VarChar