Posts by Netcode

This would help you convert the image in your picture box to binary and save it in sql server.

'//declarations to handle face capture and its conversion to binary

   Dim myfilelocation As String = lblfilePath.Text
   Dim param As New SqlParameter("@ImageData", SqlDbType.VarBinary)
   Dim ImageData As Byte() = IO.File.ReadAllBytes(myfilelocation)
   param.Value = ImageData

  '//end declaration 


  Dim dc As SqlCommand = New SqlCommand

      With dc
      .Connection = con  'assuming 'con' is your connectionstring 
      .CommandText = "INSERT INTO TableName" & _
           "(ImageColumn)" + _
              "VALUES (@imagedata)"

                .Parameters.Add(param)
      End With

	con.Open()
        dc.ExecuteNonQuery()
        con.Close()

Have you tried setting the start position to centerParent?

Welcome!

welcome!

welcome!

welcome!

In space, astronauts cannot cry properly, because there is no gravity, so the tears can't flow down their faces

WaltP is very right. Please all IDs should remain unique

Network admin do not need programming skilles except to write some small scripts

means they have to do some script writing. In my own opinion, you can do without programming as a network admin but no knowledge is a waste.

Everything counts!

Welcome to Daniweb!

see here

The issues you have is with your select statement. Fist you check for the user and then later in your datarow you check for password. Also, i advice you learn to name controls appropriately not just to help yourself but also help other programmers reading your code.

Imports System.Data
Imports System.Data.SqlClient

Public Class login1
Inherits System.Web.UI.Page

    Private Sub signInButton_Click(sender As System.Object, e As System.EventArgs) Handles signInButton.Click

        Try
            ConnectionString.ConnSQL() 'call connection string 

            Dim selectString As String = "SELECT * FROM USERS WHERE UserName = '" + userNameTextBox.Text + "' AND Password = '" + passwordTextBox.Text + "'"

            Dim dc As SqlCommand = New SqlCommand(selectString, ConnectionString.ConnSQL)

            Dim reader As SqlDataReader = dc.ExecuteReader

            If reader.Read Then

                'set action on sucessful authentication
		response.redirect("services.aspx")
            Else

		'display error message

        Catch ex As Exception
		
        End Try

    End Sub

End Class

welcome!

Why bother yourself about IPs when you can simply use the server name?

Welcome!

welcome

Welcome!

“Everything has been figured out,
except how to live.”

~ Jean-Paul Sartre
(1905-1980)

First you need to understand a whole lot about keys and constraints.

Creating a Table with a Foreign Key Reference
This demonstrates how to create a table with a foreign key. In this example, I define two foreign key references within the definition of a CREATE TABLE statement:

CREATE TABLE Person.EmployeeCreditRating(
EmployeeCreditRating int NOT NULL PRIMARY KEY,
BusinessEntityID int NOT NULL,
CreditRatingID int NOT NULL,
CONSTRAINT FK_EmployeeCreditRating_Employee
FOREIGN KEY(BusinessEntityID)
REFERENCES HumanResources.Employee(BusinessEntityID),
CONSTRAINT FK_EmployeeCreditRating_CreditRating
FOREIGN KEY(CreditRatingID)
REFERENCES Person.CreditRating(CreditRatingID)
)

How It Works:
In this example, a table was created with two foreign key references. The first four lines of code
defined the table name and its three columns:

CREATE TABLE Person.EmployeeCreditRating(
EmployeeCreditRating int NOT NULL PRIMARY KEY,
BusinessEntityID int NOT NULL,
CreditRatingID int NOT NULL,

On the next line, the name of the first foreign key constraint is defined (must be a unique name in the current database):

CONSTRAINT FK_EmployeeCreditRating_Employee

The constraint type is defined, followed by the table’s column (which will be referencing an outside primary key table):

FOREIGN KEY(BusinessEntityID)

The referenced table is defined, with that table’s primary key column defined in parentheses:

REFERENCES HumanResources.Employee(BusinessEntityID),

A second foreign key is then created for the CreditRatingID column, which references the primary key of the Person.CreditRating table:

CONSTRAINT FK_EmployeeCreditRating_CreditRating
FOREIGN KEY(CreditRatingID)
REFERENCES Person.CreditRating(CreditRatingID)

see here

More clarification needed, maybe your snapshots would help. Till then.....

Iceprince - Superstar

You should not be doing an insert then , you're trying to fetch data fro the table to display it on a label. Use your SELECT Statements as clearly stated by hericles.

Develop an application which reads two integers n1 and n2 from the user via two text-boxes and displays in a label the sum of the factorial of the integers n1  n2

You already have an answer from your own question. You made mention of having two text-boxes to take values, so from there you should know you need two text-boxes on your interface. To add to it, you would need a button which you would write the factorial codes behind it so when clicked, it does the factorial.

Coldplay- Paradise

They go side by side. Data has to be prepared by someone and for someone which brings the need for human resource.

welcome!

welcome!

How can i convert from sql money datatype to double in c#.

Got it.

Are my the only one seeing this? Daniweb seems to be out of order. Fancy buttons now just show links and member names and avatars seem to cross borders into comments and posts made by members. Also, the text space for typing replies is just in disarray as in the attached thumbnail

yeah sufyan2011, the second part ain't a big deal. I need the first the most. And thanks for your reply, already on some ajax tutorials

BitBit has given the right link. To add to that, your post should have come in handy just in the C# forum since you want to design a front-end application with C#.

There is no certification without a value. Apart from the certificate itself, there is always something new to learn.

Its a good start but you require more than just your vb.net knowledge. You need graphics handling and more and you may also want to consider hardware resources when picking a language. You can check amazon for a start, they have good books from various publishers.

best Wishes!

Congratulations!

This is more like an introduction. Your question should have come right here

welcome!

welcome buddie!

I would wager that it's not open source.

I never wanted the codes, just screen shots of the GUI and maybe how it works.

You may not get such customized software. You may need to code that yourself or if you get something lose, you can tweak it to your taste.

Hello everyone. Am designing a web application based on human resources. I need to perform a search which would give results as a dropdown as the searchstring is being typed( as seen in photo one) to include the photo/image of the person and little detailed description like the Name, Department and Personnel_ID by the side and when i click on search result, it should show me the full profile where i can edit and save changes(as sen in photo two)

NB: Am designing with Visual Basic and SQL Server.

Please . I have lost count on how many accounts I have banned today.

You need to relax a little so you don't get freaked out.

nice one, welcome!

Welcome!

John kennedy must be Abraham Lincoln. It looks like the same person. It must be the same person!

you can say that again. Maybe its reincarnation but i don't believe in reincarnation

First, you can run a network diagnosis to get a clue. Also, your router may require some security key to grant you access through it to the internet.

@jwenting, i would really like to see what that looks like. Can i have a bit of it?

Without you- David Guetta ft Usher

ColdPlay- Paradise