asp.net edit command field with css and image

 <asp:CommandField ButtonType="Image" EditText="Edit" EditImageUrl="~/images/Edit.jpg"
                            HeaderStyle-CssClass="centerText" ItemStyle-CssClass="centerText" ControlStyle-CssClass="editIconSize"
                            HeaderText="Edit" ShowEditButton="True" ShowCancelButton="false" UpdateImageUrl="~/images/save.jpg" />

Select nth row of a table in sql server

SELECT * FROM (
     SELECT     ROW_NUMBER() OVER (ORDER BY CategoryId) AS RowNo,CategoryId, CategoryName, LessThan, GreaterThan, AdvisorId, CategoryRating
          FROM CategoryMapping
WHERE     (AdvisorId = 1)

 ) AS foo
WHERE RowNo= 2

asp.net gridview get column data from datatable

 for (int i = 0; i < tableQuestion.Rows.Count; i++)
            {
 string answer = tableQuestion.Rows[i]["Sanswer"].ToString();
}

asp.net gridview hide and show linkbutton in template field

ASPX -

 <asp:TemplateField HeaderText="Publish">
                        <ItemTemplate>
                            <asp:Label ID="lblStatus" Text='<%# Eval("Status") %>' runat="server" Visible="false"></asp:Label>
                            <asp:LinkButton ID="linkpublishQues" runat="server" CommandArgument='<%#Eval("QuestionId")%>'
                                CommandName="Publish" OnClientClick="return confirm('Do you want to publish this question?')">Publish</asp:LinkButton>
                            <asp:LinkButton ID="linkunpublishQues" runat="server" CommandArgument='<%#Eval("QuestionId")%>'
                                CommandName="UnPublish" OnClientClick="return confirm('Do you want to unpublish this question?')">UnPublish</asp:LinkButton>
                        </ItemTemplate>
                    </asp:TemplateField>


.CS -

 Label lblStatus = e.Row.FindControl("lblStatus") as Label;

                if (lblStatus.Text == "Save")
                {
                    LinkButton linkunpublishQues = (LinkButton)e.Row.FindControl("linkunpublishQues");
                    LinkButton linkpublishQues = (LinkButton)e.Row.FindControl("linkpublishQues");
                    linkunpublishQues.Visible = false;
                    linkpublishQues.Visible = true;

                }
                else if (lblStatus.Text == "Publish")
                {
                    LinkButton linkunpublishQues = (LinkButton)e.Row.FindControl("linkunpublishQues");
                    LinkButton linkpublishQues = (LinkButton)e.Row.FindControl("linkpublishQues");
                    linkunpublishQues.Visible = true;
                    linkpublishQues.Visible = false;
                }

asp.net gridview change update button text on commandfield edit button

  <asp:CommandField HeaderText="Edit" ShowEditButton="True"  UpdateText="Save" />

asp.net gridview hide cancel button in commandfield edit button

  <asp:CommandField HeaderText="Edit" ShowEditButton="True" ShowCancelButton="false"
                            />

asp.net editable nested gridview

http://www.codeproject.com/Articles/20047/Editable-Nested-GridView-All-in-One

asp.net Difference between Convert.ToString() and .ToString()

Convert.ToString() handles null, while ToString() doesn't.

asp.net clear all session

 public void ClearSession()
        {
            HttpContext.Current.Session.Clear();
        }

asp.net remove from session

 public void RemoveFromSession(string key)
        {
            HttpContext.Current.Session.Remove(key);
        }

asp.net update value in session

 public void UpdateInSession(string key, object value)
        {
            HttpContext.Current.Session[key] = value;
        }

asp.net set value in session

   public void SetInSession(string key, object value)
        {
            if (HttpContext.Current == null || HttpContext.Current.Session == null)
            {
                return;
            }
            HttpContext.Current.Session[key] = value;
        }

asp.net get value from session

  public object GetFromSession(string key)
        {
            if (HttpContext.Current == null || HttpContext.Current.Session == null)
            {
                return null;
            }
            return HttpContext.Current.Session[key];
        }

asp.net create separate class for session handling

  //added by shekhar 13/6/2014 To Clear Current Session
        public void ClearSession()
        {
            HttpContext.Current.Session.Clear();
        }
        //End Of Clear Session
        //added by shekhar 13/6/2014 To Remove item in session
        public void RemoveFromSession(string key)
        {
            HttpContext.Current.Session.Remove(key);
        }
        //end Of remove  

        public void SetInSession(string key, object value)
        {
            if (HttpContext.Current == null || HttpContext.Current.Session == null)
            {
                return;
            }
            HttpContext.Current.Session[key] = value;
        }

        public object GetFromSession(string key)
        {
            if (HttpContext.Current == null || HttpContext.Current.Session == null)
            {
                return null;
            }
            return HttpContext.Current.Session[key];
        }

        public void UpdateInSession(string key, object value)
        {
            HttpContext.Current.Session[key] = value;
        }

asp.net convert data from object to string

  string advisorId = Convert.ToString(_webcontext.GetFromSession("AdvisorId"));

asp.net abstract data from dataset

 ds = _categorymappingpresenter.getCategories(advisorId);

            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                category_entity.AdvisorId = Convert.ToString(_webcontext.GetFromSession("AdvisorId"));
                category_entity.Action = "U";
                category_entity.CategoryName = ds.Tables[0].Rows[i]["CategoryName"].ToString();
                category_entity.CategoryRating = ds.Tables[0].Rows[i]["Id"].ToString();
                category_entity.CategoryId = Convert.ToInt32(ds.Tables[0].Rows[i]["CategoryId"]);
                category_entity.Result = _categorymappingpresenter.addModifyCategory(category_entity);

            }

asp.net for loop on dataset

 ds = _categorymappingpresenter.getCategories(advisorId);

            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                category_entity.AdvisorId = Convert.ToString(_webcontext.GetFromSession("AdvisorId"));
                category_entity.Action = "U";
                category_entity.CategoryName = ds.Tables[0].Rows[i]["CategoryName"].ToString();
                category_entity.CategoryRating = ds.Tables[0].Rows[i]["Id"].ToString();
                category_entity.CategoryId = Convert.ToInt32(ds.Tables[0].Rows[i]["CategoryId"]);
                category_entity.Result = _categorymappingpresenter.addModifyCategory(category_entity);

            }

asp.net find Textbox text from gridview row

  category_entity.CategoryName = ((TextBox)GridView1.Rows[e.RowIndex]
                               .FindControl("txtCategoryName")).Text;

asp.net find label text from gridview row

  category_entity.CategoryId = Convert.ToInt32(((Label)GridView1.Rows[e.RowIndex]
                               .FindControl("lblCategoryId")).Text);

sharepoint 2010 Send Mail workflow

https://www.youtube.com/watch?v=uFWQ4gptgM4&feature=youtu.be