row to column sql server

CREATE TABLE [dbo].[ashish](
    [custID] [int] NULL,
    [Question] [varchar](50) NULL,
    [answer] [varchar](20) NULL
) ON [PRIMARY]


INSERT INTO ashish values(1000,    'AAA',    '1')
INSERT INTO ashish values(1000,    'BBB B',    '2')
INSERT INTO ashish values(1000,    'CCC',    '3')
INSERT INTO ashish values(1001,    'AAA',    '2')
INSERT INTO ashish values(1001,    'BBB B',    '3')
INSERT INTO ashish values(1001,    'CCC',    '3')
INSERT INTO ashish values(1000,    'DDD',    '6')

Declare @t VARCHAR(10)
Declare @A VARCHAR(1000)
Declare @B VARCHAR(1000)
set @A='SELECT CustID'
SET @B='('
SELECT @A=@A+',['+Question+'] as [' +Question+']',@B=@B+'['+Question+'],' FROM (SELECT DISTINCT QUESTION FROM ashish) cur
-- removing last ',' from both <span class="IL_AD" id="IL_AD5">variables</span>
SET @B=SUBSTRING(@B,1,LEN(@B)-1)
SET @A=@A+ + ' FROM (SELECT CustID, Answer, Question FROM ashish) s  PIVOT (max(answer) FOR QUESTION IN ' +@B+')) p ORDER BY [CUSTID]; '
exec(@A);

JAVASCRIPT YES NO ALERT

function PrintAlert()
        {  
            ModalPopups.Confirm("idConfirm1",  
            "Print Confirmation",  
            "<div style='padding: 25px;text-align:center;'>Print OK ?</div>",   
            {  
                yesButtonText: "Yes",  
                noButtonText: "No",  
                onYes: "ModalPopupsConfirmYes()",  
                onNo: "ModalPopupsConfirmNo()" 
            }            
            );  
        }  
function ModalPopupsConfirmYes() {  
   // alert('You pressed Yes');  
    ModalPopups.Close("idConfirm1");  
  var printflag = "Y";
   var txtSearchClientID="<%=Hiddden_grid_value.ClientID%>";
            GetPrint(printflag,document.getElementById(txtSearchClientID).value);
}  
function ModalPopupsConfirmNo() { 
var printflag = "N";
  //  alert('You pressed No');  
    ModalPopups.Cancel("idConfirm1");  
     var txtSearchClientID="<%=Hiddden_grid_value.ClientID%>";
            GetPrint(printflag,document.getElementById(txtSearchClientID).value);
   
}


function GetPrint(print,maxkey)
        {
            if(print!="")
            {
            alert(print);
                var hfPrintClientID="<%=hfPrint.ClientID%>";
                var hfPrint=document.getElementById(hfPrintClientID);
                hfPrint.value=print;
                var hfmaxkeyClientID="<%=hfmaxkey.ClientID%>";
                var hfmaxkey=document.getElementById(hfmaxkeyClientID);
                hfmaxkey.value=maxkey;
                var btnRefreshViewClientID="<%=btnRefreshView.ClientID %>";
                var btnRefreshView=document.getElementById(btnRefreshViewClientID);
                btnRefreshView.click();
            }
        }


<script language="javascript" type="text/javascript" src="../Scripts/ModalPopups.js"></script>

Gridview Add Row

 public void newrow()
    {
        DataTable dt = new DataTable();
        DataRow dr = null;
        dt.Columns.Add(new DataColumn("Select", typeof(string)));
        dt.Columns.Add(new DataColumn("sr_no", typeof(string)));
        dt.Columns.Add(new DataColumn("Source", typeof(string)));
        dt.Columns.Add(new DataColumn("Destination", typeof(string)));
        dt.Columns.Add(new DataColumn("Rate", typeof(string)));

        dr = dt.NewRow();
        dr["Select"] = string.Empty;
        dr["sr_no"] = string.Empty;
        dr["Source"] = string.Empty;
        dr["Destination"] = string.Empty;
        dr["Rate"] = string.Empty;

        dt.Rows.Add(dr);
        gridNEW_REC.DataSource = dt;
        gridNEW_REC.DataBind();



    }
    public void addnewrow()
    {

        conn.cn.Open();
        DataTable dt = new DataTable();
        DataRow dr;
        dt.Columns.Add(new DataColumn("Select", typeof(string)));
        dt.Columns.Add(new DataColumn("sr_no", typeof(string)));
        dt.Columns.Add(new DataColumn("Source", typeof(string)));
        dt.Columns.Add(new DataColumn("Destination", typeof(string)));
        dt.Columns.Add(new DataColumn("Rate", typeof(string)));
        if (gridNEW_REC.Rows.Count > 0)
        {
            for (int i = 0; i < gridNEW_REC.Rows.Count; i++)
            {
                dr = dt.NewRow();

                TextBox t1 = (TextBox)gridNEW_REC.Rows[i].Cells[1].FindControl("txtno");
                dr[1] = Convert.ToString(t1.Text);
                TextBox t2 = (TextBox)gridNEW_REC.Rows[i].Cells[2].FindControl("txtSOURCE_STATION");
                dr[2] = Convert.ToString(t2.Text);
                TextBox t3 = (TextBox)gridNEW_REC.Rows[i].Cells[4].FindControl("txtDEST_STATION");
                dr[3] = Convert.ToString(t3.Text);
                TextBox t4 = (TextBox)gridNEW_REC.Rows[i].Cells[6].FindControl("txtRATE");
                dr[4] = Convert.ToString(t4.Text);
                dt.Rows.Add(dr);
            }
            dr = dt.NewRow();
            dt.Rows.Add(dr);
            gridNEW_REC.DataSource = dt;
            gridNEW_REC.DataBind();
            auto_gen_grid_no();
        }


    }