Click here to Skip to main content
15,899,314 members
Home / Discussions / C#
   

C#

 
GeneralRe: Manipulate XML Pin
NarVish19-Apr-10 3:11
NarVish19-Apr-10 3:11 
GeneralRe: Manipulate XML Pin
NarVish19-Apr-10 19:13
NarVish19-Apr-10 19:13 
GeneralRe: Manipulate XML Pin
NavnathKale19-Apr-10 21:48
NavnathKale19-Apr-10 21:48 
GeneralRe: Manipulate XML Pin
NarVish19-Apr-10 23:34
NarVish19-Apr-10 23:34 
GeneralRe: Manipulate XML Pin
NavnathKale20-Apr-10 0:58
NavnathKale20-Apr-10 0:58 
GeneralRe: Manipulate XML Pin
NarVish20-Apr-10 1:20
NarVish20-Apr-10 1:20 
GeneralRe: Manipulate XML Pin
NavnathKale20-Apr-10 1:21
NavnathKale20-Apr-10 1:21 
QuestionHow to put large text data (~20mb) into sql cs 3.5 database? Pin
Anindya Chatterjee18-Apr-10 21:42
Anindya Chatterjee18-Apr-10 21:42 
I am using following query to insert some large text data :

internal static string InsertStorageItem =
            "insert into Storage(FolderName, MessageId, MessageDate, StorageData) values ('{0}', '{1}', '{2}', @StorageData)";


and the code I am using to execute this query is as follows :

string content = "very very large data";
string query = string.Format(InsertStorageItem, "Inbox", "AXOGTRR1445/DSDS587444WEE", "4/19/2010 11:11:03 AM");
var command = new SqlCeCommand(query, _sqlConnection);
var paramData = command.Parameters.Add("@StorageData", System.Data.SqlDbType.NText);
paramData.Value = content;
paramData.SourceColumn = "StorageData";
command.ExecuteNonQuery(); 


But at the last line I am getting this following error :

System.Data.SqlServerCe.SqlCeException was unhandled by user code
Message=The data was truncated while converting from one data type to another. [ Name of function(if known) = ]
Source=SQL Server Compact ADO.NET Data Provider
HResult=-2147467259
NativeError=25920
StackTrace:
at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommandText(IntPtr& pCursor, Boolean& isBaseTableCursor)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery()
at Chithi.Client.Exchange.ExchangeClient.SaveItem(Item item, Folder parentFolder)
at Chithi.Client.Exchange.ExchangeClient.DownloadNewMails(Folder folder)
at Chithi.Client.Exchange.ExchangeClient.SynchronizeParentChildFolder(WellKnownFolder wellknownFolder, Folder parentFolder)
at Chithi.Client.Exchange.ExchangeClient.SynchronizeFolders()
at Chithi.Client.Exchange.ExchangeClient.WorkerThreadDoWork(Object sender, DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
InnerException:

Now my question is how am I supposed to insert such large data to sqlce db?

AnswerRe: How to put large text data (~20mb) into sql cs 3.5 database? Pin
Ashfield18-Apr-10 22:16
Ashfield18-Apr-10 22:16 
GeneralRe: How to put large text data (~20mb) into sql cs 3.5 database? Pin
Anindya Chatterjee18-Apr-10 22:28
Anindya Chatterjee18-Apr-10 22:28 
GeneralRe: How to put large text data (~20mb) into sql cs 3.5 database? Pin
Ashfield18-Apr-10 22:43
Ashfield18-Apr-10 22:43 
GeneralRe: How to put large text data (~20mb) into sql cs 3.5 database? Pin
Md. Marufuzzaman19-Apr-10 0:09
professionalMd. Marufuzzaman19-Apr-10 0:09 
GeneralRe: How to put large text data (~20mb) into sql cs 3.5 database? Pin
Anindya Chatterjee19-Apr-10 0:41
Anindya Chatterjee19-Apr-10 0:41 
QuestionMFC to C# HELP ? Pin
Nematjon Rahmanov18-Apr-10 20:16
Nematjon Rahmanov18-Apr-10 20:16 
AnswerRe: MFC to C# HELP ? Pin
Jimmanuel19-Apr-10 4:08
Jimmanuel19-Apr-10 4:08 
QuestionNetwork Scanning Pin
satsumatable18-Apr-10 19:39
satsumatable18-Apr-10 19:39 
Questiondeploying web service on windows 7 Pin
Ice_Freez0518-Apr-10 18:56
Ice_Freez0518-Apr-10 18:56 
AnswerRe: deploying web service on windows 7 Pin
Calla18-Apr-10 21:36
Calla18-Apr-10 21:36 
GeneralRe: deploying web service on windows 7 Pin
Ice_Freez0518-Apr-10 23:28
Ice_Freez0518-Apr-10 23:28 
GeneralRe: deploying web service on windows 7 Pin
Calla19-Apr-10 0:09
Calla19-Apr-10 0:09 
GeneralRe: deploying web service on windows 7 Pin
Ice_Freez0519-Apr-10 15:13
Ice_Freez0519-Apr-10 15:13 
AnswerRe: deploying web service on windows 7 Pin
Md. Marufuzzaman19-Apr-10 0:18
professionalMd. Marufuzzaman19-Apr-10 0:18 
QuestionWeird delay when writing a file Pin
svanwass18-Apr-10 13:34
svanwass18-Apr-10 13:34 
AnswerRe: Weird delay when writing a file Pin
Richard Andrew x6418-Apr-10 13:45
professionalRichard Andrew x6418-Apr-10 13:45 
GeneralRe: Weird delay when writing a file Pin
Not Active18-Apr-10 14:21
mentorNot Active18-Apr-10 14:21 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.