DataSource Controls :: Pull A SubString From A Linq Datasource But Can't Use INTs Per .SubString(int, Int)
Feb 5, 2010
I need to pull a SubString from a Linq Datasource, but can't use INTs per .SubString(int, int) I have strings such as xxxx.xxxx.xxxxx.AAAA.xxxx.xxxx.xxxx.xxx and I need to pull AAAA out. the preceeding x's will be varying lengths, so I can't use a static int. What I do know is that there will be a static number of periods (.) leading up to the AAAA. I can't figure out how to use the SubSting with characters rather than indexs. This is what I have so far:
I have an SQL table which looks similar to the following:
Title | Author | Tags 'title1' 'author1' 'horror, steven king, clowns' 'title2' 'author2' 'childrens, roald dahl, chocolate'
Let's say I wanted to find the name of a book that has the tag 'clowns' in it...how can I do this? 'clowns' is a substring of the tag for 'title1'...but how do I search for substrings? I have tried to use the "LIKE" keyword but obviously it doesn't work in this situation.
I have a gridview that has a field called TargetDate which is formatted as dd/mm/yyyy. I want to substring the numbers out of the date. So basically remove the '/'. How do I do that? can't just substring(0,2) because sometimes the date is single digits, sometimes 2 digits. I am using vb.net.
For context: First of all, I am new to LINQ, as I have been using SubSonic for quite some time now.
I have two tables, Users, and Affiliates. They both have a very typical schema. The FK that joins them is the UserId field, which is in the Affiliates table. I want to create a LINQ query that pulls the Username from the Users table using the AffiliateId value. The AffiliateId is a primary key of the Affiliates table.
I have tried to accomplish this using many variations of the following code:
[Code]....
In the above query, I expect to get a single row result set. However, I instead receive the entire table of results.
How can I make this work? I have yet to see an example or article out there to do what I am trying to do.
The following is a line of huge .txt file and i am reading it line by line. I need the value of second column. In this line, I need to extract 'C9006'.
Mr ABC|C9006|The white field, ON|493-493-4939|493-493-4939|YR|Inactive
Note : The delimiter char is pipe sign '|'. The length of second column is not consistent.
I am binding some data to control, but want to limit the number of character of a specific field to a 30 first characters. I want to do it, if it's possible, on aspx page.
I want to display first 200 characters of the content put into database from an html editor.I am not able to use substring since the ocntent contains html tags .If I take the plain text, I will loose all the formatting and font styles.
I have an intranet application which I have been putting together with ASP.NET. I have been using VWD 2010 Beta 2 which has been fine so far. But when I go to deploy the work i've done so far to a local IIS a variable which is supposed to be; being filled with the value from HttpContext.Current.User.Identity.Name is not being filled i.e. an error occurs when substring goes out of bounds. I believe it is because the HttpContext.Current.User.Identity.Name is not putting a value into the string variable 'username'. But it is quite strange as when I run the website project within VWD 2010 it works fine without any errors. IIS is set to Integrated Windows Authentication and Annonomous Users are allowed.
public static String getName() { // Store username String name = HttpContext.Current.User.Identity.Name; // Truncate username from domain name String[] substring = new String[1]; // Define the token at which the string will be broken at char[] token = { '\' }; // Split the string substring = name.Split(token); // Return the username return substring[1]; }
Any ideas why when running the exact same files from local IIS gives me errors?
I need to split the words from random character displayed.For example character like
Textbox1--Textbox2, the mention character have to be split up only by the ('--') and both the characterslike("Textbox1","Textbox2") have to be display in corresponding textboxs.
Dim RandomNumber As New Random() Dim num As Integer num = RandomNumber.Next(1, 75).ToString Try Dim Cnn As New OleDb.OleDbConnection("File Name=E:WebRHIUDLShelf_Life.UDL;") Dim da As New OleDb.OleDbDataAdapter("SELECT tbMaster_List.dbMFG, tbMaster_List.dbDescription, tbInStock.ID, tbInStock.dbMFG_Lot_Code, tbInStock.dbDateReceived, tbInStock.dbDateOpened, tbInStock.dbExpireDate, tbInStock.dbLocation FROM (tbInStock INNER JOIN tbMaster_List ON tbInStock.LnkToMaster = tbMaster_List.ID) ", Cnn) Cnn.Open() Dim dtt As New DataTable() da.Fill(dtt)
This is were I am stuck.
I need to filter all rows out except where row(index) = num
Me.GridView4.DataSource = dtt Me.GridView4.DataBind() Catch Label1.Text = "Error: Unable to Pull Data" End Try
I was put in charge of a database that has no source control, and all work was done in the database. I want to pull all the objects (stored procs, views, tables) from the database, and add to my new source control.
Is there a way to get all the objects into individual files out of a database?
Our database is SQL 2005. I have Visual Studio 2005/2008/2010 (beta 2) at my disposal.
I have location #s, date, time, the sales amount, and tax in a excel file. The system pulls sales numbers throughout the day from each store location and places the total sales and tax numbers along with the polling date into a file.
So the most current date/time has the most upto date sales numbers at the time for that location number, but it also lists the older entries so mgmt can see how sales went during the day, and this is where my issue is, I don't need to see the old numbers from this generated file (atleast at this part of the program).
What I would like to do is write a query that only selects the most recent sales numbers for each location. I will output this to a table in ASP.NET. The query I tried using the TOP 1 clause only gave me the very first row listed below.
On a test page, I successfully created a google map that pulls both marker and infoWindow information from an XML file. I did this just to get a feel for working with the API. It works fine. However, I do have a SQL database that has this information in it already. This database is updated behind the scenes regulary via a webservice.
I would like to try pulling the map information from my SQL database instead so I don't have to hand maintain the .xml file. The dabase alread has the lat/long information needed for markers. What is the easiest way for me to get that data from the SQL database? Is there a way to run a query and use the data, or will I need to run the query and somehow have it write/update my .xml file for me?
public IEnumerable<Customer> GetCustomers() { Table<Customer> custObject = context.Customers; IEnumerable<Customer> filteredCustList = from customer in custObject select customer; filteredCustList; } GridView2.DataSource = utilLinqClass.GetCustomers(); GridView2.DataBind();
(no errors at build time or at compile time) Error I am getting is: An attempt to attach an auto-named database for file App_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
