SQL Server Provider

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi,

I've downloaded the evaluation version of the calendar software and it looks like were close to purchasing a license for it.  The problem is that we do our development in VB.NET (2005) and SQL Server 2000. The VB.NET calendar sample does not show how to connect the calendar to SQL Server tables.

I've looked at the C# example that includes the SQL Server customer provider classes (providerSQLServer.cs and SQLDataHelper.cs). Is there some way I could get the custom SQL provider source code so that it would work for the VB.NET sample? Or is there someway to use that C# provider code in the VB.NET sample?

I'm admittedly new to using third-party components (and fairly new to VS.NET in general), so please bear with me if I tend to sound like a newbie. 

Thanks!

-Matt

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
hildegoat Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 30 November 2006 Status: Offline Points: 11	Post Options Post Reply Quote hildegoat Report Post Thanks(0) Quote Reply Topic: SQL Server Provider Posted: 30 November 2006 at 5:37pm
	Hi, I've downloaded the evaluation version of the calendar software and it looks like were close to purchasing a license for it. The problem is that we do our development in VB.NET (2005) and SQL Server 2000. The VB.NET calendar sample does not show how to connect the calendar to SQL Server tables. I've looked at the C# example that includes the SQL Server customer provider classes (providerSQLServer.cs and SQLDataHelper.cs). Is there some way I could get the custom SQL provider source code so that it would work for the VB.NET sample? Or is there someway to use that C# provider code in the VB.NET sample? I'm admittedly new to using third-party components (and fairly new to VS.NET in general), so please bear with me if I tend to sound like a newbie. Thanks! -Matt

sserge Members Profile Send Private Message Find Members Posts Add to Buddy List Moderator Group Joined: 01 December 2004 Status: Offline Points: 1297	Post Options Post Reply Quote sserge Report Post Thanks(0) Quote Reply Posted: 01 December 2006 at 5:02pm
	Hi Matt, Actually C# and VB.NET are so similar that you can simply convert both those classes using something like http://authors.aspalliance.com/aldotnet/examples/translate.aspx and use the converted code. For example, try adding it into a regular VB.NET sample... -- WBR, Serge

hildegoat Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 30 November 2006 Status: Offline Points: 11	Post Options Post Reply Quote hildegoat Report Post Thanks(0) Quote Reply Posted: 01 December 2006 at 5:34pm
	Thanks. I'll give that a try.

shady14u Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 07 May 2007 Location: United States Status: Offline Points: 5	Post Options Post Reply Quote shady14u Report Post Thanks(0) Quote Reply Posted: 09 May 2007 at 7:57pm
	Did you every get this resolved? I am trying to do the same thing... Any Assistance would be great.

hildegoat Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 30 November 2006 Status: Offline Points: 11	Post Options Post Reply Quote hildegoat Report Post Thanks(0) Quote Reply Posted: 15 May 2007 at 2:09pm
	I basically did what sserge suggested. I took the SQLServerProvider code from the C# sample, used an online converter to turn it into VB and put it in as a separate module in my VB.NET project.