show the data in grid view

Question

1.00/5 (1 vote)

See more:

I have to write the code for following situation:
[select the item from dropdownlist then after clicking on button i have to show the information of only selected item in gridview]
. plz help me.
I have created the code but by using my code whole information are seen in gridview.

C#

 SqlConnection cn = new SqlConnection();
            cn.ConnectionString = @"Data Source='XYZ-88EEDEE15AC\SQLEXPRESS';Integrated Security=True;Pooling=False;Initial Catalog='legal'";
            cn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = cn;
            string str = DropDownList1.SelectedItem.Text;
            cmd.CommandText = "select * from branch where" + str;
            cmd.ExecuteNonQuery();
SqlDataAdapter adp = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
adp.Fill(ds);
            GridView1.DataSource = ds;
            GridView1.DataBind();
        }
        catch (Exception ex)
        {
            Response.Write("Error is" + ex.Message);

        }

Posted 8-Jan-13 16:45pm

amu jamdade

Updated 8-Jan-13 16:51pm

AshishChaudha

v2

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

AshishChaudha · Answer 1 · 2013-01-08T16:53:00

Solution 2

There is a problem in following line

C#

cmd.CommandText = "select * from branch where" + str;

It will be like this

C#

cmd.CommandText = "select * from branch where columnname='" + str +"'";

Note: Use parameterized query for better performance.

Thanks

Posted 8-Jan-13 16:53pm

AshishChaudha

Comments

amu jamdade 8-Jan-13 23:09pm

your answer gives following error:
Error isIncorrect syntax near 'item name '.

[no name] 8-Jan-13 23:44pm

'item name' means, that's the column name or dropdown selected item name

pranathis012 · Answer 2 · 2013-01-08T17:07:00

Solution 3

Hi,

Please be use proper select Statement.

SQL

select * from table_name where column_name='string'
or
select * from table_name where column_name=int

please be use proper syntax in select statement

Posted 8-Jan-13 17:07pm

pranathis012

Ronjon1 · Answer 3 · 2013-01-08T17:41:00

Hello,
Here is some issue in your codes,

command text will like this

cmd.CommandText = "select * from Teble_name where columnname = '" + str +"'";

No need this line because ExecuteNonQuery is use for INSERT/UPDATE/DELETE Operation no need for Select operation

cmd.ExecuteNonQuery();

here is a complete code for select data may this help you

string ConnectionString = ConfigurationManager.ConnectionStrings["ConStrName"].ConnectionString;
            DataTable dt = new DataTable();
            string sql = "SELECT * FROM TABLE_NAME WHERE COLUMNNAME = '" + value + "';
            //Take the connection 
            SqlConnection connection = new SqlConnection(ConnectionString);
            try
            {
                //now open the connection
                connection.Open();
                //Take a command with query and connection
                SqlCommand command = new SqlCommand(sql, connection);
                //say the command type
                command.CommandType = CommandType.Text;                
                //take a dataadapter for selecting data 
                SqlDataAdapter DataAd = new SqlDataAdapter(command);
                //fill the datatab 
                DataAd.Fill(dt);
                //close the connection 
                connection.Close();
            GridView1.DataSource = dt;
            GridView1.DataBind();
                //return the table 
                return dt;
            }
            catch (Exception ex)
            {
                connection.Close();
                throw new Exception(ex.Message.ToString());
 
                //or you can throw exception 
            }

Christian Graus · Answer 4 · 2013-01-08T16:50:00

You have several issues. There is no space after 'where'. str needs to contain all the sql ( such as myNAme = 'fred' ). Finally, building SQL by string mashing leaves you open to the most basic of attacks, and should never be done. And of course, you should not be calling SQL from your presentation layer

show the data in grid view

4 solutions

Solution 2

Solution 3

Solution 4

Solution 1

Add your solution here

Preview 0