Home > DeveloperSection > Forums > Listview databind error
marcel ethan
marcel ethan

Total Post:105

Points:735
Posted on    February-03-2014 12:02 AM

 C# C# 
Ratings:


 1 Reply(s)
 865  View(s)
Rate this:

I currenty have a stored procedure that I am running and hoping to bind the data from the sp with my list view. However, I am unsure of how to go upon doing this.

Here is my current code. I was thinking it was similar to databinding a gridview but got lost doing it.

HTML

<asp:ListView runat="server">

                        <LayoutTemplate>

                            <table>

                                <tr style="background-color:green">

                                    <th><asp:LinkButton ID="lnkid" runat="server">Role ID</asp:LinkButton></th>

                                    <th><asp:LinkButton ID="lnkdesc" runat="server">Role Description</asp:LinkButton></th>

                                </tr>

                            </table>

                        </LayoutTemplate>

                        <ItemTemplate>

                            <tr>

                                <td><asp:Label runat="server" ID="lblroleid">Role ID</asp:Label></td>

                                <td><asp:Label runat="server" ID="lblroledesc">Role Desc></asp:Label></td>

                            </tr>

                        </ItemTemplate>

                        <AlternatingItemTemplate>

                            <tr style="background-color:Aqua">

                                <td><asp:Label runat="server" ID="lblroleid">Role ID</asp:Label></td>

                                <td><asp:Label runat="server" ID="lblroledesc">Role Desc</asp:Label></td>

                            </tr>

                        </AlternatingItemTemplate>

                    </asp:ListView>

c#

protected void roles()

    {

        txtSearch.Focus();

        string[] queryvalue = txtSearch.Text.Split(' ');

        SqlConnection myconn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Rollup2ConnectionString"].ConnectionString);

        SqlCommand cmd = new SqlCommand();

        cmd.CommandType = CommandType.StoredProcedure;

        cmd.CommandText = "USP_GET_USER_ROLES";

        cmd.Connection = myconn;

        cmd.Parameters.Add("@NUID", SqlDbType.VarChar).Value = queryvalue[0].ToString();

        myconn.Open();

        SqlDataAdapter da = new SqlDataAdapter(cmd);

        DataSet ds = new DataSet();

        da.Fill(ds);

        myconn.Close();

        myconn.Dispose();

    }



Pravesh Singh

Total Post:411

Points:2881
Posted on    February-03-2014 12:56 AM

Hi Marcel,

This should help you out

<asp:SqlDataSource ID="sdsYourData" Runat="server"

    ProviderName="System.Data.SqlClient"

    ConnectionString="Server=(local);Database=Northwind;Integrated Security=SSPI;"

    SelectCommand="dbo.YourStoredProcName"

    <SelectParameters>

        <asp:Parameter Name="Param1" Type="String" />>

    </SelectParameters>

</asp:SqlDataSource>




Don't want to miss updates? Please click the below button!

Follow MindStick