selecting less text from database

sarbjeet singh

15y2.3k.NET

hello guys ,,

i have one column in database name article ,i just want to show one line of article using datalist and i will give read more option next to that plz tell me how to do

thanx in advance

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ankit Nandekar15y ago
Accepted answer
Try this query it will retrieve on few lines from big Text field

SELECT LEFT([Article],200)

FROM ArticleTable

here LEFT function retrieve only 200 words u can increase how many u want to display .
0
Suthish Nair15y ago
you didn't said how your data looks like.
0
Sam Hobbs15y ago
The first line probably has "\r\n" at the end, so you can use the IndexOf method of strings to find the end of the line then use Substring to get the text.
0
sarbjeet singh15y ago
sir but problem is how to show one line of text from lots of text from database
0
Ankit Nandekar15y ago
try this simple steps

1. Design DataList as per ur requirement.
2.on DataList ItemTemplate write like this

ArticleId must be unique.

in Code File DataList's ItemCommand event write this code

protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
    {
        if (e.CommandName == "Readmore")
        {

                 Response.Redirect("ReadMore.aspx?id=" + e.CommandArgument);

            }
   }

3. Readmore.aspx page Load event use this query to fetch Details

"select * from Mobile_table where Product_id="+Request["id"]+""

if u r getting any problem then let me know.
0