After I decided at last to implement my Int128 in C#, I thought it would be nice to make it look like other dotNet data types.. But I could not implement the following feature:
suffix initialization: such as 13L and 0.2D
Can I make my own suffix in C#?
And if I can not.. how can I initialize it?
i.e
Int128 a= ??
I am using the below piece of code for SQL Bulk copy
using (SqlConnection con = new SqlConnection(strConString))
{
con.Open();
SqlBulkCopy sqlBC = new SqlBulkCopy(con);
sqlBC.DestinationTableName = "SomeTable";
sqlBC.WriteToServer(dtOppConSummary);
}
Can anyone provide me the equvalent code using Data access block Enterprise library
hi all i want to know that while specifying url in my iphone native application for downloading purpose it works fine but if i want to know the exact size of data either in kb or in Mb coming from that url how could i do that plz guide me to do that demonstarting a sample code would be a big boost
thanks
Hello,
Q: Is there a way to direct MYSQLDUMP to export VIEW's with data (and not just the CREATE SQL)? I want to use the resulting SQL to create a new table.
Thanks!
Jon
Hi everyone,
I use MonoDevelop 2.2.2 with Mono 2.6.3 on OpenSuse so the linq to sql feature is implemented. But I have the problem I can create a new connexion to a postgresql database it's ok but when I click in Tool - Generate Data classes and select the connexion I've created before I obtain nothing, no tables appear.
What's the problem ?
Currently my MySQL data stored like below
product | total
------------------------------------------
puma,adidas | 100.00,125.00
puma | 80.00
reebok,adidas,puma | 70.00,100.00,125.00
adidas,umbro | 125.00,56.00
How to combine, explode, merge and total it like this in php?
puma 485.00
adidas 350.00
reebook 70.00
umbro 56.00
When user start typing in their username in textBox field, a dropdown list shows old data. How can I clear this?. It's a class room and many students logs in from the same pc everyday, I don't want the student to see his mates usernames.
I have created an .SDF file and inserted data into the SDF database file on a mobile device. I want to transform .SDF file to a SQL Server 2008 Database File but don't know how. Any pointers or suggestions would be appreciated.
I have some specific requirements, with the most important at the top:
Can plot line and stacked bar charts
Can customize mouse events (hover, click) on chart data
Compatible and performant with IE7/8 (likely will use excanvas.js)
Can optionally control label formats, legends, colors
Open source preferred, or at least can purchase the source
Can be hosted locally
I have seen a couple potentially good ones:
Google's interactive charts (But code must be accessed via Google servers)
EJSChart
Flot
Does anyone have experience with these, or others, and can make a recommendation?
I am trying to upload a tab delimitted file with MySQL. I want a query something likes this: LOAD DATA LOCAL INFILE 'file' INTO TABLE tbl FIELDS TERMINATED BY 'TAB' Is there something I can subsitute for TAB to make this work?
Looking for a data type that is similar to VARCHAR as to the values I would like, but is there a way to have a MIN/MAX character length?
VARCHAR(6,10)
This would have a minimum of 6 characters and a maximum of 10 characters.
Hi
im a little confused by this diagram http://www.b-eye-network.com/images/content/i030ht0104.gif (Last diagram in the article)
1 - In the "ACCOUNTING ENTRY" table it shows "DebitEntry" and "CreditEntry"
i) is this two column or
ii) is this two rows of data? or
iii) is it two separate tables on its own, Acounting_entry_credit and Accounting_entry_debit?
Same question with the "ACCOUNT" table, it shows asset account, livabilities account, equaity account? are they 3 columns or are they 3 rows?
Source: http://www.tdan.com/view-articles/5227/
I am using the RESTEasy client framework to call a RESTful webservice. The call is made via a POST and sends some XML data to the server. How do I accomplish this?
What is the magical incantation of annotations to use to make this happen?
Hi!
The following is an excerpt of my XML data source:
<file>
<ALL_INSTANCES>
<instance>
<ID>1</ID>
<start>5.8633333333</start>
<end>29.8216666667</end>
<code>Player 1</code>
</instance>
<instance>
<ID>2</ID>
<start>28.4566666667</start>
<end>51.1450000000</end>
<code>Player 2</code>
</instance>
<instance>
<ID>3</ID>
<start>49.8383333333</start>
<end>71.1150000000</end>
<code>Player 3</code>
</instance>
<instance>
<ID>4</ID>
<start>72.9850000000</start>
<end>95.3766666667</end>
<code>Speler 1</code>
</instance>
</ALL_INSTANCES>
I'm looking to restructure this data into something like this:
<Player 1>
<ID>1</ID>
<start>5.8633333333</start>
<end>29.8216666667</end>
</Player 1>
<Player 1>
<ID>4</ID>
<start>72.9850000000</start>
<end>95.3766666667</end>
</Player 1>
<Player 2>
<ID>2</ID>
<start>28.4566666667</start>
<end>51.1450000000</end>
</Player 2>
<Player 3>
<ID>3</ID>
<start>49.8383333333</start>
<end>71.1150000000</end>
</Player 3>
Could anyone please help me to achieve this? Much appreciated!
Cheers,
Frank
Hi,
I have an application where I receive each data 40.000 rows. I have 5 million rows to handle (500 Mb MySQL 5.0 database).
Actually, thoses rows are stored in the same table = slow to update, hard to backup, ...
Which king of scheme is used in such application to allow long term accessibility to the datas without problems with too big tables, easy backup, fast read / write ?
Is postgresql better than mysql for such purpose ?
Thanks in advance
BEst regards
I want to turn a screen shot from the clipboard into a array data (Red/Green/Blue) in my program. so i guess it's as simple as that. but i don't want to use anything else then the print screen and clipboard if i can?
anyway any questions just ask.
Hi all,
I'm wondering whether there is a bossibility to export some selected data from my rails mysql db to a other sqlite db. The aim is to send that sqlite file directly to my iPhone application... That way I don't have to do a lot of xml integration in the iPhone app. That seems to be very slow...
Markus
Hello,
I am unable to access an action in my controller using .ajax. The code works on my development machine but as soon as I place it on the server it gives the error 401 Unauthorized. Here is a snippet of the code in the .aspx file...
var encoded = $.toJSON(courseItem);
$.ajax({
url: '<%= Url.Action("ViewCourseByID", "Home") %>/',
type: "POST",
dataType: 'json',
data: encoded,
//contentType: "application/json; charset=utf-8",
success: function(result) {
Thank you for the help.
hello, i have some scientific data that i want to insert into oo.org calc. when i do this, instead of displaying 0.35678 in a cell it displays 0.35 (only the first 2 digits after the decimal). but on clicking the cell, the formula bar shows the correct value...please help
Hi all,
i have to validate the data contains numeric or not and if it is not numeric return 0 and if it is numeric or empty return 1.
Below is my query i tried in SQL
SELECTdbo.Regex('^[0-9]','123') --- This is returning 1
SELECTdbo.Regex('^[0-9]','') -- this is not returning 1 but i want to return as 1 and i try to put space in "pattern" also it is not working...
please can any one help....
Thanks in advance
hello,
Can someone elaborate the difference between Control template and Data template in wpf?
It would be great if an example of how each can be used in different scenarios can be provided.
I am building an application that will function as a client-server application, and also as a disconnected client application. I will be using WPF (browser app for client-server application).
When interacting with the server's database, I will need to connect using WCF web services. When connecting with the localized database, I will need to connect using the local db's data access layer.
What methods/patterns exist for this sort of architecture?
I'm learning SQL Server Compact for a program I'm writing that requries a local database. I have multiple tables, each with different columns and I'd like to mark each column as being a certain type (not a data type, just an integer tag) to let the program know what to do with it. I'm clueless about SQL. How does one do this?