VB.NET Programming Corner!

[bobitoz]

Sir halos binigay ko na buong file nyan sa post ko. hehe! mabagal kasi ang mediafire ngayon kaya d ko mai-upload yung mismong solution file.
follow the steps na binigay ko sir wala kang magiging problema. 100% running yan kasi tinest ko ulit yan kahapon bago ko gawan ng tutorial.

Bgyan mo nmn aq ng tutorial sir on how to connect data base using access khit image lng and then me search button, add, delete ,

 

[rocketpuncher]

hello po ask ko lang po kung pano yung coding sa
pag first run ko po ng form ko is read nya yung database na connected sa program which is mysql
then kailangan daw po pag walang laman yung database first execute nya yung sign up else log in form naman po
sabi po ng sir ko we need to use record count but hindi ko po alam pano yun gamitin
tnaks po

 

[knives645]

hello po ask ko lang po kung pano yung coding sa
pag first run ko po ng form ko is read nya yung database na connected sa program which is mysql
then kailangan daw po pag walang laman yung database first execute nya yung sign up else log in form naman po
sabi po ng sir ko we need to use record count but hindi ko po alam pano yun gamitin
tnaks po

Post your code, ayusin natin.

 

[bobitoz]

Tutorial nmn dyan sa add. Delete. Search using database access

 

[rocketpuncher]

Post your code, ayusin natin.

Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
connectDB()
connectUser("Select * from tbluser")
daUser.Fill(dsUser, rsUser, "tbluser")
dtuser.DataSource = dsUser.Tables("tbluser").DefaultView

If rsUser.RecordCount = 0 Then
frmSignup.ShowDialog()
Else
frmLogin.ShowDialog()
End If

i have 3 forms po frmsign up frmlogin and frmMain

yung kailangan po is pag run ng app if wala pang laman ang database inang mag boboot ang sign up form else log in

 

[bobitoz]

Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
connectDB()
connectUser("Select * from tbluser")
daUser.Fill(dsUser, rsUser, "tbluser")
dtuser.DataSource = dsUser.Tables("tbluser").DefaultView

If rsUser.RecordCount = 0 Then
frmSignup.ShowDialog()
Else
frmLogin.ShowDialog()
End If

i have 3 forms po frmsign up frmlogin and frmMain

yung kailangan po is pag run ng app if wala pang laman ang database inang mag boboot ang sign up form else log in

Tingin ng file or screen shot

 

[arvinpastoraquio]

Tutorial nmn dyan sa add. Delete. Search using database access

Sir kung marunong ka ng magprogram using other databases the same lang po using access. .

- - - Updated - - -

Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
connectDB()
connectUser("Select * from tbluser")
daUser.Fill(dsUser, rsUser, "tbluser")
dtuser.DataSource = dsUser.Tables("tbluser").DefaultView

If rsUser.RecordCount = 0 Then
frmSignup.ShowDialog()
Else
frmLogin.ShowDialog()
End If

i have 3 forms po frmsign up frmlogin and frmMain

yung kailangan po is pag run ng app if wala pang laman ang database inang mag boboot ang sign up form else log in

Ma'am suggestion ko lang po, the sequence should be like this:

Upon opening the Program, Whether there is no record or has existing records the first form to appear should be the Login form. Where in Login Form, there is an Option or Button to fire-up the Sign-up Form para magkaron si User ng Account to be able to Login to the System. Suggestion ko lang po yan para mas maayos ang loading ng program mo.

 

[uchihame]

Hi Visual Basic users, may alam po ba kayo on how to set a document properties gamit ang visual basic.
ObjWord.Activedocument.CustomDocumentProperties yan lang yung nahanap ko pero di ko na masundan, any advice? foe example mag se-set ako ng margin or orientation?.. thanks

 

[rocketpuncher]

Sir kung marunong ka ng magprogram using other databases the same lang po using access. .

- - - Updated - - -




Ma'am suggestion ko lang po, the sequence should be like this:

Upon opening the Program, Whether there is no record or has existing records the first form to appear should be the Login form. Where in Login Form, there is an Option or Button to fire-up the Sign-up Form para magkaron si User ng Account to be able to Login to the System. Suggestion ko lang po yan para mas maayos ang loading ng program mo.

yun po kasi yung task ng sir namen

 

[bobitoz]

Sir kung marunong ka ng magprogram using other databases the same lang po using access. .

- - - Updated - - -




Ma'am suggestion ko lang po, the sequence should be like this:

Upon opening the Program, Whether there is no record or has existing records the first form to appear should be the Login form. Where in Login Form, there is an Option or Button to fire-up the Sign-up Form para magkaron si User ng Account to be able to Login to the System. Suggestion ko lang po yan para mas maayos ang loading ng program mo.

Newbie plang sir eh d ko nga alam kung ano pinagkaiba ng database using access and sql

 

[arvinpastoraquio]

yun po kasi yung task ng sir namen

Ah ok. I think po kasi hindi best practice bilang isang programmer yung ganung sequence. Anyway, try mo po ito. fresh from my own coding. 100% working po:

Place it in your Login Form's Load Event

Application.DoEvents();

DataTable dt = new DataTable();

SqlConnection SQLConn = new SqlConnection("your_Connection_String");
SQLConn.Open();

