ASP.NET

Dylan98821-Mar-12 4:29

Dylan988

21-Mar-12 4:29

the error occurs at the following line of code:

Dim ds As DataSet = searching.Search(searchName.Text)

Is there any way that i can improve this line?

ZurdoDev21-Mar-12 4:33

ZurdoDev

21-Mar-12 4:33

You are getting a null reference error. But you already have an if statement checking searchName.Text so it isn't searchName which means either searching is null or the error is actually occuring inside the searching.Search method.

I believe your error is actually happening within Search so try stepping into that function as you debug.

There are only 10 types of people in the world, those who understand binary and those who don't.

Dylan98821-Mar-12 4:45

Dylan988

21-Mar-12 4:45

thanks ryan.
for my search service i have the following code

<WebMethod()> _
Public Function Search(ByVal searchName As String) As System.Data.DataSet
    Dim connectionString As String = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString
    Dim MyConnection As New SqlConnection(connectionString)
    Dim MyCommand As New SqlCommand()

    MyCommand.Connection = MyConnection
    MyCommand.CommandType = Data.CommandType.Text

    MyCommand.CommandType = "SELECT * From Book WHERE WineType like @prmSearchName"

    MyCommand.Parameters.AddWithValue("prmSearchName", "'%" & searchName & "%'")

    MyCommand.Connection = MyConnection

    Dim selectAdapter As New Data.SqlClient.SqlDataAdapter
    Dim ds As New Data.DataSet
    MyConnection.Open()
    selectAdapter.Fill(ds, "Wine")
    MyConnection.Close()

    Return ds

End Function

does the code looks good to you?

ZurdoDev21-Mar-12 4:51

ZurdoDev

21-Mar-12 4:51

Ya, I didn't notice anything wrong which is why I suggest you step into the web service, if you can. Is the web service in a different project? If so, put try catch around your code in the service (which you really should have anyway Smile | :)

) and hopefully you can see a stack trace of which line exactly is causing the issue.

There are only 10 types of people in the world, those who understand binary and those who don't.

Dylan98821-Mar-12 4:58

Dylan988

21-Mar-12 4:58

thanks ryan for your replies. yes the web service is a different project. i did the web referencing and stuffs required to be brought in accordingly. but still the error exists.

ZurdoDev21-Mar-12 5:04

ZurdoDev

21-Mar-12 5:04

So, when you debug is searching null? If not, the error is happening inside the webmethod so you need a way to debug that. For example, add a try catch and write to a log.

There are only 10 types of people in the world, those who understand binary and those who don't.

read byte of saved picture

Anudeep Jaiswal - MCA28-Mar-12 23:07

Anudeep Jaiswal - MCA

28-Mar-12 23:07

Suppose This Query

SELECT * From Wine WHERE WineType='ABC'

Return No Table

Then How Can You Set the Datasource Of Gridview1 to ds.tables[0]

GridView1.DataSource = ds.Tables(0)

Hope U Understand this. Smile | :)

comptech219-Mar-12 21:21

19-Mar-12 21:21

hi.i want to read byte of save picture and show in fileUpload control.the below code dont work.please quidance me

while (dr.Read())
            {
  picture_fileUpload = (byte[])dr["picture"];
}

Not Active20-Mar-12 22:47

20-Mar-12 22:47

You can't assign a value to an upload control. What are you trying to accomplish?

Failure is not an option; it's the default selection.

comptech221-Mar-12 9:04

21-Mar-12 9:04

this is edit page and i want that fileupload kept last image value and if we select new image then change its value

Not Active21-Mar-12 9:22

21-Mar-12 9:22

So display the existing image and check the FileUpload.HasFile property. If true then the user has selected a new file to be uploaded. Why make it more difficult?

Failure is not an option; it's the default selection.

comptech221-Mar-12 9:47

21-Mar-12 9:47

but how to set the value to file upload control during postback ?

Not Active21-Mar-12 9:50

21-Mar-12 9:50

You DON'T set it. How many times do you need to be told this?

Failure is not an option; it's the default selection.

satalaj21-Mar-12 6:34

satalaj

21-Mar-12 6:34

Hi,
Asp.net fileUpload control has FileBytes properties. It returns file content in terms of byte array. Upload image file and save in sql server.

comptech221-Mar-12 9:13

21-Mar-12 9:13

this is edit page and i want that fileupload kept last image value and if we select new image then change its value

shreekar21-Mar-12 10:13

shreekar

21-Mar-12 10:13

OK - lets do it one step at a time.

Have you managed to save the uploaded image to wherever you want?

Shreekar

Not Active21-Mar-12 12:32

21-Mar-12 12:32

Have you even read this thread? The first post shows the OP is obtaining the image from a database. The question isn't about uploading an image.

Failure is not an option; it's the default selection.

Not Active21-Mar-12 9:28