Comments by Sureshfrompalladam (Top 16 by date)

if i use decimal means it automatically convert into double and show me the error as
cannot store double into decimal ..

i need to store the id , name & image in database. In that design form i can only show the empid and image in the page .....

help me friend ......

Data can't be fetched from EmpNumberTextbox.text

can u please try the above code and help me to correct it

In the above coding the empid is the error statement i got while i use break statement.

Dim DBConnectionString As String = "Data Source=BOSS\SQLEXPRESS;Initial Catalog=simple;User ID=sa"

Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
Dim connection As New SqlConnection
Try
Dim img As FileUpload = CType(imgUpload, FileUpload)
Dim imgByte As Byte() = Nothing
If img.HasFile AndAlso Not img.PostedFile Is Nothing Then
'To create a PostedFile
Dim File As HttpPostedFile = imgUpload.PostedFile
'Create byte Array with file len
imgByte = New Byte(File.ContentLength - 1) {}
'force the control to load data in array
File.InputStream.Read(imgByte, 0, File.ContentLength)
End If
' Insert the employee name and image into db
' Dim conn As String = ConfigurationManager.ConnectionStrings("Data Source=BOSS\SQLEXPRESS;Initial Catalog=simple;User ID=sa").ConnectionString
connection = New SqlConnection(DBConnectionString)
connection.Open()
Dim sql As String = "INSERT INTO EmpDetails(Empid,Empname,Empimage) VALUES(@empid, @empname, @empimage) "
Dim cmd As SqlCommand = New SqlCommand(sql, connection)
cmd.Parameters.AddWithValue("@empid", EmpNumberTextBox.Text)
cmd.Parameters.AddWithValue("@empname", txtEName.Text.Trim())
cmd.Parameters.AddWithValue("@empimage", imgByte)
Dim id As Char
lblResult.Text = String.Format("Employee ID is {}", id)

Catch
lblResult.Text = "There was an error"
Finally
connection.Close()
End Try
End Sub



this is my coding friend but empid is problem for me to store this can u help me to finish my project

dear nirav prabtani friend

thanks for ur reply but i need of varchar datatype i modified my question please see that