How to bind image url in gridview

in .ASPX page

<asp:GridView ID="grd1" runat="server" Width="100%" AutoGenerateColumns="false">

        <Columns>

        <asp:TemplateField>

        <ItemTemplate>

        <asp:Image runat="server" ID="img1" ImageUrl='<%# Eval("product_image","~/Images/{0}") %>' Height="30px" Width="30px"/>

        </ItemTemplate>

        </asp:TemplateField>

        <asp:BoundField DataField="prod_code" HeaderText="Code" />

        <asp:BoundField DataField="prod_name" HeaderText="Name" />

        <asp:BoundField DataField="prod_price" HeaderText="Price" />

        <asp:BoundField DataField="prod_add_date" HeaderText="Date" />

        </Columns>

        </asp:GridView>

In .aspx.CS

private SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["MyDbConn1"].ToString());

        protected void Page_Load(object sender, EventArgs e)

        {

            if (!IsPostBack)

            {

                DataTable dt = new DataTable();

                SqlDataAdapter da = new SqlDataAdapter(@"select * from products", cn);

                da.Fill(dt);

                if (dt != null)

                {

                    grd1.DataSource = dt;

                    grd1.DataBind();

                }

            }

        }

        protected void btnSubmit_Click(object sender, EventArgs e)

        {

            try

            {                

                FileInfo image_file = new FileInfo(fu1.FileName);

                string des_path = HttpContext.Current.Server.MapPath("") + "\\Images";

                if (!Directory.Exists(des_path))

                    Directory.CreateDirectory(des_path);

                string file_extension = image_file.Extension;

                des_path += "\\" + txtCode.Text.Trim() + file_extension;

                fu1.SaveAs(des_path);

                SqlCommand cmd = new SqlCommand(@"INSERT INTO [dbo].[products]

           ([prod_code]

           ,[prod_name]

           ,[prod_price]

           ,[product_image]

           ,[prod_add_date])

     VALUES

           ('" + txtCode.Text.Trim() + "','" + txtName.Text.Trim() + "','" + txtPrice.Text.Trim() + "','" + txtCode.Text + file_extension + "',GETDATE())", cn);

                cn.Open();

                cmd.ExecuteNonQuery();

                cn.Close();

            }

            catch (Exception ex)

            {

                Response.Write(ex.Message.ToString());

            }

        }

RUN SQL SCRIPTS USING BATCH FILE IN C#.NET

//This method creates a batch file in given location for given db credentials. Here script1.sql is sql script file.
 private void createbatch(string filepath,string filename,string dbname,string dbserver,string dbuser,string dbpwd)
        {
            string scriptfile1="\"script1.sql\"";
            string path = filepath + "\\" + filename;
            string text = @"@echo off";
            text += "\r\n";
            text += "\r\n";
            text += @"REM  **** start: database configuration details where you would like to create views ***** ";
            text += "\r\n";
            text += @"SET PMVIEWS_DATABASE=" + dbname;
            text += "\r\n";
            text += @"SET PMVIEWS_DB_SERVER=" + dbserver;
            text += "\r\n";
            text += @"SET PMVIEWS_DB_USER=" + dbuser;
            text += "\r\n";

            text += @"SET PMVIEWS_DB_PWD=" + dbpwd;
            text += "\r\n";
            text += @"REM  **** end: database configuration details where you would like to create views ***** ";
            text += "\r\n";
            text += "\r\n";
            text += @"Sqlcmd -S %PMVIEWS_DB_SERVER% -d %PMVIEWS_DATABASE%  -U %PMVIEWS_DB_USER% -P %PMVIEWS_DB_PWD% -i " + scriptfile1 + "";
            text += "\r\n";
            using (StreamWriter strwr = File.AppendText(path))
            {
                strwr.WriteLine(text);
                strwr.Flush();
                strwr.Close();
            }
        }

//This method runs given batch file. Make sure that this batch file and sql script file contains in same folder.
        private void ExecuteBatch(string strFilePath)
        {
            string fullPath = Directory.GetParent(strFilePath).FullName;
            // Create the ProcessInfo object
            System.Diagnostics.ProcessStartInfo psi = new System.Diagnostics.ProcessStartInfo("cmd.exe");
            psi.UseShellExecute = false;
            psi.RedirectStandardOutput = true;
            psi.RedirectStandardInput = true;
            psi.RedirectStandardError = true;
            psi.WorkingDirectory = fullPath;// strPath;

            // Start the process
            System.Diagnostics.Process proc = System.Diagnostics.Process.Start(psi);
            // Open the batch file for reading
            System.IO.StreamReader strm = System.IO.File.OpenText(strFilePath);
            // Attach the output for reading
            System.IO.StreamReader sOut = proc.StandardOutput;
            // Attach the in for writing
            System.IO.StreamWriter sIn = proc.StandardInput;
            // Write each line of the batch file to standard input
            while (strm.Peek() != -1)
            {
                sIn.WriteLine(strm.ReadLine());
            }
            strm.Close();
            // Exit CMD.EXE
            string stEchoFmt = "# {0} run successfully. Exiting";
            sIn.WriteLine(String.Format(stEchoFmt, strFilePath));
            sIn.WriteLine("EXIT");
            // Close the process
            proc.Close();
            //this.AfterInstall += new InstallEventHandler(ServiceInstaller_AfterInstall);
            sIn.Close();
            sOut.Close();
        }

How to create PROXY CLASS from WebSerivce

Open Visual Studio Command Prompt and run below

wsdl /out:myProxyClass.cs http://hostserver/application/service.asmx?WSDL

It will create a C# class in C Drive

HOW TO KNOW SQL QUERY EXECUTION TIME

--Track query execution time
DECLARE @EndTime   DATETIME
DECLARE @StartTime DATETIME
SET @StartTime = GETDATE()

--Query goes here
select * from My_Table

SET @EndTime = GETDATE()

PRINT 'StartTime = ' + CONVERT(VARCHAR(30),@StartTime,121)
PRINT '  EndTime = ' + CONVERT(VARCHAR(30),@EndTime,121)
PRINT ' Duration = ' + convert(varchar,DATEDIFF(ms, @StartTime, @EndTime))+' mill seconds'

GET GIVEN DATE FORMAT FOR GIVEN INPUT FORMAT

private string DateFormat(string DateValue, string DateFormat, string RequiredFormat)
        {
            string result = DateValue;
            IFormatProvider provider = CultureInfo.InvariantCulture;
            try
            {
                if (!string.IsNullOrEmpty(DateValue) && !string.IsNullOrEmpty(DateFormat))
                    result = DateTime.ParseExact(DateValue, DateFormat, provider).ToString(RequiredFormat);

            }
            catch (Exception ex)
            {              
                throw ex;
            }
            return result;
        }

SELECT TRIGGERS LIST IN A DATABASE IN SQL SERVER

SELECT
     sysobjects.name AS trigger_name
    ,USER_NAME(sysobjects.uid) AS trigger_owner
    ,s.name AS table_schema
    ,OBJECT_NAME(parent_obj) AS table_name
    ,OBJECTPROPERTY( id, 'ExecIsUpdateTrigger') AS isupdate
    ,OBJECTPROPERTY( id, 'ExecIsDeleteTrigger') AS isdelete
    ,OBJECTPROPERTY( id, 'ExecIsInsertTrigger') AS isinsert
    ,OBJECTPROPERTY( id, 'ExecIsAfterTrigger') AS isafter
    ,OBJECTPROPERTY( id, 'ExecIsInsteadOfTrigger') AS isinsteadof
    ,OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') AS [disabled]
FROM sysobjects

INNER JOIN sysusers
    ON sysobjects.uid = sysusers.uid

INNER JOIN sys.tables t
    ON sysobjects.parent_obj = t.object_id

INNER JOIN sys.schemas s
    ON t.schema_id = s.schema_id

WHERE sysobjects.type = 'TR'

HOW TO CONVERT FIRST LETTER OF EACH WORD TO UPPER CASE USING C#

 public string UPPERCASE_FIRSTCHAR(string source)
        {
            string result = "";
            try
            {
                result = source;
                if (!string.IsNullOrEmpty(source))                  
                source=System.Threading.Thread.CurrentThread.CurrentCulture.TextInfo.ToTitleCase(source.ToLower());
            }
            catch (Exception ex)
            {
               throw ex;
            }
            return source;
        }

Execute Batch File Using c#.net

   private void ExecuteBatch(string strFilePath)
        {
            string fullPath = Directory.GetParent(strFilePath).FullName;
            // Create the ProcessInfo object
            System.Diagnostics.ProcessStartInfo psi = new System.Diagnostics.ProcessStartInfo("cmd.exe");
            psi.UseShellExecute = false;
            psi.RedirectStandardOutput = true;
            psi.RedirectStandardInput = true;
            psi.RedirectStandardError = true;
            psi.WorkingDirectory = fullPath;// strPath;

            // Start the process
            System.Diagnostics.Process proc = System.Diagnostics.Process.Start(psi);
            // Open the batch file for reading
            System.IO.StreamReader strm = System.IO.File.OpenText(strFilePath);
            // Attach the output for reading
            System.IO.StreamReader sOut = proc.StandardOutput;
            // Attach the in for writing
            System.IO.StreamWriter sIn = proc.StandardInput;
            // Write each line of the batch file to standard input
            while (strm.Peek() != -1)
            {
                sIn.WriteLine(strm.ReadLine());
            }
            strm.Close();
            // Exit CMD.EXE
            string stEchoFmt = "# {0} run successfully. Exiting";
            sIn.WriteLine(String.Format(stEchoFmt, strFilePath));
            sIn.WriteLine("EXIT");
            // Close the process
            proc.Close();
            //this.AfterInstall += new InstallEventHandler(ServiceInstaller_AfterInstall);
            sIn.Close();
            sOut.Close();
        }

GridView Javascript Validations

GridView needs 2 types of validations as below:

1. FooterRow Validations while Adding
2.EditRow Validations while updating

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Footer Row Validations.
In the below code, GridViewID is gridview id. replace textbox id as per requirment.
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

 <script type="text/javascript">
function Validate_Add() {
        var error = "";
        var code = document.getElementById('<%=((TextBox)GridViewID.FooterRow.FindControl("txtAddCode")).ClientID%>')
        var Server = document.getElementById('<%=((TextBox)GridViewID.FooterRow.FindControl("txtAddServerName")).ClientID%>')
        var username = document.getElementById('<%=((TextBox)GridViewID.FooterRow.FindControl("txtAddUserName")).ClientID%>')
        var password = document.getElementById('<%=((TextBox)GridViewID.FooterRow.FindControl("txtAddServerPassword")).ClientID%>')
        if(code=="")
        error+="Enter Unique Code for  Server";
        if (Server.value == "") {
            error += "Enter  Server Name\r\n";          
        }    
        if (username.value == "")
            error += "Enter  Server User Name\r\n";
        if (password.value == "")
            error += "Enter  Server User Password\r\n";

        if (error == "")
            return true;
        else {
            alert(error)
            return false;
            }
        }



////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Edit Row Validations.
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

        function Validate_Edit(btnCtrl) {
            var error = "";
            var selectedRowIndex = btnCtrl.parentNode.parentNode.rowIndex;
            var gridView = document.getElementById('<%= GridViewID.ClientID %>');

            var Server = gridView.rows[parseInt(selectedRowIndex)].cells[1].children[0];
            var user_name = gridView.rows[parseInt(selectedRowIndex)].cells[2].children[0];
            var password = gridView.rows[parseInt(selectedRowIndex)].cells[3].children[0];
            if (Server.value == "")
                error += "Enter  Server Name\r\n";
            if (user_name.value == "")
                error += "Enter  User Name\r\n";
            if (password.value == "")
                error += "Enter  Server User Password\r\n";

            if (error == "")
                return true;
            else {
                alert(error)
                return false;
            }
        }
   
    </script>


////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
GridView Code
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////


<asp:GridView ID="GridViewID" runat="server" CssClass="GridStyle" HorizontalAlign="Left"
            AutoGenerateColumns="false" DataKeyNames="Code" AllowPaging="True" PageSize="10"
            ShowFooter="true" OnRowCancelingEdit="GridViewID_RowCancelingEdit" OnRowCommand="GridViewID_RowCommand"
            OnRowDeleting="GridViewID_RowDeleting" OnRowEditing="GridViewID_RowEditing"
            OnRowUpdating="GridViewID_RowUpdating">
            <Columns>
                <asp:TemplateField>
                    <HeaderTemplate>
                        Code</HeaderTemplate>
                    <ItemTemplate>
                        <%#Eval("Code") %></ItemTemplate>
                    <EditItemTemplate>
                        <%#Eval("Code") %>
                    </EditItemTemplate>
                    <FooterTemplate>
                        <asp:TextBox ID="txtAddCode" runat="server" CssClass="gridcontrol" MaxLength="10"
                            ToolTip="EnterUnique code for  Server"></asp:TextBox>
                    </FooterTemplate>
                </asp:TemplateField>
                <asp:TemplateField>
                    <HeaderTemplate>
                        Server Name</HeaderTemplate>
                    <ItemTemplate>
                        <%#Eval("ServerName") %></ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="txtEditServerName" runat="server" CssClass="gridcontrol" Text='<%#Eval("ServerName") %>'
                            MaxLength="100" ToolTip="Enter  Server Name"></asp:TextBox>
                    </EditItemTemplate>
                    <FooterTemplate>
                        <asp:TextBox ID="txtAddServerName" runat="server" CssClass="gridcontrol" MaxLength="100"
                            ToolTip="Enter  Server Name"></asp:TextBox>
                    </FooterTemplate>
                </asp:TemplateField>
                <asp:TemplateField>
                    <HeaderTemplate>
                        User Name</HeaderTemplate>
                    <ItemTemplate>
                        <%#Eval("UserName") %></ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="txtEditUserName" runat="server" CssClass="gridcontrol" Text='<%#Eval("UserName") %>'
                            MaxLength="100" ToolTip="Enter  Server User Name"></asp:TextBox>
                    </EditItemTemplate>
                    <FooterTemplate>
                        <asp:TextBox ID="txtAddUserName" runat="server" CssClass="gridcontrol" MaxLength="100"
                            ToolTip="Enter  Server User Name"></asp:TextBox>
                    </FooterTemplate>
                </asp:TemplateField>
                <asp:TemplateField>
                    <HeaderTemplate>
                        Password</HeaderTemplate>
                    <ItemTemplate>
                        ******</ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="txtEditPassword" runat="server" CssClass="gridcontrol" TextMode="Password"
                            MaxLength="100" ToolTip="Enter  Server User Passwor"></asp:TextBox>
                    </EditItemTemplate>
                    <FooterTemplate>
                        <asp:TextBox ID="txtAddServerPassword" runat="server" CssClass="gridcontrol" TextMode="Password"
                            MaxLength="100" ToolTip="Enter  Server User Passwor"></asp:TextBox>
                    </FooterTemplate>
                </asp:TemplateField>
                <asp:TemplateField>
                    <HeaderTemplate>
                        Description</HeaderTemplate>
                    <ItemTemplate>
                        <%#Eval("Desc") %></ItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="txtEditDesc" runat="server" CssClass="gridcontrol" MaxLength="100"
                            Text='<%#Eval("Desc") %>' ToolTip="Enter Description"></asp:TextBox>
                    </EditItemTemplate>
                    <FooterTemplate>
                        <asp:TextBox ID="txtAddDesc" runat="server" CssClass="gridcontrol" MaxLength="100"
                            ToolTip="Enter Description"></asp:TextBox>
                    </FooterTemplate>
                </asp:TemplateField>
                <asp:TemplateField>
                    <ItemTemplate>
                        <asp:ImageButton ID="imgEdit" runat="server" CommandName="Edit" ImageUrl="~/Images/Edit.png"
                            ToolTip="Edit this  Server" CssClass="iconstyle" />
                        <asp:ImageButton ID="imgDelete" runat="server" CommandName="Delete" ImageUrl="~/Images/delete.png"
                            ToolTip="Delete this  Server" CssClass="iconstyle" OnClientClick="javascript:return confirm('Are you sure you want to Delete this  Server ?','Yes','No');" />
                    </ItemTemplate>
                    <EditItemTemplate>
                        <asp:ImageButton ID="imgUpdate" runat="server" CommandName="Update" ImageUrl="~/Images/Update.png"
                            ToolTip="Update this  Server" CssClass="iconstyle" OnClientClick="return Validate_Edit(this)" />
                        <asp:ImageButton ID="imgDelete" runat="server" CommandName="Cancel" ImageUrl="~/Images/Cancel.png"
                            ToolTip="Cancel Editing of this  Server" CssClass="iconstyle" />
                    </EditItemTemplate>
                    <FooterTemplate>
                        <asp:Button ID="btnAdd" CssClass="btnstyle" ToolTip="Add  Server" CommandName="Add"
                            runat="server" Text="Add" OnClientClick="return Validate_Add();" />
                    </FooterTemplate>
                </asp:TemplateField>
            </Columns>          
            <FooterStyle CssClass="GridFooter" />
            <HeaderStyle CssClass="GridHeader" />
            <PagerSettings Mode="NumericFirstLast" />
            <PagerStyle HorizontalAlign="Center" CssClass="GridPager" />
            <AlternatingRowStyle CssClass="GridAlter" />
            <RowStyle CssClass="GridRowStyle" />
        </asp:GridView>

save text into notepad using c#.net

 public static void SaveMessage(string Message,string FileName)
        {
            string path = HttpContext.Current.Server.MapPath("Messages");
            if (!Directory.Exists(path))
                Directory.CreateDirectory(path);
            string filename = path + "\\" +FileName+"_"+ DateTime.Now.Year.ToString() + DateTime.Now.Month + DateTime.Now.Day + ".txt";
            string error = "\r\nMessage Occur at :" + DateTime.Now.ToString() +
              "\r\nMessage is : \r\n" + Message +          
              "\r\n***********************************************************************************************************************";
            using (StreamWriter strwr = File.AppendText(path))
            {
                strwr.WriteLine(error);
                strwr.Flush();
                strwr.Close();
            }
        }