ASP.NET

protected void MainGrid_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
        string s = ((DataRowView)e.Row.DataItem).ToString();
}

string Password = "Password123";
object getPasswordFromUser =(object)Password;
xl.ActiveSheet.Protect(ref getPasswordFromUser, ref obj,
ref obj, ref obj, ref obj, ref obj, ref obj, ref obj, ref obj, ref obj,
ref obj, ref obj, ref obj, ref obj, ref objTrue, ref obj);

<br />
    <asp:GridView ID="gridOrganizationDetails" runat="server" <br />
                    AutoGenerateColumns ="false" OnRowEditing ="gridOrganizationDetails_RowEditing"<br />
                OnRowDeleting ="gridOrganizationDetails_RowDeleting" CellPadding="7" <br />
                    onrowcreated="gridOrganizationDetails_RowCreated" AllowPaging="True" <br />
                    PageSize="1"><br />
                    <RowStyle ForeColor="#000066" /><br />
                    <FooterStyle BackColor="White" ForeColor="#000066" /><br />
                    <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" /><br />
                    <PagerSettings Mode="NextPrevious" /><br />
                    <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" /><br />
                    <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" /><br />
                    <AlternatingRowStyle BackColor="#ffffff" /><br />
                    <AlternatingRowStyle BackColor="#ffffff" /><br />
                    <Columns><br />
                        <asp:BoundField HeaderText="Id" Visible ="true" DataField ="pk" /> <br />
                        <asp:BoundField HeaderText="Organization Name" Visible ="true" DataField ="name" />    <br />
                        <asp:BoundField HeaderText="Address 1" Visible ="true" DataField ="address1" />   <br />
                        <asp:TemplateField HeaderText="Active"><br />
                            <ItemTemplate><%# DisplayActive((Byte)Eval("is_Active"))%></ItemTemplate><br />
                        </asp:TemplateField>    <br />
                        <asp:CommandField ShowEditButton ="true" HeaderText ="Edit" <br />
                            HeaderStyle-HorizontalAlign ="Center" ItemStyle-HorizontalAlign ="Center" ><br />
                        <HeaderStyle HorizontalAlign="Center"></HeaderStyle><br />
<br />
                        <ItemStyle HorizontalAlign="Center"></ItemStyle><br />
                        </asp:CommandField><br />
                    </Columns><br />
                </asp:GridView><br />

<br />
 DataSet ds = myAction.GetOrganizationDetailsPaging(roleId, userId);<br />
        <br />
        //if (reader != null)<br />
        //{<br />
        gridOrganizationDetails.DataSource = ds;<br />
        gridOrganizationDetails.DataBind();<br />

if (roleId == Convert.ToInt32(UserRole.Admin))
          {
              query = "Select * from organization";
          }
          else
          {
              query = "select * from organization orga , user us where (orga.pk =us.org_fk) and us.role_fk ='" + roleId + "'" + "and (us.pk ='" + userId + "')";

          }



          DbAction dbConnector = new DbAction();
          //MySqlDataReader reader = dbConnector.ExecuteReader(query);
          DataSet ds = new DataSet();
          ds = dbConnector.ExecuteDataSet(query);
          return ds;

public DataSet ExecuteDataSet(String query)
       {
           DataSet ds = new DataSet();
           MySqlDataAdapter adapter = new MySqlDataAdapter(query, ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
           adapter.Fill(ds);

           return ds;
       }