You need to do these things to learn, thats the only way you can impress people
adam_k commented: How is the try..catch going to help with searching the database? -1
You need to do these things to learn, thats the only way you can impress people
Oh, I see. Well, all those secrets were exposed the public in the movie Independence Day.
Okay. I'll have to check 'independence day' out because i've really not heard of it. Area 51 was really not much fun to me
by the way i want to change the copyright where i can change the this copyright?
My.Application.Info.Copyright
check your application properties
where is the timer here?
its obvious you did not go through the code
Unfortunately not in Daniweb as you "solve" the thread in statistic points if you wrote any message to thread not your own before it was marked solved.
If you explained a solution to OP, and (s)he understood, then you are geek. (If you made OP to find it "himself", you are guru ;) )
i see
Public Class Splash
Private Sub Splash_FormClosed(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosedEventArgs) Handles Me.FormClosed
Library.Show()
End Sub
Private Sub Splash_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Application title
If My.Application.Info.Title <> "" Then
lblTitle.Text = My.Application.Info.Title
Else
'If the application title is missing, use the application name, without the extension
lblTitle.Text = System.IO.Path.GetFileNameWithoutExtension(My.Application.Info.AssemblyName)
End If
' Version.Text = System.String.Format(Version.Text, My.Application.Info.Version.Major, My.Application.Info.Version.Minor, My.Application.Info.Version.Build, My.Application.Info.Version.Revision)
lblVersion.Text = String.Format("Version {0}", My.Application.Info.Version.ToString)
'Copyright info
lblCopyright.Text = My.Application.Info.Copyright
With Me
.Icon = Library.Icon
.Text = "Library Management System"
End With
End Sub
Public Sub New()
' This call is required by the Windows Form Designer.
InitializeComponent()
' Add any initialization after the InitializeComponent() call.
Me.Opacity = 0 'form is invincible as startup
End Sub
Private Sub tmrSplash_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles tmrSplash.Tick
Me.Opacity += 0.01
If Me.Opacity = 1 Then
tmrSplash.Enabled = False
Library.Show()
Me.Dispose() 'close the splash screen
End If
End Sub
Private Sub pnlSplash_Paint(ByVal sender As System.Object, ByVal e As System.Windows.Forms.PaintEventArgs) Handles pnlSplash.Paint
End Sub
End Class
the redirect method would serve you
What exactly has been your wildest thought or fantasy which you clear know/knew is/was unachievable?
Am currently eating hunger......dats the only thing in my belly
You reached 188 points, so you achieved position 398722 of 1598621 on the ranking list
You type 257 characters per minute
You have 43 correct words and
you have 0 wrong words
We have to live today by what truth we can get today, and be ready tomorrow to call it falsehood.
use the structured error control and use a messagebox to display the cause:
Try
'statement(s)
Catch ex as exception
Messagebox.show(ex.message)
End Try
Dim fileName As String = "myfile"
Dim pathname As String = "\mydir\"
Dim fullPath As String
fullPath = Path.GetFullPath(pathname)
Console.WriteLine("GetFullPath('{0}') returns '{1}'", pathname, fullPath)
fullPath = Path.GetFullPath(fileName)
Console.WriteLine("GetFullPath('{0}') returns '{1}'", fileName, fullPath)
Am not sure you have asp.net installed" Try this:
To install asp.net on IIS, run:
> cmd as administrator
> %windir%\microsoft.net\framework\v4.0.30319\aspnet_regiis.exe -i
Enable FTP access on the remote computer where your sql server exists and check for various suitable connections strings in the link: http://connectionstrings.com
What version of SQL are we talking about?
If it's Express, then there are limitations (to concurent users, GUI and others).
Other than that all SQL servers are available to the network.
Have your program connect to the SQL via the appropriate connection string (Look here : http://www.connectionstrings.com/ )
best reply
What file Info? the file name or file extension?
For VB6.0, i would advice you create your projects and the database file in the C:\ drive. You can create a folder there to save projects so when you move your project folder to another system, the name and directory of the Access Dbase file remains the same.
Having said that, here is the code for MS Access connection:
Option Explicit
Public conn As New ADODB.connection
Public rs As New ADODB.Recordset
Sub connection()
Set conn = New ADODB.connection
conn.Open "Provider = Microsoft.Jet.OLEDB.4.0; Data Source=" & App.Path & "\data\DataBaseName.mdb"
End Sub
Don't get your head stuck in a spot.......Explore
it has. There's a movie called Area 51. its actually just about some Military Protected area where aliens are kept and some other secrets the US government decided to keep away from the citizens. You can check it out.
This is not the right place for this, avoid discrimination. Please mark this thread as solved to avoid further post
State the actual error you receive or observe and try some code simplification by breaking them down. That way, you can be more efficient in debugging your own codes
Read as much as you can come across and practice as much as you read
Private Sub button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim myStream As Stream = Nothing
Dim openFileDialog1 As New OpenFileDialog()
openFileDialog1.InitialDirectory = "c:\"
openFileDialog1.Filter = "txt files (*.txt)|*.txt|All files (*.*)|*.*"
openFileDialog1.FilterIndex = 2
openFileDialog1.RestoreDirectory = True
If openFileDialog1.ShowDialog() = System.Windows.Forms.DialogResult.OK Then
Try
myStream = openFileDialog1.OpenFile()
If (myStream IsNot Nothing) Then
' Insert code to read the stream here.
End If
Catch Ex As Exception
MessageBox.Show("Cannot read file from disk. Original error: " & Ex.Message)
Finally
' Check this again, since we need to make sure we didn't throw an exception on open.
If (myStream IsNot Nothing) Then
myStream.Close()
End If
End Try
End If
End Sub
Are you sure your connection string is correct? and check the version of the MS Access
Yes you can. You could use a label to do the trick and a timer. I always prefer designing my own splash screen for purpose of clarity and easy manipulation
I do not agree with a word you say, but I will defend to the death your right to say it.
Facebook is hell. Funny enough, am not sure the owner(name withheld cos we all know him). its a bad distraction and no one really wants to know if you stumbled on a block. so y waste your bloody time on it.
I do believe there are things worth dying for, but the dude is obviously in the wrong. You don't just kill people to promote a book! Unless the book is going to save the world, but somehow I doubt that if we don't read it the world will split in half and shoot demons from it's core (hey that might be a cool book).
Shooter = Crazy.
to me, the guy is a frustrated soul. Maybe he felt he has done something so good and worth recognition but the world was not just giving him the attention he deserved. Well, lets not be biased judges, maybe we should all read the book
> You know you are a geek when ....
You post "You know you are a geek when ...." threads :)
And also reply to "You know you are a geek when ...." threads ;)
.........when you solve a thread
I still don't believe in his cause.He had no right to do that and even if he had something to tell the world or some sort of publicity, please there are ways of letting your opinion known and not just known but count. Now that he has made himself clear by releasing the book and causing world alert, his revolution is a dead one because no one would follow.
well, those ones were wicked to humanity
pseudorandom21, you're a damn funny ass.
But seriously, whats up with hacking. Same happened to Bieber
I really love the last result on the Google self-driven car. The International Body has decided not to legalize it because its a rule that there mist be a driver behind every wheel but come to think of it, These cars on their own are more accurate than the humans that control them
More research
love for coffee
eat junks
think even at sleep
The more extensive a man's knowledge of what has been done, the greater will be his power of knowing what to do.
Sure it does, the textbox path is also part of the FileUpload control so you cant set a property separately for it. Tou can expand the width of the control from the IDE in design time. And besides, the FileUpload control is browser dependent. You would see the textbox in Browsers like Mozilla firefox but don expect to see it in Google Chrome
First it shows your database is not well designed as you do nt have a unique identifier. Well, since you have a saving grace which is the time, you can delete all other records leaving the want you want by specifying the time in the WHERE clause
use the DISTINCT keyword
The Datasize of the column should be increased before you import from excel. Also ensure that there exist the same number of columns in sql server as with the source file and make sure sql server can accomodate the datatypes of the source file in each respective column.
Should work for you
You need am ID to specify a WHERE condition. Else, you may end up losing the whole data in the table. In order to remove the data from the table while retaining table structure, do this:
TRUNCATE TABLENAME
but you can delete a selected number from the table just as specified below:
DELETE TOP 1000 [ID]
,[Reference_Number]
,[FirstName]
,[LastName]
FROM [HumanResource].[dbo].[Employees]
Do a system restore to a date before you installed sql server, try re-installing SQL Server and be careful no to change names or properties where not necessary
well, check your code-behind file i:e. the HTML file of the page and get the width of the textbox and make the width of the FileUpload control same with the textbox. You can do this in design time
You may have isues with backward compatibility as debasidas stated, especially if you have reports and Microsoft Report Viewer used in the previous application
adam k, logs can be used for event tracking in general from login to sign out. There wont be any breach in secuirty because the aplication wont pas out account information to the text file(sql server keeps its logs just incase you're not aware).......better thinking right?
Debasisdas, thanks alot. I already did that but i have a table in the database where i do sale the logs, was just thinking there would be a better or easier way rather than writting for all events.
Thanks guys
Well, you can connect when both PC's are on the same network because there is no conflict as it recognizes the network but you definitely cannot connect when you exist on another network because you computer at home wont be seen