PDA

View Full Version : كد ريختن نتيجه كوئري در grid view



mononok
یک شنبه 03 آبان 1388, 20:33 عصر
سلام

اين كد براي ريختن نتيجه كوئري در grid view هستش
اساتيد لطف مي كنيد بگيد مشكل اين كد چيه كه چيزي نشون نمي ده؟
خطايي هم نمي ده!


Protected Sub btn_show_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn_show.Click
conn.Open()
Dim dt As New DataTable
Dim dr As DataRow
dt.Columns.Add(New DataColumn("gift_id", GetType(Integer)))
dt.Columns.Add(New DataColumn("title", GetType(String)))
dt.Columns.Add(New DataColumn("price", GetType(Integer)))
dt.Columns.Add(New DataColumn("picture", GetType(String)))
Dim cmd As New SqlCommand
cmd = New SqlCommand("select * from products where title='" + txt_search.Text + "'", conn)
Dim reader As SqlDataReader = cmd.ExecuteReader
Do While reader.Read
dr = dt.NewRow
dr("gift_id") = reader.Item("gift_id")
dr("title") = reader.Item("title")
dr("price") = reader.Item("price")
dr("picture") = reader.Item("picture")
dt.Rows.Add(dr)
Loop
Dim dv As New DataView(dt)
GridView1.DataSource = dv
GridView1.DataBind()
conn.Close()
End Sub