.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
ASPEvil
david stephan
Santhakumar Munuswamy
Fauzul Azmi
Post New Web Links

Interbase and ASP.NET 3.5

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :ASP.Net
 

Hi all, this is my first post in here.

Here is the situation:

I have a function for get some records from a Interbase 6 database.

Dim comando As New OdbcCommand("SELECT FAMILY_ATR.FAMILY_CODE || ' | ' || FAMILY_ATR.DESCRIPTION AS FAMILIA FROM FAMILY_ATR WHERE FAMILY_ATR.DESCRIPTION LIKE '%?%' ", con)
comando.Parameters.AddWithValue("FAMILY_ATR.DESCRIPTION", prefixText)

My problem its in the LIKE statement, i don't know how set the paramter to the prefixText variable.

:D

 




View Complete Post


More Related Resource Links

Import of Interbase to SQL Server

  

Hi all,

 

Hoping that someone can offer an easy solution to this but I am sure that is not going to be the case, I have been given an Interbase database which they would like to import the contents in to SQL Server 2008, I was hoping that under 2008 SSIS there might have been some way of setting this up as a data source and importing it that way, something similar to a access database file or excel file.  It seems that I am going to have to install some software to host the database and then do the import from there, sure there must be an easier way as at the end of all this they want to connect something to the main interbase database and pull everything across so I am reluctant to have to doing 2 different things to test all this, any suggestions?

 

Thanks P


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend