Hi guys,
I am trying to get a GridView in ASP.net to update some info I am getting from a DB, I have this code:
In my DAL I have:
The error I get when trying to update a field is this:
ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'UpdateEmployee' that has parameters: EmployeeId, login, password, branchid, fullname, statusid, roleid, BranchName, state, role.
So it looks like it thinks it needs the state and role name, can I not get it to work these out based upon the name people select in the gridview, i.e. set a value field and a text field?
Could anyone offer any suggestions?
Regards,
James
I am trying to get a GridView in ASP.net to update some info I am getting from a DB, I have this code:
Code:
[size=2][/size][size=2][color=#0000ff]<[/color][/size][size=2][color=#800000]asp[/color][/size][size=2][color=#0000ff]:[/color][/size][size=2][color=#800000]GridView[/color][/size][size=2] [/size][size=2][color=#ff0000]ID[/color][/size][size=2][color=#0000ff]="GridView1"[/color][/size][size=2] [/size][size=2][color=#ff0000]runat[/color][/size][size=2][color=#0000ff]="server"[/color][/size][size=2] [/size][size=2][color=#ff0000]DataSourceID[/color][/size][size=2][color=#0000ff]="ObjectDataSource1">[/color][/size]
[size=2][color=#0000ff]<[/color][/size][size=2][color=#800000]Columns[/color][/size][size=2][color=#0000ff]>[/color][/size]
[size=2][color=#0000ff]<[/color][/size][size=2][color=#800000]asp[/color][/size][size=2][color=#0000ff]:[/color][/size][size=2][color=#800000]CommandField[/color][/size][size=2] [/size][size=2][color=#ff0000]ShowEditButton[/color][/size][size=2][color=#0000ff]="True"[/color][/size][size=2] [/size][size=2][color=#0000ff]/>[/color][/size]
[size=2][color=#0000ff]</[/color][/size][size=2][color=#800000]Columns[/color][/size][size=2][color=#0000ff]>[/color][/size]
[size=2][color=#0000ff]</[/color][/size][size=2][color=#800000]asp[/color][/size][size=2][color=#0000ff]:[/color][/size][size=2][color=#800000]GridView[/color][/size][size=2][color=#0000ff]>
[/color][/size][size=2][/size][size=2][color=#0000ff]<[/color][/size][size=2][color=#800000]asp[/color][/size][size=2][color=#0000ff]:[/color][/size][size=2][color=#800000]ObjectDataSource[/color][/size][size=2] [/size][size=2][color=#ff0000]ID[/color][/size][size=2][color=#0000ff]="ObjectDataSource1"[/color][/size][size=2] [/size][size=2][color=#ff0000]runat[/color][/size][size=2][color=#0000ff]="server" [/color][/size][size=2][color=#ff0000]SelectMethod[/color][/size][size=2][color=#0000ff]="GetAllEmployeeData"[/color][/size][size=2] [/size][size=2][color=#ff0000]TypeName[/color][/size][size=2][color=#0000ff]="EmployeeDAL" [/color][/size][size=2][color=#ff0000]UpdateMethod[/color][/size][size=2][color=#0000ff]="UpdateEmployee">[/color][/size]
[size=2][color=#0000ff]<[/color][/size][size=2][color=#800000]UpdateParameters[/color][/size][size=2][color=#0000ff]>[/color][/size]
[size=2][color=#0000ff]<[/color][/size][size=2][color=#800000]asp[/color][/size][size=2][color=#0000ff]:[/color][/size][size=2][color=#800000]Parameter[/color][/size][size=2] [/size][size=2][color=#ff0000]Name[/color][/size][size=2][color=#0000ff]="employeeid"[/color][/size][size=2] [/size][size=2][color=#ff0000]Type[/color][/size][size=2][color=#0000ff]="Int32"[/color][/size][size=2] [/size][size=2][color=#0000ff]/>[/color][/size]
[size=2][color=#0000ff]<[/color][/size][size=2][color=#800000]asp[/color][/size][size=2][color=#0000ff]:[/color][/size][size=2][color=#800000]Parameter[/color][/size][size=2] [/size][size=2][color=#ff0000]Name[/color][/size][size=2][color=#0000ff]="login"[/color][/size][size=2] [/size][size=2][color=#ff0000]Type[/color][/size][size=2][color=#0000ff]="String"[/color][/size][size=2] [/size][size=2][color=#0000ff]/>[/color][/size]
[size=2][color=#0000ff]<[/color][/size][size=2][color=#800000]asp[/color][/size][size=2][color=#0000ff]:[/color][/size][size=2][color=#800000]Parameter[/color][/size][size=2] [/size][size=2][color=#ff0000]Name[/color][/size][size=2][color=#0000ff]="password"[/color][/size][size=2] [/size][size=2][color=#ff0000]Type[/color][/size][size=2][color=#0000ff]="String"[/color][/size][size=2] [/size][size=2][color=#0000ff]/>[/color][/size]
[size=2][color=#0000ff]<[/color][/size][size=2][color=#800000]asp[/color][/size][size=2][color=#0000ff]:[/color][/size][size=2][color=#800000]Parameter[/color][/size][size=2] [/size][size=2][color=#ff0000]Name[/color][/size][size=2][color=#0000ff]="branchid"[/color][/size][size=2] [/size][size=2][color=#ff0000]Type[/color][/size][size=2][color=#0000ff]="Int32"[/color][/size][size=2] [/size][size=2][color=#0000ff]/>[/color][/size]
[size=2][color=#0000ff]<[/color][/size][size=2][color=#800000]asp[/color][/size][size=2][color=#0000ff]:[/color][/size][size=2][color=#800000]Parameter[/color][/size][size=2] [/size][size=2][color=#ff0000]Name[/color][/size][size=2][color=#0000ff]="fullname"[/color][/size][size=2] [/size][size=2][color=#ff0000]Type[/color][/size][size=2][color=#0000ff]="String"[/color][/size][size=2] [/size][size=2][color=#0000ff]/>[/color][/size]
[size=2][color=#0000ff]<[/color][/size][size=2][color=#800000]asp[/color][/size][size=2][color=#0000ff]:[/color][/size][size=2][color=#800000]Parameter[/color][/size][size=2] [/size][size=2][color=#ff0000]Name[/color][/size][size=2][color=#0000ff]="statusid"[/color][/size][size=2] [/size][size=2][color=#ff0000]Type[/color][/size][size=2][color=#0000ff]="Int32"[/color][/size][size=2] [/size][size=2][color=#0000ff]/>[/color][/size]
[size=2][color=#0000ff]<[/color][/size][size=2][color=#800000]asp[/color][/size][size=2][color=#0000ff]:[/color][/size][size=2][color=#800000]Parameter[/color][/size][size=2] [/size][size=2][color=#ff0000]Name[/color][/size][size=2][color=#0000ff]="roleid"[/color][/size][size=2] [/size][size=2][color=#ff0000]Type[/color][/size][size=2][color=#0000ff]="Int32"[/color][/size][size=2] [/size][size=2][color=#0000ff]/>[/color][/size]
[size=2][color=#0000ff]</[/color][/size][size=2][color=#800000]UpdateParameters>[/color][/size]
[size=2][color=#0000ff]
[/color][/size][size=2][/size][size=2][color=#0000ff]</[/color][/size][size=2][color=#800000]asp[/color][/size][size=2][color=#0000ff]:[/color][/size][size=2][color=#800000]ObjectDataSource[/color][/size][size=2][color=#0000ff]>[/color][/size]In my DAL I have:
Code:
[size=2][/size][size=2][color=#0000ff]Public[/color][/size][size=2] [/size][size=2][color=#0000ff]Function[/color][/size][size=2] UpdateEmployee([/size][size=2][color=#0000ff]ByVal[/color][/size][size=2] employeeid [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]Integer[/color][/size][size=2], [/size][size=2][color=#0000ff]ByVal[/color][/size][size=2] login [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]String[/color][/size][size=2], [/size][size=2][color=#0000ff]ByVal[/color][/size][size=2] password [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]String[/color][/size][size=2], [/size][size=2][color=#0000ff]ByVal[/color][/size][size=2] branchid [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]Integer[/color][/size][size=2], [/size][size=2][color=#0000ff]ByVal[/color][/size][size=2] fullname [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]String[/color][/size][size=2], [/size][size=2][color=#0000ff]ByVal[/color][/size][size=2] statusid [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]Integer[/color][/size][size=2], [/size][size=2][color=#0000ff]ByVal[/color][/size][size=2] roleid [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]Integer[/color][/size][size=2]) [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]Boolean[/color][/size]
[size=2]OpenDeciusConnection()
[/size][size=2][color=#0000ff]Dim[/color][/size][size=2] cmd [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]New[/color][/size][size=2] SqlCommand([/size][size=2][color=#800000]"updateEmployee"[/color][/size][size=2], Connection)[/size]
[size=2]cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add([/size][size=2][color=#800000]"@employeeid"[/color][/size][size=2], SqlDbType.Int)[/size]
[size=2]cmd.Parameters.Add([/size][size=2][color=#800000]"@login"[/color][/size][size=2], SqlDbType.NVarChar)[/size]
[size=2]cmd.Parameters.Add([/size][size=2][color=#800000]"@password"[/color][/size][size=2], SqlDbType.NVarChar)[/size]
[size=2]cmd.Parameters.Add([/size][size=2][color=#800000]"@branchid"[/color][/size][size=2], SqlDbType.Int)[/size]
[size=2]cmd.Parameters.Add([/size][size=2][color=#800000]"@fullname"[/color][/size][size=2], SqlDbType.NVarChar)[/size]
[size=2]cmd.Parameters.Add([/size][size=2][color=#800000]"@statusid"[/color][/size][size=2], SqlDbType.Int)[/size]
[size=2]cmd.Parameters.Add([/size][size=2][color=#800000]"@roleid"[/color][/size][size=2], SqlDbType.Int)[/size]
[size=2]cmd.Parameters([/size][size=2][color=#800000]"@employeeid"[/color][/size][size=2]).Value = employeeid[/size]
[size=2]cmd.Parameters([/size][size=2][color=#800000]"@login"[/color][/size][size=2]).Value = login[/size]
[size=2]cmd.Parameters([/size][size=2][color=#800000]"@password"[/color][/size][size=2]).Value = password[/size]
[size=2]cmd.Parameters([/size][size=2][color=#800000]"@branchid"[/color][/size][size=2]).Value = branchid[/size]
[size=2]cmd.Parameters([/size][size=2][color=#800000]"@fullname"[/color][/size][size=2]).Value = fullname[/size]
[size=2]cmd.Parameters([/size][size=2][color=#800000]"@statusid"[/color][/size][size=2]).Value = statusid[/size]
[size=2]cmd.Parameters([/size][size=2][color=#800000]"@roleid"[/color][/size][size=2]).Value = roleid[/size]
[size=2]cmd.ExecuteNonQuery()
Connection.Close()
[/size][size=2][color=#0000ff]Return[/color][/size][size=2] [/size][size=2][color=#0000ff]True
[/color][/size]The error I get when trying to update a field is this:
ObjectDataSource 'ObjectDataSource1' could not find a non-generic method 'UpdateEmployee' that has parameters: EmployeeId, login, password, branchid, fullname, statusid, roleid, BranchName, state, role.
So it looks like it thinks it needs the state and role name, can I not get it to work these out based upon the name people select in the gridview, i.e. set a value field and a text field?
Could anyone offer any suggestions?
Regards,
James