TableAdapterManager Use With SSCE 3.5 Bug Or By Design?

Feb 7, 2008


I don't know if it is by design or a bug. I have tried using the TableAdapterManager with remote SQL 2005, SQL 2005 Express (local and remote) with success.
I have tried using the TableAdapterManager ,( which is included by default with the dataset), with SQL Compact 3.5 as a local (within project) and remote(not in the project) and it does not work.

I would think that if the intention is to start using SCE 3.5 as the local database for applications (which makes sense), then I would think that making use of the TableAdapterManager class would seem to be a no brainer unless I'm missing something. I've been known to do that.

I guess my question is, is this a bug or by design?

Any comments would be appreciated.

Shane

View 2 Replies


ADVERTISEMENT

C++ SSCE Example

Apr 4, 2007

Hi



Does anyone have an example code in C++ to create a SSCE db and access data?



Many thanks



Ozzie

View 3 Replies View Related

2 Problem In SSCE

Jul 31, 2007

hi,
this is my first post here, i am using Sql Server CE 2005 these days.
in a project i found 2 problem that can't find any solution for them till now , maybe there are some bugs i founded them

here is :
1- when i have a SqlCeCommand Object and the ComandText for it is "Update [Term] SET Year=? WHERE _id=? AND name=? "

the problem is in here , i added parameters for this command, if value of parameter is in Unicode ( i tested it in Farsi[Persian] language value like 'زمستان' on 'name' parameter) , in ExcuteNonQuery() method , it throws FormatException with "Input String was not a correct format".
although if i change the value of 'name' parameter to something non-unicode (for example i tested it with 'ABCDE' ) it works correctly,

i think SqlCeCommand in UPDATE query , have problem with unicode values in paramteres.


2- second one is so strange for me !! , i have a loop that update a column in a table. and then have another loop that update the next column of that table. for example first i update the column 3 in loop, then in another loop i update the column 4.
after all, the value of column 4 and 3 is substituted, it means that values that i updated for column 3 is in column 4 , and values that i updated for column 4 is in column 3 !!!!!!!
both columns is in 'int' type.

and the last point is i tested both of this situations in SQL Server 2000 Developer Edition and both worked correctly without any problem.

also i used SQL Server CE v3.1 with .Net framework 2.0 in Vs2005 and C#.
is there any missing i'v done or is it some kind of bugs.

View 4 Replies View Related

Transactions In SSCE?

May 16, 2007

We are looking into developing our application using SQL Server Compact and have created a test database to become familiar with the API. Having read about ACID transactions in SSCE we would like to know how this is actually employed. What will happen if a power failure occurs during a transaction? Does this have to be recovered in the code?

I have read the following article: http://msdn2.microsoft.com/en-us/library/csz1c3h7.aspx, but is this the best way to deal with transaction failures?

I can't find any examples on how to recover from failures in transactions in SSCE.



Any help would be greatly appreciated.

View 4 Replies View Related

SSCE Transaction Log

Jun 11, 2007

Hi,

Are there any pecularities of Transaction Logs in SSCE comparing to the same log in full scale SQL Server? How are they stored? And when they are considered to be expired in order to safely delete them?

Thanx in advance

View 6 Replies View Related

Is It A Bug In SSCE OLEDB ?

May 18, 2007

i'm use this code ,in SQL2005 std and ACCESS database, it work

but if i use SSCE ,it's throw a OleDbException in ExecuteScalar()



Exception : OleDbException





0x80040E30L


DB_E_BADTYPENAME






Code Snippet

OleDbConnection od = new OleDbConnection("Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=db.sdf;SSCE:Database Password=");

od.Open();

OleDbCommand og = new OleDbCommand("INSERT INTO [bills] ([billno],[checkouttime],[finalprice],[handle],[ischeckout],[memo],[paymode],[trick]) VALUES (@billno,@checkouttime,@finalprice,@handle,@ischeckout,@memo,@paymode,@trick)", od);

