Mostrar os dados com a lista em ASP.NET

quero mostrar a base de dados de registo na mesma página onde o utilizador regista. Posso mostrar usando a lista, configurando a base de dados com ela.

Mas eu quero fazer isso usando o comando Adicionar item em C#.

outro problema é mesmo depois que eu adicionei a referência para o listview (system.web.ui.webcontrols) o Visualstudio diz que é ambíguo quando eu digitar listview.

O meu código está abaixo de

        public void Insertfunc()//inserting into database 
        {
            string database = @"Data Source=.;Initial Catalog=NewDB;Integrated Security=True";
            SqlConnection myConn = new SqlConnection(database);
            string queryStr = @"insert into Registration values (@fname,@lname,@dob,@emailid,@uname)";
            SqlCommand myCommand = new SqlCommand(queryStr, myConn);
            myCommand.Parameters.AddWithValue("@fname", FirstName);
            myCommand.Parameters.AddWithValue("@lname", LastName);
            myCommand.Parameters.AddWithValue("@dob", DateofBirth);
            myCommand.Parameters.AddWithValue("@emailid", Mailid);
            myCommand.Parameters.AddWithValue("@uname", UserName);
            myConn.Open();
            myCommand.ExecuteNonQuery();
            myConn.Close();

            string query = @"select * from Registration";
            SqlCommand mycommand1 = new SqlCommand(query,myConn);
            SqlDataReader tbl = mycommand1.ExecuteReader();
// i just want to add the listview coding here 

        }

    }


    protected void Page_Load(object sender, EventArgs e)
    {

    }

    public void Submit_Click(object sender, EventArgs e)
    {
        UserRegistration User1 = new UserRegistration();
        int flag = 0;

       User1.Mailid = mailid.Text;
       User1.UserName = UN.Text;
       User1.FirstName = FN.Text;
       User1.LastName = LN.Text;
       User1.DateofBirth = DOB.Text;
     if (User1.Validatefunc(User1.Mailid, "[Email]") == true)
        {
            IDlbl.Text = "Provide Someother mailid";
        }
        else
        {
            IDlbl.Text = "Okay";
            flag = 1;

        }

        if (User1.Validatefunc(User1.UserName, "[Username]") == true)
        {
            UNlbl.Text = "Username Not Available";

        }
        else
        {
            flag++;
            UNlbl.Text = "Username Available";
        }
        if (flag == 2)
        {
            User1.Insertfunc();
        }


    }


}
Author: Ram, 2013-10-29

2 answers

Para mostrar os dados usando a listview usando os códigos

protected void Page_Load(object sender, EventArgs e)
        {
            ListView1.DataSource = this.GetData();
            ListView1.DataBind();
        }

        private DataSet GetData()
        {
            string conString = ConfigurationManager.ConnectionStrings["Connectionstr"].ConnectionString;
            string query = "SELECT * FROM Registration";
            SqlCommand cmd = new SqlCommand(query);
            using (SqlConnection con = new SqlConnection(conString))
            {
                using (SqlDataAdapter sda = new SqlDataAdapter())
                {
                    cmd.Connection = con;
                    sda.SelectCommand = cmd;
                    using (DataSet ds = new DataSet())
                    {
                        sda.Fill(ds);
                        return ds;
                    }
                }
            }
        }
 1
Author: Ram, 2013-11-11 07:07:10

Código ASPX

<asp:ListView ID="ListView1" runat="server" ItemPlaceholderID="PlaceHolder1">
    <ItemTemplate>

        <strong>Country Id : </strong>
        <asp:Label runat="server" ID="lblId" Text='<%# Eval("Id") %>'></asp:Label>
        <br />
        <strong>Country Name :</strong>
        <asp:Label runat="server" ID="lblName" Text='<%# Eval("CountryName") %>'></asp:Label>

        </div>
    </ItemTemplate>
    <LayoutTemplate>
        <asp:PlaceHolder runat="server" ID="PlaceHolder1"></asp:PlaceHolder>
    </LayoutTemplate>
</asp:ListView>

Aspx.código cs

SqlConnection con = new SqlConnection(@"Data Source=.\SqlExpress;Initial Catalog=dbTest2;Integrated Security=True");
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter("select * from tblCountry", con);
sda.Fill(ds);
ListView1.DataSource = ds;
ListView1.DataBind(); 
Espero que te ajude.
 0
Author: ABi, 2015-10-06 22:27:11