?
Solved

Overload resolution failed because no accessible 'Int' accepts this number of arguments

Posted on 2011-02-11
4
Medium Priority
?
1,098 Views
Last Modified: 2012-05-11
The error occures in the following code snippet:
<asp:TemplateColumn HeaderText="Size">
<HeaderStyle Wrap="False">
</HeaderStyle>
<ItemStyle Wrap="False">
</ItemStyle>
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem, "size") %>
<%# ((((int)DataBinder.Eval(Container.DataItem, "precision")) != 0) &&
(((int)DataBinder.Eval(Container.DataItem, "scale")) != 0)) ?
String.Format("({0}, {1})", (int)DataBinder.Eval(Container.DataItem, "precision"), (int)DataBinder.Eval(Container.DataItem, "scale")) : "" %>
</ItemTemplate>
</asp:TemplateColumn>
For further clarification see Attached File Code SnippetSnippet ID=7949286
Thanks in advance for any help given.
<%@ Register TagPrefix="Toolbar" TagName="HelpLogout" Src="Toolbars/HelpLogoutToolbar.ascx" %>
<%@ Register TagPrefix="Toolbar" TagName="Database" Src="Toolbars/DatabaseToolbar.ascx" %>
<%@ Register TagPrefix="Toolbar" TagName="Server" Src="Toolbars/ServerToolbar.ascx" %>
<%@ Register TagPrefix="Location" TagName="Server" Src="Toolbars/ServerLocation.ascx" %>
<%@ Register TagPrefix="Location" TagName="Database" Src="Toolbars/DatabaseLocation.ascx" %>
<%@ Register TagPrefix="Location" TagName="Table" Src="Toolbars/TableLocation.ascx" %>
<%@ Page language="VB" Inherits="SqlWebAdmin.edittable" Trace="false" CodeFile="Columns.aspx.vb" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD html 4.0 Transitional//EN" >
<html>
    <head>
        <title>Web Data Administrator - Table Columns</title>
        <link rel="shortcut icon" href="favicon.ico">
        <link rel="stylesheet" type="text/css" href="admin.css">
    </head>
    <body bottomMargin="0" leftMargin="0" topMargin="0" rightMargin="0">
        <form id="Tables" method="post" runat="server">
            <table width="100%" height="100%" cellSpacing="0" cellPadding="0" border="0">
                <!-- FIRST ROW: HEADER -->
                <tr>
                    <td colspan="3" valign="bottom" align="left" width="100%" height="36" bgcolor="#c0c0c0">
                        <table cellSpacing="0" cellPadding="0" width="100%" border="0">
                            <tr>
                                <!--BEGIN ONE LINE-->
                                <td valign="bottom" width="308"><img src="images/logo_top.gif" width="308" height="36" alt="" border="0"></td>
                                <!--END ONE LINE-->
                                <td valign="bottom" align="right" width="100%">
                                    <Toolbar:HelpLogout Runat="server" id="HelpLogout" HelpTopic="columns"></Toolbar:HelpLogout>
                                </td>
                            </tr>
                        </table>
                    </td>
                </tr>
                <!-- FIRST ROW: HEADER -->
                <!-- SECOND ROW: CRUMBS -->
                <tr>
                    <!--BEGIN ONE LINE-->
                    <td align="left" bgcolor="#99ccff" background="images/blue_back.gif" width="172" height="26"><img src="images/logo_bottom.gif" width="172" height="26" alt="" border="0"></td>
                    <!--END ONE LINE-->
                    <td align="left" bgColor="#99ccff" background="images/blue_back.gif" width="100%" height="26">
                        <table width="100%" height="26" cellSpacing="0" cellPadding="0" border="0" style="table-LAYOUT:fixed">
                            <tr>
                                <td width="12">
                                    &nbsp;
                                </td>
                                <td valign="center" align="left" width="100%" height="26">
                                    <Location:Server Runat="Server" id="ServerLocation"></Location:Server>
                                    <Location:Database Runat="Server" id="DatabaseLocation"></Location:Database>
                                    <Location:Table Runat="Server" id="TableLocation"></Location:Table>
                                </td>
                            </tr>
                        </table>
                    </td>
                    <!--BEGIN ONE LINE-->
                    <td align="left" bgcolor="#99ccff" width="12" height="26"><img src="images/blue_back_right.gif" width="12" height="26" alt="" border="0"></td>
                    <!--END ONE LINE-->
                </tr>
                <!-- SECOND ROW: CRUMBS -->
                <!-- THIRD ROW: BOTTOM SECTION -->
                <tr>
                    <!-- START NAVIGATION SECTION -->
                    <td bgcolor="#6699ff" valign="top" align="middle" width="172" height="100%">
                        <Toolbar:Server Runat="server" id="ServerToolbar">
                        </Toolbar:Server>
                        <Toolbar:Database Runat="server" ID="DatabaseToolbar">
                        </Toolbar:Database>
                    </td>
                    <!-- END NAVIGATION SECTION -->
                    <!-- START CONTENT SECTION -->
                    <td valign="top" align="left">
                        <table cellSpacing="0" cellPadding="0" border="0" width="100%">
                            <tr>
                                <!--BEGIN ONE LINE-->
                                <td valign="bottom" colSpan="2" height="8" width="100%"><img src="images/spacer.gif" width="1" height="8" alt="" border="0"></td>
                                <!--END ONE LINE-->
                            </tr>
                            <tr>
                                <!--BEGIN ONE LINE-->
                                <td align="left" width="12"><img src="images/spacer.gif" width="12" height="1" alt="" border="0"></td>
                                <!--END ONE LINE-->
                                <td align="left" class="databaseListItem" width="100%">
                                    <!-- PAGE CONTENT: START -->
                                    <!-- SECTION HEADER: START -->
                                    <table cellSpacing="0" cellPadding="0" width="100%" border="0">
                                        <tr>
                                            <td class="databaseListHeader">
                                                table COLUMNS
                                            </td>
                                        </tr>
                                        <!-- SECTION HEADER: END -->
                                        <!-- SECTION: START -->
                                        <tr>
                                            <!--BEGIN ONE LINE-->
                                            <td height="3" valign="middle" background="images/blue_dotted_line.gif"><img src="images/blue_dotted_line.gif" width="150" height="3" alt="" border="0"></td>
                                            <!--END ONE LINE-->
                                        </tr>
                                        <tr>
                                            <!--BEGIN ONE LINE-->
                                            <td height="4" valign="middle"><img src="images/spacer.gif" width="1" height="4" alt="" border="0"></td>
                                            <!--END ONE LINE-->
                                        </tr>
                                        <tr>
                                            <td bgcolor="white" class="databaseListItem">

                                                <table width="100%" cellspacing="0" cellpadding="0" border="0">
                                                    <tr>
                                                        <td align="right">
                                                            <asp:HyperLink Runat="server" CssClass="createLink" ID="AddNewColumnHyperLink"><img src="images/new.gif" width="16" height="16" alt="" border="0">
                                                            <span style="position:relative; top: -3px;">Create new column</span></asp:HyperLink>
                                                        </td>
                                                    </tr>
                                                </table>
                                                <br>
                                                <asp:datagrid id="ColumnsDataGrid" runat="server" Border="0" AutoGenerateColumns="False" GridLines="None" Width="100%" CellPadding="4" CellSpacing="1">
                                                    <HeaderStyle CssClass="tableHeader"></HeaderStyle>
                                                    <ItemStyle CssClass="tableItems"></ItemStyle>
                                                    <Columns>
                                                        <asp:TemplateColumn HeaderText="Key">
                                                            <HeaderStyle Wrap="False">
                                                            </HeaderStyle>
                                                            <ItemStyle Wrap="False" HorizontalAlign="Center">
                                                            </ItemStyle>
                                                            <ItemTemplate>
                                                                <asp:Image Visible='<%# ((bool)DataBinder.Eval(Container.DataItem, "key")) %>' runat="server" ImageUrl="images/key.gif" ID="Image1"></asp:Image>
                                                            </ItemTemplate>
                                                        </asp:TemplateColumn>
                                                        
                                                        <asp:TemplateColumn HeaderText="ID">
                                                            <HeaderStyle Wrap="False">
                                                            </HeaderStyle>
                                                            <ItemStyle Wrap="False" HorizontalAlign="Center">
                                                            </ItemStyle>
                                                            <ItemTemplate>
                                                                <asp:Image Visible='<%# ((bool)DataBinder.Eval(Container.DataItem, "id")) %>' runat="server" ImageUrl="images/checkmark.gif" ID="Image2"></asp:Image>
                                                            </ItemTemplate>
                                                        </asp:TemplateColumn>
                                                        
                                                        <asp:BoundColumn DataField="name" HeaderText="Name" DataFormatString="{0}">
                                                            <HeaderStyle Wrap="False">
                                                            </HeaderStyle>
                                                            <ItemStyle Wrap="False">
                                                            </ItemStyle>
                                                        </asp:BoundColumn>    
                                                                                                            
                                                        <asp:TemplateColumn HeaderText="Name">
                                                            <HeaderStyle Wrap="False">
                                                            </HeaderStyle>
                                                            <ItemStyle Wrap="False">
                                                            </ItemStyle>
                                                            <ItemTemplate>
                                                                <asp:HyperLink id="Hyperlink1" runat="server" text='<%# DataBinder.Eval(Container.DataItem, "name") %>' cssclass="databaseListBlack" NavigateUrl='<%# String.Format("editcolumn.aspx?database={0}&table={1}&column={2}", Server.UrlEncode(Request("database")), Server.UrlEncode(Request("table")), DataBinder.Eval(Container.DataItem, "encodedname")) %>'></asp:HyperLink>
                                                            </ItemTemplate>
                                                        </asp:TemplateColumn>
                                                        
                                                        <asp:BoundColumn DataField="datatype" HeaderText="Data Type" DataFormatString="{0}">
                                                            <HeaderStyle Wrap="False">
                                                            </HeaderStyle>
                                                            <ItemStyle Wrap="False">
                                                            </ItemStyle>
                                                        </asp:BoundColumn>
                                                        
                                                        <asp:TemplateColumn HeaderText="Size">
                                                            <HeaderStyle Wrap="False">
                                                            </HeaderStyle>
                                                            <ItemStyle Wrap="False">
                                                            </ItemStyle>
                                                            <ItemTemplate>
                                                                <%# DataBinder.Eval(Container.DataItem, "size") %>
                                                                <%# ((((int)DataBinder.Eval(Container.DataItem, "precision")) != 0) &&
                                                                    (((int)DataBinder.Eval(Container.DataItem, "scale")) != 0)) ?
                                                                    String.Format("({0}, {1})", (int)DataBinder.Eval(Container.DataItem, "precision"), (int)DataBinder.Eval(Container.DataItem, "scale")) : "" %>
                                                            </ItemTemplate>
                                                        </asp:TemplateColumn>
                                                        
                                                        <asp:TemplateColumn HeaderText="Nulls">
                                                            <HeaderStyle Wrap="False">
                                                            </HeaderStyle>
                                                            <ItemStyle Wrap="False" HorizontalAlign="Center">
                                                            </ItemStyle>
                                                            <ItemTemplate>
                                                                <asp:Image runat="server" ImageUrl='<%# String.Format("images/{0}.gif", ((bool)DataBinder.Eval(Container.DataItem, "nulls")) ? "checkmark" : "checknomark") %>' ID="Image3"></asp:Image>
                                                            </ItemTemplate>
                                                        </asp:TemplateColumn>
                                                        
                                                        <asp:BoundColumn DataField="default" HeaderText="Default" DataFormatString="{0}">
                                                            <HeaderStyle Wrap="False">
                                                            </HeaderStyle>
                                                            <ItemStyle Wrap="False">
                                                            </ItemStyle>
                                                        </asp:BoundColumn>
                                                        
                                                        <asp:TemplateColumn HeaderText="Edit">
                                                            <HeaderStyle Wrap="False" HorizontalAlign="Right">
                                                            </HeaderStyle>
                                                            <ItemStyle Wrap="False" HorizontalAlign="Right">
                                                            </ItemStyle>
                                                            <ItemTemplate>
                                                                <asp:HyperLink id="EditColumn" runat="server" text="edit" cssclass="databaseListAction" NavigateUrl='<%# String.Format("editcolumn.aspx?database={0}&table={1}&column={2}", Server.UrlEncode(Request("database")), Server.UrlEncode(Request("table")), DataBinder.Eval(Container.DataItem, "encodedname")) %>'></asp:HyperLink>
                                                            </ItemTemplate>
                                                        </asp:TemplateColumn>
                                                        
                                                        <asp:TemplateColumn HeaderText="Delete">
                                                            <HeaderStyle Wrap="False" HorizontalAlign="Right">
                                                            </HeaderStyle>
                                                            <ItemStyle Wrap="False" HorizontalAlign="Right">
                                                            </ItemStyle>
                                                            <ItemTemplate>
                                                                <asp:HyperLink id="DeleteColumn" runat="server" text="delete" cssclass="databaseListAction" NavigateUrl='<%# String.Format("deletecolumn.aspx?database={0}&table={1}&column={2}", Server.UrlEncode(Request("database")), Server.UrlEncode(Request("table")), DataBinder.Eval(Container.DataItem, "encodedname")) %>'></asp:HyperLink>
                                                            </ItemTemplate>
                                                        </asp:TemplateColumn>
                                                    </Columns>
                                                </asp:datagrid>
                                                <asp:label id="NoColumnsLabel" runat="server" EnableViewState="False" Font-Bold="true" Font-Size="10">There are no columns to display.</asp:label>
                                            </td>
                                        </tr>
                                        <!-- Section END -->
                                        <!-- Section Footer START -->
                                    </table>
                                    <br>
                                    <!-- Section Footer END -->
                                    <!-- Page content END -->
                                </td>
                            </tr>
                        </table>
                    </td>
                </tr>
                <!-- THIRD ROW: BOTTOM SECTION -->
            </table>
        </form>
    </body>
