DataSource Controls :: LINQ - Select Column In Data Table?
Feb 9, 2010Mmy data table has four columns. How can I get only selected columns name?
View 5 Replies
Similar Messages:
DataSource Controls :: Select A Record From A Table And Insert Into B Table Using Linq?
Jun 29, 2010how can i select a record from A table and insert into B table using linq?
View 2 RepliesDataSource Controls :: Create A Multi Column Listbox By Combining Fields In Linq Select Statement
Jan 11, 2010I am trying to create a multi column listbox by combining fields in Linq select statement, as Let Name = Last + First. The problem is how to pad the Last column with spaces as you would in SQL using REPLICATE so when I bind the listbox to the data, it looks like two columns.
View 5 RepliesDataSource Controls :: How To Select Data With Linq And Bind To A DDL
Jan 5, 2010I am trying to select data with Linq and bind to a DDL. The custid field allows duplicates in this table, but I only want unique values in the ddl. I tried the following code:
[Code]....
The use of "Select Customer.CustID", with or without the Distinct, causes this runtime error. CustID is a valid field in the table, and it shows up in intellinsense and compiles. If I just Select Customer, the error goes away, but Distinct doesn't know to look for distinct custid's.
DataBinding: 'System.String' does not contain a property with the name 'CustID'.
Forms Data Controls :: Select Uncommon Rows From Data Table Using Linq?
Jun 22, 2010I have two Data Table, One data table contain Product-A information, and another data table contain Product-B Information, I want to get the uncommon values between the two data table, I would like to achieve this using LINQ, find the sample values below
Product Data Table
Product-A-Id ProductName
W10012 A
W10013 B
W10014 C
W10015 D
Sales Data Table
ProductId ProductName
W10013 B
W10013 B
W10015 D
X10020 AC
I want to find the uncommon data from both data table using LINQ, So find my expected Data Table result is
Result Data Table
ProductId ProductName
W10012 A
W10014 C
X10020 AC
DataSource Controls :: To Select Data From A Table?
Mar 8, 2010In anyway, is it possible to select data from a table, in such a way?
[code]...
DataSource Controls :: How To Select A Column With The Latest Datetime Data Type
Jun 14, 2010How do I select a column with the latest "datetime" data type, in Visual Web Developer 2008, ASP.NET 3.5 ?
In the config data source WHERE option my options are greater than cookie, control, etc... but I would like to select where the datetime is the latest in the table.
DataSource Controls :: How To Select Column Value From Grid And Hide A Column
Oct 19, 2010I'm trying to retreive a column value from gridview5 to use it in a query to display resuls in gridview, Also how do you hide a column in the grid?
Where (p.Link_ID Like GridView5.?
[code]....
DataSource Controls :: Cannot Work With System.Data.Linq.Table
Mar 31, 2010Is there a way to do the following in VB:dim sTableClass as string = <my underlying table class in linq>dim dbTab as system.data.linq.table(<typed class of sTableClass>)I've tried cycling through the table objects of the linq data context and retrieved the following: Dim ddData = pkDB.GetTable(tt.RowType.Type.UnderlyingSystemType)(where tt reflects the row of the table I want to retrieve) But the expression returns and itable and I need the table equivalent but can't get this to work with a stri
View 1 RepliesADO.NET :: Select Name Column From The Applicant Table And Value Column From ApplicantValue Table?
Feb 2, 2011I am quite new to LINQ, and I am stuck with this probably basic problem, but haven't been able to find a solution, so I thought I could ask here.
So, I have this repository where I put my functions for data accessing, and now I need to write a function to get all the applicants that have applied for this particular advertisement, and their values too. Now, the values are stored in a separate M:N table, where every row consists of the applicantID,advertisementID and value. I just wanna append the value to every applicant that I show, so that it would look like a Ranking List.
However, I do not seem to know how to select just the name column from the Applicant table, and just the Value column from the ApplicantValue table.
And there's this Iqueryable interface that further confuses me...
Here's my function to get the Applicants only:
[Code]....
Now, if I try to add to the definition of the type two columns, it says that it only messes with types, i.e. one type should be passed. So I figured I would do a ViewModel and then pass it, like this
[Code]....
and then in the function I have no idea how to pass the values:
DataSource Controls :: Set Or Reset A Boolean Column In A Data Table?
Mar 20, 2010I have defined some binary bit columns in an SQL database table to indicate yes/no conditions, but I don't know how to set or reset them. I tried to use "profile.Volunteer = 0;" C# code in an event handler to reset a voluntary state for the Profile table of members, but what I got back was an error message that said, "Constant value '0' cannot be converted to a bool'. So, if a '0' cannot be used to reset a boolean value, what can be used?
View 2 RepliesDataSource Controls :: How To Change A Table Column Data Type
Jan 21, 2010I attempted to change a table columns data type and in the process caused a lot of issues. I had a date column in one of my tables and stupidly changed it from varchar to date. When I tried to run queries on it I keep getting the 'cant find column 3 error'. Now that tables structure is :
[Code]...
So column 4 is actually the date column. All other queries work for this table. I then tried to change it back and then copied all data to a new table and now I am using the new table and converting the dates as needed but I am still getting the error.
SELECT * FROM postlinks WHERE postlinks.date >= CONVERT(datetime,CONVERT(varchar(10),GetDate(),112))
DataSource Controls :: Accessing Specific Column In Database With Column ID With Table Adaptor
Jan 6, 2010I'm currectly tryin to access a specific value in my database in a specific column. I'm tryin to use the primary key of the table to access the actual value in the row of that ID.
The current code:
[Code]....
Just iterates through the table and looking for any row with the boolean 'checkin' value is True, then it takes the 'id' value of that row and stores it into an array. Is there a way that I can access a another entry, and only that entry, in the table with the 'id' stored in the array?
Like if my data base contained and int, primarykey, `id` value, a boolean, `checkedin` value, and a `time` value, is there a way to access, lets say, the row with `id` equalling 3 and and the checkIn value from that row?
DataSource Controls :: Unable To Select And Insert Data In Mapping Table Using Entity Framework
Jan 18, 2010I have three table like above, table C is mapping table which has foreign key of Table A and B.How can i select and insert data in Table C using Entity Frame Work?
View 2 RepliesDataSource Controls :: How To Query A Table That Contains An XML Column And Bind The Data To A Gridview Object
Jun 21, 2010I have tried to query a table with an xml column by using XQuery and I can't get the Select to work.
All my knowledge/understanding of the subject comes from this MSDN article:
[URL]
so I am probably overlooking something minor:
I tried this query Select col1, Phone.Query('element CellPhone {I am not sure about what goes here} I tried {data('Phone/cellPhone} from aTable Where Phone.Exist('/Phone/cellPhone/text()[contains.,"412-8977"]') = 1 This syntax is definitely not fun.
DataSource Controls :: How To Select Only Certain Columns With LINQ
May 11, 2010If I have a linq statement like:
[Code]....
There may be a lot of data in the Blogs table. What if all I wanted was say BlogID, BlogTitle and BlogAuthor and nothing else, is there a way to do this in an effort to make the sql more efficent?
Along the same lines in my DataContext (.dbml) file I added some associations between some of my tables. This makes coding nice when I do a linq statement that will join those tables automatically for me but my concern is does it do that everytime, thus making all my linq quieries inefficient?
DataSource Controls :: How To Select Multiple Tables By Using LinQ In MVC
May 19, 2010I'm using ASP.NET MVC to create a small web apllication.
Here is my database And here is my class
[Code]....
C# - Use Linq To Sql To Select One Column From Row?
Dec 18, 2010I am using this C# with linq to sql:
string currentLabel = from s2f in stream2FieldTypesTable
where s2f.s2fID == item.s2fID
&& (s2f.s2fLabel != item.s2fLabel || s2f.s2fIsRequired != item.s2fIsRequired)
select s2f.s2fLabel;
I am getting a compiler error saying i can't assign type System.Linq.IQueryable<string> to string.
I tried this code:
string currentLabel = from s2f in stream2FieldTypesTable
where s2f.s2fID == item.s2fID
&& (s2f.s2fLabel != item.s2fLabel || s2f.s2fIsRequired != item.s2fIsRequired)
select s2f.s2fLabel.ToString();
And that returns the same error. I'm sure this is a simple thing. what am I missing? I just want the first s2fLabel that matches the where clause.
SQL Server :: Get 3 Tables Sql Statement - Select Table C Column By Using Table A?
Mar 25, 2011 i have 3 tables which are Table A(a Id,b Id),
Table B(b Id,a Id,c Id),
Table C(c Id,b Id)
How can i select Table C column by using table A?
DataSource Controls :: Linq Query To Select Parent Records Which Have Related Children
Jan 19, 2010I have a basic CMS which I'm adding to a site to display some downloads organised into groups. I have two tables, one for the groups and one for the downloads. I'm using a repeated to display the groups with another repeater inside to display the children. This works perfectly.
However some of my download groups may not have any downloads related to them and I'd like to handle this by filter the groups so that only those with a relate download record(s) are shown.
I'm trying to do this with the query which populates the top repeater based on some ideas I read but I must be going wrong with the syntax.
Here is what I'm using to try and only select downloads groups which have downloads linked to them by the download group ID.
[Code]....
Can anyone offer any thoughts on how I should construct the query to perform this?
Forms Data Controls :: How To Add A Column Header To A Column Of Auto Generated Select Buttons
Aug 18, 2010I have a gridview which has a column of auto generated select buttons, where a user can select a row.However, I would like to add a column header to my auto generated select buttons in order to make the gridview look complete, but I am unable to see how I can do this. Does anyone know how I can add a header text to an auto generated select button?
View 2 RepliesDataSource Controls :: SQL LINQ Will Not Update Table
Apr 3, 2010I am running the folowing simple test code:
[Code]....
But the UpdateUser field does not update - it remains at NULL. No errors occur. I can use similar code to update table fields in other dbmls successfully.
DataSource Controls :: Linq To Sql: How To Retrieve Identity Column Value Before For Inserting Any Record
Apr 3, 2010I am in a serious trouble right now, i wanted to know that how to write a query in LINQ to SQL to retrieve identity column's current value before inserting any value.
I need this cos i m building a windows app n i need to display this value before inserting a record. I have tried DataContext.ExecuteCommand('DBCC CHECKIDENT (Tablename)') but it returns the number of rows modified.
DataSource Controls :: Add Read Only Computed Column In Linq To Sql Designer (dbml)?
Feb 7, 2010How do add read-only computed column in LinqToSql designer (dbml)? My existing table structure:
Name: ID, Type: int, AutoGenerate: true, AutoSync: OnInsert, PrimaryKey:
true, ServerDataType: int not null identity, Source: IDName: Name, Type: string, ServerDataType: nvarchar(100) not null, Source:
NameName: Value, Type: byte[], ServerDataType: VarBinary(max), Source:
Value, UpdateCheck: Never
I want add the 4th colum name: Name: HasValue, Type: bool --> [Value] != null
DataSource Controls :: Making A LINQ To SQL Gridview Column A Clickable Link?
Feb 24, 2010I have a database table column consisting of text URLs [URL] In my LINQ-to-SQL-driven gridview, I want to make this a clickable link programmatically, with differing link text (e.g. "Link text"). I'm getting close but am missing some key concept. Here's the core of the .vb codebehind:
Dim dctx As New ResourceMod.ResourceModDALDataContext
Dim eleResObj = From eleRes In dctx.Resources Where eleRes.Type = "url" Select siteurl = eleRes.Website
GridView1.DataSource = eleResObj
GridView1.DataBind()
This displays the raw URL in the gridview (i.e. non-clickable). I've experimented with adding an explicit hyperlink column a la [URL](setting AutoGenerateColumns false etc.), but haven't yet figured out how to assign the asp:hyperlink Text and NavigateUrl fields with the anonymous-type object eleResObj. Using a field construct such as Text='<%# Eval("siteurl") %>' isn't working, presumably a scope issue. Is a LinqDataSource needed in this case, and if so, how would that affect the original LINQ query?