Hi

I write the below code for view the sql data in the asp.net text box.This code is running no error.But no output that is not view in the text box.Is any error?Please Reply to me.

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connectionstring As String
Dim connection As New SqlConnection
Dim command As New SqlCommand

Dim strProject As String = "Project1"


connectionstring = "Persist Security Info=False;User ID=sa;Initial Catalog=dbmDirectCP;Data Source=IWAPPSVR\IWSQLDB"

connection = New SqlConnection(connectionstring)

command = connection.CreateCommand()

connection.Open()

If Label1.Text = "Project1" Then

TextBox1.ReadOnly = True

command.CommandText = "select strProjectDesc from tblProject where strProjectName='" & strProject & "'"

command.ExecuteNonQuery()


End If

Thanks