hi all, Anyone know how to edit the listview in specify of column? I just know this code only ListView1.LabelEdit = True this code is for the first of the column in listview which can be edit only but for the another column are can not to be edit! so, anyone know this? Please help!

hi, I wish to edit the item in the listview with vb.net, then save it to databases! so, any one know of this? please help! :confused: Regards, charles

hi, Everyone know this error? the database has been placed in state by user "Admin"! We are using a shared database in access databases. When more than one user has connect to my databases by my application (my program developed by vb.net) at the same time, the following error message appears. "The database has been placed in a state by user 'Admin' on machine XXXXX that prevents it from being opened or locked." * Although i already add the "Persist Security Info=False;Mode=Share Deny None" in my OleDbConnection, it still got same error! How to solve this error? please help! My following code as below: Try DB = New OleDbConnection("Provider=microsoft.jet.oledb.4.0; data source=C:\prdsystem\prdnsf.mdb; Persist Security Info=False;Mode=Share Deny None") DB.Open() Catch ex As Exception MsgBox(ex.Message, MsgBoxStyle.Information, "") End End Try Da = New OleDb.OleDbDataAdapter(sql, DB) Ds = New DataSet Da.Fill(Ds, "emp")

hi, Everyone know this error? the database has been placed in state by user "Admin"! We are using a shared database in access databases. When more than one user has connect to my databases by my application (my program)the database open, the following error message appears. "The database has been placed in a state by user 'Admin' on machine XXXXX that prevents it from being opened or locked." How to solve this error? please help! My following code as below: Try DB = New OleDbConnection("Provider=microsoft.jet.oledb.4.0; data source=C:\prdsystem\prdnsf.mdb") DB.Open() Catch ex As Exception MsgBox(ex.Message, MsgBoxStyle.Information, "") End End Try Da = New OleDb.OleDbDataAdapter(sql, DB) Ds = New DataSet Da.Fill(Ds, "emp")

hi, anyone know how to search the date by "dd/mm/yyyy" in sql query! my code is : Select datamonth from datemonthtest where datamonth >= #" & strdatefrom & "# and datamonth <=#" & strdateto "# and data type i set it to date/time! The result is not efficient to select the month! Example: when i select the date is from 01/10/2006 to date 30/10/2006 but all the previous month will be come out! 09/08/2006...... Please help!

hi, anyone know how to search the date by "dd/mm/yyyy" in sql query! my code is : Select datamonth from datemonthtest where datamonth >= #" & strdatefrom & "# and datamonth <=#" & strdateto "# and data type i set it to date/time! The result is not efficient to select the month! Example: when i select the date is from 01/10/2006 to date 30/10/2006 but all the previous month will be come out! 09/08/2006...... Please help!

Thanks, Christian Graus! the following code: Dim i As Integer For i = 0 To i <= 10 Dim textBox(i) As TextBox dim e as integer textBox(i).Multiline = True textBox(i).ScrollBars = ScrollBars.Vertical textBox(i).AcceptsReturn = True textBox(i).AcceptsTab = True textBox(i).WordWrap = True textBox(i).Text = "Welcome!" textBox(i).Visible = True textBox(i).Location = New Point(16 + e, 32) Me.Controls.Add(textBox(i)) i = i + 1 e = e + 5 Next Note: but after i set the position but It's also didn't comeout the textbox? then how to get the textbox comeout? charleslau2855

hi, anyone know how to create multiple textbox using for loop in vb.net? Dim i As Integer For i = 0 To i <= 10 Dim textBox(i) As TextBox textBox(i).Multiline = True textBox(i).ScrollBars = ScrollBars.Vertical textBox(i).AcceptsReturn = True textBox(i).AcceptsTab = True textBox(i).WordWrap = True textBox(i).Text = "Welcome!" textBox(i).Visible = True Me.Controls.Add(textBox(i)) Next I have write the above coding but it's look not successfully and didn't appear any textbox comeout!!! So, anyone know please help! charleslau2855

hi, Everyone know how to freeze panes the datagrid in vb.net? which mean DataGrid with the ability to lock the header row and columns. Please help! Regards, charles

hi, Everyone know how to convert this vb6 code " ListView1.listitem(i + 1).subitem(j + 1).add" to vb.net?? Please help! charleslau2855

