Netcode 33 Veteran Poster

You need to do these things to learn, thats the only way you can impress people

Netcode 33 Veteran Poster

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

Netcode 33 Veteran Poster

by the way i want to change the copyright where i can change the this copyright?

My.Application.Info.Copyright

check your application properties

Netcode 33 Veteran Poster

where is the timer here?

its obvious you did not go through the code

Netcode 33 Veteran Poster

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

Netcode 33 Veteran Poster
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
Netcode 33 Veteran Poster

the redirect method would serve you

Netcode 33 Veteran Poster

What exactly has been your wildest thought or fantasy which you clear know/knew is/was unachievable?

Netcode 33 Veteran Poster

Am currently eating hunger......dats the only thing in my belly

Netcode 33 Veteran Poster

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

Netcode 33 Veteran Poster

We have to live today by what truth we can get today, and be ready tomorrow to call it falsehood.

Netcode 33 Veteran Poster

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
adam_k commented: How is the try..catch going to help with searching the database? -1
Netcode 33 Veteran Poster
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)
Netcode 33 Veteran Poster

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

Netcode 33 Veteran Poster

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

Netcode 33 Veteran Poster

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

Netcode 33 Veteran Poster

What file Info? the file name or file extension?

Netcode 33 Veteran Poster

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
Netcode 33 Veteran Poster

Don't get your head stuck in a spot.......Explore

Netcode 33 Veteran Poster

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.

Netcode 33 Veteran Poster

This is not the right place for this, avoid discrimination. Please mark this thread as solved to avoid further post

Netcode 33 Veteran Poster

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

Netcode 33 Veteran Poster

Read as much as you can come across and practice as much as you read

Netcode 33 Veteran Poster
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
Netcode 33 Veteran Poster

Are you sure your connection string is correct? and check the version of the MS Access

Netcode 33 Veteran Poster

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

Netcode 33 Veteran Poster

I do not agree with a word you say, but I will defend to the death your right to say it.

Netcode 33 Veteran Poster

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.

Netcode 33 Veteran Poster

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

Netcode 33 Veteran Poster

> 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

skilly commented: 1 bad apple... +0
Netcode 33 Veteran Poster

Has anyone seen the movie 'Area 51' ?

Netcode 33 Veteran Poster

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.

Netcode 33 Veteran Poster

Those who teach, learn

Netcode 33 Veteran Poster

well, those ones were wicked to humanity

Netcode 33 Veteran Poster

pseudorandom21, you're a damn funny ass.
But seriously, whats up with hacking. Same happened to Bieber

Netcode 33 Veteran Poster

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

Netcode 33 Veteran Poster

More research
love for coffee
eat junks
think even at sleep

Netcode 33 Veteran Poster

Never say evil about the dead

Netcode 33 Veteran Poster

The more extensive a man's knowledge of what has been done, the greater will be his power of knowing what to do.

Netcode 33 Veteran Poster

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

Netcode 33 Veteran Poster

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

Netcode 33 Veteran Poster

use the DISTINCT keyword

Netcode 33 Veteran Poster

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

Netcode 33 Veteran Poster

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]
Netcode 33 Veteran Poster

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

Netcode 33 Veteran Poster

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

Netcode 33 Veteran Poster

You may have isues with backward compatibility as debasidas stated, especially if you have reports and Microsoft Report Viewer used in the previous application

Netcode 33 Veteran Poster

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

Netcode 33 Veteran Poster

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

Netcode 33 Veteran Poster

check out 'Asp.net from Novice to Professional'but most asp.net books wont give you detailed information on crystal reports or SSRS. Those are complex courses so they exist on their own