Comments by hlsc1983 (Top 38 by date)

I checked the value . its something like 13-09-2005 14:52:00

its date type.... of course when I view the columns in sqlserver , it shows date in ' yyyy/mm/ dr format.

yes thats correct..only the student's name and not the subject

in the same table. have a closer look

yes SQL server

i have a table in sql server with a number of rows. i want to identify those students whose names are present more than once in the database table

how can i do it vb.net? i need to display the data in a listview control

i am getting an error "execute local is not declared".

what about the ip address and stuff?

http://www.gpknagaland.netau.net

i removed con and now its showing another error.
" there's already an open datareader associated with this connection which must be close first!"

con is declared in a module

@CPAllini i already have a database..i was not sure about using the database since i would have to create a table just to store one value.
the admin should be able to change the timer's interval property anytime he wishes to. Also i have no idea about your lightweight solution. Some help will be appreciated. thanks.

'unhandled exception' ...and it also says that the path of the database does not exist. it happens only when another client is already logged...

its 'enable'

thanks
...... I don't think I need to iterate through all the rows and columns.....isn't the first row enough.....

thank you..

can anyone explain the need for declaring myStream as Stream datatype. i commented that line and still the application works......please shed some light. thanks..

thanks.. i still gett an error "Comexception was unhandled" associated with the line
-" xlWorkSheet.Range("A1").Resize(DataGridView1.Rows.Count, DataGridView1.Columns.Count).Value = myArray"


The code is--

Dim xlApp As Microsoft.Office.Interop.Excel.Application
Dim xlWorkBook As Microsoft.Office.Interop.Excel.Workbook
Dim xlWorkSheet As Microsoft.Office.Interop.Excel.Worksheet
Dim misValue As Object = System.Reflection.Missing.Value
Dim r As Integer
Dim c As Integer


xlApp = New Microsoft.Office.Interop.Excel.ApplicationClass
xlWorkBook = xlApp.Workbooks.Add(misValue)
xlWorkSheet = CType(xlWorkBook.Worksheets.Item("sheet1"), Microsoft.Office.Interop.Excel.Worksheet)



Dim myArray(DataGridView1.Rows.Count - 1, DataGridView1.Columns.Count - 1) As Object
For r = 0 To DataGridView1.Rows.Count - 1
For c = 0 To DataGridView1.Columns.Count - 1
myArray(r, c) = DataGridView1.Rows(r).Cells(c)
Next c
Next r



xlWorkSheet.Range("A1").Resize(DataGridView1.Rows.Count, DataGridView1.Columns.Count).Value = myArray
xlWorkSheet.SaveAs("D:\vbexcel.xlsx")
xlWorkBook.Close()
xlApp.Quit()


xlApp = Nothing
xlWorkBook = Nothing
xlWorkSheet = Nothing

MsgBox("You can find the file D:\vbexcel.xlsx")

store off in the database? how can I do it?

thanks....
the way i understand is I need to fill the array first using the data grid values..so how do I achieve it? if u can kindly give some links or code

i need to use the datgrid beacause it is populated depending on a search operation performed by the user and result of the search is used to fill up the datagrid.,, of course it is not shown in the code but that is the idea,,,

yes you are right... it is just busy.. how to speed it up?

you are right ... the code works but it is slow... how can i use an array?

sorry i dont get your question about the loop...what changes do i need to make for the code to execute faster...???

sorry i did not get your question about the loop?please tell me the changes i need to make in order to make the code execute faster..

thanks again..I vl do that

the PC with win xp is my client..it is running the .exe file which was published using win 7 laptop and vs2008. I don't want to install .net on my xp since it is supposed to run like a client .. help

thanks it works perfectly fine...thank you so much....there is however another problem.. when I type application password in my windows xp, the actual letters are getting display in the text box instead of asterisk *. but in my windows 7 laptop the asterisk is shown...what should I do so that only * is shown in windows xp too?

i dont think we can install office2007 package on windows xp.
how can i change the coding?

i dont htink we can install office2007 package on windows xp.
and the link is for Office 2010. we are deaking with office2007 here.

I tried to follow your instructions and this is my code now.


[code]
Dim str As String
str = "SELECT * FROM Login WHERE username= @txtUsername.Text & password = @txtPassword.Text"
Dim cmd As OleDbCommand = New OleDbCommand(str, DBconnection)
dr = cmd.ExecuteReader
If dr.HasRows Then
MsgBox("successfull")
Else
MsgBox("sorry")
End If
[/code]

'dr' is a datareader declared in my module

i get an error associated with the line "dr = cmd.ExecuteReader"
the error is "No value given for one or more required parameters."

thanks...i combined the two statements into one single statement
'Dim myConnection As New OleDb.OleDbConnection' and 'myConnection = New OleDb.OleDbConnection(conString)' into

' Public myConnection As New OleDb.OleDbConnection(connString)'
i dont get any error in this case.

i do however have more doubts.
is sub a better way than function to open a connection?

OK i moved the lines out of the function but i get an error with this line..
myConnection = New OleDb.OleDbConnection(conString). the error is 'declaration expected'