One of the fields in a table stores a long article. I just want to extract the beginnig part of it; could be any portion of it, like first one or two or three paragraphs. The vb code shows below:
Imports System.Data.SqlClient
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Try
[Code]....
I really don't want the whole article displaying in the literalBrief. A few paragraphs from that article would be good enough. Is it possible to achieve that? At SQL level, or in VB coding, something like substring function?
To be fair, this is a part two follow up to Using C# to recursively get a collection of controls from a controlcollection. - and rather than heap another question onto the old one, I created a new one. Here is the code that I'm using:
private void GetControlList<T>(ControlCollection controlCollection, ref List<T> resultCollection) where T : Control { foreach (Control control in controlCollection) [code]...
and is involked like this when the form is submitted
List<CheckBox> checkboxes = new List<CheckBox>(); GetControlList(RepeaterCapability.Controls, ref checkboxes);
I don't get any results when I clearly added several during the repeater OnItemDataBound event.
I put a dropdownlist in a template field with 4 choices with the values of each to a,b,c,d and when i run the update query i need it to pull from that selected row,and read the value selected in that field. I tried this:
@choice = SelectedRow.Cells[9].Text.ToString() but it didnt work
how can i extract data from a dropdownlist thats inside a template field and use in a update query?
I'm working on a pretty basic little site that has content that is populated from a sql database. It's important to know that the data in sql includes some html (bolds, italics, ordered lists,etc). The problem I'm running into, involves the search results. On the search results page, I display the results from a sql query in a gridview. The sql query only returns the first 200 characters of the "Description" field, and then there is a link to click if the user wants to read the full description. The problem I'm running into is when the gridview tries to format the data that has an opening html tag, but no closing html tag (becasue the closing tag is over the 200 character limit.
how one would retrive a value stored among several values in a single database field?
For example, the MS Customize CreateUserWizard walkthrough [URL] adds the ability to save the users preference for subscribing to a newsletter and allowing their info to be shared as 1 value in the comment column of the membership database. The result ofaspnet_Membership.Comment is Subscribe=TRUE&ShareInfo=FALSE.
My question is if Subscribe=TRUE&ShareInfo=FALSE is in one field of the database, how would you retrieve just the Subscribe=TRUE value from the field and use it to send a newsletter to the proper users while ignoring the ShareInfo=FALSE value?
I have a SQL Server table with a number of fields that are defined with the "Float" data type. I'm running a simple query to retrieve the data from this table and use it to populate a Data Table in my C#.net application.
I just discovered that the data type of the Data Table fields is Double, not Float as I expected. As such, when I store a value like 0.157 it ends up getting stored like this: 0.15700000524520874
I'm aware that such extra "noise" occurs when such a conversion occurs. My major question has to do with why .Net didn't set the Data Type to Float (ie. Single) when the table was first populated?
I'm a asp.net newbie trying to figure out how to do the following. I have a datatable. I want to extract the first row and perform a certain operation and a different operation on the remaining rows. How would I loop through the datatable to do this?
I am having one column named Location in My MS SQL 2008 Database and the values in the Column is like "Region/State/City" region, city and states are saperated by forward slash.
In that column some times City is given and somtime it is not provided means only Region and state.
Now, i need to extract that Region, state and city from one column to a view and in view there should be three columns State ,City and region.
I have tried the SUBString but it works on no. of characters but for different city and regions the no.
I want to extract emails that are currently being sent to an exchange Server. I want to extract the emails and then take some actions based on their content.
I have a package which imports several files on a regular bases . For the import I use a staging table. Now I want to split that stagingtable into two other (existing) tables with keeping the relation ( third table??) . In each record there is a dealerID which has to be injected also in the other two tables (the splittables).
How can I use a conditional split to extract the right columns to the right table? I only see that i can enter a expression for each column, but in fact i only want to split the table by "fingerpointing" the right columns. is that possible? And how should i put the relation between them in 'relation' table?
We have several asp.net web applications we've built and we also want to embed them into various sharepoint pages. We need to have them look like standalone applications when viewed in their own pages, but also have them look like they fit within the sharepoint page when embedded. We are doing this currently with IFrames and it works ok, but I'm wondering if there is some sort of proxy web part where we can configure the web part to point to an existing web app and it will proxy the contents through from the web app into the sharepoint page removing the need for an IFrame. Possible?
i have using sql server 2005 express managment studio, i have create my database and every thing just i want to extact Database and attach it to My asp.net 3.5 Project how?
I have four columns in database. Consider it as a,b,c and d. I'm trying to place a and b column values in TO part and c and d column values in CC part in outlook. a,b,c,d contains six digits numeric values. I just need to place a and b columns values in to and c and d values in cc part on click of a button.
When using SPWeb.GetCatalog(SPListTemplateType.WebPartCatalog), it returns an SPList which of course contains a SPListItemCollection of the web parts in the web part gallery. When looping through the items, is there any easy way to get properties of the web parts? Such as AllowClose, CatalogIconImageUrl, etc... I know I can probably accomplish this using the listItem.OpenBinaryStream etc and loading the xml of the .webpart file, but I wondered if there was an easier way to do this.
I found a lot of stuff on this topic but nothing that matches my problem.I'm coding a simple search function and came up with this code:
Dimsql As String = "SELECT DMS_files.id, DMS_files.descriptionSV, DMS_files.description, DMS_MainCategories.categoryNameFI AS 'main', DMS_SubCategories.categoryNameFI AS 'sub' FROM [DMS_files] INNER JOIN DMS_MainCategories ON DMS_files.cid=DMS_MainCategories.id INNER JOIN DMS_SubCategories ON DMS_files.scid=DMS_SubCategories.id WHERE (DMS_files.descriptionSV LIKE '%" & str & "%' OR DMS_files.description LIKE '%" & str & "%')" If (User.Identity.IsAuthenticated = False) Then sql = sql &" AND DMS_MainCategories.allowPublicSearch = 1" End If
With this I get the error "Multi-part identifier 'DMS_MainCategories.allowPublicSearch' could not be bound". But if I put the line straight to the first string, like below, it works.
Dim sql As String = "SELECT DMS_files.id, DMS_files.descriptionSV, DMS_files.description, DMS_MainCategories.categoryNameFI AS 'main', DMS_SubCategories.categoryNameFI AS 'sub' FROM [DMS_files] INNER JOIN DMS_MainCategories ON DMS_files.cid=DMS_MainCategories.id INNER JOIN DMS_SubCategories ON DMS_files.scid=DMS_SubCategories.id WHERE (DMS_files.descriptionSV LIKE '%" & str & "%' OR DMS_files.description LIKE '%" & str & "%') AND DMS_MainCategories.allowPublicSearch = 1"
In my application when I click on one of my button in the page it is giving error like this..
Could not find a part of the path 'V:UserEnterTrailorVideosluck.swf'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details:
System.IO.DirectoryNotFoundException: Could not find a part of the path 'V:UserEnterTrailorVideosluck.swf'.
There is No folder ("EnterTrailorVideos") in my project. But it is showing like this .
