hi,
how to remove the extra column that comes default in datagrid silverlight 4.0
is there any good links to designing(css) data grid in silverlight 4.0
thanks in advance.
prince
What are the option in terms of applications that help build SQL statements against a MSSQL database?
We have some users that need to build sql statements, perferably through drag and dropping or linking up tables etc.., against a MSSQL databse who don't have any experience in this area.
Any Ideas?
We have two tables:
Vehicle: Id, RegistrationNumber, LastAllocationUserName, LastAllocationDate, LastAllocationId
Allocations: Id, VehicleId, UserName, Date
What is the most efficient (easiest) way to update every row in Vehicle table with newest allocation? In SQL Server I would use UPDATE FROM and join every Vehicle with newest Allocation. Oracle doesn't have UPDATE FROM. How do you do it in Oracle?
i need a regular expressions string to get all anchor tags in a page with a specific css class name, in c#/vb.net
this is what i got so far
"<a.*?href=""(.*?)"".*?>(.*?)</a>"
but my attempts to add "class=name" isnt working, also is it possible to find links where the class name appears either before or after the href with one expression ?
i am familiar with 3rd party html libraries, but thats an overkill for what i have in mind, so is the webbrowser control.
I have a complex XSD schema and hundreds of XML files conforming to the schema.
How do I automate the creation of related SQL Server tables to store the XML data?
I've considered creating C# classes from the XSD schema using the xsd.exe tool and letting something like Subsonic figure out how to make a shiny database out of it, but not sure if it's the best way to approach it.
Has anyone managed to elegantly import XSD files into SQL Server?
kind of a silly question, but ive been seeing things such as tbody and thead/tfood tags in other peoples tables
are these required even if they're empty for good markup? or can i just leave them out?
thanks
This gives me auto: I need the number, so I can move one above the other?
// Swop div index
$("#panel div").each(function(){
alert($(this).css('z-index'));
});
I have a path for example
C:\files\dir\file.css
The "files" directory exists. however, the dir directory is missing and needs to be created.
When I try to create the file using File.Create, it throws an exception saying that the directory was not found.
Is there any way to make .net to create the missing folders along the path for me?
Thanks
Given an SCN (system change number), and assuming an SCN for which the data is still in the undo logs, what information about the SCN can I derive?
of course, SCN_TO_TIMESTAMP() gives an approximate time the data was committed.
Is there any other information I can derive? What transaction, what tables, what data were affected? etc?
I have 2 databases with same tables. DBProduction and DBLocal both have testTable. How can i replace testTable of DBProduction with of DBLocal? There are some new rows inserted and some updated rows in testTable of DBLocal.
Using SQL Server 2008
Hello everyone,
I modified html codes generated by Firework, and now graphic was pused down I dont know how to fix it. Sorry Im still using tables, mixing up with css to create the list items....please help....What I did was extend the original graphic to make it taller to fit the list menu
http://imageoneads.com/work/inventory.htm
Thanks ahead
Hi,
I have a small problem.
I am creating an appointment table where in the foreign key is patient id which is referenced from patient table.This table is for all registered patients.
there will be unregistered patients also, who will be seeking appointments.SO i just need to store the name,phone and few details.
I don't want to make these 2 as different tables.
So is there a way to skip the integrity check of foreign key when i ma inserting unregistered patient data
Hello Guys!
I'm mapping a set of tables that share a common set of fields:
So as you can see I'm using a table-per-concrete-type strategy to map the inheritance.
But...
I have not could to relate them to an abstract type containing these common properties.
It's possible to do it using EF?
BONUS: The only non documented Entity Data Model Mapping Scenario is Table-per-concrete-type inheritance http://msdn.microsoft.com/en-us/library/cc716779.aspx : P
I'm studying Oracle database and have to do some exercises with default "HR" schema. But I think that data in my tables is changed from default values (many students have access to DB and may be someone changed data). Where can I get SQL to construct default "HR" schema?
I have two product tables Product1 and Product2. There is a one 2 one mapping on the field ProductId.
What I want is to get all the product ids where the Product2.Exported field is false AND
Where the product ids that are in Product1 but not in Product2 table.
Right now I have two queries that I'm trying to mash into one.
SELECT ProductId FROM Product1 WHERE ProductId NOT IN(Select ProductId From Product2)
SELECT ProductId FROM Product2 WHERE Exported = 0
I want to make one website for all PC, IPhone, Blackberry, Windows Mobile (IE Mobile), Opera Mobile Browser etc.
What thing need consider, avoid. I know Javascript is not much supported by mobile browsers and CSS media handheld is not supported by IPhone.
Is there a way to specify a join on all fields from table A with only one field from table B?
Is it necessary to specify each individual field from each table instead of using the all symbol (*) for one of the tables?
Hi,
Whenever I try to load the following part in tag on firfox browser, I get the message as "$ is not define". May I know the reason? I'm trying to load the jquery.js file before loading any custom script after CSS part.
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript">
$(document).ready(function(){
I've been encountering a seeming deadlock with one of my tables and the only place I can trace it back to is a stored procedure that uses sp_xml_preparedocument on a list of data. The data inserted, btw, consists of a 100k+ records on average. Is it possible that it is causing the deadlock? What other pitfalls does using sp_xml_preparedocument have?
Im having two tables
TableA
Custid prodid Amt1
1 10 200
2 20 300
3 10 400
4 30 300
5 20 400
6 30 200
TableB
prodid Amt2
10 100
20 200
30 300
and i want sum of all amount group by prodid. can any one give me both ansi and Tsql quries.
I have some pages that are sent via HTTPS. Internet Explorer sometimes complains about "This webpage contains content that will not be delivered using a secure HTTPS".
I looked in the html source to confirm all content calls (href, src, etc...) are sent via https. My CSS files use relative paths. But I'm still getting these warnings.
Is there an easy way to track down which items are not sent via HTTPS?
Table A
tableAID
tableBID
grade
Table B
tableBID
name
description
Table A links to Table b from the tableBID found in both tables.
If I want to find the row in Table A, which has the highest grade, for each row in Table B, I would write my query like this:
select max(grade) from TableA group by tableBID
However, I don't just want the grade, I want the grade plus id of that row.
I have been using the uiwebview for a app that consists a index.html,css and javascript files.I'd like to do away with the uiwebview and open the app in the safari browser instead.All source files are located within the app bundle.Is it possible and if so can someone point me in the rite direction.Thanks in advance for any help offered.
I have a image set as a link, with a title which is used for a caption in a lightbox. I need the "title" set in order to keep the caption for the lightbox, but I don't want the tool tip to pop up when I hover over the links. Anyone got a easy css fix? Or does this need to be done in Javascript?
What is the difference between JOIN, Inner Join, Left Join and Outer Join.
Let me put you on what i know.
JOIN Statement is used to join two tables and fetch the result.