in my database table there are 200 records.in description column record value is like .....
sometextLASER
sometext1LASER
sometext2LASER
i want to delete LASER from every record using sql.can enyone tell me how to do it.
I have a table1 with first column having: usjim, uskim, uspeter, john ....
I need to insert this column into table2 excluding us if contains any ( extract substring basically)
I have tried doing this but doesn't work
[code]....
I have custom user controls each with a SQLDatasource and a GridView in a DeclarativeCatalogPart. When I try to delete a control from a WebPartZone I get the following error.The SqlDataSource control 'SDSOnCall' does not have a naming container. Ensure that the control is added to the page before calling DataBind.
View 16 Repliesi have a website that use globalization to several languages (VB Framework 4.0)
i need to get all languages exist in App_GlobalResourses directory because i don't know in future the website owner will add or remove some languages
for that i try to access in App_GlobalResources folder and i list the existing files in there now i have an array of fileInfo but i don't know how can i get some part of the file name
it return "General.resx", "General.en-US.resx", "General.fa.resx" and so one...
I have this string: "NT-DOM-NVMTA" How can I delete the first part: "NT-DOM-NV" To have this as result: "MTA"
View 6 RepliesLet's take this string has an example:
D:/firstdir/Another One/and 2/bla bla bla/media/reports/Darth_Vader_Report.pdf
I want to cut the first part of the path:
D:/firstdir/Another One/and 2/bla bla bla
And replace it with **../**, and keep the second part of the path (media/reports/Darth_Vader_Report.pdf)
If I knew the length or size of it, I could use the Replace or Substring. But since the first part of the string is dynamic, how can I do this?
Update
After StriplingWarrior question, I realized that I could have explained better.
The objective is to replace everything behind /media. The "media" directory is static, and will always be the decisive part of the path.
I am trying to retrive the query string value and display it on the aspx page. The query string is passed from a gridview. Everything works fine except i noticed that when there is an '&' in the query string then the label on the page will display only uptil the '&' (i.e. excluding the '&'). Just so to let you know. I retrive the value of the querystring into a string variable and then assign it to the variable. I have noticed this only for '&' character but maybe there are more characters with sinmilar bahaviour that I am not aware of.if anyone has a workaround on displaying all the content from the querystring then do share.
View 4 RepliesWhy is it that a simple string inside a webpart not showing when the application is run ? Actually my requirement is to use a fusion (usually called as a function) and Visifire chart (usually called as a function from javascript) in web part which i'm not able to consume at all.
View 5 RepliesI'd like to change my routes so that instead of having:
/Users/Edit?UserID=1
I can do
/Users/Edit/1
How can I create a custom route to do that?
Also, can someone direct me to a good tutorial on routes? I don't wanna create a post every time I have a simple problem with routes.
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?
View 2 RepliesI 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.
View 1 RepliesWhen 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.
View 1 RepliesOne 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?
I have a table Books with columns BookID, BookSummary, BookAuthor.
What I have stupidly done was to add a link to another url at the end of the BookSummary. Assuming the text is something like this:
This is a book about a love story in World War 2 in Europe. The book is written by Elliot James.
I have added
<a href='http=://XXXXXX'>Buy Book</a> at the end of the text making the final content of BookSummary to be like:
This is a book about a love story in World War 2 in Europe. The book is written by Elliot James.
<a href='http=://XXXXXX'>Buy Book</a>
I now need to write a code (via regex?) to read through each BookSummary, find the <a href='http://XXXXX'>Buy Book</a> and delete it. But the problem is the content in XXX could be anything and I cannot use typical string functions. Can anyone guide me to
achieve this using Regex?
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 .
This the code:
string path = Page.MapPath("../../User/VideoOut/"+sFile);
FileUplvideo.PostedFile.SaveAs(path);
Session["oldfile"] = path;
Whats the difference between a SharePoint web part and an ASP.NET web part. I found very less information describing the differences.
View 1 Replieshow to Delete Child Record And Later Delete The Parent Record if it has no child
Trigger might be the answer but i don t know how!
Could someone giving me the correct T-SQL query to update the Date part from a DateTime field?
To be more clear:
In my table i have 3 Columns, (all are DateTimes):
1. Date
2. StartingHour
3. EndingHour
This is for example one record:
2004-01-26 00:00:00.000
i hv use a crystal report in my web application if i publish my application and run in iis on different system with diff server name the crystal report part cause problem login failed with server as name is alredy defined in crystal report at publish time.Can we define the name of server for crystal report in web.config.
View 5 RepliesI am trying to get a new line when display the message. Whats wrong with this code?
Button l = (Button)e.Row.FindControl("btnDelete");
string textForMessage = @"<script language='javascript'> confirm('Are you sure you want to delete this record
test
test
test');</script>";
l.Attributes.Add("onclick", textForMessage + DataBinder.Eval(e.Row.DataItem, "Name") + ")");
Trying simple delete against a Photo table but hitting error as conversion type error.
[Code]....
Is there a better way to write this sql statement? or convert the UserId to int32 before executing? Not sure how to do that.
I m new in web part tools in asp.net, i create a simple page using web part tools, but now i want in my web part zone too open a web site like I Google..
when u use i google there is a functionality to open a web site in web part zone.
I have the following attributes in my table
[code]....
how do I create sql query to find out the number of times participant A took part in the club activity?
I am using VS 2008 with SQL in express edition . I have made my website and hosted it on server with cuteftp .Now i want to change
the website so when i tried to delete all files the App_data folder does not delete .
So i am unable delete my mdf and log file which are in this folder. It says file error.
I always use SQL in design window in VS and know less of coding in SQL.