Live images, files save in c sharp

 <form id="form1" runat="server">
    <div>
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
        <asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />
    </div>
    </form>


protected void Button1_Click(object sender, EventArgs e)
    {
        HttpWebRequest request = (HttpWebRequest)WebRequest.Create(TextBox1.Text.Trim());
        string filname = TextBox1.Text.Trim();
        filname = string.Format("{0:MMMMyyyyHHmmssFFFF}", DateTime.Now) + filname.Substring(filname.LastIndexOf("/") + 1);

        HttpWebResponse response = (HttpWebResponse)request.GetResponse();
        if ((response.StatusCode == HttpStatusCode.OK ||
                   response.StatusCode == HttpStatusCode.Moved ||
                   response.StatusCode == HttpStatusCode.Redirect) &&
                   response.ContentType.StartsWith("image", StringComparison.OrdinalIgnoreCase))
        {
            using (Stream inputStream = response.GetResponseStream())
            using (Stream outputStream = File.Create(Server.MapPath("images") + "\\" + filname + ""))
            {
                byte[] buffer = new byte[4096];
                int bytesRead;
                do
                {
                    bytesRead = inputStream.Read(buffer, 0, buffer.Length);
                    outputStream.Write(buffer, 0, bytesRead);
                } while (bytesRead != 0);
            }
        }
    }

On Submit Security per-pus option for captcha

 protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
           Session["CheckRefreshQ"] = Server.UrlDecode(System.DateTime.Now.ToString());
        }
     
    }
 #region Page Pre Render
    protected void Page_PreRender(object sender, EventArgs e)
    {
        ViewState["CheckRefreshQ"] = Session["CheckRefreshQ"];
    }
    #endregion

 protected void imgBtnSubmit_Click(object sender, EventArgs e)
    {
if (Session["CheckRefreshQ"].ToString() == ViewState["CheckRefreshQ"].ToString())
                {
                    Session["CheckRefreshQ"] = Server.UrlDecode(System.DateTime.Now.ToString());
                     }
                else
                {
                   
                }
     }

File dump by sql Store procedure

Create PROCEDURE [dbo].[SP_NAVupload]
AS
BEGIN
--Truncate Temp Current NAV Table Data
Truncate Table tblNavdailyTemp
--Truncate Temp Current NAV Table Data

Bulk Insert tblNavdailyTemp
From 'D:\1DailyNAV.csv' -- Full Path and File Name
With
(
fieldterminator = ',',
rowterminator = '\n',
FIRSTROW = 2
)

Declare @Rcounttemp1 As int;
Set @Rcounttemp1 =(Select Count(Nav_date)
From [tblNavdaily] With(NOLOCK)
Where Convert(varchar, Nav_date, 110) = (Select Top 1 Convert(varchar, Nav_date, 110) From tblNavdailyTemp))
if(@Rcounttemp1 = 0)
Begin
--print 'in'
--Dump Current NAV Table Data to History NAV Table
Insert into tblNavHistory
(fund_id,benchmark_value,fund_value,value_insdate,benchmark_id,isChecked)
Select (Select Distinct fund_id
From [tblFundsMaster] With(NOLOCK)
Where fund_status = 'Y' And
fund_code = A.rls_fundcode And
IsNull(fund_code,'') <> ''),
NULL, A.nav_value, A.nav_date, NULL, 1
From [tblNavdaily]  As A
Where A.nav_date > (Select Max(value_insdate)
From tblNavHistory With(NOLOCK))
--Dump Current NAV Table Data to History NAV Table

--Truncate Current NAV Table Data
Truncate Table [tblNavdaily]
--Truncate Current NAV Table Data

--Dump Temp Current NAV Table Data to Current NAV Table Data
Insert Into [dbo].[tblNavdaily]
([RLS_FUNDCODE],[CREDENCE_FUNDNAME],[NAV_DATE],[NAV_VALUE],Upload_Date)
Select [RLS_FUNDCODE], [CREDENCE_FUNDNAME], [NAV_DATE], [NAV_VALUE], GetDate()
From tblNavdailyTemp With(NOLOCK)
--Dump Temp Current NAV Table Data to Current NAV Table Data
end
END

Transaction use in storeprocedure

 begin transaction
--do here your sql work
        if (@@error = 0)
begin
commit Transaction
select 'Insert successfully'
end
 else
begin
 Rollback Transaction
 select 'Error in Insert'+CAST(@@error as varchar(88))
end

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())) %>'