Dynamic grid on ASP.NET

Question

I here to seek an advice ,what is the best approach.

here is the scenario.

I am building my project ASP.NET (C#)

I need to add an dynamic drop down box based on that two other text box related to drop down.

for example :

I have a button called "ADD LANDSCAPE", every time this triggered, i have to create an dynamic drop down "ddlLandscap" and two text boxes so the user can enter landscape value for each text box.

Can you guys please advise what's the best approach

Deenathaiyalan Shanmugam · Accepted Answer

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="CS1.aspx.cs" Inherits="workout.CS1" %>





    
    
    
    
    


    
        
            
                
                    
                        <%# Eval("Slno") %>
                    
                
                
                    
                        <%# Eval("Name") %>
                    
                
                
                    
                        <%# Eval("Country")%>
                    
                
                
                    
                        
                        
                    
                
            
        
        

        
        
        


        
            All form fields are required.
            
                
                    Name:

                        
                    
                    Country:

                        
                    
                
            
        

        
            All form fields are required.
            
            
                
                    Name:

                        
                    
                    Country:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

namespace workout
{
    public partial class CS1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

            if (!this.IsPostBack)
            {
                this.BindGrid();
            }

        }

        private void BindGrid()
        {
            DataTable dt = new DataTable();
            string query = "SELECT '' Slno, Name, Country FROM dd_Detils";
            string constr = "Data Source=localhost;Initial Catalog=DataBase;User ID=sa;Password=globalfocus";
            using (SqlConnection con = new SqlConnection(constr))
            {
                using (SqlCommand cmd = new SqlCommand(query))
                {
                    cmd.Connection = con;
                    using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
                    {
                        sda.SelectCommand = cmd;
                        sda.Fill(dt);
                    }
                }
            }

            if (dt.Rows.Count == 0)
            {
                //If no records then add a dummy row.
                dt.Rows.Add();
            }
            gvCustomers1.DataSource = dt;
            gvCustomers1.DataBind();
        }

        protected void Submit(object sender, EventArgs e)
        {
            int cnt = gvCustomers1.Rows.Count;

            if (!string.IsNullOrEmpty(Request.Form["name"]) && !string.IsNullOrEmpty(Request.Form["country"]))
            {
                //Fetch the Hidden Field values from the Request.Form collection.
                string[] names = Request.Form["name"].Split(',');
                string[] countries = Request.Form["country"].Split(',');

                //Loop through the values and insert into database table.
                for (int i = 0; i < names.Length; i++)
                {
                    string constr = "Data Source=localhost;Initial Catalog=Database;User ID=sa;Password=globalfocus";
                    using (SqlConnection con = new SqlConnection(constr))
                    {
                        using (SqlCommand cmd = new SqlCommand("INSERT INTO dd_Detils VALUES(@Name, @Country)"))
                        {
                            cmd.Parameters.AddWithValue("@Name", names[i]);
                            cmd.Parameters.AddWithValue("@Country", countries[i]);
                            cmd.Connection = con;
                            con.Open();
                            cmd.ExecuteNonQuery();
                            con.Close();
                        }
                    }
                }

                //Refresh the page to load GridView with records from database table.
                Response.Redirect(Request.Url.AbsoluteUri);
            }
        }
    }
}

Dynamic grid on ASP.NET

Answers (1)

Related Questions