</html>
Imports System
Imports System.Collections
Imports System.ComponentModel
Imports System.Data
Imports System.Drawing
Imports System.Web
Imports System.Web.SessionState
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports System.Web.UI.HtmlControls
Imports SqlAdmin

Namespace SqlWebAdmin
    Partial Public Class edittable
        Inherits System.Web.UI.Page
        Public Sub New()
            AddHandler Page.Init, AddressOf Page_Init
        End Sub

        Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
            Dim cookie As HttpCookie = Request.Cookies("WebDataAdministrator")
            If cookie Is Nothing Then
                Response.Redirect("default.aspx?error=sessionexpired")
            End If
            Dim server As New SqlServer(cookie.Values("server"), cookie.Values("username"), cookie.Values("password"))
            server.Connect()
            Dim database As SqlDatabase = server.Databases(Request("database"))
            If database Is Nothing Then
                server.Disconnect()
                ' Database doesn't exist - break out and go to error page
                Response.Redirect(String.Format("error.aspx?error={0}", 1000))
                Return
            End If
            Dim table As SqlTable = database.Tables(Request("table"))
            ' Set link for add new column
            AddNewColumnHyperLink.NavigateUrl = String.Format("editcolumn.aspx?database={0}&table={1}", Me.Server.UrlEncode(Request("database")), Me.Server.UrlEncode(Request("table")))
            If table IsNot Nothing Then
                ' The table exists and we do normal column editing
                ColumnsDataGrid.Visible = True
                NoColumnsLabel.Visible = False

                If Not IsPostBack Then
                    ' Update table properties
                    ' Get columns list
                    Dim columns As SqlColumnCollection = table.Columns
                    Dim ds As New DataSet()
                    ds.Tables.Add()
                    ds.Tables(0).Columns.Add("key", GetType(Boolean))
                    ds.Tables(0).Columns.Add("id", GetType(Boolean))
                    ds.Tables(0).Columns.Add("name", GetType(String))
                    ds.Tables(0).Columns.Add("datatype", GetType(String))
                    ds.Tables(0).Columns.Add("size", GetType(Integer))
                    ds.Tables(0).Columns.Add("precision", GetType(Integer))
                    ds.Tables(0).Columns.Add("scale", GetType(Integer))
                    ds.Tables(0).Columns.Add("nulls", GetType(Boolean))
                    ds.Tables(0).Columns.Add("default", GetType(String))
                    ds.Tables(0).Columns.Add("encodedname", GetType(String))

                    For i As Integer = 0 To columns.Count - 1
                        Dim columnInfo As SqlColumnInformation = columns(i).ColumnInformation
                        ds.Tables(0).Rows.Add(New Object() {columnInfo.Key, columnInfo.Identity, Me.Server.HtmlEncode(columnInfo.Name), Me.Server.HtmlEncode(columnInfo.DataType), columnInfo.Size, columnInfo.Precision, columnInfo.Scale, columnInfo.Nulls, Me.Server.HtmlEncode(columnInfo.DefaultValue), Me.Server.UrlEncode(columnInfo.Name)})
                    Next i
                    ColumnsDataGrid.DataSource = ds
                    ColumnsDataGrid.DataBind()
                End If
                ' If the table has data in it, disable edit column
                If table.Rows > 0 Then
                    ColumnsDataGrid.Columns(2).Visible = True
                    ColumnsDataGrid.Columns(3).Visible = False
                    ColumnsDataGrid.Columns(8).Visible = False
                Else
                    ColumnsDataGrid.Columns(2).Visible = False
                    ColumnsDataGrid.Columns(3).Visible = True
                    ColumnsDataGrid.Columns(8).Visible = True
                End If
                ' If the table has only one column, do not allow delete
                If table.Columns.Count = 1 Then
                    ColumnsDataGrid.Columns(9).Visible = False
                Else
                    ColumnsDataGrid.Columns(9).Visible = True
                End If
            Else
                ' The table does not exist, implying that it is new
                ColumnsDataGrid.Visible = False
                NoColumnsLabel.Visible = True
            End If
            server.Disconnect()
        End Sub

        Protected Sub Page_Init(ByVal sender As Object, ByVal e As EventArgs)
            '
            ' CODEGEN: This call is required by the ASP.NET Web Form Designer.
            '
            InitializeComponent()
        End Sub

