dotNETportal.cz

Caw. Neviem ako dostnem vysledok vyhladavnia v databaze do labelu. V databáze by to malo vyhladat cislo, a to cislo chcem dat do labelu. Ako mam pokracovat? a ako zmenim ten dataz aby sa tabulka aj stlpce ktore chcem nacitat menili podla premenej v ktorej bude ulozeny nazov tabulky alebo stlpca?

Hladal som to na fore aj v clankoch, bohuzial mi to podla toho nefungovalo. Diky

Dim con As SqlCeConnection
Dim com As SqlCeCommand

        con = New SqlCeConnection("Data Source=|DataDirectory|\tolerancie.sdf")
        con.Open()

        com = New SqlCeCommand("SELECT od, vratane, IT01, H_D FROM(d_A) WHERE (od = 3) AND (H_D = N'H') AND (vratane = 6)", con)

Dim con As SqlCeConnection
        Dim com As SqlCeCommand

        con = New SqlCeConnection("Data Source=|DataDirectory|\tolerancie.sdf")
        con.Open()

        com = New SqlCeCommand("SELECT od, vratane, IT01, H_D FROM(d_A) WHERE (od = 3) AND (H_D = N'H') AND (vratane = 6)", con)

Zřejmě jste hledal na fórech a v článcích špatně ;-)

Vytvořený příkaz je nejprve provést, aby v něm byl nějaký výsledek...

Dim reader As SqlCeDataReader = com.ExecuteReader()

While reader.Read()
   Dim prvniSloupec As Integer = reader.GetInt32(0)
   Dim druhySloupec As Integer = reader.GetInt32(1)
   ...
  
End While

A dotaz změníte jednoduše skládání Stringu, např.:

String.Format("SELECT {0} FROM {1} ", nazevSloupce, nazevTabulky)

asi som blby ale stale sa mi to nejde. vykona sa prikaz ale potom ako dam aby som to vlozil do labelu? co znamena ta (0) a (1)...???

diky, podla tohto to uz snad spravim

dalsi problem, pouzivam sql compact edition ale ak spustim program na pc kde nie je nainstalovany vb tak to vyhodi tuto chybu:

See the end of this message for details on invoking

just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************

System.DllNotFoundException: Unable to load DLL 'sqlceme35.dll': Zadaný modul sa nepodarilo nájsť. (Exception from HRESULT: 0x8007007E)

at System.Data.SqlServerCe.NativeMethods.DllAddRef()

at System.Data.SqlServerCe.SqlCeConnection..ctor()

at System.Data.SqlServerCe.SqlCeConnection..ctor(String connectionString)

at DATABAZA_TOLERANCIÍ.vypocethriadela.Button1_Click(Object sender, EventArgs e) in C:\Documents and Settings\Martin\Desktop\PROJEKT\DATABAZA TOLERANCIÍ1\DATABAZA TOLERANCIÍ1\vypocethriadela.vb:line 116

at System.Windows.Forms.Control.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ButtonBase.WndProc(Message& m)

at System.Windows.Forms.Button.WndProc(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************

mscorlib

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3603 (GDR.050727-3600)

CodeBase: file:///E:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

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

DATABAZA TOLERANCIÍ1

Assembly Version: 1.0.0.0

Win32 Version: 1.0.0.0

CodeBase: file:///E:/Documents%20and%20Settings/Michal/Desktop/Release/DATABAZA%20TOLERANCI%CD1.exe

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

Microsoft.VisualBasic

Assembly Version: 8.0.0.0

Win32 Version: 8.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0b03f5f7f11d50a3a/Microsoft.VisualBasic.dll

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

System

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0b77a5c561934e089/System.dll

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

System.Windows.Forms

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0b77a5c561934e089/System.Windows.Forms.dll

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

System.Drawing

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0b03f5f7f11d50a3a/System.Drawing.dll

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

System.Runtime.Remoting

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0b77a5c561934e089/System.Runtime.Remoting.dll

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

System.Data

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///E:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0b77a5c561934e089/System.Data.dll

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

System.Xml

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3082 (QFE.050727-3000)

CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0b77a5c561934e089/System.Xml.dll

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

System.Data.DataSetExtensions

Assembly Version: 3.5.0.0

Win32 Version: 3.5.30729.1 built by: SP

CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/System.Data.DataSetExtensions/3.5.0.0b77a5c561934e089/System.Data.DataSetExtensions.dll

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

System.Core

Assembly Version: 3.5.0.0

Win32 Version: 3.5.30729.1 built by: SP

CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/System.Core/3.5.0.0b77a5c561934e089/System.Core.dll

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

System.Data.SqlServerCe

Assembly Version: 3.5.0.0

Win32 Version: 3.5.5386.0

CodeBase: file:///E:/Documents%20and%20Settings/Michal/Desktop/Release/System.Data.SqlServerCe.DLL

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

System.Transactions

Assembly Version: 2.0.0.0

Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)

CodeBase: file:///E:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0b77a5c561934e089/System.Transactions.dll

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

************** JIT Debugging **************

To enable just-in-time (JIT) debugging, the .config file for this

application or computer (machine.config) must have the

jitDebugging value set in the system.windows.forms section.

The application must also be compiled with debugging

enabled.

For example:

<configuration>

<system.windows.forms jitDebugging="true" />

</configuration>

When JIT debugging is enabled, any unhandled exception

will be sent to the JIT debugger registered on the computer

rather than be handled by this dialog box.

Čo sa s tým dá robiť?

Na každém počítači na kterém se Vaše aplikace bude používat musí být nainstalovaná verze .Net frameworku pod kterou jste aplikaci vyvíjel.

skusam ju na dvoch a ani na jednom nejde ak ked je na obidvoch .Net framework 3.5

A nemáte v projektu nareferencovanou nějakou knihovnu která není součásti .Netu?

jedine, ako som pisal, sql compact databazu. Moze byt ze som pri jej vytvarani nieco nenastavil aby mala v sebe to co potrebuje aby fungovala bez instalacie?

nikto ziadny napad kde moze byt chyba? (okrem programatora)

ak nie je nainstalovana sql databaza na pc na ktorom sa program snazim spustit tak nejde. ale sql compact edition by mal fungovat bez toho aby bolo treba nieco instalovat nie???

Mam stejny problem a uz jsem na to prisel.

Jde o x64 system a dll neni x64 kompatibilni.

Reseni - v "Build/Configuration manager" nastavit Active solution platform x86 (volba <new>).

SQL Compact není součástí .NET Frameworku. Instalujte jej samostatně, nebo dodávejte tyto knihovny s projektem:

sqlceca30.dll

sqlcecompact30.dll

sqlceer30EN.dll

sqlceme30.dll

sqlceoledb30.dll

sqlceqp30.dll

sqlcese30.dll

System.Data.SqlServerCe.dll