|
hellow to all agine ..
i have a datagrid in my program ..
i add some data and do some changes ..
i wana put a button that say refresh ...
that will update the datagrid with the changes ..
i try to use the datagrid1.update option ..
it's not working for me !
how can i do it ..
thxx a lott 
|
|
|
|
|
If you want the datagrid to reflect changes in the data source, rebind. If you want the data source to reflect changes in the grid, you need to go through the rows and check which ones have been added/changed/removed, then update the source accordingly.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
so , how can i do this in vb code ?
|
|
|
|
|
Hi.
I have several combo boxes on my form that are used to select a date.
When i initialize the form i am using the additem command for each combobox, even though i am adding the same thing over and over again( days 1- 31, months 1-12, year 2001-2007.
i have three seperate comboboxes to select the day , month and year.
now,, i am currently using additem for each day,month,year (50 additems) for each combobox (3) for a total of 150 lines of code. can i not use additem and apply it to all three comboboxes at once(group them somehow). this doesn't work but it may give you an idea of what i am trying to accomplish
with combobox1_days and combobox2_days and combobox3_days
.additem 1
.additem 2
.
.
.additem 31
end with
your help would be appreciated
thanks
vb addict.
|
|
|
|
|
You can in fact hard code the values into the form designer, and not do this in code at all.
You can also write for loops to put numbers in, and 'group' it that way.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
You can index your combo boxes. To do this, add a combo box (e.g. combobox_days) to your form. Set its Index property to 0 or Copy, Paste, and press Yes when it asks you if you want to make an array. Do either one of these until you have all of the combo boxes you want. To add the items for the days:
Dim intCount As Integer
For intCount = 1 To 31
combobox_days(0).AddItem intCount 'This will add each day (1 through 31) to the 1st combo box
combobox_days(1).AddItem intCount 'This will add each day (1 through 31) to the 2nd combo box
combobox_days(2).AddItem intCount 'This will add each day (1 through 31) to the 3rd combo box
Next intCount
Or to comply with your message:
Dim intCount As Integer
'This loop adds duplicate information to all combo boxes with the name of combobox_days
For intCount = 0 To (combobox_days.Count - 1)
combobox_days(intCount).AddItem 1
combobox_days(intCount).AddItem 2
combobox_days(intCount).AddItem 3
...
Next intCount
Their is an ActiveX control named DTPicker that you can use by going to Projects, Components..., and selecting Windows Common Controls-2 6.0
|
|
|
|
|
thanks so much. i didn't know i could use a loop to fill in all the cb's values.
soooo much more efficient than how i was coding it...thanks again.
|
|
|
|
|
hellow to all ..
is there a way that i can change the datagrid titels in the coloms with out changing it in the tabel ...
i wana show the coloms names diffrent than there real name in the database ..
but i do not wana change it in the database manuale ..
is there a way ?
thxx !
|
|
|
|
|
In this control, there is any way to obtain the number of the line that the cursor is?
Thanks
|
|
|
|
|
Dim RowIndex As Integer
RowIndex = RichTextBox1.GetLineFromCharIndex(RichTextBox1.SelectionStart) + 1
progload
|
|
|
|
|
Could you tell me what books like Real World .NET Application ?
The book has some good application for learning.
Thanks in advance
|
|
|
|
|
Please don't ask the same question to every forum. I'm not even sure what the question is - you want a book on how to write real world applications in .NET ? The patterns and practices series from Microsoft has some good titles, but without knowing your current level of knowledge, it's hard to know what to recommend.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Dim c As Color = CType(TypeDescriptor.GetConverter(GetType(Color)).ConvertFromString(GetSetting("A", "B", "C", -1)), Color)
|
|
|
|
|
I take it there is a question in here somewhere?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
hellow i am coding a program ...
i am trying to pick a value from the datagrid ...
i pick the value fine !
but when i run the sql statment i recive the next error
"no value given for one or more required parameters"
here is the code .
Dim sConnection, ssql As String
Dim cellnum As Object
Dim row As Integer = DataGrid1.CurrentCell.RowNumber
Dim coll As Integer = DataGrid1.CurrentCell.ColumnNumber
cellnum = (DataGrid1(row, coll))
MessageBox.Show(cellnum)
Try
sConnection = "provider=microsoft.jet.oledb.4.0;data source=C:\Printers.mdb"
ssql = "Select * From [add] Where (Num ="
ssql = ssql & "'" & cellnum & "')"
MessageBox.Show(ssql)
Dim OleDbConn As OleDbConnection = New OleDbConnection(sConnection)
OleDbConn.Open()
Dim MyDataReader As OleDbDataReader
Dim MyOleDbCommand As OleDbCommand = New OleDbCommand
Dim MyDataSet As DataSet = New DataSet
Dim MyOleDataAdapter As OleDbDataAdapter = New OleDbDataAdapter
MyOleDataAdapter.SelectCommand = New OleDbCommand(ssql, OleDbConn)
MyOleDataAdapter.Fill(MyDataSet)
MyOleDbCommand.Connection = (OleDbConn)
MyOleDbCommand.CommandText = ssql
MyDataReader = MyOleDbCommand.ExecuteReader
Do While MyDataReader.Read
txt_type.Text = (MyDataReader("Machine_Type"))
txt_model.Text = (MyDataReader("Machine_Model"))
txt_serial.Text = (MyDataReader("Machine_Serial"))
Loop
MyDataReader.Close()
OleDbConn.Close()
OleDbConn.Dispose()
Catch err As System.Exception
MessageBox.Show(err.Message)
End Try
thxx great board !
|
|
|
|
|
it's a error at SQL
I Love my lover like you do!
|
|
|
|
|
please check it:
-------------------------------------------------
ssql = "Select * From [add] Where (Num ="
ssql = ssql & "'" & cellnum & "')"
-------------------------------------------------
|
|
|
|
|
any one know what
"no value given for one or more required parameters" error stand for ?
|
|
|
|
|
It means there are one or more parameters which are required, but you didn't provide them.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
You might want to change the name of that table, "add" to something that is not a reserved word.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
we are students and we have our thesis this semester... we're looking for some guidelines on ways we could accomplish our objectives.
Details:
Title: Advanced Duplicate File Scanning Tool Over LAN
Model of the Study: NoClone
Problems:
1. Comparing files produce inaccurate results.
* Distinguishing same contents in different text file formats as duplicate file.
There are times that users make used of notepad (.txt) as a way to edit or make drafts of something to start a document, afterwards it will be transferred to MS WORD. The content made in notepad is the same as the document transferred to MS WORD, meaning both of them has exact contents, logically they were duplicates but this case was ignored by the system because they have different formats (Not Supported).
*Failure to recognize files with the following scenarios
test.doc has been created and copied, producing files such as “copy of test.doc”, “copy (1) of test.doc”, “copy (2) of test.doc”, “copy (3) of test.doc” , “copy (4) of test.doc”. On the latter part, after the scanning process with NoClone, there is no results listing these five files are said to be duplicate files.
In addition, the proponents made a word document and typed the word “test” and it was then saved with “test.doc” filename. Afterwards, the file was intentionally “Save As” to another filename with the same content. This procedure continues until it reaches the fourth similar file which is “test4.doc”. Right after the saving of file, NoClone application was launched and tested to scan duplicate files. But surprisingly it didn’t found anything. This kind of instances only shows that it doesn’t have enough capability to have complete and reliable scan.
Furthermore, NoClone is unable to scan within the archive of .zip or compressed file. In scanning for duplicate files, NoClone doesn’t include the files contained by the zip or compressed file nevertheless, it ONLY include the .zip file itself but not including the file being compressed.
2. No option to search for a particular file name or folder to search for its duplicate
The system doesn’t have a field or an option to key in a particular filename or folder which a user wants to find distinctively. The ability to search for a particular file name is such a useful function so that the scanning process will not produce unintended results.
3. Inability to schedule the scanning process at specific date and time, identifying which computer to scan and compare.
As the file grows bigger everyday, there’s a huge chance that one of those files are duplicated which could consume much of the disk space. If the administrator wants to schedule a scan as part of maintenance routine to accumulate all the wasted spaces, the admin needs of course a way or an option to set the schedule. But unfortunately, this was not made available by the system.
This limitation made this application uneasy for administrators who want to set everything in place, so that if ever he/she forgot to check for duplicates between the targeted period the system would still remember and would make the work for them.
4. There is no option to separate original from duplicate files as a part of removal procedure.
After the scan process for duplicate files, it would display all detected items. But the problem is when you decide to delete all duplicate files whether manually (one-by-one, very tiresome) or clicking the option to mark all files (Recommended action); in this event the source file is also detected. There’s no option to delete only the duplicated items and leave one unique file (source file) without manually unmarking it from the list, making it hard and tiresome for the user. Like for example, the system detects 3,000 duplicate files within a single drive, the user need to selectively leave one file unchecked, in which it’s a lot of effort to do especially if the result contains a lot of items.
Objectives:
1. Make use of comparison algorithms to produce accurate results
a. Provide a content-based (using line-by-line comparison) scanning mechanism to support detection of duplicate file regardless of format, filename, and size
b. Use CRC/MD5 algorithm to efficiently scan the files within the chosen directory or path to produce much accurate results.
c. Provides a mechanism in which .zip files could be scanned within its archives and
2. . Provide filename and folder search option to search for an intended item.
3. Provide duplicate file scan scheduling in a specific date and time and specify which computer to scan and compare.
4. . Provide an option to separate original from duplicate files (removal procedure) to retain the source file without manually unmarking it.
*Objectives will be implemented in a LAN network (Network Application)
* we hope that somebody out here would help us... specifically on the ways how we could program... or does anyone here have codes which we could use for this study... thanks..
|
|
|
|
|
1. For your first problem you need to be able to read each of the file formats to get the text each file contains and compare.
2. Your second problem is simple. When you are scanning the computer for the duplicate files, log each duplicate file's name and path in an array. When your scan completes, list the results with checkboxes by them so the user can choose which files to delete and which files to save. You can also make it so the user can double-click on the item and view it before he makes his choice.
3. Windows has Scheduled Tasks folder that you can open and schedule a date and time to scan. If you look hard enough, you can probably find some code somewhere on the Internet that will allow you to add a scheduled task.
I'm assuming you are using Windows. In order to help out more I need to now what programming language you are using. Are you making this file scanner from scratch or do you already have some code to start out with? I'm not going to help you out much because this is a thesis. Don't get the wrong idea.
|
|
|
|
|
thanks alot. we're plannning to use VB 6.0... we want it from scratch. is it possible to imbed a code to an existing duplicate file finder?
|
|
|
|
|
kenvil wrote:
is it possible to imbed a code to an existing duplicate file finder?
Only if you have the source code for the file finder. But then it wouldn't really be from scratch.
VB6 comes with the DriveListBox, DirListBox, and FileListBox controls to get information about drives, folders, and files on the local computer. I don't think that you can set them to return information about a remote computer. You will probably have to create two apllications. A client program that runs in the background and allows the user to clean his own machine if he wishes to, and an administrator program that can connect to the client program on a remote computer. The client program will scan the computer as requested by the administrator program. The administrator can then decide what to do with the duplicate files. I don't know much about how to send this sort of information over LAN but, if you are willing to learn it, DirectPlay can probably be of use to you.
If you don't like the DriveListBox, DirListBox, and FileListBox controls that come with VB, you can check out the FindFirstFile, FindNextFile, and FindClose functions of the kernel32 DLL. I've used these calls before and can send you snippets if you are interested.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
