VB.NET Programming Corner!

[jyxae19]

hmmmn...
check mo nga baka reserved word yung 'character'
try mo palitan ng field name.
ganyan nangyari sakin dati, isang araw ko inaayos, reserved word pala

si @maskio ang expert pagdating sa mySQL, wait natin sagot nya

GALING. nyo po talaga sir eric.



Maraming Salamat po. hehe. sa uulitin.

 

[ericgmejia]

GALING. nyo po talaga sir eric.



Maraming Salamat po. hehe. sa uulitin.

chamba or logical process of elimination

btw ok yung pagkakatanong mo, malinaw, meron error message at nakapoint na agad sa offending line of code
ibig sabihin na analyze mo na yung problem bago ka nag post


sana ganun din magtanong yung iba

 

[jyxae19]

chamba or logical process of elimination

btw ok yung pagkakatanong mo, malinaw, meron error message at nakapoint na agad sa offending line of code
ibig sabihin na analyze mo na yung problem bago ka nag post


sana ganun din magtanong yung iba

na overwhelmed naman aku dun sir. kasi naman po, ako na nga lang ang ma memerwisyu..gagalingan ko nalang po ang pagtatanung. HEHE.

salamat nga po pala sa pagtulung sakin last week..hehe. tagumpay ang first defense ko. haha. Salamat po talaga sir eric.

 

[maskio]

@jyxae19

tama yung kay ts eric, character is a reserved word, you could write it like this `character`, para di ka mag error kung yung ginamit mo ay reserved word.

 

[ericgmejia]

na overwhelmed naman aku dun sir. kasi naman po, ako na nga lang ang ma memerwisyu..gagalingan ko nalang po ang pagtatanung. HEHE.

salamat nga po pala sa pagtulung sakin last week..hehe. tagumpay ang first defense ko. haha. Salamat po talaga sir eric.

good to know kung ganun...
pero tama na ang drama, marami ka pa i code

 

[jyxae19]

@jyxae19

tama yung kay ts eric, character is a reserved word, you could write it like this `character`, para di ka mag error kung yung ginamit mo ay reserved word.

sige po sir maskio. salamat po. tatandaan ko pu yan.

 

[rockmode]

you can also use this [character]

 

[BBCAtomic]

[HELP] Patulong po mga VB.net Experts.!

Patulong naman po about sa Problem nato. pag run ko yan ang

lumalabas.! ok naman po codes ko wala namang error

ETO PO CODES KO.!

Imports System.Data.SqlClient
Imports System.Web.UI.HTMLControls

Partial Class _Default
    Inherits System.Web.UI.Page
    Private Sub Page_Load( _
    ByVal sender As System.Object, _
    ByVal e As System.EventArgs) _
    Handles MyBase.Load

        Dim cnn As New SqlConnection("Data Source=(local);" _
          & " Initial Catalog=Northwind;User ID=Admin;Password=")

        Dim cmd As SqlCommand
        Dim rdr As SqlDataReader

        Dim row As HtmlTableRow
        Dim cell As HtmlTableCell

        row = New HtmlTableRow()

        cell = New HtmlTableCell("th")
        cell.InnerText = "Country"
        row.Cells.Add(cell)

        cell = New HtmlTableCell("th")
        cell.InnerText = "Contact Name"
        row.Cells.Add(cell)

        Customers1.Rows.Add(row)

        'Now add the data
        cmd = New SqlCommand( _
          "SELECT Country, ContactName FROM Customers" _
          & " ORDER BY Country", cnn)

        cnn.Open()

        rdr = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)

        Do While rdr.Read
            row = New HtmlTableRow()

            cell = New HtmlTableCell()
            cell.InnerText = rdr("Country").ToString
            row.Cells.Add(cell)

            cell = New HtmlTableCell()
            cell.InnerText = rdr("ContactName").ToString
            row.Cells.Add(cell)

            Customers1.Rows.Add(row)
        Loop
        rdr.Close()
    End Sub

End Class

 

[ericgmejia]

Re: [HELP] Patulong po mga VB.net Experts.!

Patulong naman po about sa Problem nato. pag run ko yan ang

lumalabas.! ok naman po codes ko wala namang error

http://www.symbianize.com/attachment.php?attachmentid=723920&stc=1&d=1362906201

ETO PO CODES KO.!

Imports System.Data.SqlClient
Imports System.Web.UI.HTMLControls

