ASP.NET

Assing sql query to gridview

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Nov 2008

Posts: 4

Reputation: speranza is an unknown quantity at this point

Solved Threads: 0

speranza

Offline

Newbie Poster

Assing sql query to gridview

Nov 15th, 2008

can you help me assign sql query to gridview..i am trying like this but it doesnt work.

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
        Dim con As New SqlConnection("Data Source=SPERANZA\SQLEXPRESS;initial catalog=master;integrated security=true")
        Dim cmd As New SqlCommand
        Dim dr As SqlDataReader
        cmd.Connection = con
        con.Open()
        cmd.CommandText = "SELECT name,dob,sex FROM users WHERE name LIKE ('%' + @name + '%')"
        cmd.Parameters.AddWithValue("@name", txtname.Text)
        dr = cmd.ExecuteReader()
        GridView1.DataSource = dr
        con.Close()
    End Sub
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
        Dim con As New SqlConnection("Data Source=SPERANZA\SQLEXPRESS;initial catalog=master;integrated security=true")
        Dim cmd As New SqlCommand
        Dim dr As SqlDataReader
        cmd.Connection = con
        con.Open()
        cmd.CommandText = "SELECT name,dob,sex FROM users WHERE name LIKE ('%' + @name + '%')"
        cmd.Parameters.AddWithValue("@name", txtname.Text)
        dr = cmd.ExecuteReader()
        GridView1.DataSource = dr
        con.Close()
    End Sub

and code in aspx file

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
 
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Height="176px"  Width="598px">
                <Columns>
                <asp:TemplateField>
                <ItemTemplate>
                <%#Eval("name")%><br />
                <%#Eval("dob")%><br />
                <%#Eval("sex") %><br />
                </ItemTemplate>
                </asp:TemplateField>
                </Columns>
</asp:GridView>
   
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Height="176px"  Width="598px">
                <Columns>
                <asp:TemplateField>
                <ItemTemplate>
                <%#Eval("name")%><br />
                <%#Eval("dob")%><br />
                <%#Eval("sex") %><br />
                </ItemTemplate>
                </asp:TemplateField>
                </Columns>
</asp:GridView>

•

Join Date: Nov 2007

Posts: 32

Reputation: Jihad is an unknown quantity at this point

Solved Threads: 1

Jihad

Offline

Light Poster

Re: Assing sql query to gridview

Nov 15th, 2008

The only thing you are missing is that you should bind the gridview to its data source. after the set of the data source and before closing the connection write this.

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
GridView1.Databind()
GridView1.Databind()

and don't forget to close the data reader

Last edited by Jihad; Nov 15th, 2008 at 1:43 pm.

•

Join Date: Oct 2008

Posts: 32

Reputation: reena12 is an unknown quantity at this point

Solved Threads: 4

reena12

Offline

Light Poster

Re: Assing sql query to gridview

Nov 17th, 2008

Try
Dim ObjSqlDataAdapter As SqlDataAdapter
Dim ObjDataSet As New DataSet
ObjSqlConnection = New SqlConnection(ConnectionString)

If ObjSqlConnection.State <> ConnectionState.Open Then
ObjSqlConnection.Open()
End If

ObjSqlDataAdapter = New SqlDataAdapter(CommandText, ObjSqlConnection)
ObjDataSet = New DataSet()
ObjSqlDataAdapter.Fill(ObjDataSet)
Gridview1.DataSource = ObjDataSet.Tables(0)

Catch ex As Exception
Throw New Exception(ex.Message)
Finally
ObjSqlConnection.Close()
ObjSqlConnection.Dispose()
End Try

if solved pls mark as solved

Reena Mehta

Remember to click on Mark as answer on the post that helped

http://www.indianic.com