Click here to Skip to main content
15,881,424 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
C#
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;
using System.Configuration;

namespace SMSReminderProject
{
    public partial class pgTemplateMaster : System.Web.UI.Page
    {
        static int wl_TemDID = 0;
        //static int wl_TH = 0;
        int i = 0;
        string lsQuery;
        static string constr = ConfigurationManager.ConnectionStrings["conster"].ToString();
        SqlConnection conn = new SqlConnection(constr);

        DataSet dtItems = new DataSet();
        
    
        protected void Page_Load(object sender, EventArgs e)
        {
         
             fill_grdtemplatemasterHeader();
            ViewState["dtItems"] = dtItems;
            BindGrid();

            if (!IsPostBack)
            {

                FillddlOperator();
                datatable();
                //datatable();
              
            }


        }


        private void FillddlOperator()
        {

            string lsquery;
        
            lsquery = "select opID,opName  from [tbl_operator]";
            SqlCommand select = new SqlCommand(lsquery, conn);
            SqlDataAdapter DA = new SqlDataAdapter(select);
            DataTable dt = new DataTable();

            conn.Open();
            select.ExecuteNonQuery();
            DA.Fill(dt);

            ddlOperator.DataSource = dt;
            ddlOperator.DataValueField = "opID";
            ddlOperator.DataTextField = "opName";

            ddlOperator.DataBind();
            ddlOperator.Items.Insert(0, new ListItem("--Select--", "0"));
            ddlOperator.SelectedIndex = 0;
            conn.Close();

        }
        public void datatable()
        {

            //DataTable CreateDataTable()
            DataTable ordersTable = dtItems.Tables.Add("Orders");
            //DataTable dtItems = new DataTable();

            //Add Auto No. Column to the DataTable
            dtItems.Tables[0].Columns.Add("StaticId", typeof(int));
            dtItems.Tables[0].PrimaryKey = new DataColumn[] { dtItems.Tables[0].Columns["StaticId"] };
            dtItems.Tables[0].Columns["StaticId"].AutoIncrement = true;
            dtItems.Tables[0].Columns["StaticId"].AutoIncrementSeed = 1;
           


            //Add three more columns to the DataTable
            dtItems.Tables[0].Columns.Add("TemDID", typeof(int));
            dtItems.Tables[0].Columns["TemDID"].DefaultValue = 0;

            dtItems.Tables[0].Columns.Add("TemHID", typeof(int));
            dtItems.Tables[0].Columns["TemHID"].DefaultValue = 0;

            dtItems.Tables[0].Columns.Add("opID", typeof(int));
            dtItems.Tables[0].Columns["opID"].DefaultValue = 0;

            dtItems.Tables[0].Columns.Add("opName", typeof(string));
            dtItems.Tables[0].Columns["opName"].ToString();

            dtItems.Tables[0].Columns.Add("IsActive", typeof(Boolean));

            dtItems.Tables[0].Columns.Add("IsDeleted", typeof(Boolean));
        
            //rupal comment
            //dtItems.Tables[0].Rows.Add(dtItems.Tables[0].NewRow());
            dtItems.Tables[0].AcceptChanges();

            ViewState["dtItems"] = dtItems;
            wp_Filltemplatedetail();

            //dtItems.Tables("IsDeleted").DefaultView.RowFilter = "";
            //ViewState["dtItems"] = dtItems;

        }

        public void wp_Filltemplatedetail()
        {
            //DataTable dtItems = new DataTable();
            dtItems.Tables[0].Columns["IsDeleted"].DefaultValue = "false";
            grdTemplateDetail.DataSource = dtItems.Tables[0];
            //grdTemplateDetail.DataSource = ViewState["dtItems"] as DataTable;
            grdTemplateDetail.DataBind();
        }
        public void btnAdd_Click(object sender, EventArgs e)
        {

            dtItems = (DataSet)ViewState["dtItems"];
            DataRow dr = dtItems.Tables[0].NewRow();


            dr["TemDID"] = 0;
            dr["TemHID"] = 0;
            dr["opID"] = ddlOperator.SelectedValue;
            dr["opName"] = ddlOperator.SelectedItem;
            dr["IsActive"] = chkIsActive.Checked;
            dtItems.Tables[0].Rows.Add(dr);
            dtItems.AcceptChanges();
            ViewState["dtItems"] = dtItems;
         
            grdTemplateDetail.DataSource = ViewState["dtItems"];
            grdTemplateDetail.DataBind();
            ddlOperator.Items.Insert(0, new ListItem("--Select--", "0"));
            ddlOperator.SelectedIndex = 0;

        }

       


        protected void grdtemplatemasterHeader_SelectedIndexChanged(object sender, EventArgs e)
        {

        }



        private void fill_grdtemplatemasterHeader()
        {
            string lsquery;
            lsquery = "select TOP 10 * from tbl_Template_H ORDER BY TemHID desc";
            SqlCommand select = new SqlCommand(lsquery, conn);
            SqlDataAdapter DA = new SqlDataAdapter(select);
            DataTable dt = new DataTable();

            conn.Open();
            select.ExecuteNonQuery();
            DA.Fill(dt);
            grdtemplatemasterHeader.DataSource = dt;
            grdtemplatemasterHeader.DataBind();

            conn.Close();

        }

       

