SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 ASP.NET
 Problem with transferring a large data to SQL Serv
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

msd1357
Starting Member

3 Posts

Posted - 07/19/2009 :  01:02:16  Show Profile  Reply with Quote
Hi
I develop an application with Visual Studio 2008 on a Windows Mobile 5 Device. In my application I need to transfer my local data to SQL Server 2005 via WiFi network. I do this scenario:
1. Make a well formed dataset on the device which contains about 4 tables.
2. Call a Stored Procedure from central server and pass my dataset as XML data type (as string format) to a stored procedure on server.
At the first glance everything works fine and I can pass dataset (as string type) to SQL Server and parse it at server side and read every 4 tables data without any problem. But when the capacity of the dataset exceed than a specific size (I thing 3 or 4 kilo bytes) I take an exception on my device when the program tries to send data to SQ Server 2005. This is the Exception that occurred:

--Message :
SqlException
--StackTrace :
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, TdsParserState state)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, TdsParserState state)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand cmdHandler, SqlDataReader dataStream)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at DataAccessLayer.DAL.Select(String StoredProcedureName, List`1 parameter)
at Niloofar.frmTransferDataToServer.mnuTransfer_Click(Object sender, EventArgs e)
at Niloofar.frmTransferDataToServer.btnTransfer_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.ButtonBase.WnProc(WM wm, Int32 wParam, Int32 lParam)
at System.Windows.Forms.Control._InternalWnProc(WM wm, Int32 wParam, Int32 lParam)
at Microsoft.AGL.Forms.EVL.EnterModalDialog(IntPtr hwnModal)
at System.Windows.Forms.Form.ShowDialog()
at CommonComponent.frmParent.ShowForm(Form frm)
at Niloofar.frmMain.mnuTransferToServer_Click(Object sender, EventArgs e)
at System.Windows.Forms.MenuItem.OnClick(EventArgs e)
at System.Windows.Forms.Menu.ProcessMnuProc(Control ctlThis, WM wm, Int32 wParam, Int32 lParam)
at System.Windows.Forms.Form.WnProc(WM wm, Int32 wParam, Int32 lParam)
at System.Windows.Forms.Control._InternalWnProc(WM wm, Int32 wParam, Int32 lParam)
at Microsoft.AGL.Forms.EVL.EnterMainLoop(IntPtr hwnMain)
at System.Windows.Forms.Application.Run(Form fm)
at Niloofar.Program.Main()

I wrote the same code in a simple windows application and it works fine with the same large dataset.
I'm very confused about this problem. Anybody could help me please?
Regards…
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000