Ado.net Entities + get table by T
- by john
Hi all
Is it posible to get a table to do queries on with Ado.net Entities?
In linq ou could do DataContext.GetTable.Where......
Thanks in advance
Search Results
Search found 25547 results on 1022 pages for 'table locking'.
Page 136/1022 | < Previous Page | 132 133 134 135 136 137 138 139 140 141 142 143 | Next Page >
-
-
mysql :ordering table with day names
- by Meko
Hi.I am trying to get day of names with and correct order like Monday ,Tuesday.. But in my table I have records that after Monday comes Friday or I have Thursday between two Tuesday .I want to order them like Monday ,Monday ,Tuesday ,Tuesday, Wednesday so on .But I don`t want to group them. I used this query but it does not make order select Day_Name from mydb.schedule where Room_NO=(510) And Week_NO =(1) it outputs Monday Monday Tuesday Wednesday Wednesday Tuesday Thursday Thursday Thursday how can I correct it?Read the article
-
Table is realigned after setting the display property to 'block'
- by Holicreature
I'm having a table and i have a row which is initially set to the display property of 'none' and i changing it to 'block' at some selection of value from my select box , at that point of time the row is not aligned properly. My two columns are set inside a single column of the above row? but when i change it again to 'none' all the other rows are aligned correctly..Read the article
-
Convert dependencies to point to View instead of Table
- by jwarzech
I currently have a SQL Server 2008 database in which I am planning to separate out some tables to other databases. I want to be able to replace all references to the separated tables from the original database using views. Is there a better way (other than manually changing all FK and SProc references) to switch all the dependencies to reference the view instead of the table?Read the article
-
Update table of two different database
- by chetan
This is the query to update table in one database that is of other Update test.temp a, test2.temp b Set a.name=b.name Where a.no=b.no; Now I don't want to write every field i.e a.name=b.name Is there any solution?Read the article
-
parse html table using ASP.NET
- by Milee
Hi, I need to read a html page and parse the contents of a table in that. I am using ASP.NET.Could anyone tell me how to do this. Thanks.Read the article
-
if validation on the form field fails, set visible=true on a table row
- by Blankman
I have a table row that has the error message in it. ... Now if someone forgets to enter text or bad text in a textbox, I want this form field to be set to visible. Can I use a asp.net validator for this or?Read the article
-
[Javascript] How to call JS to click a table element
- by Ricky
Hi all: Assume I get a table element with ID="emTab", how do I call JS to click it? Thanks.Read the article
-
Import/Export table definistrions using SQlServer Management Studio
- by fireBand
Hi, How to import/export table definitions from my dev database to production database(recreate the whole database). I have Sql server 2005, Sql Management studio with power shell. Thanks in advance.Read the article
-
MYSQL: Udate table column from subquery result
- by Jhourlad Estrella
On the Members table are columns "MemberID" and "PointsEarned". I want to update the PointsEarned column from the result of this query: SELECT m.MemberID, m.UserName, ( (SELECT COUNT(*) FROM EventsLog as e WHERE e.MemberID=m.MemberID AND e.EventsTypeID=2)*10 ) + ( (SELECT COUNT(*) FROM EventsLog as e WHERE e.MemberID=m.MemberID AND e.EventsTypeID=3)*3 ) + ( (SELECT COUNT(*) FROM ChatMessages as c WHERE c.MemberID=m.MemberID)*.1 ) as PointsEarned FROM Members as m Can anybody tell me how I should do it with a single query? Thanks!Read the article
-
Query for second maximum salary from employee table
- by Dinesh
how to find out second maximum salary from all employee in employee table ? please give me sql query.Read the article
-
SQL server 2000 how to find transaction history for a table/row
- by Stan
How do you find the modification history for a certain table / row in SQL server 2000? Thanks.Read the article
-
Scripting all the constraints and indexes without the create table statement
- by Ice
Hi there, How to get a script for all tables about all default constraints and indexes from an existing database? SQL Server Management Studio produces SQL-Scripts with the create table statements and there is no option to dismiss it. Peace IceRead the article
-
Scanning a mysql table from the bottom
- by ming yeow
When i run a mysql select statement, it takes very long because i have already previously deleted a very large number of rows. Is there a way for the table to start scanning from the bottom, as opposed to from the top?Read the article
-
Question on jpa joined table inheritance
- by soontobeared
Hi, The 'DiscriminatorColumn' annotation isn't creating any column in my parent entity. Where am I going wrong ? Here's my code @Entity @Inheritance(strategy=InheritanceType.JOINED) @DiscriminatorColumn(name="TYPE", discriminatorType=DiscriminatorType.STRING,length=20) public class WorkUnit extends BaseEntityClass implements Serializable{ @Entity @DiscriminatorValue(value="G") @Table(name="Group_") @PrimaryKeyJoinColumn public class Group extends WorkUnit implements Serializable{Read the article
-
Creating aspnet_membership table, need script please...
- by John
Does anyone out there have a create script for aspnet_membership table? I found a data structure for it on MS site but cannot find a script to create it anywhere on the web. Many thanks in advance JRead the article
-
MS-Access: SQL for updating a column in a table
- by tecnodude
Hi, I have the following table in an access database id VisitNo Weight 1 1 100 1 2 95 1 3 96 1 4 94 1 5 93 Now row 2 and 4 are deleted. So i have... id VisitNo Weight 1 1 100 1 3 96 1 5 93 However what i need is... id VisitNo Weight 1 1 100 1 2 96 1 3 93 What is the SQL query i need to accomplish the above? thanksRead the article
-
have mysql select statement return fully qualified column names like table.field
- by handsomeGun
is there a way to have a mysql select statement return fully qualified column names like "table.field" without using AS for every single field? like so: SELECT * FROM table1 LEFT JOIN table2 on table1.f_ID = table2.ID and the result would be: "table1.ID", "table1.name", "table2.ID", "table2.name", ...Read the article
-
Add table to SPDatabase object
- by Ramnik
I have created a database using a SPDatabase class. How can i add a table to it? and how to execute SQL queries in this database? Thanx....Read the article
-
LaTeX: Breaking long (sub)section titles in Table of Contents
- by V.Shevchishin
Hi! Is it possible to tune LaTeX to break automatically long (sub)section titles in the Table of Contents?Read the article
-
How to decrease width of table view cells for iphone
- by David Hsu
I'm trying to create a grouped table view with two sections. For the first section I would like the width to be only half the screen. For the second section it would be the standard width. Also, next to the first section I would like to put a button. How is this done? Thanks!Read the article
-
jQuery:Looping all radio buttons inside an HTML table
- by Shyju
I have an HTML table having n rows and each rows contain one radiobutton in the Row.Using jQuery , How can i look thru these radio buttons to check which one is checked ?Read the article
-
Large Data Table with first column fixed
- by bhavya_w
I have structure as shown in the fiddle http://jsfiddle.net/5LN7U/. <section class="container"> <section class="field"> <ul> <li> Question 1 </li> <li> question 2 </li> <li> question 3 </li> <li> question 4 </li> <li> question 5 </li> <li> question 6 </li> <li> question 7 </li> </ul> </section> <section class="datawrap"> <section class="datawrapinner"> <ul> <li><b>Answer 1 :</b></li> <li><b>Answer 2 :</b></li> <li><b>Answer 3 :</b></li> <li><b>Answer 4 :</b></li> <li><b>Answer 5 :</b></li> <li><b>Answer 6 :</b></li> <li><b>Answer 7 :</b></li> </ul> </section> </section> </section> Basically its a table structure made using divs. The first column contains a long list of questions and the second column contains answers/multiple answers which can be quite big ( there has to be horizontal scrolling in the second column.) The problem i am facing is when i scroll downwards the second column which has the horizontal scroll bar is also scrolling downward. I want horizontal scrollbar to be fixed there. as in it should be always fixed there no matter how much i scroll vertically. Much Like Google Spreadsheets: where the first column stays fixed and there's horizontal scrolling on rest of the columns with over vertical scrolling for whole of the data. I cannot used position fixed in the second column. P.S : please no lectures on using div's for making a table structure. I have my own reasons. and its kinda urgent. Thanks in advance.Read the article
-
jQuery and HTML visual glitches on table cell .toggle
- by Forkrul Assail
I have table that gets dynamically created. When using jQuery and toggle, everything works. I however get a small visual glitch - it seems the HTML sometimes get selected. How would I disable this on a faulty drag or mouse operation? Is there a difference in the DOM between text in a cell and 'not text' or buffered space in a td? Thanks in advance.Read the article
-
migrate a portion of a mysql table to SQLite
- by daniel
I have a mysql table set up like so: user_id | document 44 [blob] 44 [blob] 44 [blob] 46 [blob] I'd like to export all of user_id 44's data to an SQLite3 file. Best way to go about this without writing a script that reads the data and dumps it into a SQLite file?Read the article