og.Parameters.Add("@billno", OleDbType.VarWChar).Value = "2007051800000000";
og.Parameters.Add("@checkouttime",OleDbType.DBTimeStamp).Value="2007-5-18 11:55:40";
og.Parameters.Add("@finalprice", OleDbType.Single).Value = 0.0;
og.Parameters.Add("@handle", OleDbType.VarWChar).Value = "admin";
og.Parameters.Add("@ischeckout", OleDbType.SmallInt).Value = 0;
og.Parameters.Add("@memo", OleDbType.VarWChar).Value = "";
og.Parameters.Add("@paymode", OleDbType.VarWChar).Value = "";
og.Parameters.Add("@trick", OleDbType.VarWChar).Value = "";

og.ExecuteScalar();

od.Close();







why the same code is not work? i'm find all MSDN ,but there is no answer



Who can help me,Thanks

View 7 Replies View Related

SSCE 3.1 And 3.5 In VS 2008?

Nov 17, 2007

Hi-

VS 2008 supports targeting different versions of the .NET Framework. Will this apply to SSCE as well? I have some older apps that I want to keep in .NET 2 and SSCE 3.1. But I would also like to develop new stuff in 3.5. Will the targeting mechanism in VS 2008 support using SSCE 3.1 with .NET 2.0 and SSCE 3.5 with .NET 3.5?

Thanks.

-Gary

View 3 Replies View Related

Manage Ssce 3.5

Aug 5, 2007

I have been having "fun" trying to get all the bits (SSCE 3.5, Orcas Beta 2, SQL Managment Studio) in Vista 64 and Xp 32.

So far I have found at the SQLMetal does work with SSCE 3.5 but not in Vista64

BUT I cannot get any tool (tried SQL and SLQ express) to manage my SSCE db - ie make relationshipos so that SQLMatal can do its stuff


Any advice as to which tool to use to manage SSCE 3.5


Thanks

Mike

View 5 Replies View Related

SSCE 3.5 RTM Build Numbers

Nov 22, 2007



Does anybody have the RTM build numbers for SQL Server Compact Edition 3.5?

Thanks

View 5 Replies View Related

SSCE License Restrictions?

Sep 20, 2007

Could y'all please clarify this statement with some examples:

"A SQL Server Client Access License (CAL) is required for any connection to SQL Server, including a connection from SQL Server Compact Edition."

Is this only referring to RDA, or is it referring to data replication by any means? Is there any restrictions for connections between SSCE devices?

Thanks!

View 3 Replies View Related

Can't Update .sdf Database With SSCE 3.5

Apr 2, 2008

I've just recently downloaded Visual Studio 2008 Express which comes with SQL Server 2005 Express and SQL Server Compact 3.5, both of which were installed when I installed the products.

I've been following the tutorial videos and trying some stuff of my own and I just can't seem to get a Compact 3.5 database to actually update! I'm doing EXACTLY what is shown in the tutorials and th dataset is being updated - changes and added records - and they will show up in a DataGrid control as expected, but when I accept the changes - nothing is changed and/or added to the actual .sdf file. When I open it again, it's the same as it was before. Using exactly the same code but with an SQL Server 2005 Express database (.mdf), updates are fine.


First I created a dataset that connects to the SSCE 3.5 database .SDF file. Then I simply drag the table from the dataset to the form which creates Dataset, Table Binding Source, Table Adapter Manager and BindingNavigator items, in addition to the toolbar and DataGrid controls. The code generated from this is below. I have added the Try/Catch block and messages to see if any errors are ocurring.



Code Snippet
Public Class Form3


Private Sub TblMessageTypeBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TblMessageTypeBindingNavigatorSaveItem.Click



Me.Validate()



Me.TblMessageTypeBindingSource.EndEdit()



Try




Me.TableAdapterManager.UpdateAll(Me.AppMessagesDataSet)

MsgBox("Changes Saved")

Catch ex As Exception


MsgBox(ex.ToString)

End Try


End Sub


Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load




'TODO: This line of code loads data into the 'AppMessagesDataSet.tblMessageType' table. You can move, or remove it, as needed.


Me.TblMessageTypeTableAdapter.Fill(Me.AppMessagesDataSet.tblMessageType)


End Sub

End Class




When I run the app, the data in the database table is displayed correctly. If I make a change and add a record then click the Save button, I get the expected "Changes Saved" message indicating that there are no errors. When I look a the contents of the table, the changes and additions did not happen and the data is exactly the way it was before.