        private void wp_Clear()
        {
            txtTemplate.Text = "";
        }

        protected void btnSave_Click(object sender, EventArgs e)
        {
            int iThID = 0;
           

            iThID = ExecuteQuery("insert into tbl_Template_H(TemHName,TemHActive) values('" + txtTemplate.Text + "' ,'" + chkIsActive.Checked + "')");

            dtItems = ((DataSet)ViewState["dtItems"]).Copy();
            //foreach (DataRow dr in dtItems.Tables[0].Rows )
            foreach (DataRow dr in dtItems.Tables[0].Rows)
                {
                    if ((bool)dr["IsDeleted"] == false)
                    //if((int)dr["IsDeleted"]== 0)
                             
                    {
                         ExecuteQuery("insert into tbl_Template_D(TemHID,opID) values(" + iThID + "," + (dr["opID"])  + "   )");
                    }


                    fill_grdtemplatemasterHeader();
                    wp_Clear();
                   
                }

         
      


       
        }

        // added by Mayur on 28 apr 2015
        protected Int32 ExecuteQuery(string Query)
        {
            int li_ID;
            SqlCommand cmd = new SqlCommand(Query, conn);
            conn.Open();
            cmd.ExecuteNonQuery();
            cmd.CommandText = "SELECT @@IDENTITY";
            li_ID =System.Convert.ToInt32 (cmd.ExecuteScalar());
            //li_ID = (Int32)cmd.ExecuteScalar();
            conn.Close();
           return li_ID;
        }
       
      



        //http://www.aspnettutorials.com/tutorials/database/add-data-to-gridview-from-multiple-tables-in-asp-net-4-0-and-c/
        //http://www.aspnettutorials.com/tutorials/controls/data-table-csharp/

        protected DataTable ExecuteDT1(string Query)
        {
          
            DataTable dt1 = new DataTable();
            i = Convert.ToInt16(txtTemDID.Text);

            SqlDataAdapter adp = new SqlDataAdapter(Query, conn);
            adp.Fill(dt1);
            grdTemplateDetail.DataSource = dt1;
            grdTemplateDetail.DataBind();
            return dt1;
        }
        protected void BindGrid()
        {
            //grdTemplateDetail.DataSource = ViewState["dt"] as DataTable;
            //grdTemplateDetail.DataBind();
            grdTemplateDetail.DataSource =ViewState["dtItems"] as DataTable;
            grdTemplateDetail.DataBind();
        }
        protected void grdTemplateDetail_DataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                if (((CheckBox)(e.Row.Cells[0].Controls[0])).Checked)
                {
                    e.Row.BackColor = System.Drawing.Color.Yellow;
                }
            }
        }
        protected void grdTemplateDetail_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
           
            
        }

        protected void grdTemplateDetail_SelectedIndexChanged(object sender, EventArgs e)
        {
            i = Convert.ToInt16(txtTemDID.Text);
           
           
        }


        
        //mayur sir
        protected DataTable ExecuteDT(string Query)
        {
            DataTable dt = new DataTable();
            i = Convert.ToInt16(txtTemHID.Text);
            SqlDataAdapter adp = new SqlDataAdapter(Query, conn);
            adp.Fill(dt);
            grdTemplateDetail.DataSource = dt;
            grdTemplateDetail.DataBind();
            return dt;

           
        }
        protected void grdtemplatemasterHeader_SelectedIndexChanged1(object sender, EventArgs e)
        {
           
            txtTemHID.Text = grdtemplatemasterHeader.SelectedRow.Cells[1].Text;
            i = Convert.ToInt16(txtTemHID.Text);
            txtTemplate.Text = grdtemplatemasterHeader.SelectedRow.Cells[2].Text;

           
            ExecuteDT("select tbl_Template_D.TemHID,tbl_Template_D.TemDID, tbl_Template_D.opID  from tbl_Template_D left join tbl_Template_H on tbl_Template_D.TemHID = tbl_Template_H.TemHID where tbl_Template_H.TemHID=" + txtTemHID.Text + "");
          
                       
           
        }

       

      

       

    }

}
Posted
Updated 11-May-15 21:27pm
v2
Comments
King Fisher 12-May-15 3:31am    
dig it line by line , you can solve it.
ConnectingKamlesh 12-May-15 8:58am    
Can you be more specific, on which line you are getting that error ?
Member 11586098 13-May-15 1:59am    
when select value from dropdown and click on Add button at tat time error show
DataRow dr = dtItems.Tables[0].NewRow();
Error:Cannot find table 0

1 solution

1. Do not post that much code and expect someone to go through it all for you.
2. When you get an error, post the exact error so we don't have to guess at what the issue is. The error will clearly explain the problem.
3. If you are getting an error about table not found that is because you are trying to access a table that does not exist. Just debug the code and you'll find out exactly why.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900