ASP.NET

indian143 wrote:

I dont know how to see that, but he told me.

from a in quarterlyUpdateSubscription
join b in parallelDataContext.teBinaryDatas on  
a.DeltaReportBinaryDataID equals b.BinaryDataID
select b.Data

 public string GetQuarterlyUpdateTUCDataXml( int quarterlyUpdateJobId, int quarterlyUpdateSubscriptionId)
        {
            string strQuarterlyUpdateDeltaReport = null;            
 
            var quarterlyUpdateSubscription = parallelDataContext.teQUTUDatas.Where(c => c.QuarterlyUpdateJobID ==
     quarterlyUpdateJobId && c.QuarterlyUpdateSubscriptionID == quarterlyUpdateSubscriptionId).ToList();
 
            if ((quarterlyUpdateSubscription != null) && 
(quarterlyUpdateSubscription.Count > 0))
            {
                byte[] encryptedBytes = (from a in quarterlyUpdateSubscription
                                         join
                                             b in parallelDataContext.teBinaryDatas on  
 
a.DeltaReportBinaryDataID equals b.BinaryDataID
select b.Data).FirstOrDefault().ToArray();
 
                strQuarterlyUpdateDeltaReport = (encryptedBytes != null) ?
                  objCommon.GetDecryptedReportString(encryptedBytes) : ""; //objCommon.GetDecryptedReport(encryptedBytes); //                       
            }
            
            return strQuarterlyUpdateDeltaReport;
        }

ToList()

ToArray()

SayamiSuchi wrote:

it gave error

//DropDownList inside the gridview
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        //identifying DropDownList
        DropDownList gridDropDownList = (DropDownList)sender;
        //selecting grid row
        GridViewRow gridRow = (GridViewRow)gridDropDownList.NamingContainer;
        //setting Index
        int selectedIndex = gridRow.DataItemIndex;
        //finding textbox in selected gridview row
        TextBox textBox = (TextBox)GridView1.Rows[selectedIndex].FindControl("yourTextBoxID");
        string selected = gridDropDownList.SelectedValue;
        if (textBox != null)
        {
            textBox.Text = selected;
        }
    }