command.Parameters.AddWithValue("@number", TextBox1.Text)

[Fenerbahce]

command.Parameters.AddWithValue("@number", TextBox1.Text)

can i do this from another way?

[Paladine]

Not sure what you are asking? Why can't you use this method?

[Fenerbahce]

when i try to search something, program give me this error; Must declare the variable [EMAIL="'@number'"]'@number'[/EMAIL] on this line; DataGridView2.DataMember = "mutsuz".

full code is this.

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click

Dim baglanti As New SqlClient.SqlConnection()
Dim dataadapter As SqlClient.SqlDataAdapter
Dim command As New SqlClient.SqlCommand
Dim dataset As New DataSet
baglanti.ConnectionString = "data source=zengin\instance2000;" & "initial catalog=inandbf;" & "integrated security= SSPI"
baglanti.Open()
command = baglanti.CreateCommand
command.CommandText = "select number, name, surname from veriler where number=@number"
command.Parameters.AddWithValue("@number", TextBox1.Text)
dataadapter = New SqlClient.SqlDataAdapter(command.CommandText, baglanti)
dataadapter.Fill(dataset, "mutsuz")
DataGridView2.DataSource = dataset
DataGridView2.DataMember = "mutsuz"
baglanti.Close()
End Sub

[Fenerbahce]

sorry, error comes on this line dataadapter.Fill(dataset, "mutsuz")

[yoteksin]

Try the following intead of
command.Parameters.AddWithValue("@number", TextBox1.Text)

dataadapter.SelectCommand.Parameters.AddWithValue("@number", TextBox1.Text).

Sampiyon FeNeRbAhCe