|
Hi
me n my friend are making a software which v use in schools or coll.
our aim is as following :
There is 1 SERVER names SERVER
there r 4 client pcs names CLIENT1 , CLIENT2 , CLIENT3 , CLIENT4
*********************************************************************
all 4 clients r connected to server via LAN.
Entry work will get done from clients
Database ( SQL ) is on Server.
so i dont know the technology of networking in VB.NET
***********************************************************************
at server,
when client is doing something it will record that all in another database
like >>>>>>>>
when client 2 is finding something ( ther is a search section )
or like that
so can anybody guide me
i gott upto 50%
|
|
|
|
|
ankur0101 wrote: all 4 clients r connected to server via LAN.
Entry work will get done from clients
Database ( SQL ) is on Server.
so i dont know the technology of networking in VB.NET
Why not use a standard SQLClient to write to the database directly from each client?
ankur0101 wrote: when client is doing something it will record that all in another database
like >>>>>>>>
I don't understand what ">>>>>>>>" means. Are you trying to write to a table that for example a user clicked on a button, selected a combo box, etc?
ankur0101 wrote:
when client 2 is finding something ( ther is a search section )
or like that
Again, are you trying to record the action (button click, etc) or are you trying to write a search result to the database?
Pete Soheil
DigiOz Multimedia
http://www.digioz.com
|
|
|
|
|
hi,
Now i am phasing one problem in datagrid
according to the numbers the rows can be segrigate ie no :1's are in one color and no:2's are in one other color .....
plz help me to solve this problem
prasanna
|
|
|
|
|
Select the GridView in question, and under properties look for "AlternatingRowsDefaultCellStyle". Click on the selection combo, and select a color under "Backcolor" for it. That's all you need to do. 
Pete Soheil
DigiOz Multimedia
http://www.digioz.com
|
|
|
|
|
Hi I am trying to make a login program. I want to use access 2003 to keep track of the usernames/passwords so the program can just check with access to see if the username matches the password and if so let them continue with the program.
Here is my code so far.
'Max Bunnell
Public Class LoginForm
Dim Times As Double
Dim Username As String
Dim Password As String
Private Sub ResetButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ResetButton.Click
Me.PasswordTextBox.Text = ""
Me.UsernameTextBox.Text = ""
End Sub
Private Sub SubmitButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SubmitButton.Click
If Times < 3 Then
Username = Me.UsernameTextBox.Text
Password = Me.PasswordTextBox.Text
If Username = "mcbunnell" Then
If Password = "x1236598" Then
MessageBox.Show("Congradulations", "You got it right!", MessageBoxButtons.OK)
Me.PasswordTextBox.Text = ""
Me.UsernameTextBox.Text = ""
Times = 0
Username = ""
Password = ""
Me.Close()
Else
MessageBox.Show("Wrong Username And/Or Password", "Login Error", MessageBoxButtons.OK)
Me.UsernameTextBox.Text = ""
Me.PasswordTextBox.Text = ""
Times = Times + 1
Username = ""
Password = ""
End If
Else
MessageBox.Show("Wrong Username And/Or Password", "Login Error", MessageBoxButtons.OK)
Me.UsernameTextBox.Text = ""
Me.PasswordTextBox.Text = ""
Times = Times + 1
Username = ""
Password = ""
End If
End If
End Sub
Private Sub LoginForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Times = 0
End Sub
End Class
|
|
|
|
|
What is your question? Because the only thing we can see from this is that you spelled congratulations wrong.
|
|
|
|
|
how do i make the first connection with access
|
|
|
|
|
|
Other than you have no database code at all in this, there's already a bunch of things wrong with your code.
For instance, doesn't repeating this:
Me.UsernameTextBox.Text = ""
Me.PasswordTextBox.Text = ""
...
Username = ""
Password = ""
four times in this little code segment just scream "put me in my own method!"??
|
|
|
|
|
and how wouid i do that
please tell me how
|
|
|
|
|
have every location call this routine :
Private Sub ResetButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ResetButton.Click
Me.PasswordTextBox.Text = ""
Me.UsernameTextBox.Text = ""
End Sub
example:
ResetButton_Click(nothing,nothing)
or
create a new routine and have every location call the new routine.
|
|
|
|
|
First, you'd pick up a beginners book on VB.NET. What you're missing is very basic stuff.
BUt, you do NOT call the Click handler to do this. You move the code to it's own Sub:
Private Sub ClearUsernamePasswordTextBoxes()
UserNameTextBox.Text = ""
PasswordTextBox.Text = ""
End Sub
Then the Click handler AND all your other place just call this sub to clear the boxes out:
ClearUsernamePasswordTextBoxes()
|
|
|
|
|
What you can possibly do is to connect to the data base using ADODB and create a loop which searchs for username and password in access file.
Private Sub SubmitButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SubmitButton.Click
Dim con As New ADODB.Connection
Dim rs As New ADODB.Recordset
With con
.Provider = "Microsoft.Jet.OLEDB.4.0"
.Open("db1.mdb")
End With
rs.Open("Select * from Table1", con, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic)
Dim pSn As Boolean
Dim uNme As String
unme = StrConv(UsernameTextBox.Text, VbStrConv.ProperCase)
rs.MoveFirst()
Do While Not rs.EOF
If unme = rs(0).Value And PasswordTextBox.Text = rs(1).Value Then
MsgBox("User name and Password Accepted", MsgBoxStyle.Information)
Me.Hide()
Form1.Show()
pSn = True
Exit Do
Else
rs.MoveNext()
pSn = False
End If
Loop
If pSn = True Then
ElseIf pSn = False Then
MsgBox("The username or password is incorrect. Please retype the Username and password.", MsgBoxStyle.Exclamation, "Login")
UsernameTextBox.Clear()
PasswordTextBox.Clear()
UsernameTextBox.Focus()
End If
End Sub
Parth Patel 
|
|
|
|
|
Hi all
I have a MS Access Database which is Password protected
I want to connect to this particular database
Could u help me out how the connection string looks like
For eg:
I have given like this
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = E:\Share\UpServer\TMSServer.mdb; Password=tmss"
But its showing me an error.
Could any one help me out
Thanks in Advance
|
|
|
|
|
If you provide details of the error, this will make it easier for people to provide assistance.
Paul
|
|
|
|
|
|
con.Provider = "Microsoft.Jet.Oledb.4.0"
con.ConnectionString = "Data Source = " & mdbPath & ";Jet OLEDB:Database Password=1234"
con.Open()
Shay Noy
|
|
|
|
|
Hi i am having an error message thrown when I wish to update my database. I call a sub procedure called Savechanges(which definately works because it is straight from a textbook and has been used in various projects I have done) for the rowChanged event of the datagridview which I am using to edit information. I might be calling saveChanges() to often but thats due to the fact that I don't know where to call savechanges for the datagridview? My datasets and adapters are all generated and I have looked at the select statement for the table adapter which has the problem and the select statement is correct. The datatypes are also correct for the various fields. Is there anywhere else I can check to see why the error is happening? Where should I call saveChanges for the datagridview for optimal performance? I am using VB.NET 2005 in a single user environment. thanks
Mr Oizo
|
|
|
|
|
Do you have a GUID on each row?
Sometimes if you don't have a GUID on a row it is not clear which record is being updated and the database update falls over.
You always pass failure on the way to success.
|
|
|
|
|
G.....I have never heard of a GUID. How would I put one on each row? I'll try search on the net so long tho. Thanks
Mr Oizo
|
|
|
|
|
A GUID is a "Globally Unique Identifier". Basically a 128-bit number used to identify objects. A GUID is a bit too "heavy" for a database key.
Read up on "Primary Key[^]".
|
|
|
|
|
Not so much a GUID, but a Primary Key for each record in the table is REQUIRED to use the Adpaters.
|
|
|
|
|
the table is a table called "SONG". In this table for each song listed is a unique (autogenerated number) field called "SongID". This table also has many to one relationship with a table called "GENRE"(One genre can have many songs) and another many to many relationship with a table called "CATEGORY"(a song must belong to one or more categories and a category consists of many songs). Anyway these relationships are defined in the access database and automatically in the .xsd file for my solution. (Genre table has a primary key named "genreName" which is also a foreign key in the table song) this is all correct as far as I know. At the moment I am only running updates for the fields in the song table which is theoretically a child table of both CATEGORY and GENRE. What might the problem be?
Mr Oizo
|
|
|
|
|
Okay - there is the issue.
You mentioned Access database - well you need a unique index in order to be able to update a table in Access - or at least I always have needed on with Access databases and VB .NET .
I mentioned GUID as it is the easiest way of ensuring you have a completely unique key - actually I have come across non unique GUIDs in my career.
For a less heavy option, GUIDS can take space in your table, you could create a composite key i.e. a key made up of multiple fields such as artist, album and songname.
However you could still have issues which is why in my opinion if space is not an issue a GUID is very useful.
You always pass failure on the way to success.
|
|
|
|
|
Thanks for the reply....My song table does have a unique ID. It is an autonumber sequentially generated field named songID. Do I need to manually write an update statement to update the database? I thought the autogenerated statements would be fine? My table adapters and datasets are all auto generated and my datagridview uses the SONG table as its DataMember. I would of thought that all i need to do is update the fields in the datagridview and then record the changes back to the database? By using
Public Sub SaveChanges()<br />
<br />
'this Sub is responsible for recording changes back to the database<br />
<br />
Dim dsUpdates As dsLibraryNewest<br />
<br />
Try<br />
dsUpdates = CType(DsLibraryNewest.GetChanges(), _3rdYearProject12Aug.dsLibraryNewest)<br />
<br />
If Not (dsUpdates Is Nothing) Then<br />
'these are various adapter for the six various tables <br />
modbdaSongNewest.Update(dsUpdates)<br />
modbdaCategoryNewest.Update(dsUpdates)<br />
modbdaGenreNewest.Update(dsUpdates)<br />
modbdaAlbumNewest.Update(dsUpdates)<br />
modbdaCategorySongNewest.Update(dsUpdates)<br />
modbdaAlbumSongNewest.Update(dsUpdates)<br />
<br />
<br />
DsLibraryNewest.AcceptChanges()<br />
End If<br />
<br />
Catch ex As System.Exception<br />
<br />
' MessageBox.Show(ex.Message, "Error", _<br />
'MessageBoxButtons.OK)<br />
<br />
End Try<br />
<br />
End Sub
Mr Oizo
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
