hello friends

i have button1, textbox1 and gridview1 and table1 .. i want gridview1 to display items that i search from textbox1.text with button1

i want to select skills like insert skills below:) could you write to me as visual basic code ?

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

SglDataSource2.ConnectionString = ConfigurationManager.ConnectionStrings("ConnectionString").ToString

SglDataSource2.InsertCommand = "INSERT INTO table1 (username, productname) VALUES (@username, @productname)"

SglDataSource2.InsertParameters.Add("productname", textboxl2.Text)

Try

Server.Transfer("help.aspx")

Finally

SglDataSource2 = Nothing

End Try

If rowsaffected <> 1 Then

Else

End If

End Sub

cheers

 You will need to execute some SQL like:

SELECT  username, productname FROM table1 WHERE productname LIKE @productname + '%'

Then use this as the SelectCommand on your datasource, and bind the results to your grid. Have a go, and post again if you run into any problems.

hi

i dont know how i use selectcommand and bind the results to grid..

could you write to me as visualbacis code ?

cheers

Have a look throiugh this article- it contains all the information you need to retrieve and bind the results. 

hi

i have read this article before :)

and i write visual basic code  for select skills.. but it doesnt work..

cheers

Can you post the code you have so far, and also describe in what way it does not work for you. Is there an error? If so, could you post the error details? 

Dim SglDataSource2 As New SqlDataSource()

SglDataSource2.SelectCommand = "SELECT * FROM table1 WHERE username=textbox1.text"

SglDataSource2.SelectParameters.Add("username", textbox1.Text)

 Your problem is the statement:

"SELECT * FROM table1 WHERE username=textbox1.text"

In this case, textbox1.text is a control property so it should not be included within the SQL. This should be replaced with a parameter (i.e.' @userName'), and you can then add the parameter value to the datasource command, i.e.

SglDataSource2.SelectParameters.Add("@userName", textbox1.Text)

So , in other words, 'username' is the field name in the database- this is a constant, '@userName' is a parameter which acts as a placeholder for the parameter value which you pass to the command, which in your case is the Text property of textbox1.

Hi,

        Please try below modified code. 

Dim SglDataSource2 As New SqlDataSource()

SglDataSource2.SelectCommand = "SELECT * FROM table1 WHERE username=@user"

SglDataSource2.SelectParameters.Add("@user", textbox1.Text)

hello

i have a error :) ProductID is int maybe it is error :) and my code is below

i wait for your help :)

Dim SglDataSource2 As New SqlDataSource()

SglDataSource2.SelectCommand = "SELECT * FROM products WHERE productID=@productID"

End Sub

HI,

    Check this Link
   

   This may be useful for you.

   Mark it as a ANSWER if it is useful for you
 

Hi, 

    Set GridView1.DataSource = SqlDataSource2.ID

    GridView1.DataBind()

hi

GridView1.DataSource = SqlDataSource2.ID    this code line have a mistake.. SqlDataSource2.ID is underline :)

    GridView1.DataBind()

cheers

Hi,

 You can't pass the text in as a string- if yuor ID is an integer, your parameter type should also be an integer:

SglDataSource2.SelectParameters.Add("@productID", Integer.Parse(TextBox1.Text))