Solved

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

Posted on 2011-02-11
4
1,038 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
  • 2
  • 2
4 Comments
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 500 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

In an ASP.NET application, I faced some technical problems. In this article, I list them out and show the solutions that I found.  I hope it will be useful. Problem: After closing a pop-up window, the parent page should be refreshed automaticall…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

708 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now