What is the problem in the code .... Gridcellselect not perform any action

Question

0.00/5 (No votes)

See more:

I have written the Stored procedure "HSNMasterView" for select the value from table

I have written the FillDataGridView function fill the datagridview and call this function in SearchClick

What I have tried:

SQL

// dbo.HSNMasterView
ALTER PROCEDURE dbo.HSNMasterView
@HSNCode int AS SELECT * FROM inv_hsn WHERE  status = 1

c-sharp

//FillDataGridView
private void FillDataGridView()
        {
            try
            {
                if (sqlcon.State == ConnectionState.Closed)
                    sqlcon.Open();
                SqlDataAdapter sqlda = new SqlDataAdapter("HSNMasterView", sqlcon);
                sqlda.SelectCommand.CommandType = CommandType.StoredProcedure;            
sqlda.SelectCommand.Parameters.AddWithValue("@HSNCode",txt_HSNSearch.Text.Trim());
                DataTable dtbl = new DataTable();
                sqlda.Fill(dtbl);
                dgv_HSNMaster.DataSource = dtbl;
                dgv_HSNMaster.Columns[0].Visible = false;
                sqlcon.Close();
            }
            catch (Exception ex)
            { 
                MessageBox.Show(ex.Message);
            }
        }

//Search Code
private void dgv_HSNMaster_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
                FillDataGridView();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Error");
            }
        }

Posted 10-Nov-17 23:19pm

Nil619

Updated 11-Nov-17 0:49am

Suvendu Shekhar Giri

v2

Add a Solution

Comments

Karthik_Mahalingam 11-Nov-17 10:11am

are you getting any error message?

1 solution

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)

Suvendu Shekhar Giri · Answer 1 · 2017-11-11T00:49:00

Everything looks fine except following few things-
1. Your stored procedure expects an INT parameter where as you are passing STRING as parameter.
2. If you haven't called it in the Page_Load or some appropriate event, it will not get loaded.
3. There is no point really to bind the gridview on dgv_HSNMaster_CellClick as it will never be called unless the grid is available to click.
4. I suspect, you want to call the bind grid on a button (search or something) click rather than grid cell click.

Suggestions:
1.

C#

sqlda.SelectCommand.Parameters.AddWithValue("@HSNCode",int.parse(txt_HSNSearch.Text.Trim()));

2. Have a search button(or use if you already have it) and bind the gridview in the button click event.

Please let me know if my assumptions are not correct and your problem is something other than this.

Hope, it helps :)