Jump to content

Recommended Posts

  • 2 weeks later...
Guest djunya2006

Good morning, sorry in advance kung OT ako, gusto ko lang malaman kung pwede akong makahiram nang full version nang Windows XP. My current OS is Vista which unfortunately will not run the information that I need. Kindly assist me please.

Link to comment
  • 1 month later...

mga bro, sino nka gamit dto ng MS ACCESS (as Fornt end) MySQL (back end database)

ano mga pros and cons dto?

sa napansin ko ung image dko ma retrieve sa MS ACCESS as front end...

tnx

 

i wrote a software in visual basic 6 using ms access as database. it was not very reliable. sometimes records were deleted without apparent reason.

Link to comment
  • 2 months later...

good morning expert...

hope you can help me with this one...

 

what this code do is that it runs a query base on the variable entered by user...

and from the query result, one of the col must have a urlencode(link) to another .php

 

the problem is, instead that the result of the query will be displayed with link eh ang lumalabas is the assign variable with link..

 

can any one help me?

 

---------------------code----------------------------

<?php

$connect = mysql_connect("localhost","root","") or die ("Couldn't connect");

mysql_select_db("xdb") or die ("Couldnt find db");

 

if (isset($_GET['first']) || ($_GET['last']))

{

$first = $_GET['first'];

$last = $_GET['last'];

$query = @mysql_query("Select * FROM masterlist WHERE last LIKE '$last' && first LIKE '$first%' order by first asc");

 

while($row = mysql_fetch_assoc($query))

{

$valid = $row['archive_desc'];

$hhid = $row['hh_id'];

$por = $row['Poor'];

$fn = $row['first'];

$ln = $row['last'];

$mn = $row['mid'];

$ext = $row['ext'];

$bday = $row['birthday'];

$rel = $row['relationship'];

$city = $row['city_name'];

$brgy = $row['brgy_name'];

$datin = $row['Date Interview'];

$prov = $row['prov_name'];

$respo = $row['Respondent'];

 

echo '<tr><td><a href = "family_comp.php?hhid = ' . urlencode($row['hh_id']) . '"/a>$hhid</td><td>$valid</td></tr>';

 

?>

----------------------end of code------------------

Link to comment

mga bro, sino nka gamit dto ng MS ACCESS (as Fornt end) MySQL (back end database)

ano mga pros and cons dto?

sa napansin ko ung image dko ma retrieve sa MS ACCESS as front end...

tnx

 

Any reason why you want to use Access as the front end? I think you'd be much better off with your own PHP-based web app for that.

Link to comment
  • 2 weeks later...

mga bro, sino nka gamit dto ng MS ACCESS (as Fornt end) MySQL (back end database)

ano mga pros and cons dto?

sa napansin ko ung image dko ma retrieve sa MS ACCESS as front end...

tnx

 

I was just wondering kung bakit MySQL ang pinili mo for back end database. I am using MySQL for web-based database programs written in PHP but requires installation of PHP and other server software.

 

Kung single desktop user lang naman, have you tried using MSDE 2000 or yung Microsoft SQL Express as your backend.

Link to comment
  • 3 weeks later...

I like VB. I hate VB.NET

 

Im a solid MSACCESS/VB programmer before. Didnt even know codes puro macros gamit ko. I saw the VB codes generated by those Macros and I knew VB was good and easy to use.

 

Then I ventured into .NET due to job requirements. .NET in general has more tools and control over the data, where you have to create those datasets dynamically in VB, you can use datasets from ADO objects in .NET.

 

I guess brod you just need to see some sample codes on how VB code can be converted to .NET, im sure youll love .NET na.

 

isipin mo 200 lines ng VB code to run database code, kaya nang .NET sa 10 lines.

Link to comment
  • 1 month later...
  • 2 weeks later...

Mga Masters,

 

Pwede nyo ba ako tulungan i-convert itong code from VB6 to VB.NET (2010 Express)? I developed kasi a program for private schools at gusto ko i-upgrade ang code to .Net pero I am having problem sa coding ng ADO to ADO.net

 

Here is the code I use:

 

Public Conn As New ADODB.Connection

Public Rs As ADODB.Recordset

Public Fld As ADODB.Field

Public ConnString

Dim Arr_Enrollees()

Dim Ctr

 

 

Private Sub Form_Load()

ConnString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=littleangel_db;UID=pss;PWD=pss;OPTION=3;"

Set Conn = New ADODB.Connection

Conn.ConnectionString = ConnString

Conn.Open

Set Rs = New ADODB.Recordset

Rs.CursorLocation = adUseServer

 

with Rs

Ctr=0

.open "select count(*) from file_enrollees", Conn

redim Arr_Enrollees(.fields("count(*)"), 2)

.close

.open "select * from file_enrollees", Conn

if not .eof then

.movefirst

Ctr=0

do while not .eof

Arr_Enrollees(Ctr, 0) = .fields("enrollees_fname")

Arr_Enrollees(Ctr, 1) = .fields("enrollees_lname")

.movenext

Ctr= Ctr + 1

loop

end if

.close

 

.open "select * from file_enrollees", Conn, adOpenStatic, adLockOptimistic

.addnew

!enrollees_fname = "Juan"

!enrollees_lname = "Calintong"

.update

.close

end with

End Sub

 

 

Sana merong makatulong maka-explain ng simple kung paano ma-convert itong example to VB.Net / ADO.Net

 

Thanks in advance

 

BTW. MySQL pala gamit ko

 

May pangconvert ang vb.net. No need to revised the codes. Pm me if you need help.

Link to comment

Dahil sa gumagamit ka ng ibang database (MySQL) kailangan mong idownload yung driver nya (Go to MySQL website for the free downloads)

Then major revision yan almost everything sa code mo.

 

 

imports System.Data.MySQLClient

 

public class SomeMethod

Dim conn as new MySQLConnection("connection string here")

Dim dt as new DataTable

Dim da as MySQLDataAdapter

 

conn.open

 

da = new sqlDataAdapter("SQL Synatx here")

da.fill(dt)

 

dim ctr as integer

For Each dr As DataRow in dt.Rows

Arr_Enrollees(ctr,0) = dr.item("Field_Name").toString()

Arr_Enrollees(ctr,1) = dr.item("Field_Name").toString()

Next

 

 

End Class

 

pag nagaadd ka naman kailangan mong gumamit ng sqlCommand tapos

SQL DML statements INSERT INTO Table

Yun lang

Link to comment

mga sir.. im a com sci graduate unfortunately was not able to venture into the programming world, now i wanna go back to being a programmer, ano maadvise nyong pagaralan or ireview kong programming language na in demand ngyon.. im thinking of at least 3-5 languages.. ano po massuggest nyo and if may mapprovide po kayong link kung san pwde makakuha ng e-book or tutorial videos..

 

pati na rin po pala kung san pwde makakuha ng installer..

 

maraming maraming salamat po, sorry if medyo madami akong hinihingi,...kahit alin lang po jan ang masagot nyo.. i'll appreciate it.. thanks..

Link to comment

mga sir.. im a com sci graduate unfortunately was not able to venture into the programming world, now i wanna go back to being a programmer, ano maadvise nyong pagaralan or ireview kong programming language na in demand ngyon.. im thinking of at least 3-5 languages.. ano po massuggest nyo and if may mapprovide po kayong link kung san pwde makakuha ng e-book or tutorial videos..

 

pati na rin po pala kung san pwde makakuha ng installer..

 

maraming maraming salamat po, sorry if medyo madami akong hinihingi,...kahit alin lang po jan ang masagot nyo.. i'll appreciate it.. thanks..

 

 

I think it is best na balikan mo ung language na gamay ka then saka ka mag aral ng new language.

 

Sa mga languages naman, "in the philippines" eto ang mga in demand AFAIK.

 

1.) Mainframe (Cobol, ASPXXXX, RPG)

2.) Java

