gridview not filling RSS

• • Reply
  

  Hunain Hafee...

  Member

  238 Points

  639 Posts

  gridview not filling

  Nov 09, 2012 09:19 PM|LINK

  filling gridview on the basis of userid passed from another page, but gridview remain empty, why ?

  even value has been passed query has been tested in many other pages and working, but here i just get empty gridview , why ?

  code:

  <%@ Page Language="C#" MasterPageFile="~/MasterPageAdministration.master" AutoEventWireup="true" CodeFile="adminViewEmplyrFurther.aspx.cs" Inherits="adminViewEmplyrFurther" Title="Untitled Page" %>
  
  <asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
  </asp:Content>
  <asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
  
      <div class="superAdminGridViewContent">
      <h6>Employer's Personal Information
          <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
              DataKeyNames="pinfoid" DataSourceID="SqlDataSource1">
              <Columns>
                  <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                  <asp:BoundField DataField="pinfoid" HeaderText="pinfoid" InsertVisible="False"
                      ReadOnly="True" SortExpression="pinfoid" />
                  <asp:BoundField DataField="bankname" HeaderText="bankname"
                      SortExpression="bankname" />
                  <asp:BoundField DataField="bankdraftno" HeaderText="bankdraftno"
                      SortExpression="bankdraftno" />
                  <asp:BoundField DataField="amount" HeaderText="amount"
                      SortExpression="amount" />
                  <asp:BoundField DataField="dod" HeaderText="dod" SortExpression="dod" />
                  <asp:BoundField DataField="doc" HeaderText="doc" SortExpression="doc" />
                  <asp:BoundField DataField="firstname" HeaderText="firstname"
                      SortExpression="firstname" />
                  <asp:BoundField DataField="lastname" HeaderText="lastname"
                      SortExpression="lastname" />
                  <asp:BoundField DataField="fathername" HeaderText="fathername"
                      SortExpression="fathername" />
                  <asp:BoundField DataField="photo" HeaderText="photo" SortExpression="photo" />
                  <asp:BoundField DataField="country" HeaderText="country"
                      SortExpression="country" />
                  <asp:BoundField DataField="phoneno" HeaderText="phoneno"
                      SortExpression="phoneno" />
                  <asp:BoundField DataField="city" HeaderText="city" SortExpression="city" />
                  <asp:BoundField DataField="mobno" HeaderText="mobno" SortExpression="mobno" />
                  <asp:BoundField DataField="domicile" HeaderText="domicile"
                      SortExpression="domicile" />
                  <asp:BoundField DataField="sect" HeaderText="sect" SortExpression="sect" />
                  <asp:BoundField DataField="cnicnum" HeaderText="cnicnum"
                      SortExpression="cnicnum" />
                  <asp:BoundField DataField="nationality" HeaderText="nationality"
                      SortExpression="nationality" />
                  <asp:BoundField DataField="mailingadd" HeaderText="mailingadd"
                      SortExpression="mailingadd" />
                  <asp:BoundField DataField="companyname" HeaderText="companyname"
                      SortExpression="companyname" />
                  <asp:BoundField DataField="permanentadd" HeaderText="permanentadd"
                      SortExpression="permanentadd" />
                  <asp:BoundField DataField="companyurl" HeaderText="companyurl"
                      SortExpression="companyurl" />
                  <asp:BoundField DataField="companyemailadd" HeaderText="companyemailadd"
                      SortExpression="companyemailadd" />
                  <asp:BoundField DataField="companyadd" HeaderText="companyadd"
                      SortExpression="companyadd" />
                  <asp:BoundField DataField="faxnum" HeaderText="faxnum"
                      SortExpression="faxnum" />
                  <asp:BoundField DataField="contactperson" HeaderText="contactperson"
                      SortExpression="contactperson" />
                  <asp:BoundField DataField="companydescription" HeaderText="companydescription"
                      SortExpression="companydescription" />
                  <asp:CheckBoxField DataField="agreedtodec" HeaderText="agreedtodec"
                      SortExpression="agreedtodec" />
                  <asp:BoundField DataField="userid" HeaderText="userid"
                      SortExpression="userid" />
              </Columns>
          </asp:GridView>
          <asp:SqlDataSource ID="SqlDataSource1" runat="server"
              ConnectionString="<%$ ConnectionStrings:Waleed_orsfinalConnectionString23 %>"
              DeleteCommand="DELETE FROM [tblPersonalInfo] WHERE [pinfoid] = @pinfoid"
              InsertCommand="INSERT INTO [tblPersonalInfo] ([bankname], [bankdraftno], [amount], [dod], [doc], [firstname], [lastname], [fathername], [photo], [country], [phoneno], [city], [mobno], [domicile], [sect], [cnicnum], [nationality], [mailingadd], [companyname], [permanentadd], [companyurl], [companyemailadd], [companyadd], [faxnum], [contactperson], [companydescription], [agreedtodec], [userid]) VALUES (@bankname, @bankdraftno, @amount, @dod, @doc, @firstname, @lastname, @fathername, @photo, @country, @phoneno, @city, @mobno, @domicile, @sect, @cnicnum, @nationality, @mailingadd, @companyname, @permanentadd, @companyurl, @companyemailadd, @companyadd, @faxnum, @contactperson, @companydescription, @agreedtodec, @userid)"
              SelectCommand="SELECT [pinfoid], [bankname], [bankdraftno], [amount], [dod], [doc], [firstname], [lastname], [fathername], [photo], [country], [phoneno], [city], [mobno], [domicile], [sect], [cnicnum], [nationality], [mailingadd], [companyname], [permanentadd], [companyurl], [companyemailadd], [companyadd], [faxnum], [contactperson], [companydescription], [agreedtodec], [userid] FROM [tblPersonalInfo] where userid=@userid"
              UpdateCommand="UPDATE [tblPersonalInfo] SET [bankname] = @bankname, [bankdraftno] = @bankdraftno, [amount] = @amount, [dod] = @dod, [doc] = @doc, [firstname] = @firstname, [lastname] = @lastname, [fathername] = @fathername, [photo] = @photo, [country] = @country, [phoneno] = @phoneno, [city] = @city, [mobno] = @mobno, [domicile] = @domicile, [sect] = @sect, [cnicnum] = @cnicnum, [nationality] = @nationality, [mailingadd] = @mailingadd, [companyname] = @companyname, [permanentadd] = @permanentadd, [companyurl] = @companyurl, [companyemailadd] = @companyemailadd, [companyadd] = @companyadd, [faxnum] = @faxnum, [contactperson] = @contactperson, [companydescription] = @companydescription, [agreedtodec] = @agreedtodec, [userid] = @userid WHERE [pinfoid] = @pinfoid">
              <DeleteParameters>
                  <asp:Parameter Name="pinfoid" Type="Int32" />
              </DeleteParameters>
              <SelectParameters>
                  <asp:Parameter Name="pinfoid" Type="String" />
                  <asp:Parameter Name="bankname" Type="String" />
                  <asp:Parameter Name="bankdraftno" Type="String" />
                  <asp:Parameter Name="amount" Type="Int32" />
                  <asp:Parameter DbType="Date" Name="dod" />
                  <asp:Parameter Name="doc" Type="String" />
                  <asp:Parameter Name="firstname" Type="String" />
                  <asp:Parameter Name="lastname" Type="String" />
                  <asp:Parameter Name="fathername" Type="String" />
                  <asp:Parameter Name="photo" Type="String" />
                  <asp:Parameter Name="country" Type="String" />
                  <asp:Parameter Name="phoneno" Type="String" />
                  <asp:Parameter Name="city" Type="String" />
                  <asp:Parameter Name="mobno" Type="String" />
                  <asp:Parameter Name="domicile" Type="String" />
                  <asp:Parameter Name="sect" Type="String" />
                  <asp:Parameter Name="cnicnum" Type="String" />
                  <asp:Parameter Name="nationality" Type="String" />
                  <asp:Parameter Name="mailingadd" Type="String" />
                  <asp:Parameter Name="companyname" Type="String" />
                  <asp:Parameter Name="permanentadd" Type="String" />
                  <asp:Parameter Name="companyurl" Type="String" />
                  <asp:Parameter Name="companyemailadd" Type="String" />
                  <asp:Parameter Name="companyadd" Type="String" />
                  <asp:Parameter Name="faxnum" Type="Int64" />
                  <asp:Parameter Name="contactperson" Type="String" />
                  <asp:Parameter Name="companydescription" Type="String" />
                  <asp:Parameter Name="agreedtodec" Type="Boolean" />
                  <asp:QueryStringParameter Name="userid" Type="Int32" QueryStringField="userid" />
  
              </SelectParameters>
              <UpdateParameters>
                  <asp:Parameter Name="bankname" Type="String" />
                  <asp:Parameter Name="bankdraftno" Type="String" />
                  <asp:Parameter Name="amount" Type="Int32" />
                  <asp:Parameter DbType="Date" Name="dod" />
                  <asp:Parameter Name="doc" Type="String" />
                  <asp:Parameter Name="firstname" Type="String" />
                  <asp:Parameter Name="lastname" Type="String" />
                  <asp:Parameter Name="fathername" Type="String" />
                  <asp:Parameter Name="photo" Type="String" />
                  <asp:Parameter Name="country" Type="String" />
                  <asp:Parameter Name="phoneno" Type="String" />
                  <asp:Parameter Name="city" Type="String" />
                  <asp:Parameter Name="mobno" Type="String" />
                  <asp:Parameter Name="domicile" Type="String" />
                  <asp:Parameter Name="sect" Type="String" />
                  <asp:Parameter Name="cnicnum" Type="String" />
                  <asp:Parameter Name="nationality" Type="String" />
                  <asp:Parameter Name="mailingadd" Type="String" />
                  <asp:Parameter Name="companyname" Type="String" />
                  <asp:Parameter Name="permanentadd" Type="String" />
                  <asp:Parameter Name="companyurl" Type="String" />
                  <asp:Parameter Name="companyemailadd" Type="String" />
                  <asp:Parameter Name="companyadd" Type="String" />
                  <asp:Parameter Name="faxnum" Type="Int64" />
                  <asp:Parameter Name="contactperson" Type="String" />
                  <asp:Parameter Name="companydescription" Type="String" />
                  <asp:Parameter Name="agreedtodec" Type="Boolean" />
                  <asp:Parameter Name="userid" Type="Int32" />
                  <asp:Parameter Name="pinfoid" Type="Int32" />
              </UpdateParameters>
              <InsertParameters>
                  <asp:Parameter Name="bankname" Type="String" />
                  <asp:Parameter Name="bankdraftno" Type="String" />
                  <asp:Parameter Name="amount" Type="Int32" />
                  <asp:Parameter DbType="Date" Name="dod" />
                  <asp:Parameter Name="doc" Type="String" />
                  <asp:Parameter Name="firstname" Type="String" />
                  <asp:Parameter Name="lastname" Type="String" />
                  <asp:Parameter Name="fathername" Type="String" />
                  <asp:Parameter Name="photo" Type="String" />
                  <asp:Parameter Name="country" Type="String" />
                  <asp:Parameter Name="phoneno" Type="String" />
                  <asp:Parameter Name="city" Type="String" />
                  <asp:Parameter Name="mobno" Type="String" />
                  <asp:Parameter Name="domicile" Type="String" />
                  <asp:Parameter Name="sect" Type="String" />
                  <asp:Parameter Name="cnicnum" Type="String" />
                  <asp:Parameter Name="nationality" Type="String" />
                  <asp:Parameter Name="mailingadd" Type="String" />
                  <asp:Parameter Name="companyname" Type="String" />
                  <asp:Parameter Name="permanentadd" Type="String" />
                  <asp:Parameter Name="companyurl" Type="String" />
                  <asp:Parameter Name="companyemailadd" Type="String" />
                  <asp:Parameter Name="companyadd" Type="String" />
                  <asp:Parameter Name="faxnum" Type="Int64" />
                  <asp:Parameter Name="contactperson" Type="String" />
                  <asp:Parameter Name="companydescription" Type="String" />
                  <asp:Parameter Name="agreedtodec" Type="Boolean" />
                  <asp:Parameter Name="userid" Type="Int32" />
              </InsertParameters>
          </asp:SqlDataSource>
         </h6>
      
     </div>
  </asp:Content>

  
  
  

  Hunain Hafeez