SqlCommand SQLComm = new SqlCommand("Select * from yourTable", SQLConn);
SQLComm.CommandType = CommandType.Text;

dt.Load(SQLComm.ExecuteReader(CommandBehavior.CloseConnection), LoadOption.OverwriteChanges);

if (dt.Rows.Count > 0)
{
frm.ShowDialog();
this.Hide();
}
else
{
//Code here for authenticating user for login session
}

- - - Updated - - -

Newbie plang sir eh d ko nga alam kung ano pinagkaiba ng database using access and sql

Ah ganun po ba sir. Sa syntax sir walang pinagka-iba, pero sa features at security dun nagkakatalo. more on standalone applications kasi pag gumamit ka ng access as your backend. pag mga client server softwares d na sya advisable since hindi sya ganun ka secured. Anyway sir, try kita gawan bukas ng tutorial pag may oras ako. day off ko ngayon kaso kaylangan na magpahinga e, haha! nonood pa ako ng movie e.

 

[xxzeekee]

Pwede po ba magpaturo ng client-server na system?

 

[bobitoz]

Ah ok. I think po kasi hindi best practice bilang isang programmer yung ganung sequence. Anyway, try mo po ito. fresh from my own coding. 100% working po:

Place it in your Login Form's Load Event

Application.DoEvents();

DataTable dt = new DataTable();

SqlConnection SQLConn = new SqlConnection("your_Connection_String");
SQLConn.Open();

SqlCommand SQLComm = new SqlCommand("Select * from yourTable", SQLConn);
SQLComm.CommandType = CommandType.Text;

dt.Load(SQLComm.ExecuteReader(CommandBehavior.CloseConnection), LoadOption.OverwriteChanges);

if (dt.Rows.Count > 0)
{
frm.ShowDialog();
this.Hide();
}
else
{
//Code here for authenticating user for login session
}

- - - Updated - - -



Ah ganun po ba sir. Sa syntax sir walang pinagka-iba, pero sa features at security dun nagkakatalo. more on standalone applications kasi pag gumamit ka ng access as your backend. pag mga client server softwares d na sya advisable since hindi sya ganun ka secured. Anyway sir, try kita gawan bukas ng tutorial pag may oras ako. day off ko ngayon kaso kaylangan na magpahinga e, haha! nonood pa ako ng movie e.

Cge sir ang galing mo nmn kahit sa access muna ung tutorial sir how to connect access tas sample code narin sa add search delete button nyt sir nga pla 2010 lng ang visual studio ko

 

[maskio]

Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
connectDB()
connectUser("Select * from tbluser")
daUser.Fill(dsUser, rsUser, "tbluser")
dtuser.DataSource = dsUser.Tables("tbluser").DefaultView

If rsUser.RecordCount = 0 Then
frmSignup.ShowDialog()
Else
frmLogin.ShowDialog()
End If

i have 3 forms po frmsign up frmlogin and frmMain

yung kailangan po is pag run ng app if wala pang laman ang database inang mag boboot ang sign up form else log in

if dtuser isnot nothing then
if dtuser.rows.count > 0 then
show_login
else
show_signup
end if
end if

 

[bobitoz]

Cge sir ang galing mo nmn kahit sa access muna ung tutorial sir how to connect access tas sample code narin sa add search delete button nyt sir nga pla 2010 lng ang visual studio ko

I'll wait for the tutorial sir

 

[stench]

thank you sir

 

[DvinceCode]

Re: VB.NET Programming Corner! (Pa help po medyo urgent po ehh..)

pa help po pros.. paano po mai-print and laman datagridview??? at multiple pages po and pag print madami po ksi ung laman na data ng datagridview... please help me guys..

 

[con16]

Help
eto po table, panu po icompute lahat yung OT tapus idisplay yung total sa textbox?
Sa ginawa ko po kase bale yung isang row lang yung natotal nya. Thanks sa sasagot

EmpNo Name LogIN LogOut Date
2032-0995-0379 Cruz, Mark 9:36:23 AM 5:47:28 PM 2013-04-26 00:00:00.000
2032-0995-0379 Cruz, Mark 9:48:16 AM 6:51:13 PM 2013-04-26 00:00:00.000
2032-0995-0379 Cruz, Mark 1021 AM 5:19:56 PM 2013-04-26 00:00:00.000
2032-0995-0379 Cruz, Mark 10:20:16 AM 5:40:56 PM 2013-04-26 00:00:00.000

Dim Out As String
Dim TimeOut As Date
TimeOut = #5:30:00 PM#
Dim Ot
dt = ExecuteLocalSql0("SELECT * FROM tblAttendance WHERE EmpNo LIKE '%" & lblEmpno.Text & "%' AND Date ='" & FromPeriod.Text & "' AND Date <='" & ToPeriod.Text & "' ")
Out = dt.Rows(0)(3)
Ot = DateDiff("n", TimeOut, Out)
txtRegOT.Text = Ot
End If

 

[jiamp112]

View attachment 232243
any one??? tuwing mag add me data ayaw may eror na ganan panu po ba?

 

[JajaDina]

if dtuser isnot nothing then
if dtuser.rows.count > 0 then
show_login
else
show_signup
end if
end if

Active pa rin si Master <3