|
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=60133&lngWId=-10
|
|
|
|
|
hello there!
i would like to ask how to automatically refresh the data on vb.net. i made a simple data entry program that would add, delete and update data using access database. i used the 'insert into and delete sql commands but it didn't refresh automatically during runtime. hope you would help me.
thanks so much in advance. 
|
|
|
|
|
Depends on what you mean by refresh. Usually people forget or don't understand how to use the data adaptor update method and changes aren't made to the database. Is that what you mean? or do you mean you don't see the changes in the dataset?
|
|
|
|
|
How to delete a selected item of a listbox?
|
|
|
|
|
Do you mean delete a selected item by clicking a button???
if so add this code to your button...
ListBox1.Items.Remove(ListBox1.SelectedItem)
That should work.
|
|
|
|
|
|
Het2109 wrote:
Hope its helpful to you!
certainly not...
find why by yourself
TOXCCT >>> GEII power
[toxcct][VisualCalc]
|
|
|
|
|
I know there is a way to embed MSDE into an setup project but the article
at microsoft is way to complicated for me to understand. Does anyone have a better idea??? or easier way of explaining how to do this?
|
|
|
|
|
can you send me the link for microsoft site ???
thanks
|
|
|
|
|
You have two choices - either include the MSDE setup merge module in your setup project, or run the full MSDE setup. If you choose the latter option you will have to write your own bootstrrapper application because you cannot launch a second MSI from a running MSI.
Robert
|
|
|
|
|
I crated a datagrid and I program the DataGridTableStyle in code for the datagrid to set the display format. I also have a delete button on the form. The problem is a ghost graphics of the selected cell is left behind after the row in the datagrid has been deleted.
I will explain:
1. I initially display all the rows in the datagrid
2. I click on a cell (4,1) for that row to be deleted
3. I click on the delete button which deletes the row/record from the db and reloads the dataset and the datagrid with the updated information
4. When the datagrid is repopulated, there are only 3 rows (this is correct), but the selected cell (4,1) is still showing on the grid. The rest of the data for row 4 is gone. Just that single cell is still showing.
I have tried clearing out the table styles, but that did not work. Any suggestions?
Thanks in advanced
Jeffrey
|
|
|
|
|
|
Hi !. Thank you all in advance for any help, advice.
I would like to develop a small tool which will let me browse a fixed directory/folder and open files(.XLs, .snp, .doc, etc)
The tools itself will just let browse a folder and and selecta file to be opened using its default program(.doc will open in word, .snp will open in snap hot viewer).
Basically I am looking for ideas on how start on this using vb.net.
Thanks
|
|
|
|
|
Can some one help me get started???
|
|
|
|
|
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2224&lngWId=10
|
|
|
|
|
|
Hi All,
I have created a module using ArrayList to store my custom structure type as below codes. How can I search the this ArrayList with my custom structure ?
Public Structure MyStru
UserID As String
Name As String
Class As String
End Structure
Sub Main
Dim MyClass As New ArrayList()
Dim MyStudent As New MyStru
MyStudent.UserID = "ID001"
MyStudent.Name = "Peter Pan"
MyStudent.Class = "2C"
MyClass.Add(MyStudent)
************************************************
Suppose hereafter I have many student records need to be
inputted into MyClass. And I want to check for any duplication on
the member MyStudent.UserID from MyClass. How can I do that ??
As I know, there is a method Contains in ArrayList(), but what I can
find from the Internet is the sample of using String not Custom
Structure.
End Sub
Thanks for your professional help.
FM_668
|
|
|
|
|
Hi;
This is not as big of a problem as you may think. This is what is needed to be done.
Create you structure as follows:
Structure MyStru
Implements IComparable
Public UserID As String
Public Name As String
Public StuClass As String
Public Function CompareTo(ByVal obj As Object) _
As Integer Implements System.IComparable.CompareTo
Dim tmpObj As MyStru
tmpObj = CType(obj, MyStru)
Return Me.UserID.CompareTo(tmpObj.UserID)
End Function
End Structure
Dim MyStuClass As New ArrayList
Dim MyStudent As New MyStru
By defining “Implements IComparable” and implementing the function CompareTo in your structure, when you now call ArrayList.Sort and ArrayList.BinarySearch, your CompareTo function will be called. Because you know the structure and know how you want to sort and search the objects you pass those items to the system which knows how to compare the strings. The Me.UserID in the return statement above is the first string to compare to the tempObj.UserID the other string which ArrayList.Sort or ArrayList.BinarySearch sent to compare.
Before you can call ArrayList.BinarySearch the object must be sorted, the ArrayList.Sort will do that for you.
And now the rest of the code:
‘ Call sort before calling MyStuClass.BinarySearch
MyStuClass.Sort()
' The index into the ArrayList where it
‘ found the record you wanted.
Dim index As Integer
‘ Holds the item you are searching for.
Dim tmpStru As New MyStru
tmpStru.UserID = txtFind.Text.ToString()
index = MyStuClass.BinarySearch(tmpStru)
The value of index will be a negative number meaning it was not found or a positive number meaning the zero based index of the value you were looking for in your arraylist.
Hope this was of some help.
|
|
|
|
|
Thanks Very Much
|
|
|
|
|
Hello There
I have a textbox and when I make the border style flat then a black line comes around it. I want to change the color of that line. can Any one knows how to ?
also if I want to change the color to any custom color from Hexadecimal then how to do that ?
|
|
|
|
|
Im not sure how you would do that but i do know of a method that would work
for putting a border of any color or thickness around a textbox.
I would use labels to draw lines and form a box around the textbox.
Select label, draw the label thin like a line.
set these properties
Text = (Nothing)
BackColor = Desired Color
Size = This will depend on vertical or horizantal, play around with the smallest number to get the desired thickness. ex. Size = 352,8 (change the 8 to a 1 to get the thinnest line possible)
Now make both a vertical and horizantal line, copy and paste each so you have 2 of each and just resize them to make a box/border around the textbox.
|
|
|
|
|
Hi,
I need print a lot of DOC, XLS, PDF, PPT files with the path in header or footer.
Thanks
|
|
|
|
|
Dim wrd As Word.Application
Dim doc As Word.document
Set wrd = New Word.Application
Set doc = wrd.Documents.Open("c:\Filename.doc")
wrd.Visible = True
'Header
wrd.ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader
With wrd.Selection
.ParagraphFormat.Alignment = wdAlignParagraphCenter
.TypeText "Header Text"
End With
'Footer
wrd.ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageFooter
With wrd.Selection
.ParagraphFormat.Alignment = wdAlignParagraphRight
.TypeText "First Line of Footer text" & vbCrLf & "Second Line of Footer text" & vbCrLf & "Third Line of Footer text" & vbCrLf
.ParagraphFormat.Alignment = wdAlignParagraphCenter
.TypeText "Fourth Line of Footer text"
End With
'doc.Close wdSaveChanges
Set doc = Nothing
'wrd.Quit
Set wrd = Nothing
|
|
|
|
|
Does anyone know how to get rid of this database logon prompt when using crystal
reports. I am running my installed application on a client computer but it asks me
for my DB logon information everytime i run the report. Is there anyway for the report
to connect just using my connection string in my App.config file rather than prompting for DM info everytime?????????????????
|
|
|
|
|
Hi, please somebody tell me or rather explain to a novice VB6 programmer how to create a report whereby I can query it during runtime? Any help is most welcome.
THANKS!
Shiro
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
