Re: Create database table from a dataset which has no of data table - Visual Basic Discussion Boards

nitin_ion1-Oct-08 1:50

1-Oct-08 1:50

This can be done only if we have SQL express edition instaled. But if i am using mdf in the project like in VS 2005 then i need to connect to another mdf file on network

Change back color of selected dates in Month calender control in vb.net

~Khatri Mitesh~30-Sep-08 21:43

~Khatri Mitesh~

30-Sep-08 21:43

Hii
I want to change the back color of selected dated in month calender.
Like i have appointments on following dates 1-10-2008,5-10-2008,10-10-2008,15-10-2008
so i want to show these date back color is green.
How can i do this.
Please suggest.
Thanx
Mitesh Khatri

~Khatri Mitesh
khatrimitesh@hotmail.com
Bikaner (Rajasthan)
INDIA

Re: Change back color of selected dates in Month calender control in vb.net

HemJoshi1-Oct-08 1:18

HemJoshi

1-Oct-08 1:18

Hi Mitesh,
You can only show a range between to dates wiith different backcolor in the month calender control but you can not show for that different different dates(not in range).In range all the dates witll have same color.
Thnx

Create database table directly from a dataset which has many no. of data table [modified]

snehasish30-Sep-08 21:39

snehasish

30-Sep-08 21:39

