I'm using Stored Procedure,3 tier and VB.net. :) Now, i click the gridview and then want to show the data in textboxes and pictureBox to update the informations. :rolleyes: :java: The problem is that , how can i retrieve photo to picture box???:confused: X| :doh: :mad: :(( Here is my code :|

Private Sub gdCompany_CellClick(ByVal sender As System.Object, ByVal e As Telerik.WinControls.UI.GridViewCellEventArgs) Handles gdCompany.CellClick
btnSave.Text = "ျပင္ရန္"
txtCompanyName.Text = gdCompany.CurrentRow.Cells(1).Value.ToString()
txtDescription.Text = gdCompany.CurrentRow.Cells(2).Value.ToString()
txtPhoneNo.Text = gdCompany.CurrentRow.Cells(3).Value.ToString()
txtFaxNo.Text = gdCompany.CurrentRow.Cells(4).Value.ToString()
txtEmail.Text = gdCompany.CurrentRow.Cells(5).Value.ToString()
txtWebsite.Text = gdCompany.CurrentRow.Cells(6).Value.ToString()
ddlBankName.SelectedValue = Convert.ToInt32(gdCompany.CurrentRow.Cells(7).Value.ToString())
ddlBankBranch.SelectedValue = Convert.ToInt32(gdCompany.CurrentRow.Cells(8).Value.ToString())
txtBankAccountNo.Text = gdCompany.CurrentRow.Cells(9).Value.ToString()
txtAddress.Text = gdCompany.CurrentRow.Cells(10).Value.ToString()

    'picCompanyLogo.Image = Convert.ToByte(gdCompany.CurrentRow.Cells(15).Value.ToString())
   

  
    txtCompanyName.Focus()
End Sub

'In DA_Company'

Function Company_Save(ByVal M_Model_DA As Model.M_Company) As String
Try
connection_enable()
cmd = New SqlCommand()
cmd.CommandText = "SP_HR_Company_Insert"
cmd.Connection = con
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@Company_Logo", SqlDbType.Image).Value = M_Model_DA.Company_Logo
err_message = cmd.ExecuteNonQuery()
Catch ex As Exception
err_message = ex.ToString()
End Try
Return err_message
End Function

'In BL_Company'

Function Company_Save(ByVal M_Company_BL As Model.M_Company) As String
Try
DA_Company = New DataAccess.DA_Company()
error_message = DA_Company.Company_Save(M_Company_BL)
Catch ex As Exception
error_message = ex.ToString()
End Try
Return error_message
End Function

'In M_Company'

Public Property Company_Logo() As Byte
Get
Return Me.CompanyLogo
End Get
Set(ByVal value As Byte)
Me.CompanyLogo = value
End Set
End Property

'In Frm_Company'

Private Sub Company_Save()
Try
BL_Company = New BusinessLogic.BL_Company()
M_Comapny = New Model.M_Company()
M_Comapny.Company_Logo = Convert.ToByte(browseCompanyLogo.Value)
error_message = BL_Company.Company_Save(M_Comapny)

        If error\_message > 0 Then
            MessageBox.Show("Complete Save")
            Company\_GridView\_FillData()
        End If
    Catch ex As Exception
        MessageBox.Show(ex.Message.ToString())
    End Try

Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click

Company_Save()

End Sub

But It Shows Input Stream was not in a correct format . Why ? please !

I have the excel file (Insert.xls) and i want to bind the data from it. I wanna bind data with various Textboxes for each excel column. How can i read it ? please suggest me or please pay the sample codes for it. :(( :doh:

thanks dear brother.....that's work :)

I have the table(tblCompany) which have the fields(ID,CompanyName,Address,PhoneNumber,Email)etc.. There is a data entry man(Role=marketer) to insert the company. I don't want to publish (new company) directly to the website and I(Role=Admin) wanna check again . If i approve the (new Company) , then publish to the users(Role=Public and Role= Annonymous). How can I write the code for this problem? Please , suggest to me my all dear.....

I'm a junior developer and now i'm doing the online shopping website. The problem is that i don't know how to connect with PayPal for the payment system. So, give me advice and suggestion all of my friends. :)

SEO program ? Search Engine Oprimization is for websites. Here is the Links that u can study for SEO. With best wishes.. http://www.w3schools.com/web/web_search.asp[^]

In the www.jobsdb.com and www.jobstreet.com, the registered member can get their job alert via Email. See this sites and get member. And then,plz help me because my boss wanted to do like that ... :(

How can i create the Job Alert with C#(Asp.net) please answer me .