sql server 2008 table

Hi....

Please anyone can help me out for table's column properties.In my table there is Description column and the size must be 20nvarchar for description and when I present table data on the webpage I just want to show only 15nvarchar and the rest of 5nvarchar want to show as a dot dot dot(three dot) (eg.15...). 15 nvarchar ... please can anybody give me any idea for that coz i dont know how to write to be like that. please..thanks a lot

Re: sql server 2008 table

You will need to write a function that takes in the string and returns a string with ... at the end. If you provide your code I could provide more specific information. Something like this:

protected string DotDotDot(string dbstring)
{
     if (dbstring.Length > 15)
          dbstring = string.Format("{0}...", dbstring.Substring(0, 14));

     return dbstring;
}

It's likely you're using this in a datatable or gridview. you will need to bind with something like this <%# DotDotDot(container["dbfield"]); %>

Re: sql server 2008 table

you can also try like this
protected string DotDotDot(string dbstring)
{
     if (dbstring.Length > 15)
      dbstring =dbstring.SubString(0,15)+"..." ;

     return dbstring;
}

Re: sql server 2008 table

Hi....

I did try but the error comes out like that and the code that i use is

protected string DotDotDot(string dbstring)
        {
            if (dbstring.Length > 15)
                dbstring = dbstring.Substring(0, 15) + "...";

            return dbstring;
        }

<ItemTemplate>
                <li style="background-color: #DCDCDC;color: #000000;">
                    Name:
                    <asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name") %>' />
                    <br />
                    Description:
                    <asp:Label ID="DescriptionLabel" runat="server"
                        Text='<%# DotDotDot(container["dbfield"]); %>' />
                    <br />
                    Price:
                    <asp:Label ID="PriceLabel" runat="server" Text='<%# Eval("Price") %>' />
                    <br />
                </li>
            </ItemTemplate>

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: CS1026: ) expected

Source Error:

Line 13:                     <br />
Line 14:                     Description:
Line 15: <asp:Label ID="DescriptionLabel" runat="server"
Line 16:                         Text='<%# DotDotDot(container["dbfield"]); %>' />
Line 17:                     <br />

Re: sql server 2008 table

Try removing the ; in your databinding .aspx code

Re: sql server 2008 table

Nope......

its still not working even i take out the ; in aspx. It shows the same complilation error...please..help me out...thanks

Re: sql server 2008 table

Are you copying the container stuff?

container["dbfield"]) should be Eval("whateverfieldhere")

Re: sql server 2008 table

Yes

If i did Eval("Description") its not changing anything like before i want to be 15... if i did the one like DotDotDot(container["dbfield"]) or Eval("dbfield") or DotDotDot(container["dbfield"]); its show the compilation error. Please will you give me any idea.

Re: sql server 2008 table

You are doing DotDotDot(Eval("Description"))

Re: sql server 2008 table

No...I didn't do like that...please can you give me anyidea here is my code again

<asp:ListView ID="ListView1" runat="server" DataKeyNames="Id" OnPagePropertiesChanging="ListView1_PagePropertiesChanging">
            <ItemTemplate>
                <li style="background-color: #DCDCDC;color: #000000;">
                    Name:
                    <asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name") %>' />
                    <br />
                    Description:
                    <asp:Label ID="DescriptionLabel" runat="server"
                        Text='<%# Eval("Description") %>' />
                    <br />
                    Price:
                    <asp:Label ID="PriceLabel" runat="server" Text='<%# Eval("Price") %>' />
                    <br />
                </li>
            </ItemTemplate>
            <LayoutTemplate>
                <ul ID="itemPlaceholderContainer" runat="server"
                    style="font-family: Verdana, Arial, Helvetica, sans-serif;">
                    <li runat="server" id="itemPlaceholder" />
                </ul>
                <div style="text-align: center;background-color: #CCCCCC;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000000;">
                    <asp:DataPager ID="DataPager1" runat="server" PagedControlID="ListView1" PageSize="5" QueryStringField="pageNumber" EnableViewState="true">
                        <Fields>
                            <asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True"
                                ShowNextPageButton="False" ShowPreviousPageButton="False" />
                            <asp:NumericPagerField />
                            <asp:NextPreviousPagerField ButtonType="Button" ShowLastPageButton="True"
                                ShowNextPageButton="False" ShowPreviousPageButton="False" />
                        </Fields>
                    </asp:DataPager>
                </div>
            </LayoutTemplate>
        </asp:ListView>

