how to bind gridview data from dropdownlist outside the gridview ..

Question

0.00/5 (No votes)

See more:

SQL

CREATE PROCEDURE hms.`Select_Parameter`(_Branch_Id int ,_Tenant_Id int)
BEGIN
 SELECT a.ParameterName,
             a.Target_Value,
             b.Last_Date,
             b.Result,
             b.Measurement_Frequency,
             b.Next_Due_Date,
             a.Remarks,
             a.Active
        FROM    patient_progress_tracking b
             INNER JOIN
                disease_parameter a
             ON a.ParameterId = b.ParameterId
       WHERE  a.Branch_Id=_Branch_Id and a.Tenant_Id=_Tenant_Id ;

END;

this is my procedure and and below is bindgrid()

C#

protected void BindCarePlan()
       {

           MySqlConnection strConnection = new MySqlConnection();
           strConnection.ConnectionString = StrConn;
           MySqlCommand strCommand = new MySqlCommand();

           try
           {
               strConnection.Open();


                   strCommand.CommandType = CommandType.StoredProcedure;
                   strCommand.CommandText = "Select_Parameter";

               strCommand.Connection = strConnection;

               strCommand.Parameters.AddWithValue("_Tenant_Id", Convert.ToInt32(Session["Tenant_Id"]));
               strCommand.Parameters.AddWithValue("_Branch_Id", Convert.ToInt32(Session["Branch_Id"]));

               MySqlDataAdapter da = new MySqlDataAdapter(strCommand);
               DataTable dt = new DataTable();
               da.Fill(dt);
               grdcareplan.DataSource = dt;
               grdcareplan.DataBind();

           }

           catch (Exception ex)
           {
               obj.InfoEntry(DateTime.Now + "     " + " BindCarePlan" + "     " + "HomeHealthCare.aspx" + "     " + ex.Message, "");
               obj.InfoEntry(DateTime.Now + "     " + ex.StackTrace, "");
               Session["strerrormsg"] = DateTime.Now + "     " + " BindCarePlan" + "     " + "HomeHealthCare.aspx" + "     " + ex.Message;
               Session["strerrortrace"] = DateTime.Now + "     " + ex.StackTrace;
               Response.Redirect("ErrorPage.aspx");
           }

           finally
           {
               // GridViewBill.DataBind();
               strConnection.Close();
           }

       }

i am having dropdownlist of diseasename..which is outside the gridview..by selecting diseasename i want to bind parameter with gridview...
so what should i write in selectedindex changed event of dropdownlist and also what will be the modification in procedure as i am also having DiseaseId Coloumne in disease_parameter table

Posted 17-Dec-12 22:53pm

ujali

Updated 17-Dec-12 23:06pm

AshishChaudha

v2

Add a Solution

Comments

AshishChaudha 18-Dec-12 5:09am

What problem you are facing?? are you getting any exception??

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)

ashokmmrk · Answer 1 · 2012-12-17T23:04:00

Hi,

try this

on selectedindex changed event of dropdownlist, you can bind the gridview by passing selected diseases_id (or) diseases name of dropdown list

SQL

CREATE PROCEDURE hms.`Select_Parameter`(_Branch_Id int ,_Tenant_Id int,_Disease_Id int )
BEGIN
 SELECT a.ParameterName,
             a.Target_Value,
             b.Last_Date,
             b.Result,
             b.Measurement_Frequency,
             b.Next_Due_Date,
             a.Remarks,
             a.Active
        FROM    patient_progress_tracking b
             INNER JOIN
                disease_parameter a
             ON a.ParameterId = b.ParameterId
       WHERE  a.Branch_Id=_Branch_Id and a.Tenant_Id=_Tenant_Id and a.DiseaseId=_Disease_Id;

END;

AshishChaudha · Answer 2 · 2012-12-17T23:11:00

you can simply call your

VB

BindCarePlan()

on selectedIndexChange of the Dropdownlist ddldisease and pass parameters to the procedure. No need of using session for this.

C#

strCommand.Parameters.AddWithValue("_Tenant_Id", Convert.ToInt32(ddlTenant.SelectedValue));
                strCommand.Parameters.AddWithValue("_Branch_Id", Convert.ToInt32(ddlBranch.SelectedValue));

ujali · Answer 3 · 2012-12-17T23:15:00

SQL

CREATE PROCEDURE hms.`Select_Parameter`(_Branch_Id int ,_Tenant_Id int,_Disease_Id int )
BEGIN
 SELECT a.ParameterName,
             a.Target_Value,
             b.Last_Date,
             b.Result,
             b.Measurement_Frequency,
             b.Next_Due_Date,
             a.Remarks,
             a.Active
        FROM    patient_progress_tracking b
             INNER JOIN
                disease_parameter a
             ON a.ParameterId = b.ParameterId
       WHERE  a.Branch_Id=_Branch_Id and a.Tenant_Id=_Tenant_Id and a.DiseaseId=_Disease_Id;

END;

if i am taking this then what shud i write in selectedindexchanged event of dropdownlis

ujali · Answer 4 · 2012-12-17T23:22:00

Solution 4

I am Only having DiseaseName in dropdownlist

Posted 17-Dec-12 23:22pm

ujali

Comments

Anuja Pawar Indore 18-Dec-12 6:20am

Post it as a comment, this is not answer

how to bind gridview data from dropdownlist outside the gridview ..

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0