hi, Anyone know how to convert the code below for vb6 to vb.net? here is my vb6 source code! Function LoadLR() dbrs.Open "select Badge,Time,Day,InOut From TimeAInfor where InOut='" + CStr("<") + "' and Month='" + CStr(Mid(Combo1(3).Text, 1, 2)) + "' and Year='" + CStr(Mid(Combo1(4).Text, 3, 2)) + "' order by Day", dbsql 'j = 0 For j = 0 To Form3.ListView1(2).ListItems().Count - 1 If dbrs.RecordCount <> 0 Then dbrs.MoveFirst For i = 0 To dbrs.RecordCount - 1 If Form3.ListView1(2).ListItems(j + 1).SubItems(1) = dbrs.Fields(0) Then h = DatePart("h", CStr(dbrs.Fields(1))) h = h * 60 n = DatePart("n", CStr(dbrs.Fields(1))) F = h + n If F < WorkIn Or F = WorkIn Then Form3.ListView1(2).ListItems(j + 1).SubItems(dbrs.Fields(2) + 1) = "-" Else If Form3.ListView1(2).ListItems(j + 1).SubItems(dbrs.Fields(2) + 1) <> "-" Then If F > WorkIn Then T = Form3.ListView1(2).ListItems(j + 1).SubItems(dbrs.Fields(2) + 1) If T = "" Then Form3.ListView1(2).ListItems(j + 1).SubItems(dbrs.Fields(2) + 1) = (F - WorkIn) Else If (F - WorkIn) < Val(T) Then Form3.ListView1(2).ListItems(j + 1).SubItems(dbrs.Fields(2) + 1) = (F - WorkIn) End If End If End If End If End If End If dbrs.MoveNext Next For i = 2 To 32 If Not Form3.ListView1(2).ListItems(j + 1).SubItems(i) = "" And Not Form3.ListView1(2).ListItems(j + 1).SubItems(i) = "-" Then totalLR = totalLR + Val(Form3.ListView1(2).ListItems(j + 1).SubItems(i)) End If Next Form3.ListView1(2).ListItems(j + 1).SubItems(33) = totalLR totalLR = 0 End If Next Call CloseTASystem For i = 0 To ListView1(2).ListItems().Count 'MsgBox ListView1(2).ListItems().Count If ListView1(2).ListItems().Count <> 0 The

hi, Everyone know how to create the daily employees OverTime hour report in listview which mean the listview must included with some columns eg: Name, Age, Day1, Day2....... Day31! So, the output is something like this: Name Month Day1 Day2 Day3 ........ Day31 Steven Dec 1hour 2hour 0.5hour 1 hour Marry Dec 5hour 1hour 2 hour 3 hour . . . . . . . . . . . . So, i want create a new application which using the vb.net with m.access and the output record is look something like the "calendar" but it is using the "listview " to list the everyday record data for each employee! Please help!!! charleslau2855

:laugh:hai.. thanks for ur reply... Actually, i do many testing in filestream, but the results are just can convert the file(.txt file) to string. my friend told to me that this is can't to convert the (.exe file) to string. Is true? :confused:

Thanks for ur reply.... Actually i just know the code from BitMapToString, but i dont know how to use this to convert it from FileToString... So, any suggestion for this function.... Public Function BitmapToString(ByVal sImagePath As String) As String Try Dim data As String Dim ms As MemoryStream = New MemoryStream Dim bmp As Bitmap = New Bitmap(sImagePath) ' Save as PNG format (IMHO, much better! // ) bmp.Save(ms, System.Drawing.Imaging.ImageFormat.Png) data = Convert.ToBase64String(ms.ToArray()) Return data Catch ex As Exception Return String.Empty End Try End Function

hai, i have set my program as a .msi window installed file, when i type the following command in command prompt msiexec /i xxxxxxx.msi /qn the .msi file will ran in silent install mode. So, the problem is i want to start the silent install mode without manually key in the command like above one. how to when we start install and then will auto run silent install command....:omg: Thanks....;P

hai, :) ;)Everyone who know that sending the command from Server to Client to execute .exe file.:wtf: thus, Client can perform installation! :confused: Thanks for ur reply!!! :cool:

hai, ;P Everyone who know that how to use the install.inf file to perform the silent installation??:doh: i mean that what are the coding in the .inf file to perform silent installation!:confused: Example: the coding can hide the next button when perform installation! Thanks for ur!!!!:rose:

hai, ;P Everyone who know that how to use the install.inf file to perform the silent installation??:doh: i mean that what are the coding in the .inf file to perform silent installation!:confused: Example: the coding can hide the next button when perform installation! Thanks for ur!!!!:rose:

:-Dhai... everyone.. who know how to use the vb.net to perform the silent installation? :confused: For this purpose, because i want to perform install s/w program that means can install program at 10 client pc at ths same time.:cool: :doh:Actually, i want use the install.inf file to perform the silent installation, but i also dont know the command for .inf file.:eek: So,;) everyone who know about this!!! that give me some guideline(web site or coding) to do this..... :rolleyes: Thanks you!:rose:

hai, everybody!!! :confused:I got problem with silent install by using platform VB.NET and actually, i dont know how to start it!:doh: So, everyone who know the sample code or any web site for this silent installation that can let me for reference it! :wtf: :-OThanks for ur!;P