A field or property with the name 'DocType' was not found on the selected data source.

Question

1.00/5 (1 vote)

See more:

i try to show documents specifically like hr admin only view hr documents and finance admin only view finance documents for this first i create a sp

SQL

alter procedure sphrdoc

@UserName  nvarchar(50),
@Password nvarchar(50)
as
select DepID from Userss where UserName=@UserName AND [Password]=@Password

and

C#

Session["a"] = dd.hrdoc(Convert.ToString(Session["Login2"]), (Convert.ToString(Session["Login3"])))

;

when admin user signup then his/her department id also save in userss table..

then i create a sp

SQL

create procedure sphrdocid1
@DepID int
as
select * from DocumentInfo where DepID=@DepID

and then i also a create a funtion

SQL

public int  hrdoc(string Username,string password)
      {
          return Convert.ToInt32( db.ExecuteScalar("sphrdoc",new object[]{Username,password}));

      }
      public DataTable hrdoc1(int id)
      {
          return db.ExecuteDataSet("sphrdocid1",new object[]{id}).Tables[0];


      }

and

C#

GrdFileApprove.DataSource = dd.hrdoc1(Convert.ToInt32(Session["a"]));
                GrdFileApprove.DataBind();

and gridview code is

XML

<asp:GridView ID="GrdFileApprove" runat="server" BackColor="White"
                  BorderColor="#336666" BorderStyle="Double" BorderWidth="3px" CellPadding="4"
                  GridLines="Horizontal" AutoGenerateColumns="False"
                    onrowcommand="GrdFileApprove_RowCommand"
                OnRowDataBound="OnRowDataBound"
                onselectedindexchanged="GrdFileApprove_SelectedIndexChanged1" >
                     <Columns>
                       <asp:TemplateField HeaderText="S no">
                           <ItemTemplate>
                               <%# Container.DataItemIndex+1 %>
                               <asp:HiddenField runat="server" ID="HdnFileID" Value='<%# Eval("DocID") %>' />
                           </ItemTemplate>
                       </asp:TemplateField>
                       <asp:BoundField DataField="DocID" HeaderText="DocumentID"  />
                       <asp:BoundField DataField="DocName" HeaderText="DocName"  />
                       <asp:BoundField DataField="Uploadfile" HeaderText="File Name" />
                       <asp:BoundField DataField="DocType" HeaderText="Document" />
                       <asp:BoundField DataField="DepType" HeaderText="Department" />

<%--                      <asp:BoundField HeaderText="ApproveID" DataField="ApproveID" ></asp:BoundField>
--%>              <asp:TemplateField>
                    <ItemTemplate>
                       <asp:Label ID="lblCountry" runat="server" Text='<%# Eval("ApproveID") %>' Visible = "false" />

                        <asp:DropDownList ID="DropDownList4" runat="server" EnableViewState="true" class="vpb_dropdown" DataTextField="ApproveType" DataValueField="ApproveID" AutoPostBack="true" OnSelectedIndexChanged="DropDownList4_SelectedIndexChanged">
                             <asp:ListItem Text="Pending" selected="selected" Value="3"></asp:ListItem>
                             <asp:ListItem Text="Approve" Value="1"></asp:ListItem>
                             <asp:ListItem Text="Reject" Value="2"></asp:ListItem>
                        </asp:DropDownList>
                    </ItemTemplate>
                </asp:TemplateField>

but it shows me error in this line

C#

GrdFileApprove.DataBind();

any solution?

Posted 22-Oct-13 7:59am

Diya Ayesa

Updated 22-Oct-13 8:00am

v2

Add a Solution

Comments

Ranjan.D 22-Oct-13 14:36pm

Put a breakpoint on line GrdFileApprove.DataBind(); and check whether the datasource has a column for DocType.

Diya Ayesa 22-Oct-13 14:43pm

but in database there is record of doctype

Ranjan.D 22-Oct-13 14:45pm

It doesn't matter. Did you do single step debug and try to verify whether the DataTable has that particular column or not ?

