DataSource Controls :: Drill Down Into The Description Property To Get The Actual Descriptive Text
May 28, 2010
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.
View 4 Replies
Similar Messages:
Feb 28, 2011
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
May 24, 2010
Is it possible to display a list of descriptive phrases (say pulled from a lookup table in a database) but store a code in another table? I'm a beginner at ASP.NET but have some experience with SQL Server. If so, how can I do it?
View 9 Replies
Jul 10, 2010
I created one web user control with property named "ReadonlyField" with boolean datatype. I am able to use in my web pages and now i wanted to add a description to that property so that i dont need to explain each time to my team member what is that property's intention.
I got following snippet in c# but didnt find any equivalent in vb.net and also not sure whether it will work or not.
[Description("My Description")]
public int MyIntProperty
{
get {..}
set {..}
}
View 1 Replies
Aug 27, 2010
I'm doing up a search engine & what i want to happen is to get the title and description from the page as in below:
[Code]....
And here is the code that gets the meta tags:
[Code]....
Just can't write the code to get the title & description to show on the search result page.
View 1 Replies
Nov 26, 2010
I need to create one custom text box control which should be bind with data base.
I am referring following link...
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.databoundcontrol.aspx
I used DataBoundControl to create my control but i am not able to do it properly.
public class SimpleTextBoxControl : DataBoundControl
{
private TextBox nameTextBox;
public string DataTextField
{
get
{
object o = ViewState["DataTextField"];
return ((o == null) ? string.Empty : (string)o);
}
set
{
ViewState["DataTextField"] = value;
}
}
[
Bindable(true),
Category("Data"),
DefaultValue(""),
Description("The text to display on the link."),
Localizable(true),
PersistenceMode(PersistenceMode.InnerDefaultProperty)
]
public virtual string DataTexValue
{
get
{
string s = (string)ViewState["Text"];
return (s == null) ? String.Empty : s;
}
set
{
ViewState["Text"] = value;
}
}
protected override void PerformDataBinding(IEnumerable retrievedData)
{
if (retrievedData == null)
return;
base.PerformDataBinding(retrievedData);
Controls.Clear();
nameTextBox = new TextBox { ID = "nameTextBox" };
foreach (object dataItem in retrievedData)
{
if (DataTextField.Length > 0)
{
nameTextBox.Text = DataBinder.GetPropertyValue(dataItem, DataTextField, null);
}
DataTexValue = nameTextBox.Text;
}
this.Controls.Add(nameTextBox);
}
}
View 1 Replies
Jun 24, 2010
my web application i use FindControl to retrieve a Control By Name (it returns an System.Web.UI object). The control can be of various type and I don't want to treat them differently: I'd like to set the Text property to a defined string. I hope there's a class that I may use to cast the control and set the Text property.
View 8 Replies
Feb 26, 2011
The following link: [URL]javascript has a link on the right-hand-side to switch code from C# to VB, but the actual example text does not change when the selection is chosen. Can someone tell me if this tutorial is exclusively for C#, or can it be built in VB as well?
View 2 Replies
Nov 27, 2010
In my code below, I'm trying to re-write a string and convert and http text into actual web links.
It doesn't seem to be working and I think the problem may be that I'm rewriting the string and inserting another http string into the original string which then causes problems with the loop.
[Code]....
View 8 Replies
Jan 30, 2011
<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
View 3 Replies
Apr 3, 2010
I wondered what the difference between
'dbo.Property' and 'Property'
would be in an sql query
View 2 Replies
May 3, 2010
Traditionally with an Object Data Source, the wired up class will have its public properties available for binding (i.e. Gridview columns, etc.) which works well. But what if one of my wired up business objects has a property that is an object itself; can I drill down to a property on that object property and still use it?
So in additiona to the traditional:MyBusniessObject.OrderID...I want to use:MyBusniessObject.Customer.NameID
Your 1st response might be to just wire up the 'Customer' class, but I need properties both on 'MyBusinessObject'and 'Customer'. I do not think this can be done, as the ODS will not display properties on an object instance property. I have tried manually typing in the drilled down value as well, but that wasn't a success either.
View 4 Replies
Oct 27, 2010
I am storing a custom "Organisation" object as a session variable. One of the properties of the Organisation object is "OrganisationID" (integer). I have a DataSource that requires a parameter value to run, and I want to use a SessionParameter to populate this. In a previous version, I stored the OrganisationID directly as a session variable. In that case, I could easily access it like this:
[Code]....
However, how do I now access the OrganisationID property of an "Organisation" type session variable (called "Organisation")? I have tried this, which does not seem to work: <asp:SessionParameter Name="OrganisationID" SessionField="Organisation.OrganisationID" Type="Int32" />
View 2 Replies
Jun 28, 2010
We are working on a drill up/drill down application. The drill functionality is provided by the dropdown list box. The data breaks down during drill down and roll ups during drill up (sum and averages)
We have used the gridview (which is not databound) for data presentation to generate a column during each drill level to indicate the current drill level.
At one particular drill level, a hyperlink has to be provided for an existing field on the data, to display its details.
Can hyperlink be provided in a gridview that is not databound?
Can a hyperlink control be created in a gridview during runtime (when the specific drill level is selected in the drop down list box)?
As a solution to this problem, we created a databound gridview, with the hyperlink for the required column and made it visible for that particular drill level.
View 4 Replies
Apr 14, 2010
SqlDataSource1.SelectCommand = "select * from [xw] where [CustName] Like '" + TextBox2.Text +
"%'"
How Can I make two textboxt1.text and texbox2.text ?
SqlDataSource.selectCommand = "Select* from [xw] Where [Country]= textbox1.text and [CustName] Like '"+Textbox2.text+"%"
View 7 Replies
Mar 6, 2010
I have build a composite control which renders a TextControl or a RADEditor control, dependable of a property a set. Both rendered controls have a Text-property. The problem is that when I change the Textvalue on my webpage (when it is running) it won't set the new Text-value but the old Textvalue instead.
Below the code of my composite-control.
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Telerik.Web.UI;
using System.Web.UI.HtmlControls;
using Framework.WebControls;
namespace Components.Broadcasting.Controls.....
View 1 Replies
Aug 16, 2010
I have a user control registered on content page in content page i hve a label control
How i set content pages label control text property from usercontrol in u.control page load.
View 3 Replies
Dec 8, 2010
I'm modifying an existing application. I need to be able to bind the Text property of an asp:DropDownList control to one of two fields when the page is rendered. The existing code is like this:
[Code]....
I've tried to use conditional logic on the .aspx page when setting the Text property, but everything I've tried results in an error. I've also tried using code-behind to set the Tetxt property in the Page_Load event. This doesn't generate an error, but it doesn't set the property either.
View 6 Replies
Sep 19, 2010
I'm tyring to write a simple DetailsView only used for inserting new records that will pre-fill a textbox with a query string value. Here's the DetailsView:
[code]....
All I want to do is set VenueID_FK.Text to = the "VenueID" querry string. I also want the user to be able to see the VenueID number as they are filling out GridView1.
I know this is probably a simple thing, but I am very new to asp.net. I thought I could handle this in the page load event, but when I try something like this
TextBox VenueID_FK = (TextBox)DetailsView1.FindControl("VenueID_FK");
And then follow by setting the Text property programitically. I've accomplished something similar to this on a different page using a FormView, but only for ReadOnly mode and it was handled in the databound event on that page.
I get the error "The name 'DetailsView1' doesn't exist in the current context." when trying to do the above mentioned. When trying the same line in the databound event here, I get the same error.
View 1 Replies
Apr 16, 2010
I'm trying to figure out how to find whether a column exists in a dataset, and if not, remove certain controls on the page (otherwise it will error out with: DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'my column')
So...
I have a gridview that has xml data loaded dynamically by drop down list selections.
The xml elements vary depending on the file.
One XML file may look like this:
[Code]....
View 7 Replies
Mar 31, 2011
i have some textboxes in my parent page and a search button. when the search button is clicked, my modalpopup pops up. after chosing (clicking on the select button of the row) an entry from a gridview within my modalpopup (each row in the gridview has a buttonField), the rowCommand_Event fires... within this event i try to set the .Text property of some textboxes within the page containing my modalpopupExtender... i get no exceptions, but the textboxes are not set...
ModalPopupExtender:
[Code]....
ModalPopupPanel:
[Code]....
RowCommandEvent:
[Code]....
View 7 Replies
May 26, 2010
i am trying to call a SP from SQL Server in asp.net app, but it keep crashing every time it hit
'cmd.Connection.Open();' ,,, it give me this message
"The ConnectionString property has not been initialized "
[Code]....
[Code]....
View 2 Replies
Jul 20, 2010
I am trying to get an asp:SessionParameter of a SelectParameters, to use a property of an object in session
instead of having a string in the session like Session["CustomerID"]
Something like Session["Customer"] where the property is ((Customer) Session["Customer"]).CustomerID)
My code:
<asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="<%$ ConnectionStrings:DBConnectionString %>" xmlns:asp="#unknown"> SelectCommand="SELECT * FROM getStoreCustomers (@customerID,@week,@day)"
ProviderName="System.Data.SqlClient">
<selectparameters>
<asp:sessionparameter name="customerID" sessionfield="Customer" /> ?????? (what is the syntax to pass the property here?)
<asp:controlparameter controlid="ddWeek" defaultvalue="-1" name="week" propertyname="SelectedValue" /> <asp:controlparameter controlid="ddDay" defaultvalue="-1" name="day" propertyname="SelectedValue" /> </selectparameters>
The class I use is like any other class (but serializable)
[Serializable]
public class Customer
{
public int CustomerID
{
get;
set;
}
}
View 2 Replies
May 26, 2010
I m working in Asp.net 2.0 with C#.... I have a custom control and i have to use 'Datasource' property which is exactly like a repeater having.
View 1 Replies
May 25, 2010
I have a link button in my gridview. It is populating correctly; however, being I am populating the values in the gridview using "Eval()" method I don't know how to get the value of the selected Link Button (which is only selected by a user actually clicking
the Link Button).
The user can click on the text directly (instead of showing the "Select" auto created). I want to be able to capture the item they have clicked on's Text property.
Example:Column 1
Value1
Value2
Value3
When the click on "Value2" I want the text property to be stored in a string variable (In this case the text would be "Value2"). In the past I have captured this through GridView.SelectedValue; however, I am not using autopopulate selected button so I need to do this manually and I am unsure as to how I will do this.
Here is my code for HTML and I have not created any code for C# (I want to capture the item using C# in my Grd_Tables_SelectedIndexChanged Event)
[code]....
View 7 Replies