• • Reply
  

  paindaasp

  Star

  12070 Points

  2034 Posts

  Re: gridview not filling

  Nov 09, 2012 11:39 PM|LINK

  Try deleting all of your SELECTPARAMETERS except

  <asp:QueryStringParameter Name="userid" Type="Int32" QueryStringField="userid" />

  • Marked as answer by Hunain Hafeez on Nov 10, 2012 02:15 PM
• • Reply
  

  oned_gk

  All-Star

  31361 Points

  6411 Posts

  Re: gridview not filling

  Nov 09, 2012 11:41 PM|LINK

  You have set datatype of select parameter querystring ti int32, try set to empty data type

  SelectCommand="SELECT [pinfoid], [bankname], [bankdraftno], [amount], [dod], [doc], [firstname],
  [lastname], [fathername], [photo], [country], [phoneno], [city], [mobno], [domicile], [sect], [cnicnum],
  [nationality], [mailingadd], [companyname], [permanentadd], [companyurl], [companyemailadd], [companyadd],
  [faxnum], [contactperson], [companydescription], [agreedtodec], [userid] FROM [tblPersonalInfo] where
  userid=@userid"
  
   
  <SelectParameters>
      <asp:QueryStringParameter Name="userid" QueryStringField="userid" />
  </SelectParameters>

  Programming to simplify, dont look for hard way