3.) Oracle

4.) SAP

5.) VB.NET

 

Ung "Game Programming" available narin satin. Ang alam ko sa subic ang office nila, C# and C++ ang common. Meron din demand sa iOS (IPAD, Iphone) platform.

 

For softwares and tutorials search ka na lng sa torrent.

 

Good luck sa pag balik mo sa gusto mong career. Di tulad ko na COE graduate na napunta sa programming. :(

Link to comment

I think it is best na balikan mo ung language na gamay ka then saka ka mag aral ng new language.

 

Sa mga languages naman, "in the philippines" eto ang mga in demand AFAIK.

 

1.) Mainframe (Cobol, ASPXXXX, RPG)

2.) Java

3.) Oracle

4.) SAP

5.) VB.NET

 

Ung "Game Programming" available narin satin. Ang alam ko sa subic ang office nila, C# and C++ ang common. Meron din demand sa iOS (IPAD, Iphone) platform.

 

For softwares and tutorials search ka na lng sa torrent.

 

Good luck sa pag balik mo sa gusto mong career. Di tulad ko na COE graduate na napunta sa programming. :(

 

Thanks ng madami.. nagapply kasi ako dati sa Accenture as Software Engineer after grad eh atat ako magkatrabaho agad, at hindi na nahintay ang Accenture, napunta tuloy ako sa CallCenter, although IT Field pa din nman ang hawak ko, medyo nagssawa nako.. so try ko bumalik.. hehehe..

 

As for the PL that im used to, gamay ko ang Visual Basic 6.. so i think ill start off with VB.net..

 

thanks again.. :)

Link to comment
  • 2 weeks later...

Thanks ng madami.. nagapply kasi ako dati sa Accenture as Software Engineer after grad eh atat ako magkatrabaho agad, at hindi na nahintay ang Accenture, napunta tuloy ako sa CallCenter, although IT Field pa din nman ang hawak ko, medyo nagssawa nako.. so try ko bumalik.. hehehe..

 

As for the PL that im used to, gamay ko ang Visual Basic 6.. so i think ill start off with VB.net..

 

thanks again.. :)

 

Sana hinintay mo na lng ung sa Accenture. Para sakin "SAYANG".

Link to comment
  • 1 year later...

Hi guys, I'm looking for a programmer who can create an off-line database for me. The idea is, I need a program (installable to any pc) to do quizes or exams for our sales team in the field. There will be databank of questions and then randomly, 20 questions will pop-up (by 1's) in a window. The sales person will now take the exam (multiple choice or essay) in a time pressured manner. Each question will be shown for two minutes only then will go to another question in the same window. All data like scores and where the sales person got the wrong answer will now be synched to an admin (back-end in the office). I can explain the full details of the requirement in person or via cellphone. Should anyone be interested, please call me at 0917-5073692. This is Jon. Thanks.

Link to comment
  • 2 months later...

Hi guys, I'm looking for a programmer who can create an off-line database for me. The idea is, I need a program (installable to any pc) to do quizes or exams for our sales team in the field. There will be databank of questions and then randomly, 20 questions will pop-up (by 1's) in a window. The sales person will now take the exam (multiple choice or essay) in a time pressured manner. Each question will be shown for two minutes only then will go to another question in the same window. All data like scores and where the sales person got the wrong answer will now be synched to an admin (back-end in the office). I can explain the full details of the requirement in person or via cellphone. Should anyone be interested, please call me at 0917-5073692. This is Jon. Thanks.

 

May I know your ETC for this? Saka ko na alamin details kung swak pa sa sched ko.

Link to comment
  • 3 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...