Partial Class _Default
    Inherits System.Web.UI.Page
    Private Sub Page_Load( _
    ByVal sender As System.Object, _
    ByVal e As System.EventArgs) _
    Handles MyBase.Load

        Dim cnn As New SqlConnection("Data Source=(local);" _
          & " Initial Catalog=Northwind;User ID=Admin;Password=")

        Dim cmd As SqlCommand
        Dim rdr As SqlDataReader

        Dim row As HtmlTableRow
        Dim cell As HtmlTableCell

        row = New HtmlTableRow()

        cell = New HtmlTableCell("th")
        cell.InnerText = "Country"
        row.Cells.Add(cell)

        cell = New HtmlTableCell("th")
        cell.InnerText = "Contact Name"
        row.Cells.Add(cell)

        Customers1.Rows.Add(row)

        'Now add the data
        cmd = New SqlCommand( _
          "SELECT Country, ContactName FROM Customers" _
          & " ORDER BY Country", cnn)

        cnn.Open()

        rdr = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)

        Do While rdr.Read
            row = New HtmlTableRow()

            cell = New HtmlTableCell()
            cell.InnerText = rdr("Country").ToString
            row.Cells.Add(cell)

            cell = New HtmlTableCell()
            cell.InnerText = rdr("ContactName").ToString
            row.Cells.Add(cell)

            Customers1.Rows.Add(row)
        Loop
        rdr.Close()
    End Sub

End Class

meron ba problem sa error message at ini-ignore parati?

sa kaso mo malinaw na sinasabi na di maka connect sa sql server

a good programmer will ask himself
1. sure ba ako na naka UP ang server?, goto 2 to verify
2. tama kaya ang connection string ko? pano ko maverify? try ko kaya mag connect ng ibang app para ma verify

listen to the error message, di naman yan manloloko

 

[ungastzki]

sir/mam suggestion syntax please bwt my thesis Laundry Management (Machine in particular)

Problem: Que of Machines for jobs

Scenario: Each machine has quota in my option form

1. 3 possible job output (white,light,dark)

Thus if quota is reached = New Job

2.Job is Inserted into Washing Machine


eto yung problem more than 3 yung machine kung onte pasok ng job at hindi nakastack yung machines ko puro kay washing 1 lang ibabato yung job

ang gusto ko mangyari is parang nakapila yung machines for the job para utilize lahat ng machine

help bwt syntax na pwdeng gamitin or suggestions! please! thanks in advance!

 

[maskio]

sir/mam suggestion syntax please bwt my thesis Laundry Management (Machine in particular)

Problem: Que of Machines for jobs

http://www.symbianize.com/attachment.php?attachmentid=723926&stc=1&d=1362907006

Scenario: Each machine has quota in my option form

1. 3 possible job output (white,light,dark)

Thus if quota is reached = New Job

2.Job is Inserted into Washing Machine


eto yung problem more than 3 yung machine kung onte pasok ng job at hindi nakastack yung machines ko puro kay washing 1 lang ibabato yung job

ang gusto ko mangyari is parang nakapila yung machines for the job para utilize lahat ng machine

help bwt syntax na pwdeng gamitin or suggestions! please! thanks in advance!

ilagay mo ang machines mo into a list of machines, each machine must have a status. if machine = onUse then next machine.
if gamit ang lahat ng machine then job = pending. resume pag na free na ang machine (update mo ang status ng machine na free)

that way, magkakaroon ka ng cycle on all machines.

 

[maskio]

Re: [HELP] Patulong po mga VB.net Experts.!

Patulong naman po about sa Problem nato. pag run ko yan ang

lumalabas.! ok naman po codes ko wala namang error

http://www.symbianize.com/attachment.php?attachmentid=723920&stc=1&d=1362906201

ETO PO CODES KO.!

Imports System.Data.SqlClient
Imports System.Web.UI.HTMLControls

Partial Class _Default
    Inherits System.Web.UI.Page
    Private Sub Page_Load( _
    ByVal sender As System.Object, _
    ByVal e As System.EventArgs) _
    Handles MyBase.Load

        Dim cnn As New SqlConnection("Data Source=(local);" _
          & " Initial Catalog=Northwind;User ID=Admin;Password=")

        Dim cmd As SqlCommand
        Dim rdr As SqlDataReader

        Dim row As HtmlTableRow
        Dim cell As HtmlTableCell

        row = New HtmlTableRow()

        cell = New HtmlTableCell("th")
        cell.InnerText = "Country"
        row.Cells.Add(cell)

        cell = New HtmlTableCell("th")
        cell.InnerText = "Contact Name"
        row.Cells.Add(cell)

        Customers1.Rows.Add(row)

        'Now add the data
        cmd = New SqlCommand( _
          "SELECT Country, ContactName FROM Customers" _
          & " ORDER BY Country", cnn)

        cnn.Open()

        rdr = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)

        Do While rdr.Read
            row = New HtmlTableRow()

            cell = New HtmlTableCell()
            cell.InnerText = rdr("Country").ToString
            row.Cells.Add(cell)

            cell = New HtmlTableCell()
            cell.InnerText = rdr("ContactName").ToString
            row.Cells.Add(cell)

            Customers1.Rows.Add(row)
        Loop
        rdr.Close()
    End Sub