• • Reply
  

  Hunain Hafee...

  Member

  238 Points

  639 Posts

  Re: gridview not filling

  Nov 10, 2012 09:04 AM|LINK

  ok sir, i did what u suggested but still emtyp gridview

  Hunain Hafeez
• • Reply
  

  oned_gk

  All-Star

  31361 Points

  6411 Posts

  Re: gridview not filling

  Nov 10, 2012 09:24 AM|LINK

  try open directly to the url address with userid that you beleive will show the data. Maybe the problem is your hyperlink

  adminViewEmplyrFurther.aspx?userid=123

  Programming to simplify, dont look for hard way
  • Marked as answer by Hunain Hafeez on Nov 10, 2012 02:14 PM
• • Reply
  

  Hunain Hafee...

  Member

  238 Points

  639 Posts

  Re: gridview not filling

  Nov 10, 2012 02:15 PM|LINK

  oned_gk

  Maybe the problem is your hyperlink

  adminViewEmplyrFurther.aspx?userid=123

  oooooppppppsssssss :p  , yes exactly,  there wasn't any entry for userid that i was passing, but now i used valid id and its working ! Thanks bro !

  Hunain Hafeez
• • Reply
  

  Hunain Hafee...

  Member

  238 Points

  639 Posts

  Re: gridview not filling

  Nov 10, 2012 02:15 PM|LINK

  yes exactly, this was the first issue !

  Hunain Hafeez