I have in my database the News Table which consist of => Id, Title, txt . I need to be able to get a description text from the whole text which exist in txt Field , but without any codes like <...> , just a pure text !! how can I do this?
View 3 Replies
SELECT *
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME =
'Description'
vw_aspnet_Applications Description
aspnet_Roles Description
vw_aspnet_Roles Description
aspnet_Applications Description
The above query returns only those columns that are named "Description" from the default asp.net membership tables. That is not what I want. Each column has a property called "Description" which allows the developer to provide a detailed description for each SQL field (a.k.a. "column"). Example: aspnet_Membership has a column "Password" which does not have anything in the "Description" property although it should have imo
because without a description, it is not obvious that the password's value happens to be encrypted.
Scenario: Assume that I have a table called Trucks that has data like
Number Odometer ... et cetera
It's schema looks something like this (abbreviated)
COLUMN_NAME Description
Number yyyynnnn where 'yyyy' is year truck was purchased, 'nnnn' is sequential number.
Odometer most recent odometer reading in kilometres
How would I code a SQL SELECT statement in SSMS 2008 to display the schema data such as a column's name, its description text, et cetera? because "description" is such a generic term, I've so far been unsuccesful at locating further information in Google.
I tried to add for a text R&D, through the sitemap.
<siteMapNode
url="/RandD/Default.aspx"
title="$resources:Menu,
ttRD"
description="$resources:Menu,
descRD"
pageTitle="$resources:Menu,
pgttRD"
metaDesc="$resources:Menu,
metaDescRD"
metaKeywords="$resources:Menu,
metaKeyRD">
The thing is it showing in the menu the right value R&D but passing over the description look like R&D
<asp:FormView ID="FormView1" runat="server" DataKeyNames="productnum"
DataSourceID="EDS_Product">
<ItemTemplate>
<div class="ContentHead"><%# Eval("name") %></div><br />
<table border="0">
<tr><td style="vertical-align: top;">
<img src='images/big/<%# Eval("image") %>' border="0" alt='<%# Eval("name") %>' /></td>
<td style="vertical-align: top"><%# Eval("description") %>
<br /><br /><br /></td></tr></table>
<span class="price"><b>Your Price:</b> <%# Eval("price", "{0:c}")%><br /><span class="number"><b>Number:</b> <%# Eval("number") %>
</span><br /><a href='AddToCart.aspx?productnum=<%# Eval("productnum") %>'>
<span class="ProductListItem"><b>Add To Cart<b></font></span></a>
</ItemTemplate>
</asp:FormView
this is from the product details page and the description goes in a straight line always - i want to make the description a box and have lenght of 30 characters every line -- i want to modify the description not to be in a straight line
I have an old database that still contains depreciated Text fields. I need to pull from these fields and display the results. You would think this should be easy... First my select statement caused a problem:
Code:
SELECT DISTINCT ..., CustomerInstructions, ... FROM Orders
where CustomerInstructions is a Text field.
The error I get: "The text data type cannot be selected as DISTINCT because it is not comparable." A quick search shows I can cast the text field as a varchar(max).
Code:
SELECT DISTINCT ..., CAST(CustomerInstructions AS VARCHAR(MAX)), ... FROM Orders
Now I get an error while trying to load the instructions into a text box: "Specified argument was out of the range of valid values. Parameter name: index"
Not sure what the problem is here. I have text and a text box. What's with the "out of range" crap?
Currently we are saving files (PDF, DOC) into the database as BLOB fields. I would like to be able to retrieve the raw text of the file to be able to manipulate it for hit-highlighting and other functions.Does anyone know of a simple way to either parse out the files and save the raw text on save, either via SQL or .net code. I have found that Adobe has a filtdump utility that will convert the PDF to text. Filtdump seems to be a command line tool, and i don't see a way to use a file stream. And what would the extractor be for Office documents and other file types?-or-Is there a way to pull out the raw text from the SQL Full text index, without using 3rd party filters?Note i am trying to build a .net & MSSql solution without having to use a third party tool such as Lucene
View 5 Repliesi could not able to include the meta tag for description and keyword, set to unique on all the pages.
View 1 RepliesTrying to figure out how to handle data returned for a site search from a description field. I don't think I want to display all the text from the description field, but I also don't want to "chop" a word in half. How do I get the first 100 characters, plus a few extra letters if needed to prevent a word from being chopped in half. In some cases, the description field is less than 100 characters, so all the text will be displayed. However, if the description does need to be chopped at 100, I'd like to finish the word and add ... to indicate that there is more text.
View 6 Repliesi have the following two questions:-
1. let say i have a table for ITEMS including (item id,item description id (FK to the ITEM Description tabe), item price,etc) and have ITEM Description look up table having (item descriptionid,item description),.
so what is better to use the ITEM DESCRIPTION look up table and store the item description id in the items table
or
to directly store the item description "Not the id" in the item table.
2. I am working on an MVC web application using LINQ, now if i want to modify the SQL server tables which i have created for example modify some of the foreign key properties will the effect be directly reflected on any new inserted or deleted records or i have to create a new LINQ to SQL class?
I want display text of a asp text box to be different of its original text.
View 4 Repliesi want asp button or imagebuttom with both background image and text above button.
i dont want to write text directly on image.
I have try the following method, but none of them can make the treeview to wrap the
node text. When the node text is exeeding a certain amnout of characters. It will just expand the
[code]....
I have a page where my user enters a search term and submits it against my database. What I want to happen is when the result(s) return, I want headings to pop up over my gridviews. For example, I want "Photographs" to appear over my gridview for photographs, "Documents" to appear of my gridview for documents, etc...
When I run my page, those headers are already there, even though I have not conducted a search yet and my gridviews have not populated. If I go into properties and select visible=false, they never show up, which is not exactly what I want either. I have read about literals, textboxes, panels, and have confused myself.
I wanna search operation on the basis of the keyword write in the text box and search the subsequent result from the database..
View 2 RepliesHow do I make A, B and D navy blue?
Region
Stuff
Stuff
tried this just for one of the cells but it's not working what am I missing?
[Code]....
clarify: i am using a virtual keyboard that has to work on deferent text fields, and deferent pages, every time i click on a text field it sould pop up and every key i press i need to show on the text field....the problem, as every one knows, is to bind a deferent text field to the virtual keyboard, And as i said, also, to use it on deferent pages without rewriting the keyboard code for every page again and again, some thing that will not do... still can not give any code as there is no code to give, so there is no code...
i don't have code to show becouse i am trying to figure out how to do this and not showing a problem...
Background: I have an aspx file that holds a keyboard div and a hidden TextArea or an Input type=hidden (not decided yet). This page is a user control so it cen be used in all the pages that needs it...
What i am tring to do: Using JQuery bind('focus',...) method to bind any field in a certian aspx page (not the keyboard UC itself) to the hidden text field, i want that every thing i click on the keyboard will show in the text field that is on focus....
Can i relate in JS/JQuery to a field that is in a different page, will it recognise it? how can i do the bind, how can i transfer text from one field to another? if there a better way to do this, i will be happy to hear about it...
Is there a way in .net to display the text automatically when i type the first letter or word in a text box? I am looking for something like MS-Excel.. In MS-Excel, if the first word is given, automatically it displays the remaining texts, only if values are given previously.
View 6 Replieshow to show the quick changing text as like shown in text editor of mobile phone(While message writing it shows no of characters left)
View 5 Repliesi have a text box with a large amount of text is it possible to enable paging in the text box and force it to split the text between multiple pages
View 5 RepliesI want to change text of text object in crystal report (.rpt file). The datasource for the report is a datatable which consists of a column named sale, if it is '0' then I want to display the text of text object as 'sale' and if it is '1' then I want to display the text of text object as 'lease'. how to add formula and based upon the result of formula I have to change the text of text object being displayed.
View 1 RepliesI have a .net 3.5 web form with an ajax combo box and a text box inside it. The bombo box is bound to a SqlDataSource.
My requirement is to show/hide the text box depending on the text of the selected item in the combo box. If a particular string, say 'xyz', appears in the text of the selected item, the I will make the text box invisible. I enabled the AutoPostback, made the text box disappear in the SelectedIndexChanged event, and everything worked fine.
However, when users enter their own texts (which are not in the list items), I am unable to show / hide the text box. I've tried the TextChanged event but nothing happens. It seems the event is not trigger after I enter a new text and locate the focus to other place.
is there a way to prevent the user ented text from being inserted into the bombo box?
I have written the following ocde to save the data in to textfile.
using(TextWriter tw=new StreamWriter(file))
{
string refcode = txtReftypecode.Text;
tw.Write(refcode.PadLeft(1,'0'));
string priorcode = txtPrioritycode.Text;
tw.Write(priorcode.PadLeft(2, '0'));
tw.Write(txtImmediateddest.Text.PadLeft(2,'0'));
tw.Write(txtImmediateorg.Text.PadLeft(10,'0'));
string date=txtFilecreatdate.Text.Replace("/","");
tw.Write(date.PadLeft(6,'0'));
string time1=txtFilecreattime.Text.Replace(":","");
tw.Write(time1.PadLeft(4,'0'));
tw.Write(txtFileIDmodifier.Text);
tw.Write(txtRecsize.Text.PadLeft(3,'0'));
tw.Write(txtBlockingfac.Text.PadLeft(2,'0'));
tw.Write(txtFormatcode.Text.PadLeft(1,'0'));
tw.Write(txtImmeddestname.Text.PadRight(23,' '));
tw.Write(txtImmedorgname.Text.PadRight(23,' '));
tw.Write(txtRefcode.Text.PadRight(8,' '));
tw.WriteLine();
}
Now i would like to represent the data in to the corresponding to text boxes when i open that text file.
I have what I think is a weird issue. I send text from one page to another via Session Variable. When page 2 loads, the text box has the session text set, but if the user changes the text and clicks the button, the SQL database is update with the original session text. If I remove the redirect from the page 2 button_Click method, then, the page refreshes with the textbox reverting to the session text and thr SQLDataSource has the session text added to it.
[Code]....
I have a page with a text box, a button and a GridView. Enter an account number in the text box, press the check button and the result will show in the GridView.
Now user wants that if the text box is clear, the GridView disappear.
I can only find TextBox1_OnTextChanged. But I want to have that while the user is clearing the text, if the length of text becomes zero, the GridView is clear out. So I am looking for OnTextChanging(). Well of course this function does not exist. How to achieve the same purpose?
site that is multilingual.I am using a database to store the text I have a translation object that loads the correct language using session variables.I recently found that on google.fr for example,only the english text is referenced and no french text at all.
View 1 Replies