I had the full SQL Serer 7.0 installed as well so I thought there might be a conflict or something became corrupted. In uninstalled SQL Server 7.0, SQL Server 2005 Express and SQL Server Compact 3.5. I "repaired" VB 2008 Express which reinstalled SQL Server Compact 3.5 and separately reinstalled SQL Server 2005 Express. Same problem.

As I mentioned above, what gets me is that if I use the same setup for a SQL Server 2005 Express database, changes and inserts work just fine. (Used the Northwind.mdf (Express) and the Northwind.sdf (Compact) sample databases and created my own sample .mdf and .sdf databases - same results.)

I've looked at whatever I can to see if I can find the problem but just can't put my finger on it. Very frustrating.

Does anyone have any advice on what I might be doing wrong with Compact or if there is something I've missed or if there's a property somewhere that needs to be set, or perhaps a configuration issue??

Many thanks,

Ben

View 6 Replies View Related

SSCE 3.5 In VS2008 - Gold?

Nov 20, 2007

I just installed VS2008 RTM and noticed that it really wants me to use 3.5 instead of 3.1. As I am doing most of my SSCE work through the SQL Server 2005 Management Studio (its query editor is still far superior to VS'), I found that I can still use 3.1 without much trouble (so long as I manually browse and add the 3.1 reference to my project).

That said, I'd like to use 3.5. My two questions are:
- Is the SSCE 3.5 version included in VS2008 final? I noticed the dlls are all over a month old. Can I redistribute these with my app?
- Will there be support in SQL 2005 or SQL 2008 for connecting to 3.5 databases? I know that a new SQL server 2008 CTP was released, but haven't seen mention of SSCE support. I'd really hate to lose the great query editor of the Management Studio when moving to 3.5.

View 5 Replies View Related

SSCE OLEDB Bug In GetParameterInfo

Dec 11, 2007

Howdy folks,

I may have stumbled upon the most obscure bug imaginable. I was noticing my parameterized queries were failing on our SBC (WinCE5 x86), but not on our WinCE5 x86 emulator, WinXP setup, or WinCE5 ARMIV emulator. After much grief, I discovered the source of the problem had to do with a call to ICommandWithParameters::GetParameterInfo().

On all platforms other than our SBC, the DBPARAMINFO::ulParamSize was (correctly) retrieved as 16B for type DBTYPE_DBTIMESTAMP. On the SBC this value was retrieved as 8B. Now I know that natively all platforms of SSCE store a datetime object in 8B, but a DBTIMESTAMP structure (16B) is what's always used to transfer those fields to and from the database. Needless to say, with the wrong ulParamSize being returned, my data buffer (which used DBTIMESTAMP's) was being overwritten.

The erroneous value can be seen in this image

Just to further the case that this is a bug, the column size of a datetime field is correctly retrieved as 16B on the same platform when GetColumnInfo is run, as shown here.

Do y'all have any insight in this matter?

View 4 Replies View Related

SSCE 2005 + Windows 98

Jun 22, 2007

Does SSCE 2005 work in Windows 98 ??? If yes, How do I deploy my aplication with SSCE 2005 in Windows 98 ???



Thanks every one,

View 3 Replies View Related

Conversion MSAccess -&&> SSCe

Dec 6, 2006

We have plan to migrate our database from Access to SqlCe.

Here our situation:

We will never use a Pocket PC applications, only Windows desktop application.
We want to migrate the .mdb file to a .sdf file (I've seen the ADS application, but since we don't use mobile devices, it's no use)
The .sdf will be use on local client machine only.
Here's my problems:

I've use a conversion to migrate from access (http://www.primeworks-mobile.com/Downloads/DPW.html) and seem to work fine.
I updated the source code to use the SqlServerCe dll instead of OleDB.
Some of my queries work fine, but others just won't work in VS2005 using C#.

To check if the query is really wrong, I take exactly the same query and put it Query Builder from the Server Explorer in VS2005.
And the query just work fines!!! It's bring back all the records asked for, and I've got an error for the same query from my source code.

I'm using a datatable, here's the code used for filling the DataTable. I've got an error on the line adapter.FillSchema()






string connectionString = @"Data Source=" + fic_parent.CheminFichierComplet;
using (SqlCeConnection connection = new SqlCeConnection(connectionString))
{
SqlCeDataAdapter adapter = new SqlCeDataAdapter();

connection.Open();

SqlCeCommand command = new SqlCeCommand(requete, connection);

command.CommandType = CommandType.TableDirect;
adapter.SelectCommand = command;

tableResultats = new DataTable();
adapter.FillSchema(tableResultats, SchemaType.Source);
adapter.Fill(tableResultats);

// Close connection
connection.Close();
}



Error is:

Message="The specified table does not exist. [ (...) ]"
Source="SQL Server 2005 Everywhere Edition ADO.NET Data Provider"
HResult=-2147217865
NativeError=0

Here my questions:

Is it possible to have an application that will convert my Access databases to an SSCe .sdf file ?
Why I can query in Server Explorer and can't in my source code using the same sql statement ?

At which level my code isn't good, because I just replace all OleDB* --> SqlCe* in my code.
I hope that I explain clearly my problem, do not hesitate to ask me questions about this problem.

View 8 Replies View Related

SSCE With Flash Memory

Dec 11, 2007



Hi,

I have a question about using SSCE with flash memory. Our CE components equally allocate the write access to the memory location. But write access is guaranteed only 10000 times per memory cell.
So I need to know

1. what changes are made to the file system if I add an entry to a table?
Is this entry the only information added to the file system?
2. What happens if I delete an entry? Will SSCE optimize the data in the filesystem?

Thanks a lot for helping.
Regards Flo

View 1 Replies View Related

Cannot Get SSCE 3.5 Beta 2 To Work

Aug 3, 2007

I'm running VS2008 beta2. I've succefully added a SDF database file to my project and created a couple of tables in it from VS. I added a reference to the System.Data.SqlCeConnection. When I try to create a new instance of the SqlCeConnection class I get a nasty error that states I'm missing the 'sqlceme35.dll' file. I copy all of the files .dll into by bin folder. Now I'm getting a BadImageFormat error when I create an instance. Does anyone know what that means? or why I had to copy those files to begin with? This is very odd. Any help would be appreciated. I am new to SqlCe.

View 14 Replies View Related

What Is Maximum Database Size In The SSCE?

Apr 24, 2007

Hi,



I've found a two different answers for this question:

one - on the http://support.microsoft.com/Default.aspx?kbid=920700 site where on the Performance improvements section there is a 128MB value in the Database size.

other is in the product datasheet there is a information that this version supports databases up to 4 GB.



Could you tell me what is the correct answer?



Regards,

Mariouche

View 3 Replies View Related

What Tool To View SSCE Database?

Mar 11, 2008



What tool should I use to view SQL Server Compact Edition database?

I have VS2008 Professional, but I didn't find any tool in the installation. So I tried to install the SQL Server Developer Edition, which is included in the VS2008 package, but the installation has quit saying the that there is nothing to upgrade (there is probably newer version of SQL installed by VS2008 itself).

I also tried to download and install SQL Server Managment Studio Express. The installation went well, but then I wasn't able to select any SSCE database (there was only SQL Server Express or something like that selectable).

Is there anything else I should do?

View 1 Replies View Related

Can SSCE 3.0/3.5 Cater For Multi-user Instances?

Oct 4, 2007

Hi all,

I just want to know if SSCE 3.0/3.5 can cater for Multi-user instances? I have a desktop application that I want to allow multiple Windows-user accounts to access. basically I need a datastore that can be lightweight (which SSCE is) and support "User Instances" (like in SQL Server Express)


thanx!

View 5 Replies View Related

Migration MySQL To SSCE...big Problems In SQL CE Language...

Jul 10, 2007

hello,(sorry for my english language but im french :-) )

I have a lots of problems to convert the SQL language from MySQL to SSCE because the SSCE language is so poor...

If somebody have some URL with a lots of examples of request (select, update).
for example, im not able to convert this update request :

Update reservation,lockers set reservation.ERS_ID='A' where lockers.LCK_CONF!='LW' AND lockers.LCK_PHYS_NO=reservation.LCK_PHYS_NO AND reservation.ERS_ID IN('V','M','E','S','F','D','P');

how to use 2 tables in the same update???
i saw the MSDN but there arent explicit and GOOD examples...
http://msdn2.microsoft.com/fr-fr/library/ms174122.aspx

Thanks you

View 1 Replies View Related

[Bug?]Exception Thrown In SSCE 3.5 Beta2 But Not In 3.5 Beta1.

