[eidecedie17]

ano po ba ibig sabihin ng nested relationship?

[wrredraye]

Mga sir panu po b ang proper ng pag update insert at delete sa ms access using oledb? . .

po in advance

[3xpl0r3r]

sr polens, Nagawa q n ung Threading n cnsv mo.. hnd n hang ung apps q,, eto nman prob q ngaun, nauuna matapos ung progress bar q kesa dun s sqlserver connection q. ang gusto q po sanang manyare eh sbay sila matapos. pwd po b un sir?
tnx

[polens]

Originally Posted by 3xpl0r3r

sr polens, Nagawa q n ung Threading n cnsv mo.. hnd n hang ung apps q,, eto nman prob q ngaun, nauuna matapos ung progress bar q kesa dun s sqlserver connection q. ang gusto q po sanang manyare eh sbay sila matapos. pwd po b un sir?
tnx

i think mahirap na gawin un. .tansain mo lng ung time sa pagconnect tapos mag add ka lng para sure...

for example eto sa name generator ko..

System.Threading.Thread.Sleep(500)
                worker.ReportProgress(x / 1000 * 100)

ung x ko dyan eh asa loop

for x=0 to 1000
next

ex..
ung x=1
so(1/1000)=.001 * 100 = 0.1 so habang nag iinsert ako sumasabay sa progress bar...
thats the idea...

[3xpl0r3r]

Originally Posted by polens

i think mahirap na gawin un. .tansain mo lng ung time sa pagconnect tapos mag add ka lng para sure...

for example eto sa name generator ko..

System.Threading.Thread.Sleep(500)
                worker.ReportProgress(x / 1000 * 100)

ung x ko dyan eh asa loop

for x=0 to 1000
next

ex..
ung x=1
so(1/1000)=.001 * 100 = 0.1 so habang nag iinsert ako sumasabay sa progress bar...
thats the idea...

ah cge bossong aralin q yan.. salamat ulit..

[dheorwyne]

ayaw po gumana ng loop.. ung first record lng na dedetect nya kht may for loop naman.. sinu po may alam na way para mai add ang timevalue from db na naka loop.. pa revise na lang po ng code sa may nakakaalam.. salamat

i have 3 records from fieldname: dtr_grantotal:

= 10:41:00
= 01:11:00
= 03:30:10

sqlSTR = "select * from tblTImelog where dtr_datelog Between '" & DateTimePicker1.Text & "' AND '" & DateTimePicker2.Text & "'"
ExecuteSQLQuery(sqlSTR)

_totalDays = sqlDT.Rows.Count

If sqlDT.Rows.Count > 0 Then
Dim T1 As String = "00:00:00"
Dim myRow As DataRow = sqlDT.Rows(sqlDT.Rows.Count - 1)
Dim span1 As TimeSpan = TimeSpan.Parse(T1)

For i = 0 To sqlDT.Rows.Count - 1
Dim span2 As TimeSpan = TimeSpan.Parse(sqlDT.Rows(i)("dtr_grandtotal"))
t1 = span1.Add(span2).ToString
Next

MsgBox(t1)
End If

FIX:

For i = 0 To sqlDT.Rows.Count - 1
Dim span2 As TimeSpan = TimeSpan.Parse(sqlDT.Rows(i)("dtr_grandtotal"))
span1 = span1.Add(span2)
Next

t1 = span1.ToString
MsgBox(t1)

pinapakita lng ng msgbox ung fisrt.. at hnd cya nag aadd.. any help?


nasolve ko na po.. na edit ko narin ung fix code para sa mga need ng ganyan.. very use full pa yan kapag nag aadd ng time from db.. thank you..

[polens]

Originally Posted by dheorwyne

ayaw po gumana ng loop.. ung first record lng na dedetect nya kht may for loop naman.. sinu po may alam na way para mai add ang timevalue from db na naka loop.. pa revise na lang po ng code sa may nakakaalam.. salamat

i have 3 records from fieldname: dtr_grantotal:

= 10:41:00
= 01:11:00
= 03:30:10

pinapakita lng ng msgbox ung fisrt.. at hnd cya nag aadd.. any help?

sqlSTR = "select * from tblTImelog where dtr_datelog Between '" & DateTimePicker1.Text & "' AND '" & DateTimePicker2.Text & "'"
ExecuteSQLQuery(sqlSTR)

