Find Jobs
Hire Freelancers

Generic module: Populate combo box or list box with database items.

$30-250 USD

En curso
Publicado hace casi 8 años

$30-250 USD

Pagado a la entrega
Generic module: Populate combo box or list box with database items. Convert vb 6 function to VB 2010-2013. This is a function that I can call to populate a forms combo box, or list box with the Database items. I am looking for a coder to help me move from VB6 to vb.net 2010. I am retired, and am on a budget so a price consideration will be greatly appriciated. I would like to get this done for under $50.00 if I can, and ASAP An access database ([login to view URL]) with text items is attached. I have a lot of future work for the right coder. Providing me with an example exe in VB 2010 is a must to be considered for the job. Here is Function I need (called from any form) I place this in the form load event to fill all the combo boxes on the form It must reside in an external module to drop into any program's form. FillCombos Me, lstEmployees, "Select Distinct NCO FROM employerFunds", "NCO", "ALL" FillCombos = Name of function Me is the form that is loaded lstEmployees = Table Name NCO is field returned "ALL" is a default First item in Combo box (Listindex = 0) if added(Optional) --------------------------- vb6 version: Public Sub FillCombos(F As Form, ControlName As Control, TableNameorSQL As String, FieldDescriptor As String, Optional AddText As String) Do not use Jet, but ODBC. Here is code in vb 2010 form that works, but must be added to each form & for each combo box. (Load Combo box with the Last Name of "Smith" from the Members Table. Dim LastName$ LastName$ = "Smith" Dim dbSource$ dbSource$ = [login to view URL] & "\Members..mdb" Dim TableNameorSQL$ TableNameorSQL$ = "Select * From Employees WHERE [Last Name] = '" & LastName$ & "'" Dim strConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbSource$ Dim objConnection As New OleDbConnection(strConnection) 'Open the connection with error handling Try [login to view URL]() Catch OleDbExceptionErr As OleDbException [login to view URL]([login to view URL]) Catch InvalidOperationErr As InvalidOperationException [login to view URL]([login to view URL]) End Try 'Create a command object with the SQL statement needed to select the first and last names Dim strSQL As String = TableNameorSQL$ Dim objCommand As New OleDbCommand(strSQL, objConnection) 'Create a data adapter and data table then fill the data table Dim objDataAdapter As New OleDbDataAdapter(objCommand) Dim objDataTable As New DataTable(TableName$) [login to view URL](objDataTable) 'Create connection and release resources [login to view URL]() [login to view URL]() objConnection = Nothing [login to view URL]() objCommand = Nothing [login to view URL]() objDataAdapter = Nothing 'Fill names into the listbox For Each row As DataRow In [login to view URL] [login to view URL]([login to view URL](LastName$)) Next 'Release resources [login to view URL]() objDataTable = Nothing
ID del proyecto: 10969833

Información sobre el proyecto

11 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
11 freelancers están ofertando un promedio de $48 USD por este trabajo
Avatar del usuario
I am VB, VB.NET, MVC, XML & MS SQL programmer. I have experience about 10 years in programming complex database application as well as Windows Desktop and Server/Client application. I have read your codes carefully and hope understood... I have experience on converting functions from vb5/vb6 to vb2010 to vb2015. Because I have my own application Stock Exchange Back Office ("SPARKtech Soft Interface" see on my portfolio) written on vb5 and using since 2005. I have created lot of .net object by converting those vb5 modules and class and used back to the vb5 application as well as new features that supports only .net not vb5/vb6...(e.g sending emails via .net and many more) It is not clear that you want to use ODBC or OLEDB (Microsoft.Jet.OLEDB.4.0) Following code usages Ms Jet 4.0 and it is not connects Database on ODBC [Dim strConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbSource$] To add context in all Combos exists on specific Form Object, dynamic run time coding is required to fill all Combos with data returned by the database query. you will get yearly service and support as well as update of this software to avail new version from me. I am professional to provide corporate custom complex software which is not available in the recent market. So you may turn your desired application dream in real. Long term support.
$30 USD en 1 día
5,0 (11 comentarios)
5,6
5,6
Avatar del usuario
Hello, I know well what you're asking for, as I'm right now making a VB>VB.NET conversion myself. Actually it's older VB4/5 code using DAO to transact with Access-97. Open chat to me, I'll send you a .NET exe that loads up a combo with Mr & Mrs Smith from that table ;-) so that you call it from a form of yours. Looking forward to your contact, Grunty.
$50 USD en 3 días
4,7 (29 comentarios)
5,3
5,3
Avatar del usuario
hi im an expert in .net and sql i have been working in software development for the last 2o years .N et is very different to vb6. the way to link the data to the controls is very different also de disposition of the objects a generic class to do this is the better way regards carlos
$88 USD en 1 día
4,8 (15 comentarios)
4,7
4,7
Avatar del usuario
I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
$35 USD en 1 día
4,9 (21 comentarios)
4,3
4,3
Avatar del usuario
I have more than 8 years of experience in Asp.net, C#, VB.Net and Sql server. I have good proficiency over MVC, MVVM, Web Service, Windows Service, Web API, Jquery, JSON, Ajax, Java Script, HTML, CSS3, Boot Strap,WPF, Xamarin (Android & IOS), Entity, VB 6.0. Reports : RDLC, Crystal Report and SSRS. Knowledge in using Github, TFS and Tortoise SVN We are very much interested in working in this job. Please call us for the interview, we are ready to start working with you.
$40 USD en 2 días
5,0 (5 comentarios)
3,5
3,5
Avatar del usuario
Hi, if you will use data binding to the data table you will not need to do the loop. Regards, Yair
$50 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Bensalem, United States
4,9
65
Forma de pago verificada
Miembro desde ene 7, 2005

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.