Aug 14, 2007



Hi,
I replace the reference assembly System.Data.SqlServerCe with version 3.5 beta2 in Microsoft.Practices.EnterpriseLibrary.Data.SqlCe. When I used the Data.SqlCe block in application, an exception ("Cannot access a disposed object named SqlCeConnection") threw. This didn't occur in SSCE 3.5 beta1 and early versions.
Finally I found the difference between beta1 and beta2.
In the SqlCeConnection class, there is a RemoveWeakReference method. this is code snippet of beta1:





internal void RemoveWeakReference(object value)
{
if (this.weakReferenceCache != null)
{
this.weakReferenceCache.Remove(value);
}
}
and this is for beta2:




internal void RemoveWeakReference(object value)
{
if (this.weakReferenceCache == null)
{
throw new ObjectDisposedException("SqlCeConnection");
}
this.weakReferenceCache.Remove(value);
}




So, if we dispose a connection before a command, such as:
SqlCeConnection cn;SqlCeCommand cmd;... cn.Dispose();cmd.Dispose(); // Error, an exception will be threw. Is it a bug of Beta2?

View 1 Replies View Related

Table And Query Hints Not Working In SSCE 3.1 ?

Aug 23, 2007

I am trying to use hints and they don't seem to be working.
Something like:

select * from TABLE_NAME with (tablock,xlock)

fails.

Documentation clearly states that this is supported (TABLOCK, NOLOCK, XLOCK, etc.), so I must be missing something simple.

Please let me know how do I use Hints in SQL Server 2005 Compact.
Thanks.


PS.
I am using C#. It doesn't work in my code when I use

SqlCeDataReader rs = cmd.ExecuteReader();

And it doesn't work from inside the VS 2005 "query tool" or whatever it is called, when you do "Connect to Database" and so on.

View 1 Replies View Related

SSCE Open Database On Desktop Application

Jan 31, 2008

Hello

I am writing a Desktop application accessing a SSCE database. I am running Windows XP SP2, VS2005 SP1, and have SQLServerCE3.1 installed. Debugging the application shows that ds.m_spInit->QueryInterface() returns E_NOINTERFACE. I have checked that SSCE runtime library is installed, IDBCreateSession uuid exists in the registry and m_spInit.CoCreateInstance(CLSID_SQLSERVERCE_3_0) return S_OK. Can you suggest me what need adding/installing to get the CSession.Open(datasource) working?

Thanks
Ares,

View 1 Replies View Related

Cannot Construct A SELECT DISTINT COUNT... Statement In SSCE 3.1

Oct 4, 2007

Hi everyone,

sorry to b a pest again! Before I made the decision to change the DB used in my app from SQL Server Express to SSCE, I had no problems with constructing a SELECT statement as laid out in the Title.

Basically, I have 2 tables with a one-many relationship between them. In the Parent table, I had a SQL Statement as follows:

SELECT DeptID, DeptName,

(SELECT DISTINCT COUNT(Active) FROM Documents WHERE (Documents.DeptID = Dept.DeptID) AND
(Documents.Active = 'True') AS CountOfActive
FROM Dept


Now in SSCE 3.1, I get an "Unable to parse query" error message when I construct the same SQL statement in my dataset designer.

Any thoughts on how I may solve this?

Much thanx!
Shalan

View 15 Replies View Related

SSCE Visual Studio Setup / Integration Woes

Dec 19, 2007

I have had a heck of a time trying to get SQL Compact Edition 3.5 working in by Visual Studio 2008 environment. I (now) know it comes along with Visual Studio 2008 by default, however, I didn't realize that at first and went and installed one of the SQL Compact Edition MSI's that were available from MS download. Since then I am unable to create a new compact edition database (Add New Item...) in visual studio it says:


The data provider required to connect to the local data file could not be found. The file will be added to the project but the typed DataSet associated with the file will not be generated.

Also, When I try to create a new connection under server explorer, I notice the SQL Compact Edition is not a data source option.


I am running the relased build from the MSDN download iso: en_visual_studio_team_system_2008_development_x86_x64wow_dvd_X14-26382.iso


I have uninstalled the seperate install of the SQL Compact Edition and run repair on the visual studio 2008 installer and it does not fix the problem. I have seen a reference that says the design time installer should be under Program FilesMicrosoft Visual Studio 9.0Common7IDE, but it isn't in my install. I did find it on the source DVD under the folder WCUSSCESSCEDeviceRuntime-enu.msi.


After running that, I no longer get the original error message. Now I get a little further and then the Data Source Configuration Wizard comes up and says

An error occured while retrieving the information from the database:


SQL Server Compact is either not installed or the installation has been corrupted.


OK, so I look under C:Program FilesMicrosoft SQL Server Compact Editionv3.5 which install from the DVD (WCUSSCESSCEDeviceRuntime-enu.msi.) created and notice a readme file that inside has a link for downloading and installing the Runtime for Desktop computers.

Thinking that perhaps the runtime is a seperate install from the design tools I follow the link and setup starts. At this point I notice that the set says Compact Edition 3.5 BETA - hmm that doesn't seem right so I cancel. Not sure why the final product for the design tools would have a readme that points to a download link for the BETA of the runtime, but going back to the DVD I see the file WCUSSCESSCERuntime-enu.msi and run it. This time it says it will install Compact Edition 3.5 - looks good no BETA.

Finish the instal and viola! it works....

So what worked for me in the end:

1) Uninstall any other installs of Compact Edition 3.5 you might have
2) repair visual studio
3) install the design tools from the DVD WCUSSCESSCEDeviceRuntime-enu.msi.
4) install the runtime fgrom the DVD WCUSSCESSCEDeviceRuntime-enu.msi.




View 2 Replies View Related

Bad Error Message Connecting To SSCE V3.5 From Orcas Beta 1 In SSMSX SP2 Under Vista

May 12, 2007

I'm receiving a bad error message when attempting to connect to SSCE .sdf files installed by Orcas Beta 1 (e.g., Northwind.sdf from the ...v3.5Samples folder) and created by the Orcas Beta 1 Sync Designer with SQL Management Studio Express SP2 (version 9.00.3042.00).



The message is:

TITLE: Connect to Server
------------------------------

Cannot connect to C:Program FilesMicrosoft SQL Server Compact Editionv3.5SamplesNorthwind.sdf.

------------------------------
ADDITIONAL INFORMATION:

You are trying to access an older version of a SQL Server Compact Edition database. If this is a SQL Server CE 1.0 or 2.0 database, run upgrade.exe. If this is a SQL Server Compact Edition 3.0 or later database, run Compact / Repair. [ Db version = 3505053,Requested version = 3004180,File name = C:Program FilesMicrosoft SQL Server Compact Editionv3.5SamplesNorthwind.sdf ] (SQL Server Compact Edition ADO.NET Data Provider)

------------------------------


Obviously 3505053 is a newer than SSCE 3004180, not earlier. I don't understand why SSMSX SP2 would request a specific version and refuse to open the latest version.



I don't recall having this problem with SSMSX SP2 and VS Orcas March CTP under Windows Server 2003 (March CTP wasn't certified for Vista).



VS Orcas Beta 1's Server Explorer can open the .sdf files and display their content but won't execute DDL commands against them.



There also is what I believe to be a related problem with the Sync Designer failing to add LastEdited and CreatedDate fields to the .sdf files (see Sync Designer/SSCE Version Problems with Orcas Beta 1 in the Sync Services forum.



--rj







VS Orcas

View 6 Replies View Related

VS2008 Solution With Multiple Projects. Best Practices For Connection Strings And SSCE Files?

Jan 15, 2008

Hi everyone - I'm getting myself into a right muddle and am looking for advice.


How do people deal with connection string matters when taking a dataset defined in one assembly (and by default using the connection strings defined within that assembly in the settings files) and then using that assembly in an app (which also has a requirement to see the same physical database).

I'm not sure I've explained that terribly well but what I'm trying to avoid is duplicate copies of my database which so far seems to be the only way that I've managed to make stuff work. I'm not very experienced with SSCE data access (I'm a serices/sockets/ip person) and this may just be ignorance. Most of the examples seem to assume that the data is in the same place as the app whereas I'm trying to collate a whole series of functions into a helper assembly that I'd like to re-use for other things.

Ideally the dataset designer would provide an easy way of choosing from centralised connection strings - perhaps this is what the Dataset Project implies - but again the docs are mostly focused on SQL Server? Otherwise the best I've been able to do is make the connection properties public and try to update them that way or use a post-build action to copy the database from my datalayer project directory to that of my application |DataDirectory|

