Ad:

ASP.NET Discussion Thread
Unsolved
Views: 624

Nov 27th, 2008

error on search code

Expand Post »

hai friends i am writing the code for search button;

while i am wrote and complied that it gives the following error.
so many times i checked and posting into the forum now please clarify this problem..

code is:

asp.net Syntax (Toggle Plain Text)
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
 
public partial class nextpage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection("user id=sa;password=vikram;database=MUDIAM_INC");
        SqlCommand cmd = new SqlCommand("select * from mudiamINC", con);
        cmd.Connection = con;
        con.Open();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection("user id=sa;password=vikram;database=MUDIAM_INC");
        SqlDataAdapter da = new SqlDataAdapter("select * from mudiamINC where fname like" + TextBox1.Text + " %", con);
        DataSet ds = new DataSet();
        da.Fill(ds, "mudiamINC");
        con.Open();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "select * from mudiamINC";
 
    }
}
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class nextpage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection("user id=sa;password=vikram;database=MUDIAM_INC");
        SqlCommand cmd = new SqlCommand("select * from mudiamINC", con);
        cmd.Connection = con;
        con.Open();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection("user id=sa;password=vikram;database=MUDIAM_INC");
        SqlDataAdapter da = new SqlDataAdapter("select * from mudiamINC where fname like" + TextBox1.Text + " %", con);
        DataSet ds = new DataSet();
        da.Fill(ds, "mudiamINC");
        con.Open();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = "select * from mudiamINC";

    }
}

Error Is:

ASP.NET Syntax (Toggle Plain Text)
An expression of non-boolean type specified in a context where a condition is expected, near 'likekrani'
An expression of non-boolean type specified in a context where a condition is expected, near 'likekrani'

please check the error and tell me the correct solution for that..
ASAP

another one is search information could be displayed in the browser in a tabular format.
please clarify my doubt.

please...please...please...please...please...please...please...please...

Last edited by peter_budo; Nov 28th, 2008 at 1:28 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

Similar Threads

Search code in a database in Visual Basic 4 / 5 / 6
'Object variable or With block variable not set' Error in ASP.NET
Visual C++ error LNK2022: metadata operation failed (80131187) in C++
Error while executing in Java
binary search in C++

krany18

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

19 posts
since Nov 2008

Permalink

Nov 27th, 2008

Re: error on search code

I think the problem is where you're building your select

ASP.NET Syntax (Toggle Plain Text)
SqlDataAdapter da = new SqlDataAdapter("select * from mudiamINC where fname like" + TextBox1.Text + " %", con);
SqlDataAdapter da = new SqlDataAdapter("select * from mudiamINC where fname like" + TextBox1.Text + " %", con);

I'm think you need a space after the like, but not before the %

ASP.NET Syntax (Toggle Plain Text)
SqlDataAdapter da = new SqlDataAdapter("select * from mudiamINC where fname like " + TextBox1.Text + "%", con);
SqlDataAdapter da = new SqlDataAdapter("select * from mudiamINC where fname like " + TextBox1.Text + "%", con);

Note however that I suspect this code is 'bad form'. You are taking user input without validation and putting it into SQL queries. This potentially puts your application at risk for SQL injection attacks.

Murtan

Reputation Points: 344

Solved Threads: 116

Practically a Master Poster

Offline

670 posts
since May 2008

Permalink

Nov 28th, 2008

Re: error on search code

please send me the correct code for that...

krany18

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

19 posts
since Nov 2008

Permalink

Nov 28th, 2008

Re: error on search code

I think for testing your example, you could ignore the 'bad form'.

But if this will be accessed by other people (especially the public) that might ever have malicious intent then you should address this and any other code that might be subject to attack.

For more information on protecting yourself from SQL Injection attacks, I recommend the following article:

http://msdn.microsoft.com/en-us/library/ms998271.aspx

Murtan

Reputation Points: 344

Solved Threads: 116

Practically a Master Poster

Offline

670 posts
since May 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: I'm new and need help and advice!

Next Thread in ASP.NET Forum Timeline: creating pdf files

DaniWeb Message

Cancel Changes

User Name
Password