hi,
my problem is that.....
Recently i get a complex xml.Which have huge no of data.When i read xml by dataset i get 6 realated tables.Each have 10 to 20 no of coloumn.so i want to directly move this data to sqlserver database.
please help me Frown | :(

modified on Wednesday, October 1, 2008 5:12 AM

Re: Create database table from a dataset which has no of data table

C1AllenS30-Sep-08 23:10

C1AllenS

30-Sep-08 23:10

Hello,

So you basically wants to move the XML data into the SQL server. If you are trying to do
this through code, then you can have a look at the given web link which should give you
some fair idea on how to achieve this.

http://www.dbazine.com/sql/sql-articles/cook2[^]

Hope this will help.

Regards,

Allen Smith

ComponentOne LLC
www.componentone.com

Re: Create database table from a dataset which has many no. of data table

snehasish1-Oct-08 0:57

snehasish

1-Oct-08 0:57

hi Allen,

Thanks for your suggestion.I think it will work if i create related table first. But i do not want to create table by myself.i want something dynamically to store it from dataset to database.

Hope you help me again.

Re: Create database table from a dataset which has many no. of data table

Paddy Boyd2-Oct-08 2:32

Paddy Boyd

2-Oct-08 2:32

You just need to issue a create table statement first, surely...

Re: Create database table from a dataset which has no of data table

rprateek1-Oct-08 14:09

rprateek

1-Oct-08 14:09

you can insert xml file directly to sql server.

for this you can see How to insert XML data in sql server database through visual basic .net

may be you have to work through it if you got big xml but it is very handy way of getting your xml data in database.

Blog for Programmers

Check printer connected status before print a job

Jy1130-Sep-08 19:10

Jy11

30-Sep-08 19:10

Hi, is that a way using VB6 to check printer status whether it connected or not connect to the printer device before print any job? Confused | :confused:

Please comment.
Thanks in advance.

Regards,
Jy

Keeping socket connections alive

Mariano Capezzani30-Sep-08 9:07

Mariano Capezzani

30-Sep-08 9:07

Hi all,

I have a server application awaiting incoming connections through a series of sockets set in "listen" mode. I have a number of client applications in remote locations that communicate via tcp/ip, opening the corresponding socket connection to the server and transmitting data.

The problem I have is that the client-to-server socket connections seem to die out after a while, specially in locations where internet is intermittent. When this happens, the connection does not terminate, rather it stays in "connected" state, but data transfer is lost in the web. Even though the winsock.state = sckConnected, the data is not received.

In order to solve this, I implemented a refresh timer, that closes and reopens all sockets in the server once every n seconds. It works, but it's terribly unelegant. I have found no other way of doing this, keeping the connections alive.

Anybody could please give me a suggestion on how this can be done properly? How can I determine if a connection is alive or dead, regardless of what .state says?

Thanks,
Regards.

Re: Keeping socket connections alive

rprateek1-Oct-08 14:13

rprateek

1-Oct-08 14:13

are you using win sock . I had the similar problem before using win sock where i lost data even the client was connected with the server.

But later i used dart sock and it helped me you can get the trial version of these from www.dart.com and try it out, hope this would help you.

Blog for Programmers

Re: Keeping socket connections alive

Mariano Capezzani1-Oct-08 16:12

Mariano Capezzani

1-Oct-08 16:12

Yes, I use winsock. Thanks for the tip!!, but I think I might have solved temporally in a rather clumsy way.

I set up each client to "ping" the server every second. The server "pongs" to each "ping". I there is no "pong", the connection is down and a reconnect is issued. This check is performed at both sides.

Unelegant, but it works, and it´s free...

Has anybody implemented a different type of "keep alive" mecanism?

Regards,

DataAdaptor Update Error

kermit88830-Sep-08 8:54

kermit888

30-Sep-08 8:54

I am getting ORA-01036 (Illegal Variable Name/Number) when I call the oracledataadaptor.update method.

I am able to fill the dataset & bind to the datagridview. When I try to update Oracle with the dataadaptor,
I get the Illegal Variable name exception.

Any ideas?

Thanks in advance!

' '' ''' '''' Call the update method

Try
daCustomers.Update(ds.Tables("Customers"))
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try

' '' ''' '''' Set up Oracle Update Command
Private Sub SetCommands()

Dim uCMD As New OracleCommand
uCMD.Connection = cnOra
uCMD.CommandType = CommandType.Text
uCMD.Parameters.Add("@inFNAME", OracleType.Char, 30, "FNAME")
uCMD.Parameters.Add("@inID", OracleType.Int32, 12, "ID")

uCMD.CommandText = "Update NYOUG_CUSTOMERS SET FNAME = @inFNAME WHERE ID = @inID"
daCustomers.UpdateCommand = uCMD
End Sub

Re: DataAdaptor Update Error

Wendelius30-Sep-08 9:36

Wendelius

30-Sep-08 9:36

The syntax of bind variables depends on the connection type you use. Try using : instead of @. For example:

kermit888 wrote:
uCMD.CommandText = "Update NYOUG_CUSTOMERS SET FNAME = @inFNAME WHERE ID = @inID"

uCMD.CommandText = "Update NYOUG_CUSTOMERS SET FNAME = :inFNAME WHERE ID = :inID"

The need to optimize rises from a bad design

Re: DataAdaptor Update Error

kermit88830-Sep-08 9:40

kermit888

30-Sep-08 9:40

I tried switching the "@" with ":" but got the same result.

Re: DataAdaptor Update Error

Wendelius30-Sep-08 9:48

Wendelius

30-Sep-08 9:48

Did you also replace it in parameters. You could also try without semicolon and perhaps with less info to the constructor. Meaning, try both variations:

uCMD.Parameters.Add(":inFNAME", OracleType.Char, 30)
uCMD.Parameters.Add(":inID", OracleType.Int32)

and

uCMD.Parameters.Add("inFNAME", OracleType.Char, 30)
uCMD.Parameters.Add("inID", OracleType.Int32)

The need to optimize rises from a bad design

Problems with Flash content viewing in Web Browser Control

Falcon12330-Sep-08 3:15

Falcon123

30-Sep-08 3:15

I'm having problems using the Web Browser control in Vista. When I go to a page with any type of Flash Content it won't load. I went to the Flash plugin page and it said 64bit web browsers are not supported. This only happens on the Web Browser Control that I am programming with. If I just open the Microsoft Internet Explorer 7 it works just fine and has no problem loading Flash content. If I can't display Flash content it's a big problem so if anybody can point me in the right direction it would surely make my day.

Thanks In Advance

PS I have tried both the com version and the one that comes with VB.Net
both will not display Flash Content

I am using Vb.Net 2008 Express
Operating System Vista Home Premium Service Pack 1

Ken

Need Crystal x64 msm

Anoop Brijmohun30-Sep-08 2:32

Anoop Brijmohun

30-Sep-08 2:32

Hi Guys...
i am using vs2005 to develeop my apps.

i need to install a simple application that uses crystal reporting on a windows server 2008 environment.

the error i am getting is that when i call up my report it reports back an error stating that i dont have the right CRRedist*.msm installed......

i have included in my mergemodules the Crystal Redistributable 2005_x86.msm.....

does anyone have an idea where i can get the 64 bit msm file from as i searched google and business objects but cant find it....

thanks in advance

Anoop Brijmohun

User Authentication on the server

kmathebula30-Sep-08 2:07

kmathebula

30-Sep-08 2:07

Hi
Am a newbie on VB.NET...Please i would like to know how would i authenticate users on the web application using their domain name and username (eg. FVCJBN01\F2999999) and also get their roles here is how my User table looks
USER_EMPL_NO F2999999
USER_LOGIN FVCJBN01\F2999999
USER_NAME Lisa Lopes
USER_CO_CODE 80
USER_BRN_CDE 189
USER_EMAIL lopes@test.co.za
USER_TYPE AdminOnly
HEAD_OFFICE_FLAG 0
USER_ACTIVE_FLAG 1

the application should pick up the user from their machines where they have logged on with their user authentication and check it against the database

dial phone no or send sms th mobile modem

Vikash Yadav30-Sep-08 0:23

Vikash Yadav

30-Sep-08 0:23

Hi,
I am writing a programe for project report. i need code in vb.net 2005 for send SMS or dial phone no th Atteched mobile Mobile on PC.

How it will Possible.

PLZ Help me.

Thanks & Regards

Form :-
Vikash Yadav

Re: dial phone no or send sms th mobile modem

ChandraRam30-Sep-08 1:26

ChandraRam

30-Sep-08 1:26

What have you tried so far? Searched on Google?

Re: dial phone no or send sms th mobile modem

Rajesh Anuhya30-Sep-08 1:42

Rajesh Anuhya

30-Sep-08 1:42

first detect the communication port which u r connected mobile to the pc.

open the communication port.
and send commands.

to send SMS:- at+cmgs="+919000234140"<vbcrlf>
>hi <ctrl+z>
to dial number :- atdt+91900234140;<vbcrlf>

** note : the above commands are not suitable for all mobile manufactures.
there may be a change in the command, so search the AT commands list in internet(recommended GOOGLE).

Rajesh B --> A Poor Workman Blames His Tools <--

Problems with MS Sync Framework in VB.NET

IgorKuchaev29-Sep-08 22:04

IgorKuchaev

29-Sep-08 22:04

Hello to everyone.
I have the problem with my experimental, tutorial project (made in VB.NET) of syncing Microsoft SQL Server Standard Database (it is server) and MS SQL Compact DB (it is client). The synchronizer is based on MS Sync Framework (MSF) API classes.
The problem happens with SyncAgent Class. I created the class mySyncAgent which inherits the SyncAgent class. In the mySyncAgent I just gave settings for Local and Remote Providers (connection strings, sync type, direction etc - everything like it was described in MSDN tutorial example).
Now I try to make synchronization by using the method: statistics = myAgent.Synchronize where statistics is the instance of SyncStatistics class, and myAgent is the instance of SyncAgent class.
When I do it, the program stops to run and VB.NET compiler shows me the following error>: Method not found: 'Microsoft.Synchronization.Data.SyncException Microsoft.Synchronization.Data.SyncExpt.AnotherSyncInProgressError(System.String, System.String)'.

It is very strange error and I don't understand what causes it. First, there is no synchronization.data.syncexception library - it exists in another, older version of that class - but I can say for 100% sure that there is no conflict of versions generally in this project - so this is not a cause, not a reason. Anyway, the problem is not because of the missing method (there is a new one, in a new version), but the fact that Another Sync is in Progress. But I didn't call synchronization anywhere else except this method "statistics = myAgent.Synchronize" (I checked if there are other callings of .synchronize - there are no calls; neither in constructors nor anywhere else). I was doing debugging with tracing of variables, parameters of objects. This is the content of this variables at the run-time error.
myAgent:
*RemoteProvider: Everything is OK (like I set) - i.e. Connection Strings, SyncAdapters etc
*LocalProvider: Here is the most interesting stuff that (maybe) calls this error. There is subproperty "ClientID" which contains 2 properties called "Message" with the same content:
"Method not found: 'Microsoft.Synchronization.Data.SyncException Microsoft.Synchronization.Data.SyncExpt.AnotherSyncInProgressError(System.String, System.String)".

And property StackTrace of ClientID contains " at Microsoft.Synchronization.Data.SqlServerCe.SqlCeClientSyncProvider.BeginTransaction(SyncSession syncSession)
at Microsoft.Synchronization.Data.SqlServerCe.SqlCeClientSyncProvider.get_ClientId()"

What could be the cause of this problem? Could it happen because the connection to localProvider (based on MSSQL Compact 2005) is not open (by some reason)?
If anyone could just tell me where the possible mistake could be???

Thank You

Igor

Searching Inside the .zip

Amit Kushwaha29-Sep-08 21:19

Amit Kushwaha

29-Sep-08 21:19

Hello All,

How can I search for a particular file inside the .zip file?

Thanks in advance

Amit

Re: Searching Inside the .zip

jzonthemtn30-Sep-08 1:39

jzonthemtn

30-Sep-08 1:39

Check out the System.IO.Packaging namespace (.net 3.0 or 3.5). It allows you to create zip files so I'm guessing if there is a way it will let you do it.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.