the code behind is

protected string DotDotDot(string dbstring)
        {
            if (dbstring.Length > 15)
                dbstring = dbstring.Substring(0, 15) + "...";

            return dbstring;
        }

it doesnt work nothing change at all...thanks

Re: sql server 2008 table

I think I should change in sql database table's column properties to appear like that...but i am not sure..please give me idea

Re: sql server 2008 table

What does this produce?

<asp:ListView ID="ListView1" runat="server" DataKeyNames="Id" OnPagePropertiesChanging="ListView1_PagePropertiesChanging">
             <ItemTemplate>
                 <li style="background-color: #DCDCDC;color: #000000;">
                     Name:
                     <asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name") %>' />
                     <br />
                     Description:
                     <asp:Label ID="DescriptionLabel" runat="server"
                        Text='<%# DotDotDot(Eval("Description")) %>' />
                     <br />
                     Price:
                     <asp:Label ID="PriceLabel" runat="server" Text='<%# Eval("Price") %>' />
                     <br />
                 </li>
             </ItemTemplate>
             <LayoutTemplate>
                 <ul ID="itemPlaceholderContainer" runat="server"
                    style="font-family: Verdana, Arial, Helvetica, sans-serif;">
                     <li runat="server" id="itemPlaceholder" />
                 </ul>
                 <div style="text-align: center;background-color: #CCCCCC;font-family: Verdana, Arial, Helvetica, sans-serif;color: #000000;">
                     <asp:DataPager ID="DataPager1" runat="server" PagedControlID="ListView1"  PageSize="5" QueryStringField="pageNumber" EnableViewState="true">
                         <Fields>
                             <asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True"
                                 ShowNextPageButton="False" ShowPreviousPageButton="False" />
                             <asp:NumericPagerField />
                             <asp:NextPreviousPagerField ButtonType="Button" ShowLastPageButton="True"
                                 ShowNextPageButton="False" ShowPreviousPageButton="False" />
                         </Fields>
                     </asp:DataPager>
                 </div>
             </LayoutTemplate>
         </asp:ListView>
 

the code behind is
 
protected string DotDotDot(string dbstring)
{
     if (dbstring.Length > 15)
          dbstring = dbstring.Substring(0, 15) + "...";
 
     return dbstring;
}

Re: sql server 2008 table

Nothing happen in my description name its still show all character not like with dotdotdot(15...) the one 15nvarchar...

Re: sql server 2008 table

If you set a break point in the DotDotDot function does it get called? Can you paste your updated code? Can you also paste the output you're seeing and the HTML source

Re: sql server 2008 table

the code that you show me before it shows the compilation error ( which means you ask me if i run the code what happen ) I means it shows error the code that you said

Re: sql server 2008 table

Hi...

Can anybody help me out for this...please

Re: sql server 2008 table

kyithar

I think I should change in sql database table's column properties to appear like that...but i am not sure..please give me idea

Change the Select statement for your datasource to something like this:

SELECT *, LEFT(Description,15) + CASE WHEN LEN(Description) > 15 THEN '...' ELSE '' END AS ShortDescription
FROM MyTable

Then you can reference ShortDescription in your ListView.

Re: sql server 2008 table

No...please following code is not working as well.

SELECT *, LEFT(Description,15) + CASE WHEN LEN(Description) > 15 THEN '...' ELSE '' END AS ShortDescription
FROM MyTable

Can anybody help me out .. pls..thanks

Re: sql server 2008 table

kyithar

No...please following code is not working as well.

SELECT *, LEFT(Description,15) + CASE WHEN LEN(Description) > 15 THEN '...' ELSE '' END AS ShortDescription
FROM MyTable

Can anybody help me out .. pls..thanks

Can you please show us your original code for the ListView and SqlDataSource?

Re: sql server 2008 table

try this,

SELECT *, CASE WHEN LEN(Description) > 15 THEN CONVERT(varchar(15), description)+ '...' ELSE description END AS ShortDescription
FROM MyTable