I'm trying to debug an assembly with System.Data.SqlServerCe - and when I deploy to a IPAQ 2210 - I get no errors! Alas, when I try to debug using the Pocket PC 2003 SE Emulator - I get the "cannot P/Invoke SQLCEME30.DLL" exception.
Can anyone offer directions?
best regards,
Walther
Hi. I have a problem. I'm working at the moment on application witch should write and read data from sql server. The application should work on windows mobile devices. I'm linking this code to event on a button:
Code Block private void menuItem1_Click(object sender, EventArgs e)
{
SqlConnection sqlCon;
sqlCon = new SqlConnection(String.Format(@"Data Source={0};Initial Catalog={1};User ID={2};Password={3}",
@"192.168.54.149sqlexpress", "MojDom", "kuba", "abuk"));
sqlCon.Open();
string insertString = @"insert into {0} values ('{1}', {2})";
SqlCommand cmd;
cmd = new SqlCommand(string.Format(insertString, "MojDom", "Kuba", 15), sqlCon);
cmd.ExecuteNonQuery();
if (sqlCon.State == ConnectionState.Open)
sqlCon.Close();
}
and on line sqlCon.Open() i get exception:
Code Block
System.Data.SqlClient.SqlException was unhandled
Message="SqlException"
Class=20
LineNumber=0
Number=6
Procedure="ConnectionOpen (Connect())."
Server="192.168.54.149\SQLEXPRESS"
Source=".Net SqlClient Data Provider"
State=0
StackTrace:
at System.Data.SqlClient.SqlConnection.OnError()
at System.Data.SqlClient.SqlInternalConnection.OnError()
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Connect()
at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin()
at System.Data.SqlClient.SqlInternalConnection..ctor()
at System.Data.SqlClient.SqlConnection.Open()
at AIHouse.FormMain.menuItemSettings_Click()
at System.Windows.Forms.MenuItem.OnClick()
at System.Windows.Forms.Menu.ProcessMnuProc()
at System.Windows.Forms.Form.WnProc()
at System.Windows.Forms.Control._InternalWnProc()
at Microsoft.AGL.Forms.EVL.EnterMainLoop()
at System.Windows.Forms.Application.Run()
at AIHouse.Program.Main()
And when im using exactly the same code in windows console application everytihng works fine when i run it on pc with sql server and emulator, or other pc connect to network. I'm working on emulator of Pocket PC 2003, I've "put" it in cardle and the emulated device has connection to my pc and internet, the firewall is off.
I really dont have any idea why it's not working.
sorry for my english, but its not my foreign language.
thx for sugestions and reply.
regards Kuba
Hi,
i have Smart Device with following Configuration :
Processor: ARMv4i
OS: Window CE 5.0
I have installed SQL CE 3.0 on my Device.
When I try to make new database on my devcie using Qurey Analyser 3.0 , it gives "ISQLW Provider Failed... ".
When I try Deploye SQL CE 3.0 Database Application using F5 in VS2005 , it give an error "Can€™t find P/Invoke DLL sqlceme30.dll".Plz tell me How can i resolve that problem.
thanks.
VIJAY KUMAR
Hi,
I'm a developer of VB.NET mobile applications at work. We have used Access in the past, and manually pushed flat files to and from the scanner. We are now exploring SQL CE.
Trouble is, I am having a difficult time figuring out how to open SQL CE databases on the Pocket PC emulator. I've worked more on the middleware programs in the past - and have just dealt with ADO.NET connection strings - not the actual development on the scanner itself.
I am try to figure out how to actually connect to SQL Server CE on the Pocket PC 2003 SE emulator.
When I deploy the application on the emulator, it installs SQL Server CE onto the emulator. However, I'm not sure how to install the sample database (starting off with Northwind.sdf for testing purposes) onto the emulator. I'm also not positive the connection string is correct - as it seems to be different than typical ADO.NET.
Here's my code (for connecting to the database) so far.
Code Snippet
Public Class SampleInventorySystem
Private _conn As SqlCeConnection
Public Sub New()
' This call is required by the Windows Form Designer.
InitializeComponent()
_conn = New SqlCeConnection("Data Source = .Northwind.sdf") 'This is one of 'many connection strings I've tried
End Sub
Private Sub SampleInventorySystem_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim cmd As New SqlCeCommand()
cmd.Connection = _conn
cmd.CommandText = "SELECT [Employee ID], [Last Name], [First Name], Photo FROM Employees"
Try
_conn.Open()
Catch ex As Exception
MessageBox.Show("Error opening database", "Error")
End Try
End Sub
End Class
When I deploy the application, the Try Catch block catches the error "Error Opening Database". I've also tried putting the full path for the connection string. Is there a folder which I should directly put the .sdf file into the emulator - similar to the folder directory of the scanner? (i.e. Storage Card/...)
Thanks for your help!
hi...!
I'm creating a small device application using visual studio.NET 2003. Is it possible to get a sql server ce database file (.sdf) that i created at the pocket pc emulator to my desktop pc ?
If that's possible, then can you tell me how to do that ??
thanx b4
Hi all,
I am trying to access my SQL Server database through SqlCeConnection:
cecon = new SqlCeConnection("Data Source=D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf");
cecon.Open();
I am getting the following error:
System.Data.SqlServerCe.SqlCeException was unhandled
Message="The path is not valid. Check the directory for the database. [ Path = D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf ]"
HResult=-2147467259
NativeError=25009
Source="SQL Server 2005 Mobile Edition ADO.NET Data Provider"
StackTrace:
at System.Data.SqlServerCe.SqlCeConnection.ProcessResults()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at nddbpda.frmCeMain.frmCeMain_Load()
at System.Windows.Forms.Form.OnLoad()
at System.Windows.Forms.Form._SetVisibleNotify()
at System.Windows.Forms.Control.set_Visible()
at System.Windows.Forms.Application.Run()
at nddbpda.Program.Main()
When I tried to get the path from which the database file is being accepted, I got a different path:
string path;
path = System.IO.Path.GetDirectoryName(
System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
MessageBox.Show(path);
This code gives me this path:
Program Filesddbpda
Then I changed the path in my connection string to this:
cecon = new SqlCeConnection("Data Source=\Program Files\nddbpda\nddbpdadatabase.sdf");
cecon.Open();
When I ran my application it worked (virtually), but the database is not getting updated (for obvious reasons).
What should I do now to correct this?
Thanks in advance.
Saswata.
Hi all,
I am trying to access my SQL Server database through SqlCeConnection:
cecon = new SqlCeConnection("Data Source=D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf");
cecon.Open();
I am getting the following error:
System.Data.SqlServerCe.SqlCeException was unhandled
Message="The path is not valid. Check the directory for the database. [ Path = D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf ]"
HResult=-2147467259
NativeError=25009
Source="SQL Server 2005 Mobile Edition ADO.NET Data Provider"
StackTrace:
at System.Data.SqlServerCe.SqlCeConnection.ProcessResults()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at System.Data.SqlServerCe.SqlCeConnection.Open()
at nddbpda.frmCeMain.frmCeMain_Load()
at System.Windows.Forms.Form.OnLoad()
at System.Windows.Forms.Form._SetVisibleNotify()
at System.Windows.Forms.Control.set_Visible()
at System.Windows.Forms.Application.Run()
at nddbpda.Program.Main()
When I tried to get the path from which the database file is being accepted, I got a different path:
string path;
path = System.IO.Path.GetDirectoryName(
System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
MessageBox.Show(path);
This code gives me this path:
Program Filesddbpda
Then I changed the path in my connection string to this:
cecon = new SqlCeConnection("Data Source=\Program Files\nddbpda\nddbpdadatabase.sdf");
cecon.Open();
When I ran my application it worked (virtually), but the database is not getting updated (for obvious reasons).
What should I do now to correct this?
Thanks in advance.
Saswata.
RDA - vb 2005 app - desktop & pocket pc emulator - error: 80072F76 native error: 28035
PDA info:
.NET CF 1.0 env-string...
MS SQL client
MS SQLCE 2.0 dev
MS SQLCE 2.0
DESKTOP info:
Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600
copied an app from http://www.codeproject.com/netcf/PocketPCwithSQLCE/PocketPCwithSQLCE_Src.zip
modified its CONFIG.XML to...
<?xml version="1.0" encoding="utf-8" ?>
<Configuration>
<DatabaseServer>192.168.1.89</DatabaseServer>
<DatabaseName>D1Temp</DatabaseName>
<DatabaseLogin>sa</DatabaseLogin>
<DatabasePassword></DatabasePassword>
<SQLCEURL>http://192.168.1.89/SqlMobile/sqlcesa30.dll</SQLCEURL>
<LocalDBConnect>Provider=Microsoft.SQLServer.OLEDB.CE.2.0; Data Source=My DocumentsMyFav.sdf;</LocalDBConnect>
<LocalDBLocation>My Documents</LocalDBLocation>
<LocalDBName>MyFav.sdf</LocalDBName>
<IISLogin>192.168.1.89/Jason</IISLogin>
<IISPassword>batman2005</IISPassword>
</Configuration>
error is "Header information is either corrupted or missing. [,,, header name,,]"
have spent weeks google-ing trying to get this to work, to no avail.
Has ANYONE got RDA PULL to work with above setups?
How to Connect sqlServer 2000 in Pocket PC 2003 Application.
In Packet PC 2003 Application I have to connect to sql server 2000 on
my machine. The application gives error if connected using sqlConnection. Is SQL server CE necessary to connect to sql server 2000 in .Net Compact Framework?
I am unable to debug code from a SQL Database Project using the CLR. After VS 2005 does the auto-attaching to the SQL server, VS hangs until I tell it to stop debugging. Many others have reported this as a similar problem, however this only seems to affect me when I€™m connecting to specific servers. Specifically it seems to be remote connections. When I attempt to connect to my SQL 2005 Developer Edition €œlocally€? I get right through and can debug.
From my VS output window:
Auto-attach to process '[1688] [SQL] gx620-eric' on machine 'gx620-eric' succeeded.
Debugging script from project script file.
testing
No rows affected.
(0 row(s) returned)
Finished running sp_executesql.
The thread 'gx620-eric [59]' (0x1730) has exited with code 0 (0x0).
The thread 'gx620-eric [59]' (0x1730) has exited with code 0 (0x0).
The thread 'gx620-eric [59]' (0x1730) has exited with code 0 (0x0).
The thread 'gx620-eric [59]' (0x1730) has exited with code 0 (0x0).
The program '[1688] [SQL] gx620-eric: gx620-eric' has exited with code 0 (0x0).
When I attempt to connect to a remote server running Enterprise Edition, it hangs after a successful attach.
Auto-attach to process '[1856] [SQL] virtual2003eric' on machine 'virtual2003eric' succeeded.
Sometimes after countless attempts, I am able to get this to work, but lately I have had no success. As far as the SQL Server side, enabling and disabling the CLR through the Surface Area Configuration seems to be the only place to do anything relative to the CLR inside SQL server.
I have firewalls disabled. All SQL Servers presently have both SQL 2005 SP2 and Visual Studio 2005 SP1 installed.
I€™ve tried restarting servers and services, checking and un-checking €œAllow SQL/CLR Debugging€? and those steps did not work for me.
Does anyone have any insight on this one? Any ideas on how I can further debug this one?
Thanks.
Eric
Hi,
I have found that when I'm debugging a custom component in BIDS that I've created in another instance of Visual Studio, every time I rebuild the component I have to shutdown and restart BIDS and then reattach to the BIDS process. Which is pretty time consuming... And if I find a small error in my custom component when debugging then I don't seem to be allowed to make any changes to the code unless I stop debugging and go through the process above.
Am I missing something here? Or do I really have to manually go through these steps every time I want to change code in the component I'm debugging?
Can I automate the process with MSBuild or NAnt? If so, is there an example of this anywhere?
Thanks in advance,
Lawrie.
i ham having a problem with dll slceme30.dll on the emulatior pocket PC 2003
whens creating a sql sserver mobile database
dim SCE a new sqlCeEngine("data source = " & dbpath)
i get tme message
DLL Pinvoke 'sqlceme30.dll introuvable
i am running vs2005 and have added the refeences
sytem.data
system.data.sqlclient
system.data.sqlserverce
the sqlserver Smobile SDK has been installes separataly because VS 2005 failed
i have read maby posts but have not found the solution.
what must i do ?
Hi all,
i am creating one database file <name>.sdf using SQL CE in visual studio 2005 IDE, and its giving this error "Can't find PInvoke DLL 'sqlceme30.dll'." at run-time whenever i am initialising the the SqlCeEngine. what could be the problem ? i have already installed "sql.phone.wce5.armv4i.CAB" file on my emulator from path "C:Program FilesMicrosoft SQL Server Compact Editionv3.1SDKinClientv2.0wce500armv4i".
can anybody help me ?
Thanks
I create a smll app that should created a database in the hand held, it compiles without problem but when I debugg it
I ge the error message: Cannot find PInvoke DLL SqlCeMe30.dll
I found such dll to be located in:C:Program FilesMicrosoft SQL Server 2005 Mobile EditionDeviceMobilev3.0wce500x86 among other folders.
Why then is "not found"?
Dear All,
Please let me know how I can overcome the following Error.
System.InvalidOperationException was unhandled
Message="An error occurred creating the form. See Exception.InnerException for details. The error is: Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)"
Source="RDA_Dummy"
StackTrace:
at RDA_Dummy.My.MyProject.MyForms.Create__Instance__[T](T Instance) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 190
at RDA_Dummy.My.MyProject.MyForms.get_frmMain()
at RDA_Dummy.My.MyApplication.OnCreateMainForm() in C:TestMy ProjectApplication.Designer.vb:line 35
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[] commandLine)
at RDA_Dummy.My.MyApplication.Main(String[] Args) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 81
at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
Regards,
I am using an O2 XDA II mini running Windows Mobile 2003 SE. Tried creating a Windows Mobile 5.0 Pocket PC project but during deployment, I get this error.
Can't find PInvoke sqlceme30.dll
I have searched thru the forums and found something similar. I tried all their recommendations but no luck. Is there anything I am doing wrong? I copied the DLL files in the device's Windows directory (sqlceme30.dll, sql*.dll...around 5 DLLs)
I would appreciate any assistance
I am developing for an ipaq handheld. I just upgraded to Windows Mobile 5.0 and tried to run my application and I get this message.
Can't find PInvoke DLL 'sqlceme30.dll'
I am using a sql Mobile DB and vs2005
hai
I have deployed an application on mobile and when i run the application on mobile it shows this error
"can't find PInvoke DLL'sqlceme30.dll'"
What's the problem pls explain
thanks.
Here's what I did to a VS2005 Smart Device application.
Removed the reference to System.Data.SqlServerCe.dll.
Set a reference to C:Program FilesMicrosoft SQL Server Compact Editionv3.1SDKinwce500 System.Data.SqlServerCe.dll.
While it€™s loading in the emulator I notice that it appears to still be loading SQLCE3.0 instead of 3.1.
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev3.0wce500ARMV4isqlce30.ppc.wce5.armv4i.CAB'
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev3.0wce500ARMV4isqlce30.repl.ppc.wce5.armv4i.CAB'
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev3.0wce500ARMV4isqlce30.dev.enu.ppc.wce5.armv4i.CAB'
Do I need to set something else?
It would be great to get some feedback on this, I've wasted nearly the whole day trying to figure it out.
I've created a simple test database called test.sdf. It contains a few tables but no data. My plan is to populate the database programatically; however, the INSERT command does not seem to be working correctly. I can see that the data actually gets added to the database when I add it and iterate over it programatically (using SqlCeCommands), but after the program completes and I look at the Table in "Server Explorer" via VS 2005, the data is no longer there!
Now note that the location of the sdf is in the Emulator's "shared folder." I have read from other posts (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=173589&SiteID=1) that you cannot create a database on emulated "storage card" with PPC 2005 emulators but I've read nothing about modifying a database which exists there. Unfortunately I do not currently have access to a "real" device so I can't test this in any other way.
Here's the test function:
public void Test()
{
SqlCeConnection conn = null;
try
{
conn = new SqlCeConnection();
conn.ConnectionString = @"Data Source = Storage Card est.sdf";
conn.Open();
SqlCeCommand cmd1 = conn.CreateCommand();
cmd1.CommandText = "INSERT INTO Customers VALUES ('Joe Schmoe')";
int n = cmd1.ExecuteNonQuery();
cmd1.CommandText = "INSERT INTO Customers VALUES ('Alice Wonderland')";
n = cmd1.ExecuteNonQuery();
SqlCeCommand cmd2 = conn.CreateCommand();
cmd2.CommandText = "SELECT * FROM Customers";
SqlCeDataReader rdr = cmd2.ExecuteReader();
//this correctly prints out Joe Schmoe and Alice Wonderland
while (rdr.Read())
{
String str = rdr.GetString(0);
Console.WriteLine(str);
}
rdr.Close();
}
finally
{
conn.Close();
}
}
After running this test function, I open the Customers table in VS2005 and no Customer rows exist despite the fact that the SqlCeDataReader correctly iterated through the previously added 2 customers.
Why I can't connect sql server 2000 with wm5 or emulator ?
I used windows server 2003, sql server 2000 Enterprie SP4, visual studio 2005.
My this code can connect to sql server with win application (.net framework 2.0) but can't connect to sql server with device application (.net compact framework).
Dim strcon As New SqlConnection("Data Source=192.168.0.3;Initial Catalog=nortwind;User ID=sa")
Try
strcon.Open()
Dim sqlcom As New SqlCommand("select * from products", strcon)
Dim s As String = sqlcom.ExecuteScalar.ToString
Catch ex As Exception
MessageBox.Show(ex.Message.ToString, "")
Finally
strcon.Close()
End Try
Question
1. How to tip for setup and config windows server 2003 and sql server 2000 can connect with device?
2. What's IP of device in running ?
Hi Guys,
View 7 Replies View RelatedHi,
i know i have the chance to access my mobile device (physical or emulator) from Management Studio.
I went to Connect Object Explorer, server type Sql Server Mobile but i can´t connect to my emulator and i can´t see any way to connect to a physical device either. How can i do this?
The only thing i can do is create a sql server mobile database (.sdf).
Thanks
SP
Team:
How to invoke a stored procedure "out of process", meaning i want to add it to a queue.
Reason: we have a proc that is fired real-time each time an order comes into the system and it take a few seconds and when there is plenty of order activity in the system, the process times out. I would like to essentially add this to a queue and move on and some other process will process from the queue. Is CLR call the way to do? I know that the easiest way can be to add to a table and process from the table every 5 mins or something like that. Thoughts?
Thx
Sri
I am developing a mobile application with Visual Studio 2005 RTM. I created a .SDF database from scratch within the Server Explorer window. Based on the properties of the database, this is a version 3.0 DB. I then deploy the application to the Pocket PC 2003 SE Emulator and I receive an error when trying to open the database from my app. It's a very generic error:
System.SData.SqlServerCE.SqlCEException
I trap the error in my code, but there is no message in the exception object.
If I try to open it with Query Analyzer on the device, I get an error stating "The file is not a valid database file". It appears that SQL CE 2.0 was deployed to the emulator.
I noticed that when I add a reference in my project to the System.Data.SQLServerCE namespace, it defaults to this DLL:
C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev2.0System.Data.SqlServerCe.dll
I tried removing that and manually adding a reference by browsing to this 3.0 DLL:
C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev3.0System.Data.SqlServerCe.dll
I then receive the following build error:
Unable to load referenced library 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerMobilev3.0System.Data.SqlServerCe.dll': Version 2.0 is not a compatible version.
If I build the database in my application from scratch from within my code, everything works fine, which I believe is because it is a 2.0 database that is generated.
To make a long story short:
How do I get my project to reference the 3.0 SQL Server CE namespace and deploy it to the emulator?
Hi!
I have developed DTS package for various tasks and scheduled to run some time. I have included SQL Mail task to notify me for each process when it fails. The questions is, When I open the package and execute from the menu, it works and it notifies me through SQL Mail task when it fails but when DTS package invokes at scheduled time and it got failed but it did not notify me that process in between has failed. It seems like SQL Mail task does not work when i schedule the package. Is there any one did come across this situation? or is there any way to resolve this issue? Any help would be appreciated!
Thanks,
Mohana
I want to creat an alert that will back up my database when the log files get to 90% full. When i try to create a new alert and select performance condition and select sqlserver:databases as the object then log file(s) Used size (kb) as the counter but when i go and select the instance i dont see my database in the drop down list but if I change to sql server event alert I see the database i want to use for this alert. I dont want to wait until the log is already full to back it up i want to do it when it hits a percent full. Is there a way to do this as a performance condition? thanks for your help!
View 7 Replies View RelatedWe have a Compact Framework 1.1 application that uses Sql Server CE 2.0. In VS2003, a reference to System.Data.SqlServerCe causes the Sql Server CE dlls and Query Analyzer to install to the Emulator or PDA.
I am currently converting the application to Compact Framework 2.0, but we are not upgrading to Sql Server Mobile (yet). However, the reference to System.Data.SqlServerCe, in VS 2005, no longer causes Sql Server CE to install to the PDA/Emulator.
There is a difference in the build outputs between VS2003 & VS2005. In 2003, System_SR_enu.cab, sqlce.wce4.x86.cab & sqlce.dev.wce4.x86.cab are copied & lanuched. In 2005, only System_SR_enu.cab is copied... no launch.
Any ideas? Reinstall VS2005?
Feeling really dumb tonight - below is my stored procedure and code behind which completes (it puts "completed" in TextBox4) but does not insert anything into database.
Questions:1) do in need to include the primary key field in the insert stored procedure?2) do I need a DataAdapter to actually get it running and open and close the connection? STORED PROCEDURE running on SQL 2000 server: ______________________________________
CREATE PROCEDURE newuser003.InsertCompanyInfo
@CS_CompanyName nchar(100),@CS_City nchar(500),@CS_Phone varchar(20)
AS
INSERT into tblCompanyInfo_Submit(CS_CompanyName, CS_City, CS_Phone)VALUES ('@CS_CompanyName', '@CS_City', '@CS_Phone')RETURN
C# CODE BEHIND: ______________________________________________________
public partial class ContractorSubmision : System.Web.UI.Page{ protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["localhomeexpoConnectionString2"].ConnectionString); SqlCommand cmd = new SqlCommand("CompanyInfoSubmit", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CS_CompanyName", TextBox1.Text); cmd.Parameters.AddWithValue("@CS_City", TextBox2.Text); cmd.Parameters.AddWithValue("@CS_Phone", TextBox3.Text); TextBox4.Text = "Completed"; }}
hello everybody, i have a question to ask, suppose i have a sqldatasource, can i use it in a method??this is my case, i need to make a new method to count the rows in a datagrid, so i will have to read the sqldatasource. the problem is, how to retrieve it?? usually i use the built in sqldatasource_selected to count the rows.... is there any other way??
View 6 Replies View RelatedI have a DTS Package to populate data from excel sheet to direct simple table. I like to call this DTS from User interface. thanks in advance
View 2 Replies View RelatedHi Guys,
Anyone can tell me, How to invoke ssis package as webservice ?
Is it possible ? If yes How ?
Yogesh V. Desai. | SQLDBA|
I've got an application uses a WPF GUI, is built in VS2008 final, targets .Net Framework 3.5, and uses a Sql Ce 3.5 database for local storage. After a specific WPF window is rebound the application hangs. Hitting pause on the debugger reveals the offending method is a call to SqlCeConnection.Dispose(). Via Reflector I can see this method calls SqlCeConnection+ObjectLifeTimeTracker.Close() which in turn calls GC.WaitForPendingFinalizers(). Within WPF there are some objects (specifically TextBox) which need to have their resources freed on the main application thread. The finalizer thread is waiting on the main application thread, which is in turn waiting on the finalizer thread, resulting in a deadlock.
You can see some additional discussion of the topic including our temporary resolution in this thread.
My question is why is there a call to GC.WaitForPendingFinalizers() buried within the SqlCeConnection.Dispose() call tree?