#Region "Web Form Designer generated code"
        ''' <summary>
        ''' Required method for Designer support - do not modify
        ''' the contents of this method with the code editor.
        ''' </summary>
        Private Sub InitializeComponent()

        End Sub
#End Region

    End Class
End Namespace

Open in new window

0
Comment
Question by:homeshopper
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 2000 total points
ID: 34870478
Your page language is VB where as this syntax

((int)DataBinder.Eval(Container.DataItem, "precision")

is used in C#

Change it to
CType(DataBinder.Eval(Container.DataItem, "precision"), Integer)
0
 

Author Comment

by:homeshopper
ID: 34870756
I now have the following:
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem, "size") %>
<%#(((CType(DataBinder.Eval(Container.DataItem, "precision"), Integer)) & ((CType(DataBinder.Eval(Container.DataItem, "scale"), Integer))) & String.Format("({0}, {1})", CType(DataBinder.Eval(Container.DataItem, "precision"), Integer), CType(DataBinder.Eval(Container.DataItem, "scale"), Integer))))%>
</ItemTemplate>
error now:
Name 'bool' is not declared
<%# DataBinder.Eval(Container.DataItem, "size") %>
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 34870796
In VB, its Boolean
0
 

Author Comment

by:homeshopper
ID: 34872789
Thanks, the error was occuring, as I found other lines needed converting from C#
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In .NET 2.0, Microsoft introduced the Web Site.  This was the default way to create a web Project in Visual Studio 2005.  In Visual Studio 2008, the Web Application has been restored as the default web Project in Visual Studio/.NET 3.x The Web Si…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question