ASP.NET

ARINDAM1981 wrote:

In SelectedNodeChanged event whenever I am selecting any leaf node, it's taking only the first leaf node

Protected void Page_Load(object sender,EventArgs e)
{
  if (!IsPostBack)
            {
                PopTree();
            }
}

 public void PopTree()
    {
        TreeView1.Nodes.Clear();
        com = new OracleCommand();
        con = new OracleConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);
        com.Connection = con;
        com.CommandText = "select a.meeting_no,a.meeting_no ||'-->' || a.meeting_desc comb,b.meet_no from tpc_meetings a,tpc_meets b where a.meeting_no=b.meeting_no and a.status='LIV' and b.status='LIV' order by a.meeting_no,b.meet_no";
        da = new OracleDataAdapter();
        ds = new DataSet();
        da.SelectCommand = com;
        da.Fill(ds, "Meets");
        object[] marr = GetDistinct(ds.Tables["Meets"], "meeting_no");
        foreach (object mval in marr)
        {
            string mcomb = ds.Tables["Meets"].Select("meeting_no='" + mval.ToString() + "'")[0]["comb"].ToString();
            TreeNode meetingnode = new TreeNode(mcomb);
            meetingnode.SelectAction = TreeNodeSelectAction.None;
            TreeView1.Nodes.Add(meetingnode);
            string matchval = dal.ModifyStringDotNet(meetingnode.Text.Trim());
            DataRow[] children = ds.Tables["Meets"].Select("comb='" + matchval + "'");
            foreach (DataRow drow in children)
            {
                TreeNode meetnode = new TreeNode(drow["meet_no"].ToString(),drow["meeting_no"].ToString());
                meetnode.SelectAction = TreeNodeSelectAction.Select;
                meetingnode.ChildNodes.Add(meetnode);
            }
        }

    }
  protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
    {
        com = new OracleCommand();
        con = new OracleConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);
        com.Connection = con;
        try
        {
            com.CommandText = "select meeting_no,meet_no,to_char(to_date(meet_date,'yyyymmdd'),'dd-mm-yyyy') meet_date," +
              "to_char(to_date(meet_date||' ' || meet_time,'yyyymmdd hh24mi'),'hh:mi PM') meet_time," +
              "chair_pno from tpc_meets where meeting_no=" + TreeView1.SelectedNode.Value + " and meet_no=" + TreeView1.SelectedNode.Text + "";
            OracleDataReader dr;
            con.Open();
            dr = com.ExecuteReader();
            if (dr.Read())
            {
                txtMeetingNo.Text = dr[0].ToString();
                txtMeetNo.Text = dr[1].ToString();
                txtMeetDate.Text = dr[2].ToString();
                txtTime.Text = dr[3].ToString();
                txtChairPno.Text = dr[4].ToString();
            }
            dr.Close();
            btnSave.Text = "Update";
            hPick.Visible = false;
            txtMeetingNo.Enabled = false;
        }
        catch (Exception ex)
        {
            string ermsg = "window.alert('" + ex.Message + "');";
            ClientScript.RegisterClientScriptBlock(this.GetType(), "erkey1", ermsg, true);
        }
        finally
        {
            if (con.State == ConnectionState.Open)
                con.Close();
        }
    }

Raveendar Reddy wrote:

Can any one help me in providing a as-you-type spell check feature to an email application

Bandanenilima wrote:

can we use vs flex grid such type control into asp.net

Bandanenilima wrote:

so can we use any third party control with asp.net

Bandanenilima wrote:

sap .net

Bandanenilima wrote:

which third party control