i want to call a printer thats connected to a terminal that my PDA is connected to, so that i can print stuff on my PDA. how do i do that in coding? and is there any support for printer stuff in vb.net? i'm using it to develop a smart device application for my pda. thanks!

hi all, i only want to get my scrollbars working. what i have done is paste 1 horizontal and 1 vertical bar on my form, put a button in the form but its out of view of the user(outside the form) and when i run the program i want it to be able to scroll to the place where i have placed my button. however it doesnt work, cause the button nv shows up. do i need to do any coding for this? thanks!!

Hi all, i have a pda application that uses SQLServerCE, and i would like to have wireless support for it so that i can use Remote data access to access SQLServer on a desktop terminal, and synchronise the data on the pda with the data on the desktop. I have a few questions here: 1)do i need any extra hardware or software on the desktop to enable for wireless connection? 2)In the code i have below, i left InternetUrl as blank as i'm not sure what i am supposed to put there. what is the parameter supposed to be? address of the desktop? 3)Is the code below sufficient for me to connect to the desktop database wirelessly? Dim conn As String = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=admin;" & _ "Data Source=terminal;Packet Size=4096;Workstation ID=terminal;User Id=;Password=" Dim rda As SqlServerCe.SqlCeRemoteDataAccess = Nothing Try rda = New SqlServerCe.SqlCeRemoteDataAccess 'rda.internetUrl = "?" rda.LocalConnectionString = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=\My Documents\test.sdf" rda.Pull("admin", "Select * from admin", conn, RdaTrackOption.TrackingOnWithIndexes, "ErrorTable") Catch err As SqlServerCe.SqlCeException MessageBox.Show(err.Message) Finally rda.Dispose() End Try Thanks for looking at my post =)

i found the problem, i forgot to close the filestream object which i set permissions on. thanks for the reply anyway.

i'm writing this code to be used on a PDA, what i want is to just create a Word document, write some things in and close it. But when i try opening it, an error appears saying that the file cant be opened. Dim fs As New FileStream("newfile.doc", FileMode.Create, FileAccess.Write, FileShare.None) Dim sm As New StreamWriter(fs) Dim i As Integer Dim j As Integer sm.WriteLine("test") sm.Close() what did i do wrong?

huh??? i didnt say that i dont want to use parameterised queries did i? there was a misunderstanding, i thought that parameterised queries was something thats similar to what i had typed out. now that i've checked it, i know i was wrong and now i that i've changed it, everything works fine. thanks for everything =)

i tried String.format and String.Concat, and when i use String.format, i get this error: System.ArgumentNullException; and if i use Concat i get an error when trying to insert the data: the specified data type is not valid. maybe i'm doing it wrongly, so i'll just post my code: dim price as string price = String.Concat(newprice)

i know that SqlMoney is not of a string type, but then again i'm not trying to insert a string into the query. The data type i specified in my database is of type Money, which is why i'm using SqlMoney in my code. Right now i'm thinking of ways on how to insert the value in, but its giving me errors so far.......thanks for the reply anyway.

i'm just trying to insert some values into a table, but i got this error which says: Operator & not defined for types System.Data.SqlTypes.SqlMoney This is the line which gives the error: cmd = New SqlCeCommand("INSERT INTO stock (name,price,desp) VALUES ('" & name & "', '" & newprice & "' ,'" & desp & "'')", connectionstring) all other parts of the code work fine, which is why i'm only posting this small bit. price in my database is defined as type money, and newprice is of type SqlMoney too. Can someone help? thanks!

Hi all, i'm trying to create a new database in CE but it doesnt seem to work for some reason........can someone help? thanks!! Imports System.Data.SqlServerCe Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'create DB Dim engine As New SqlServerCe.SqlCeEngine("Data Source = \My Documents\test.sdf") engine.CreateDatabase() 'error here 'connect to DB Dim ssceconn As New SqlServerCe.SqlCeConnection("Data Source = \My Documents\test.sdf") ssceconn.Open() 'ceate table Dim sqlCreateTable As SqlServerCe.SqlCeCommand = ssceconn.CreateCommand() sqlCreateTable.CommandText = _ "CREATE TABLE People(people_id int IDENTITY(0,1) PRIMARY KEY, f_name ntext, l_name ntext)" sqlCreateTable.ExecuteNonQuery() 'inserting rows Dim sqlInsertRow As SqlServerCe.SqlCeCommand = ssceconn.CreateCommand() sqlInsertRow.CommandText = "INSERT INTO People(f_name, l_name) VALUES('John', 'Doe')" sqlInsertRow.ExecuteNonQuery() 'close connection ssceconn.Close() End Sub An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll Additional information: SqlCeException SQL Server CE encountered problems in creating the SQL Server CE database [,,,Connection String,,]

hmm ok. i'll try my luck in the Mobile forum. thanks for the reply anyway.

Hi all, i'm trying to create a new database in CE but it doesnt seem to work for some reason........can someone help? thanks!! Imports System.Data.SqlServerCe Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click 'create DB Dim engine As New SqlServerCe.SqlCeEngine("Data Source = \My Documents\test.sdf") engine.CreateDatabase() 'error here 'connect to DB Dim ssceconn As New SqlServerCe.SqlCeConnection("Data Source = \My Documents\test.sdf") ssceconn.Open() 'ceate table Dim sqlCreateTable As SqlServerCe.SqlCeCommand = ssceconn.CreateCommand() sqlCreateTable.CommandText = _ "CREATE TABLE People(people_id int IDENTITY(0,1) PRIMARY KEY, f_name ntext, l_name ntext)" sqlCreateTable.ExecuteNonQuery() 'inserting rows Dim sqlInsertRow As SqlServerCe.SqlCeCommand = ssceconn.CreateCommand() sqlInsertRow.CommandText = "INSERT INTO People(f_name, l_name) VALUES('John', 'Doe')" sqlInsertRow.ExecuteNonQuery() 'close connection ssceconn.Close() End Sub An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll Additional information: SqlCeException