Diya Ayesa 22-Oct-13 15:04pm

yes i set a breakpoint but it can not even go on that line <asp:BoundField DataField="DocType" HeaderText="Document" />

and it show me error on this line GrdFileApprove.DataBind();

Ranjan.D 22-Oct-13 15:08pm

Wait you have to set a breakpoint on the below line on GrdFileApprove.DataSource , Then hit F11 for single step debug, then check the GrdFileApprove.DataSource , use visualizer to see the datatable.

GrdFileApprove.DataSource = dd.hrdoc1(Convert.ToInt32(Session["a"]));
GrdFileApprove.DataBind();

Diya Ayesa 22-Oct-13 15:43pm

when i set a breakpoint and point out the datasource it shows me this...GrdFileApprove.DataSource = null

Diya Ayesa 22-Oct-13 15:52pm

when i set a break point and point out the datasource it shows me this..."GrdFileApprove.DataSource = null"

JoCodes 22-Oct-13 15:14pm

Put a breakpoint on the hrdoc1 method and check whether ur datatable returns the doctype column in it

Gourav_Garg 22-Oct-13 15:16pm

<asp:BoundField DataField="DocType" HeaderText="Document" />

Remove this aND run your code...if it execute then check the database it has not "DocType" column

Diya Ayesa 22-Oct-13 15:45pm

now i try this sp

alter procedure sphrdoc2

@UserID int
as
select * from DocumentInfo where UserID=@UserID

and when i test the query as this

sphrdoc2 6

it show me this

DocID DocDesciption DocName Uploadfile DocTypeID DepID ApproveID UploadedBy UserID
8 paperssSSS SDASDASD dsfsdf.docx 1 4 NULL john 6
9 hr report dr reprt n analysis HR.docx 1 4 NULL john 6
10 hr reprttt hr report HR.docx 1 4 NULL john 6

and then i try thison page load

GrdFileApprove.DataSource = dd.gethrdoc22(Convert.ToInt32(Session["Userid"]));
GrdFileApprove.DataBind();

but whne i debug it can not show me any documents in form

Ranjan.D 22-Oct-13 17:10pm

I see there's one problem in your Grid. Your stored procedure does not return data for column DepType , so how can you have the below mentioned BoundField ? Remove that and verify.

<asp:BoundField DataField="DepType" HeaderText="Department" />

JoCodes 23-Oct-13 0:36am

You need to return the columns from the SP/Query which you intend to bind to the GridView. In this case , it seems that the SP doesnt do that. Either you remove DepType and DocType from the BoundField or include those in your Sp ( You may use Joins for that. )

Diya Ayesa 23-Oct-13 4:25am

ok nw i try this sp but it alwayas not show me gridview...
ALTER procedure [dbo].[sphrdoc2]

@UserID int
as
SELECT DocumentInfo.DocID,
dbo.DocumentInfo.DocName,
dbo.DocumentInfo.Uploadfile,
dbo.DocType.DocType,
dbo.Department.DepType ,
dbo.ApproveType.ApproveType AS ApproveID
FROM dbo.DocumentInfo
LEFT JOIN dbo.DocType ON dbo.DocumentInfo.DocTypeID=dbo.DocType.DocTypeID
LEFT JOIN dbo.Department ON dbo.DocumentInfo.DepID=dbo.Department.DepID
LEFT JOIN dbo.ApproveType ON dbo.ApproveType.approveid=dbo.Department.DepID where UserID=@UserID

JoCodes 23-Oct-13 5:18am

Whats the rows this SP fetching for you?

JoCodes 23-Oct-13 5:21am

Are you using sphrdocid1 or sphrdocid2 SP in your code?

Diya Ayesa 23-Oct-13 6:08am

i use sphrdoc2 .......
public DataTable gethrdoc22(int id)
{
return db.ExecuteDataSet("sphrdoc2", new object[] { id }).Tables[0];

}

Diya Ayesa 23-Oct-13 13:54pm

????

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)