files approve in dms

Question

1.00/5 (1 vote)

See more:

, +

hey

i try to approve documents using following code and quey

CODE

C#

protected void GrdFileApprove_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "_Approve")
            {
                using (SqlConnection con = DataAccess.GetConnected())
                {
                    try
                    {
                        int rowindex = Convert.ToInt32(e.CommandArgument);
                        GridViewRow row = (GridViewRow)((Control)e.CommandSource).NamingContainer;
                        LinkButton Prove_Button = (LinkButton)row.FindControl("BtnApprove");
                        SqlCommand cmd = new SqlCommand("approvefiles", con);
                        cmd.CommandType = CommandType.StoredProcedure;
                        int result = cmd.ExecuteNonQuery();
                        if (result != 0)
                        {
                            GrdFileApprove.bind();
                        }
                    }

                    catch (Exception ex)
                    {
                    }
                    finally
                    {
                        con.Close();
                    }
                }
            }


            else if (e.CommandName == "_Reject")
            {
               
            }

            }

then when i debug following error appear

The name 'DataAccess' does not exist in the current context

'System.Web.UI.WebControls.GridView' does not contain a definition for 'bind' and no extension method 'bind' accepting a first argument of type 'System.Web.UI.WebControls.GridView' could be found (are you missing a using directive or an assembly reference?)

Posted 26-Sep-13 1:57am

Diya Ayesa

Updated 26-Sep-13 1:58am

v3

Add a Solution

Comments

Harshil_Raval 26-Sep-13 8:05am

hi, there is no method like gridview.bind()!!! To bind grid you must have one datasource, and then you can bind grid.

gridview.DataSource = your datasource;
gridview.DataBind();

Diya Ayesa 26-Sep-13 8:43am

and what about the first error

Harshil_Raval 26-Sep-13 8:56am

At which line you are facing this error? The name 'DataAccess' does not exist in the current context

Diya Ayesa 26-Sep-13 9:19am

using (SqlConnection con = DataAccess.GetConnected())

IN THIS LINE

Harshil_Raval 26-Sep-13 9:28am

So, DataAccess is your static class name, in which you have created, static function GetConnected. From this you are getting connection string. Right?

Diya Ayesa 26-Sep-13 9:38am

i create connection string in web.config

Harshil_Raval 27-Sep-13 2:46am

Then what is DataAccess here?

Diya Ayesa 27-Sep-13 7:41am

ok now i use this way
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["mydms"].ConnectionString))

but i gives me compliation error

Diya Ayesa 27-Sep-13 23:00pm

/?????

Diya Ayesa 27-Sep-13 7:42am

compliation error
Server Error in '/' Application.
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS1061: 'ASP.supervisor_aspx' does not contain a definition for 'UPanle_DataBinding' and no extension method 'UPanle_DataBinding' accepting a first argument of type 'ASP.supervisor_aspx' could be found (are you missing a using directive or an assembly reference?)

Source Error:

Line 8:
Line 9:
Line 10: <asp:UpdatePanel runat="server" ID="UPanle" ondatabinding="UPanle_DataBinding">
Line 11: <contenttemplate>
Line 12: <asp:GridView ID="GrdFileApprove" runat="server" AutoGenerateColumns="false"

Harshil_Raval 28-Sep-13 0:24am

Hi, this error shows that you have not implement method UPanle_DataBinding in your code. Are you sure you have implement this method?

Diya Ayesa 28-Sep-13 19:24pm

yes

Diya Ayesa 28-Sep-13 19:25pm

protected void UPanle_DataBinding_Click(object sender, EventArgs e)
{

}
this is upanl _databindings

Diya Ayesa 28-Sep-13 19:29pm

when i implement UPanle_DataBinding code it give me error

Server Error in '/' Application.
The control with ID 'UPanle' requires a ScriptManager on the page. The ScriptManager must appear before any controls that need it.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The control with ID 'UPanle' requires a ScriptManager on the page. The ScriptManager must appear before any controls that need it.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: The control with ID 'UPanle' requires a ScriptManager on the page. The ScriptManager must appear before any controls that need it.]
System.Web.UI.UpdatePanel.get_ScriptManager() +365117
System.Web.UI.UpdatePanel.RegisterPanel() +87
System.Web.UI.UpdatePanel.OnInit(EventArgs e) +19
System.Web.UI.Control.InitRecursive(Control namingContainer) +333
System.Web.UI.Control.InitRecursive(Control namingContainer) +210
System.Web.UI.Control.InitRecursive(Control namingContainer) +210
System.Web.UI.Control.InitRecursive(Control namingContainer) +210
System.Web.UI.Control.InitRecursive(Control namingContainer) +210
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +378

then when i add script manager adn it look like this

<div class="vpb_main_wrapper2" top=20 align="center" style="left: inherit"/><br clear="all"/>
<div>
<asp:ScriptManager ID="ScriptManager1" runat="server">
<asp:UpdatePanel runat="server" ID="UPanle"
ondatabinding="UPanle_DataBinding_Click">
<contenttemplate>
<asp:GridView ID="GrdFileApprove" runat="server" AutoGenerateColumns="false"
onrowcommand="GrdFileApprove_RowCommand"
onselectedindexchanged="GrdFileApprove_SelectedIndexChanged">
<columns> <asp:TemplateField HeaderText="S no">
<itemtemplate>
<%# Container.DataItemIndex+1 %>
<asp:HiddenField runat="server" ID="HdnFileID" Value='<%# Eval("DocID") %>' />

<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:TemplateField HeaderText="S no">
<itemtemplate>
<asp:Button runat="server" Id="BtnApprove" CommandName="_Approve"
CommandArgument='<%# Eval("DocID") %>' Text="Aprrove" />
<asp:Button runat="server" Id="Button1" CommandName="_Reject"
CommandArgument='<%# Eval("DocID") %>' Text="Reject" />

</div>

Diya Ayesa 28-Sep-13 19:32pm

then it give me error when i debug

Server Error in '/' Application.
Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Type 'System.Web.UI.ScriptManager' does not have a public property named 'UpdatePanel'.

Source Error:

Line 18: <div>
Line 19: <asp:ScriptManager ID="ScriptManager1" runat="server">
Line 20: <asp:UpdatePanel runat="server" ID="UPanle"
Line 21: ondatabinding="UPanle_DataBinding_Click">
Line 22: <contenttemplate>

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)