End Class

yung error mo was on line 37: cnn.open() which means na sa pag connect ng program mo to the database, di nya mahanap ang database. tama si ts, you should check your connection string, or check your server. try using sql server studio management to connect to your server and verify if your connection string is correct or if your server is up and running.

 

[Gamecore]

ask ko lang po ito sa system .. medyo inayus ko po yung flow ng program ko

bale po may search form po ako ( iniisip ko lang po kung view lang ang function nun or may edit at insert function na rin yung search form ko para pag click ko lang dun sa name eh ,, mamimili na yung user kung insert or update sya)

or mag lagay ako ng seperate button sa insert grade , update student info , update student grade ?


bale po search form may insert student , update student button na ako dun bale dun na lang po sya mag nanavigate sa search form kung anu gagawin nya sa student na yun

or

seperate buttons

e.g

insert grade
update student info
update grade

kaso paano ko po mavavalidate na tama lalagyan kong student





pasensya na po sa explanation ko kung magulo pede ko po ulitin ,,ehhe salamat po talaga sa tutulong

 

[maskio]

ask ko lang po ito sa system .. medyo inayus ko po yung flow ng program ko

bale po may search form po ako ( iniisip ko lang po kung view lang ang function nun or may edit at insert function na rin yung search form ko para pag click ko lang dun sa name eh ,, mamimili na yung user kung insert or update sya)

or mag lagay ako ng seperate button sa insert grade , update student info , update student grade ?


bale po search form may insert student , update student button na ako dun bale dun na lang po sya mag nanavigate sa search form kung anu gagawin nya sa student na yun

or

seperate buttons

e.g

insert grade
update student info
update grade

kaso paano ko po mavavalidate na tama lalagyan kong student





pasensya na po sa explanation ko kung magulo pede ko po ulitin ,,ehhe salamat po talaga sa tutulong

validate it via studentId

 

[im with jesus]

pano pu yung adodb.command?

 

[ericgmejia]

pano pu yung adodb.command?

ADODB po ay ginagamit sa vb6
ADO.NET po dito sa .NET

dito may sample ng ADODB
http://www.symbianize.com/showthread.php?t=163979

 

[ericgmejia]

ask ko lang po ito sa system .. medyo inayus ko po yung flow ng program ko

bale po may search form po ako ( iniisip ko lang po kung view lang ang function nun or may edit at insert function na rin yung search form ko para pag click ko lang dun sa name eh ,, mamimili na yung user kung insert or update sya)

or mag lagay ako ng seperate button sa insert grade , update student info , update student grade ?


bale po search form may insert student , update student button na ako dun bale dun na lang po sya mag nanavigate sa search form kung anu gagawin nya sa student na yun

or

seperate buttons

e.g

insert grade
update student info
update grade

kaso paano ko po mavavalidate na tama lalagyan kong student





pasensya na po sa explanation ko kung magulo pede ko po ulitin ,,ehhe salamat po talaga sa tutulong

hmmn medyo magulo nga

i kwento ko nalang kung ano ang pattern na ginagawa ko sa desktop

or better yet, eto ang sample, run mo nalang
notice yung steps sa products master

https://dl.dropbox.com/u/15897480/VB.NET/POS.rar

 

[im with jesus]

ADODB po ay ginagamit sa vb6
ADO.NET po dito sa .NET

dito may sample ng ADODB
http://www.symbianize.com/showthread.php?t=163979

pano po yung code ng addnew using sql n adodb.command? nid lang po tom. tnx po.

 

[ericgmejia]

pano po yung code ng addnew using sql n adodb.command? nid lang po tom. tnx po.

INSERT INTO TABLE1(FIeld1, Field2) VALUES(Value1, Value2)

i run mo yan sa Command object

may google din po para sa karagdagang kaalaman

or yung sample dito
http://www.symbianize.com/showthread.php?t=163979

vb6 yan

 

[im with jesus]

pa help po. please.