Lock Request time out period exceeded.

If the table or Stored procedures has locked by Sql server means Use the below Commands to release.


TO check Due to which operation its got blocked:
DBCC opentran()

To see in detail.
sp_who2 70
sp_lock 70

Kill That transaction
KILL 70

Downloading files from server folder in C# on link button clicked Event which is inside GridView

     


              

 protected void lnk_attach4_Click(object sender, EventArgs e)

    {

        try

        {

            LinkButton _lnk = (LinkButton)sender;

            GridViewRow _row = (GridViewRow)_lnk.NamingContainer;

            int _i = Convert.ToInt32(_row.RowIndex);

            int _reqID = Convert.ToInt32(gv_hrmrequest.DataKeys[_i][0].ToString());

            string _LogPath = ConfigurationManager.AppSettings["Docs"].ToString();

            string _filename1 = _LogPath + _reqID + "_4_" + _lnk.Text;

            if (_lnk.Text != string.Empty)

            {

                if (_lnk.Text.EndsWith(".txt"))

                {

                    Response.ContentType = "application/txt";

                }

                else if (_lnk.Text.EndsWith(".pdf"))

                {

                    Response.ContentType = "application/pdf";

                }

                else if (_lnk.Text.EndsWith(".docx"))

                {

                    Response.ContentType = "application/docx";

                }

                else

                {

                    Response.ContentType = "image/jpg";

                }

                string filePath = _lnk.Text;

                Response.AddHeader("Content-Disposition", "attachment;filename=\"" + filePath + "\"");

                Response.TransmitFile(_filename1);

                Response.End();

            }

        }

        catch (Exception ex)

        {

        }

        finally

        {

        }

    }

Select / Dis select all the check boxes inside the Grid view using java script.

// javascript block



function SelectAll() {
            var gv = document.getElementById('<%=gv_orderdetails.ClientID%>');

            if (gv.rows[0].cells[5].getElementsByTagName("INPUT")[0].checked == true) {
                for (var i = 1 ; i < gv.rows.length; i++) {
                    gv.rows[i].cells[5].getElementsByTagName("INPUT")[0].checked = true;
                }
            }
            else {
                for (var i = 1 ; i < gv.rows.length; i++) {
                    gv.rows[i].cells[5].getElementsByTagName("INPUT")[0].checked = false;
                }
            }

        }

        function disselect()
        {
            var gv = document.getElementById('<%=gv_orderdetails.ClientID%>');

            var x = false;

            for (var i = 1 ; i < gv.rows.length-1; i++)
            {
                if (gv.rows[i].cells[5].getElementsByTagName("INPUT")[0].checked == true)
                {
                    x = true;
                }
                if (gv.rows[i].cells[5].getElementsByTagName("INPUT")[0].checked == false)
                {
                    x = false;
                    break;
                }

            }

            if (!x)
            {
                gv.rows[0].cells[5].getElementsByTagName("INPUT")[0].checked = false;
            }
            else
            {
                gv.rows[0].cells[5].getElementsByTagName("INPUT")[0].checked = true;
            }
        }




------------------------------------------------------------------

// In Design


             <asp:TemplateField HeaderStyle-Width="30px">
                    <HeaderTemplate>
                        <asp:CheckBox ID="chk_Headerselect" runat="server"                              onclick="Javascript:SelectAll();" />
                    </HeaderTemplate>
                    <ItemTemplate>
                        <asp:CheckBox ID="chk_select" runat="server"
  onclick="Javascript:disselect();"/>
                    </ItemTemplate>
                    <ItemStyle HorizontalAlign="Center" />
                    <HeaderStyle HorizontalAlign="Center" />
                </asp:TemplateField>

Creating New Outlook mail Item Using C#

using Microsoft.Office.Interop.Outlook;
using OutlookApp = Microsoft.Office.Interop.Outlook.Application;

-----------------------------------------------------------------------------


               OutlookApp outlookApp1 = new OutlookApp();
                MailItem _mi =(MailItem) outlookApp1.CreateItem(OlItemType.olMailItem);
                _mi.Subject = "This is the subject";
                _mi.To = "someone@example.com";
                _mi.Body = "This is the message.";
                _mi.Attachments.Add(@"C:/Users/Manjunath.le/Downloads/Annexure.pdf");
                _mi.Display(false);


// This will open New Outlook mail Create Window.

Preventing user to select date greater than today in Ajax calender extender.

<script type="text/javascript">

function checkDate(sender, args) {
            if (sender._selectedDate > new Date()) {
                alert("You cannot select a day Greater than today!");
                sender._selectedDate = new Date();
                // set the date back to the current date
                sender._textbox.set_Value(sender._selectedDate.format(sender._format))
            }

</script>


Design:


  <asp:TextBox ID="txt_FDate" runat="server" Width="100px"></asp:TextBox>
                <img id="calendar_Img1" src="Images/calendar.gif" alt="Calendar" />
                <cc1:CalendarExtender ID="CalendarExtender1" runat="server" TargetControlID="txt_FDate"
                    CssClass="cal_Theme1" Format="yyyy-MM-dd" PopupButtonID="calendar_Img1" OnClientDateSelectionChanged="checkDate">
                </cc1:CalendarExtender>

Getting Data table from the Excel Sheet Using C#

        string connectionString = "";

        bool flag = true;

        object value;

        try

        {

            string fileName = Path.GetFileName(fb_master.PostedFile.FileName);

            string fileExtension = Path.GetExtension(fb_master.PostedFile.FileName);

            string folder = ConfigurationManager.AppSettings["TargetFiles"];

            string fileLocation = ConfigurationManager.AppSettings["TargetFiles"]+System.DateTime.Today.ToString("dd-MMyyyy")+"_"+ fileName;

            DirectoryInfo dir = new DirectoryInfo(folder);

            if (!dir.Exists)

                dir.Create();

            fb_master.SaveAs(fileLocation);

            if (fb_master.HasFile)

            {

                //Check whether file extension is xls or xslx

                if (fileExtension == ".xls")

                {

                    connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";

                }

                else if (fileExtension == ".xlsx")

                {

                    //connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1\"";

                    connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"";

                }

                //Create OleDB Connection and OleDb Command

                OleDbConnection con = new OleDbConnection(connectionString);

                OleDbCommand cmd = new OleDbCommand();

                cmd.CommandType = System.Data.CommandType.Text;

                cmd.Connection = con;

                OleDbDataAdapter dAdapter = new OleDbDataAdapter(cmd);

                DataTable dtExcelRecords = new DataTable();

                con.Open();

                DataTable dtExcelSheetName = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

                string getExcelSheetName = dtExcelSheetName.Rows[0]["Table_Name"].ToString();

                cmd.CommandText = "SELECT * FROM [" + getExcelSheetName + "] where Finyear is not null ";

                dAdapter.SelectCommand = cmd;

                dAdapter.Fill(dtExcelRecords);

                con.Close();

          }

        }

        catch (Exception ex)

        {

            UserMessage.ShowUserMessage("Excel file cannot be uploaded.please check the data in Excel file.It may contains Null values.");

            _gb.ErrorLog(ex.Message);

        }

Avoiding special characters in C# using javascript

 function isNumber(evt)
       {
                   evt = (evt) ? evt : window.event;
                   var charCode = (evt.which) ? evt.which : evt.keyCode;
                   if (charCode > 59 && charCode < 64)     // here m checking for < > ? characters only
                  {
                      return false;
                   }
                   return true;
        }


// Call this javascript function onkeypress event of the text box like -   onkeypress="return isNumber(event)"