Add dynamic DataTable Columns , Rows data

============c sharp code====================
  DataTable _dt1 = new DataTable();
        DataColumn col11 = new DataColumn("InvestmentObject");
        col11.DataType = System.Type.GetType("System.Int32");
//System.Type.GetType("System.String");
        _dt.Columns.Add(col11);

        int I;
        for (I = 0; I <= ddlInvestmentObject.Items.Count - 1; I++)
        {
            if (ddlInvestmentObject.Items[I].Selected)
            {
                DataRow researchRow1 = _dt1.NewRow();
                researchRow[col11] = Convert.ToInt32(ddlInvestmentObject.Items[I].Value);
                _dt1.Rows.Add(researchRow1);
            }
        }
        _admin.strInvestmentObject = GetXMLOfDataTable(_dt1);
================Function create here===================
 public static string GetXMLOfDataTable(DataTable dtToProcess)
        {
            string strOutput = "";
            try
            {
                dtToProcess.TableName = "Table";

                StringWriter sw = new StringWriter();

                dtToProcess.WriteXml(sw);
                strOutput = sw.ToString();
            }
            catch (Exception ex)
            {
            }


            return strOutput;
        }

===============DATA Query=======================
Decalre @xmlLanguage xml
DELETE FROM tb_InvestmentObject_SchemeMaster_Mapping WHERE Scheme_ID = @Scheme_ID
SELECT
ISNULL(cast(Colx.query('data(InvestmentObject)') as varchar(max)),'0') as [InvestmentObject]
INTO #TMPLanguage2 FROM @InvestmentObject.nodes('DocumentElement/Table') AS Tabx(Colx)
insert into tb_InvestmentObject_SchemeMaster_Mapping([Scheme_Id],[InvestmentObject_Id])
select @Scheme_ID,[InvestmentObject] from #TMPLanguage2

Write folder file in c#

string[] filePaths = Directory.GetFiles(@"d:\test\");
        foreach ( var kk in filePaths)
        {
           
            Response.Write(Path.GetFileName(kk)+"<br>");
        }

Gridview url concatenate

NavigateUrl='<%# Eval("Id", "~/Details.aspx?Id={0}") %>'
PostBackUrl=' <%# FundName_url(Eval("DisplayName", "https://abc.com?schemeName={0}")) %>'
Multi parameter:-

NavigateUrl='<%# string.Format("~/Details.aspx?Id={0}&Name={1}&Country={2}",

HttpUtility.UrlEncode(Eval("Id").ToString()), HttpUtility.UrlEncode(Eval("Name").ToString()), HttpUtility.UrlEncode(Eval("Country").ToString())) %>'

Google custom search account details link

https://csea.google.co.in/cse/all

Google SMTP function for C sharp code

var client = new SmtpClient
{
Port = 587,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Credentials = new NetworkCredential("yourGmailUsername", "yourGmailPassword"),
Host = "smtp.gmail.com"
};
var message = new MailMessage
{
// Setup your MailMessage instance here...
}
client.Send(message);

changes date format code behid site C sharp

<system.web>
    <globalization uiCulture="es" culture="es-US" />
</system.web>

 Ex:- 7/13/2015 3:04:00 PM

CSV File upload and read time give error

Execute this services for this error

AccessDatabaseEngine_x64.exe