Comments by PunithaSabareeswari (Top 43 by date)

use datetimepicker

Thank You......................................................................

Thank You......

ok... pa.... i'm waiting......

Really.... Confused....................... Wat i want to do.............

i think u got my needs.... when i want to do this all while creating company or else...

ya... correct man... all databases want to store in the server system of LAN network...

hi... Thanks for ur idea.... but i want to some depth knowledge in this.. can u give...
i'm learner of database.... that's why i needed clear info for this... plz...

Thanks Man... It's Working for PreviewKeyDown Event.......

Can i add this R2 pack in sql server2005?..

I tried to add reference objectlistview project to my project.. but i had error like "Add reference to "ObjectListView2008" could not be added.Adding this project as a reference would cause circular dependency "

thank you..............

i created project in vb.net... it's in c#.... what can i do... can i add this... or any other choice....

do u know about ObjectListView.dll?

Thanks................................

can i take the data separately... i need dat format.. can i do....

thank you

Thank you for ur idea

datetime data type....

Sorry... I won't Work..... query selected only that veh.no records it won't check the date

i wrote this comment in DateTimePicker2_ValueChanged event.. is it possible..

I store some dates in database... Then according to that date, i want notification in notification icon... compare current time with database time and display the notification......

"select top(10) mobno from Table_name"


It may be used for u...... Use It

Dim a, km As Integer
con1.Open()
con.Open()
cmd.Connection = con
cmd.CommandText = "select * from TyreFitting where TyreNo= '" & cb_RemTyre.Text & "' and Reason='In Vehicle' "
dr = cmd.ExecuteReader
While dr.Read
cmd2.Connection = con1
cmd2.CommandText = "select CKM from CurKM where VehNo='" & dr(1) & "'"
dr1 = cmd2.ExecuteReader
While dr1.Read
a = dr1(0)
End While
dr1.Close()
con1.Close()
con1.Open()
cmd1.Connection = con1
km = a - dr(5)
cmd1.CommandText = "update TyreFitting set KMUsed= " & km & " where TyreNo= '" & cb_RemTyre.Text & "' "
cmd1.ExecuteNonQuery()
End While
dr.Close()
con.Close()
con1.Close()
THANK YOU MAN.... I GOT IT..

Can u make any changes in that code....

I could add the the items in list view... i can place the list view item in text box when i click on item in list view... but i won't delete in the list view...
Older record And Edited record both are displayed in the list view...

I got it.... Thank you...

Thank you

Hi... I try this.. But i had error "InvalidArgument=Value of '0' is not valid for 'index'. Parameter name: index" when i choose item from listview.

Thank you...

Remote System won't have any user id and password... waht can i do?...

More info means about what.

What And

SELECT TOP(1) *
FROM YourTable
ORDER BY FieldID DESC

ya... good idea... but at first there is no records in that table... which result i displayed

It won't repeating....

mmmm.. but i want to do like that.... can u help for that

Private Sub txt_unload_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txt_unload.KeyPress
If e.KeyChar = ChrW(Keys.Enter) Then
con.Open()
cmd.Connection = con
cmd.CommandText = "insert into Trip(TDate,TFrom,Tto,Party,KM,Quantity,Rate,Type,FAmt,Rcv,Balance,TLoad,TUnload,TSDate,VehNo)values('" & dtp_trip.Value & "','" & cb_from.Text & "','" & cb_to.Text & "', '" & cb_party.Text & "', " & txt_km.Text & ", " & txt_qty.Text & "," & txt_rate.Text & ",'" & cb_mkqty.Text & "', " & txt_freight.Text & "," & txt_recv.Text & "," & txt_bal.Text & ", " & txt_load.Text & "," & txt_unload.Text & ",'" & dtp_date.Value & "','" & cb_vno.Text & "')"
cmd.ExecuteNonQuery()
dtp_trip.Focus()
'ElseIf e.KeyChar = ChrW(Keys.Tab) Then
''Dim cmdstr As String
'cmdstr = "select * from Trip"
'da = New SqlDataAdapter(cmdstr, con)
'ds = New DataSet()
'da.Fill(ds, "trip")
'dgtrip.DataSource = ds.Tables(0)
Dim row As New DataGridViewRow
Dim cell As New DataColumn
row = New DataGridViewRow
'row.Cells(0).Value = dtp_trip.Value
row.Cells(1).Value = cb_from.Text
row.Cells(2).Value = cb_to.Text
row.Cells(3).Value = cb_party.Text
row.Cells(4).Value = txt_km.Text
row.Cells(5).Value = txt_qty.Text
row.Cells(6).Value = txt_rate.Text
row.Cells(7).Value = cb_mkqty.Text
row.Cells(8).Value = txt_freight.Text
row.Cells(9).Value = txt_recv.Text
row.Cells(10).Value = txt_bal.Text
row.Cells(11).Value = txt_load.Text
row.Cells(12).Value = txt_unload.Text
dgtrip.Rows.Add(row)
End If
End Sub

I get "error=Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index".
help me.....