|
I find that webservices pass datasets quite well. So if you don't mind the overhead I would suggest passing a dataset with one table with however many rows you need that have one column.
Ben
|
|
|
|
|
Hello,
VS 2005 & SQL 2005
I have a database field called signature and is an image datatype (binary data).
I am trying to display that signature in a crystal reports.
The signature has been displayed properly in the database as I can display the signature into a picture box using a memory stream. So I know the picture is there.
I am using typed datasets.
In CR i have dragged the signature field on to the crystal report and when i hover the mouse over it comes up with BLOB field.
However, when I run crystal reports it doesn't nothing in that field.
Is something more I have to do to display a picture in crystal reports?
Many thanks,
Steve
|
|
|
|
|
please follow this link it will help u a lot
prasanna
|
|
|
|
|
http://www.neodynamic.com/ND/FaqsTipsTricks.aspx?tabid=66&prodid=1&sid=68
prasanna
|
|
|
|
|
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[^]".
|
|
|
|