_totalDays = sqlDT.Rows.Count

If sqlDT.Rows.Count > 0 Then
Dim T1 As String = "00:00:00"
Dim myRow As DataRow = sqlDT.Rows(sqlDT.Rows.Count - 1)
Dim span1 As TimeSpan = TimeSpan.Parse(T1)

For i = 0 To sqlDT.Rows.Count - 1
Dim span2 As TimeSpan = TimeSpan.Parse(sqlDT.Rows(i)("dtr_grandtotal"))
t1 = span1.Add(span2).ToString
Next 

MsgBox(t1)
End If

direct to the point sir...
medyo magulo kasi..

ang ngyayari kasi sa code mo eh ung last record ang pumupunta sa T1 mo...
loop 0:T1=first record
loop 1:T1=second record
loop 2:T1=last record

declare mo kasi as string lng ung T1
kaya ang nagyayari eh wala laging new data ang pumupunta sa T1 mo..

lagay mo ung messagebox sa loob ng loop

anyway anong purpose? pinapaikot mo lng ung code

[rijolo012593]

Mga ka symb, pa naman po.

Sa pagsisave po ng record, ok naman po siya kaya lang tinatanggap nea lahat ng gusto kong ilagay.
Ang gusto ko po sana mangyari is kapag nag'input ako ng username na meron na sa database ko, may lalabas po na msgbox na nagsasabing may nagmamay'ari na ng ganong account. Ung txtUsername lang po ang di pwede maduplicate, pero ung password tsaka mga email, pwede po maduplicate.

Sana po matulungan neu ako.

Ito po yung code ko.

Private Sub cmdSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdSave.Click
Dim sqlconn As New SqlConnection("data source=.\SQLEXPRESS;Initial Catalog=EmailSender;Integrated Security=True")
Dim sqlda As New SqlDataAdapter
Dim sqlcmd As New SqlCommand
Dim dt As New DataTable

Try
sqlconn.Open()
Dim sqlstr As String = "insert into tblLogIn (Username,Password,GmailEmail,GmailPassword,YahooE mail,YahooPassword,HotmailEmail,HotmailPassword) values ('" _
& txtUsername.Text & "','" _
& txtPassword.Text & "','" _
& txtGmailEmail.Text & "','" _
& txtGmailPassword.Text & "','" _
& txtYahooEmail.Text & "','" _
& txtYahooPassword.Text & "','" _
& txtHotmailEmail.Text & "','" _
& txtHotmailPassword.Text & "') where not exists (select Username from tblLogIn where Username='Username')"
sqlcmd = New SqlCommand(sqlstr, sqlconn)
Dim icount = sqlcmd.ExecuteNonQuery
sqlconn.Close()
MessageBox.Show("Accout has been saved!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information)
Catch ex As Exception
MsgBox("This account has an owner", MsgBoxStyle.Exclamation + vbYesNo, "Error")

End Try


End Sub

All help will be appreciated. mga ka Symb.

[wrredraye]

padaan po. .. heheh

[dheorwyne]

Originally Posted by rijolo012593

Mga ka symb, pa naman po.

Sa pagsisave po ng record, ok naman po siya kaya lang tinatanggap nea lahat ng gusto kong ilagay.
Ang gusto ko po sana mangyari is kapag nag'input ako ng username na meron na sa database ko, may lalabas po na msgbox na nagsasabing may nagmamay'ari na ng ganong account. Ung txtUsername lang po ang di pwede maduplicate, pero ung password tsaka mga email, pwede po maduplicate.

Sana po matulungan neu ako.

Ito po yung code ko.




All help will be appreciated. mga ka Symb.

sir gamit ka muna ng selct statement na may where na nag eequal dun sa ini input mo.. then kpg nag recordcount > 0 then dun mo lagay ang warning u na bawal ma save kc meron ng ganun.. then if recordcount is 0 then save u ang insert query mo..
mas maganda kng gawa ka ng function na boolean sir.. na ilalagay mo dun ang select where query mo na true or false.. para tawagin u na lang.. bigyan lng kta idea.. pero kaya u yan sir.. recorcount sa vb6.. rows.count naman sa vb.net..

bigyan kita idea.. ung login d b.. kpg mali ang input which is wrong and connat process.. same din ang method jan sir.. na kpg worng login means save.. hehe.. bsta ganun lng.. laruin u lng ang idea sir..