Monday 2 December 2013

How to Merge Two Table

Below will give you the solution about, how to merge two tables
Code:
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
 SqlConnection con;
 SqlDataAdapter da; 
 DataSet ds1 = new DataSet();
 DataSet ds2 = new DataSet();

 protected void Page_Load(object sender, EventArgs e)
 {
   binddata();
 }

 public void binddata()
 {
   con=new SqlConnection(“Data Source=MCN101; Initial Catalog=MergeTable; Uid=sa; pwd=***”);
   da = new SqlDataAdapter(“Select * from Table1?, con);
   da.Fill(ds1, “Record”);
   da = new SqlDataAdapter(“select * from Table2?, con);
   da.Fill(ds2, “Record”);
   ds1.Merge(ds2);
   GridAllRecord.DataSource = ds1;
   GridAllRecord.DataBind();
 }
}

How to display Telerik RadDatePicker Calendar PopUp Above

For this issue,you have to do two simple steps.These simple two steps are  as follows:--

Step-1:
   First use this JavaScript in your HTML code
JavaScript :

     


Step-2:
After that you have to use this below code in your .cs file(Page_Load event)
RadDatePicker1.DatePopupButton.Attributes.Add("onclick","PopupAbove(event, '" +  RadDatePicker1.ClientID + "');return false;");
Note:-

If you are till facing problem,i mean to say that Calendar popup not showing on top then let me know.Comment please

Telerik RadGrid Pager 508 compliances

Here is the code:
Copy this code and paste it in your RadGrid.

     
       
-------
-------