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
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
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
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.
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 ?
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 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?
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 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?
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!
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 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?
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.
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
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 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
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.
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.
my object has field with data type int. when i put in html form in this textbox letter not number the validator say- The field must be a number. how can i change this messages like this
[Required(ErrorMessage = "??????? ????????")]
[DisplayName("????????")]
public int age { get; set; }
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 have a table of users - It contains around millions of rows (user-id is the primary key).
I just want to retrieve user-id and their joining date.
Using SELECT user-id, joining-date FROM users requires lot of time. Is there a fast way to query/retrieve the same data from this table?