I suppose the question might be if you have a dataset containing multiple tableadapters that assumes one connection string, is there any easy way to keep such strings co-ordinated between projects without hardcoding them? With a server resource, the same non-specific connection string resolves to the same server (if that make sense) and this seems to be were I can't make the logical shift.

Does anyone have any thoughts and can they please point this SSCE noob in the right direction?

Cheers

View 2 Replies View Related

DB Design :: Database Design For Matrix Representation

May 13, 2015

I have a scenario like below

Product1
Product2 Product3
Product4 Product5
Product1 1
1 0 0
1
Product2 1
1 0 0
1
Product3 0
0 1 1
0
Product4 0
0 1 1
0
Product5 1
1 0 0
1

How to design tables in SQL Server for the above.

View 2 Replies View Related

Database Design/query Design

Feb 13, 2002

Ok, I'm doing a football database for fixtures and stuff. The problem I am having is that in a fixture, there is both a home, and an away team. The tables as a result are something like this:

-------
Fixture
-------
fix_id
fix_date
fix_played

----
Team
----
tem_id
tem_name

-----------
TeamFixture
-----------
fix_id
tem_id
homeorawayteam
goals

It's not exactly like that, but you get the point. The question is, can I do a fixture query which results in one record per fixture, showing both teams details. The first in a hometeam field and the second in an away team field.

Fixture contains the details about the fixture like date and fixture id and has it been played

Team contains team info like team id, name, associated graphic

TeamFixture is the table which links the fixture to it's home and away team.

TeamFixture exists to prevent a many to many type relationship.

Make sense? Sorry if this turns out to be really easy, just can't get my head around it at the mo!

View 2 Replies View Related

DB Design :: Table Design For Packages

Aug 18, 2015

I would like to create a table called product. My objective is to get list of packages available for each product in data grid view column while selecting each product. Each product may have different packages type (eg:- Nos, CTN, OTR etc). Some product may have two packages and some for 3 packages etc. Quantity in each packages also may be differ ( for eg:- for some CTN may contain 12 nos or in other case 8 nos etc). Prices for each packages also will be different that also need to show.  How to design the table.. 

Product name   :  
Nestle milk |
Rainbow milk
packages  :
CTN,OTR, NOs |

CTN, NOs
Price:
50,20,5 |
40,6

(Remarks for your reference):CTN=10nos, OTR=4 nos  
| CTN=8 Nos

View 3 Replies View Related

Homebrew 'compaction' Vs SSCE Compaction

Dec 11, 2007

Howdy all,

I'm working on a program that does a 'compaction' or more literally, a replication, of one SSCE file to another. We couldn't use the built-in compaction routine due to some of its limitations. The basic steps of my program are as follows:

1. Create the full schema
2. Add constraints, indeces, etc.
3. Replicate each table by:
a. Selecting all records from the old database
b. Preparing a parameterized insert query with the number of records in the old database
c. Insert each record sequentially via the parameterized query

My question is such: If I have an SSCE compacted database of 189.67MB and run my 'compaction' routine on it, I get a filesize of 216.01MB. Both files have the exact same data and schema. The latter file ONLY had insert statements run on it.

How can I get my program to give similar results to SSCE? I'm using VC++ and OLEDB code with SSCE 3.1.

Thanks!
Jeff

View 5 Replies View Related

Converting A Data Type Double To A Type Float Using A Data Adapter && SSCE 3.5

Feb 13, 2008

Hi,

I can populate a dataTable with type double (C#) of say '1055.01' however when I save these to the CE3.5 database using a float(CE3.5) I lose the decimal portion. The 'offending' code is:


this.court0TableAdapter1.Update(this.mycourtsDataSet1.Court0);

this.mycourtsDataSet1.AcceptChanges();

this.court0TableAdapter1.Fill(this.mycourtsDataSet1.Court0);


This did not happen with VS2005/CE3.01.

I have tried changing all references to decimal (or money in CE3.5) without luck.

I'm beginning to think that string may be the way to go!!!!!!!

Can someone shed some light on my problem.

Thanks,

Later:

It's necessary to update the datatable adapter as the 3.01 and 3.5 CE are not compatible.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved