Posts by Netcode

I deal with vb.net, but i want to take a look at java. Whats your advice on things to expect?

1st world countries (developed), no second world but the poor ones are called third world countries.
Why?

Hi everyone, this is a kind of poll.
Daniweb is one of the best and leading forums for problem solving of all kinds. Its one forum i know that you can have a friends list and add people to them, also you can send and receive private messages. Sometimes, we see ourselves online and try to make a private discussion maybe on a particular problem posted on the forum and the Private message may be a little stressful.

Whats your opinion about having an Instant Messaging(IM) system and your reason.

mark as solved

Please mark this thread as solved

Try calling up the Main form before you clear all resources used by the Login form

'insert all codes including user validation 
     MainForm.Show
'Clear all login form resources
Me.Dispose

you may want to try this:

Dim sql5 As String = "insert into table_data(type,description) values('ERROR','" + str_exception + "')"

Dim cmd_sql5 As New SqlCommand(sql5, connection)

connection.Open()
	cmd_sql5.ExecuteNonQuery()
connection.Close()

I wonder if there's anyone in my shoes and if there is, if his leg fits in the shoe just as mine. I work with the Feds in my country and with a health agency. Its normal to introduce Info Tech in all fields but its damn nuts here.
I get little recognition on the job, no dedicated job description. When you raise an idea, your stupid boss takes it in and swallows the glory and cash that comes with it and am just left to do the clean up.

Whats your case?

why would you want to execute commands from a text-box when you can simply declare variables to hold the commands.

You may have everything well installed but some times, the Windows Firewall prevents remote access to your computer except such application is on its trusted list. You cannot turn off your system firewall just because you want to grant external users access to one application......thats lame so you can just enable FTP access on the windows firewall.

well, mine has been living under the sea to see the beautiful color. I wish and am still wishing

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

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

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

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]

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

Hi Everyone
I want every single operation carried out on my application from signing in to signing out written to a text file and the operations would have a timestamp for each corresponding operation. How do i go about this, i have no single idea at all.

Thanks

Hello everyone!
I want to write my connection strings and functions in a class and always call the class when i need to make a connection to my database to avoid code repetition and increase code reuse but i have an error. Here is my code below

Public Class ConnectionString

    '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
    Public Shared Function ConnSQL() As SqlConnection
        Dim connectionString As String
        Dim cnn As SqlConnection
        connectionString = "localhost;Initial Catalog=MSS;User ID=;Password="
        cnn = New SqlConnection(connectionString)
        Try
            cnn.Open()
            Return cnn
        Catch ex As Exception
            MsgBox("Can not open connection ! ")
        Finally
            cnn.Close()
        End Try

    End Function

The end function is underlined and states this: Function Sqlconn does not return a null value on all code paths

Hello Everyone!
Am working on a project and its ready for the production server. I used the windows login controls and ASPNET.mdf as the default database. I have moved the folder containing the project to the production server and deployed it on IIS but when a uer tries to access a page and is redirected to the login screen, it give the following error:

"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"

Please i need help with this

Thanks

i think you should reintall the server 2008

Hello everyone,
Please am working on a project basically for storing personal data for some employees. I have a dropdownlistbox which gets its content from a table in SQL-Server. I also have a textbox which i want its text to be the same with the selectedted item of the dropdownlist but it seems not to be working

Here's my simple code which was inplemented in the dropdownlistbox_Selectedindexchanged Procedure:

TextBox1.Text = DropdownListBox1.SelectedItem.ToString

How do i move from one tab page to another with a single button click?

Hi guys!
I just installed a new windows vista on my newly bough hard drive. i tried to deploy my web application to the local IIS server but the default web site appears to be stopped which prevents any site from being accessible over the LAN and when i try to start the process it throws his error: "The process cannot access the file because it is being used by another process.(Exception from HRESULT:0x80070020)"
Please what could be the problem?

Pls everyone, i need help with two regula expressions

One to accept only file word and pdf file and the other to accept only images(.jg|.bmp|.png|.gif)
Thanks

Imports System.Math

Public Class calculator

    Dim cleardisplay As Boolean
    Dim operand1 As Double
    Dim operand2 As Double
    Dim Operator1 As String

    Private Sub Digit_Click(ByVal sender As System.Object, _
        ByVal e As System.EventArgs) Handles btn1.Click, btn2.Click, _
            btn3.Click, btn4.Click, btn5.Click, btn6.Click, _
            btn7.Click, btn8.Click, btn9.Click, btn0.Click
        If cleardisplay Then
            txtDisplay.Text = ""
            cleardisplay = False
        End If
        txtDisplay.Text = txtDisplay.Text + sender.Text
    End Sub

    Private Sub btnPeriod_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPeriod.Click
        If txtDisplay.Text.IndexOf(".") > 0 Then
            Exit Sub
        Else
            txtDisplay.Text = txtDisplay.Text & "."
        End If
    End Sub

    Private Sub btnClear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClear.Click
        txtDisplay.Text = ""
    End Sub

    Private Sub btnEquals_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEquals.Click

        Dim result As Double
        operand2 = Val(txtDisplay.Text)
        Select Case Operator1
            Case "+"
                result = operand1 + operand2
            Case "-"
                result = operand1 - operand2
            Case "*"
                result = operand1 * operand2
            Case "/"
                If operand2 <> "0" Then result = operand1 / operand2
        End Select
        txtDisplay.Text = result
        cleardisplay = True
    End Sub

    Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
        operand1 = Val(txtDisplay.Text)
        Operator1 = "+"
        cleardisplay = True
    End Sub

    Private Sub btnPrefix_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPrefix.Click
        txtDisplay.Text = -Val(txtDisplay.Text)
        cleardisplay = True
    End Sub

    Private Sub btnInvers_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnInverse.Click
        If Val(txtDisplay.Text) <> 0 Then txtDisplay.Text = 1 / Val(txtDisplay.Text)
        cleardisplay = True
    End Sub

    Private Sub btnTimes_Click(ByVal sender As …

I have created an application and also created the setup.The application adds it executable file to the user program menu but it does not create a shortcut on the desktop. How do i make my applications create a shourtcut menu on the desktop when they are installed

If i may ask, Is it possible to update multiple rows in a database at once. if yes, how?
I have a dbase of almost 100 people. Each one has a unique reference number like this: NPHCDA/MSS/109 but i want to update the records of the hundred people and include year into their reference number so it all looks like this: NPHCDA/MSS/10/109 where '10' stands for 2010

I want my application to be able to print details from the databse. I hava a report already in the program but it displays the list off all persons in the database. I want to create a form where i can use a query and the result of the query would be printed on the report.

Hi everyone! I want to design a biometrics system. already, i've got it working to an extent. i can now save individual details with their images and thumbprints but i want to do a validation on the thumprints so no one person can be registered twice. thanks

Hi everyone, pls i need serious help. I got a free template which am editing in asp. the template just has header, footer, sidebar and others but i want to add multiple textboxes for data entry and also a submit button. pls how do i go about it because the CSS file does not include the new controls.

simply use:

Textbox1.text = Now.Date

How can i send a friend request to someone on Daniweb?

How can one search for multiple items at once and display the result in a datagrid? for example, i want to search for multiple mobile numbers (in sql server database)at once and display the found numbers and their corresponding names.

dim con as sqlconnection = new sqlconnection( _
"server= server name; database= d-basename; user id = server id; password= server password;")

hi everybody! i want to get all drives and their directories and sub-directories displayed on a tree view just as windows explorer. pls i need very comprehensive codes to do that...thanks

hi guys. its been a long time but sincerely, am happy to be back. now i've got a problem on my mind and that is; am trying to develop a database application but i want it to be a console application. the major issue is that i dont know how to go about connecting vb.net console application to sql server or if its possible at all, but am sure its possible in this world of ours....love you all.