C# Mysql gridview trim error Cannot find column [Patient_ID]

Question

0.00/5 (No votes)

See more:

Here is the code below. but, i use the same code for other gird views it works like charm here it is showing this error why is that thanks in advance

C#

<pre lang="cs">public void searchbasedidadddetailsupdate()
        {
            try
            {
                con.Open();

                DataView view = new DataView();
                view.Table = ds.Tables[0];
                view.RowFilter = "Patient_ID = '" + txtupdatesearch.Text.Trim() + "'";
                dtvupdate.DataSource = view;

                if (dtvupdate.RowCount < 1)
                {
                    MessageBox.Show("Invalide ID! Please select Patient ID from the following combobox or try again", "Medi Alert Patien Care System", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            }
            catch (MySqlException ms)
            {
                MessageBox.Show(ms.Message);
            }


            con.Close();
        }

Posted 19-Jun-14 7:06am

zakirox123

Updated 19-Jun-14 7:09am

v2

Add a Solution

Comments

ZurdoDev 19-Jun-14 13:08pm

What's your question?

zakirox123 19-Jun-14 13:11pm

when i try to trim the particular column based on patient ID from patient information which i have been already connected to the grid view but, it says no column found

ZurdoDev 19-Jun-14 13:17pm

That means that ds.Tables[0] does not have a column named Patient_ID . Where is ds? You'll have to debug it to figure out why.

zakirox123 19-Jun-14 13:29pm

Hi, every thing was ok it is showing the database on the particular grid view but, the problem is with the trim. my previous grid views are working perfect with the same code.
public void showdatabase()
{
con.Open();
da = new MySqlDataAdapter("select * from patientinformation", con);
ds = new DataSet();
da.Fill(ds);
dtvupdate.DataSource = ds.Tables[0];
con.Close();

}

ZurdoDev 19-Jun-14 13:36pm

The only Trim you have is on a textbox. There is no way that is the issue.

zakirox123 19-Jun-14 13:44pm

i don't think so because this is the code which is same like the previous i have mentioned above. but, this works perfect

public void showchannelingdatabase() {

con.Open();
da = new MySqlDataAdapter("select * from channeling", con);
ds = new DataSet();
da.Fill(ds);
dgvchanneling.DataSource = ds.Tables[0];
dgvchannelingupdate.DataSource = ds.Tables[0];
con.Close();

}

public void searchbasedidupdate()
{

try
{
con.Open();

DataView view = new DataView();
view.Table = ds.Tables[0];
view.RowFilter = "Channeling_ID = '" + cmbchannelingidupdate.Text.Trim() + "'";
dgvchannelingupdate.DataSource = view;

if (dgvchannelingupdate.RowCount < 1)
{
MessageBox.Show("Invalide ID! Please select Channeling ID from the following combobox or try again", "Medi Alert Patien Care System", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (MySqlException ms)
{
MessageBox.Show(ms.Message);
}

con.Close();
}

ZurdoDev 19-Jun-14 13:56pm

Trim cannot possibly give that error you are getting. The error is because Patient_ID is not in your select statement. You aren't showing all the code so no one can point it out to you. Wherever you are filling your DataSet, like above you have SELECT * FROM channeling. Wherever you do that for the other one, Patient_ID is not in there. It's that simple.

zakirox123 19-Jun-14 14:14pm

here is my full set of code i think the problem arise because i am trying to show both database with the single data set and data adapter

namespace MediAlert.Patient
{
public partial class Patient_Details : Form
{

//database connection {
MySqlConnection con;
dbconnection dbcon = new dbconnection();
MySqlDataAdapter da;
DataSet ds;
MySqlDataReader dr;
//}

public Patient_Details()
{
InitializeComponent();
}

private void Patient_Details_Load(object sender, EventArgs e)
{

con = dbcon.openconnection();
showdatabase();
showchannelingdatabase();

}
public void showdatabase()
{
con.Open();
da = new MySqlDataAdapter("select * from patientinformation", con);
ds = new DataSet();
da.Fill(ds);
dtvupdate.DataSource = ds.Tables[0];
con.Close();

}

public void showchannelingdatabase() {

con.Open();
da = new MySqlDataAdapter("select * from channeling", con);
ds = new DataSet();
da.Fill(ds);
dgvchannelingupdate.DataSource = ds.Tables[0];
con.Close();

}

public void searchbasedidadddetailsupdate()
{
try
{
con.Open();

DataView view = new DataView();
view.Table = ds.Tables[0];
view.RowFilter = "Patient_ID = '" + txtupdatesearch.Text.Trim() + "'";
dtvupdate.DataSource = view;

if (dtvupdate.RowCount < 1)
{
MessageBox.Show("Invalide ID! Please select Patient ID from the following combobox or try again", "Medi Alert Patien Care System", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (MySqlException ms)
{
MessageBox.Show(ms.Message);
}

con.Close();
}

public void searchbasedidupdate()
{

try
{
con.Open();

DataView view = new DataView();
view.Table = ds.Tables[0];
view.RowFilter = "Channeling_ID = '" + cmbchannelingidupdate.Text.Trim() + "'";
dgvchannelingupdate.DataSource = view;

if (dgvchannelingupdate.RowCount < 1)
{
MessageBox.Show("Invalide ID! Please select Channeling ID from the following combobox or try again", "Medi Alert Patien Care System", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (MySqlException ms)
{
MessageBox.Show(ms.Message);
}

con.Close();
}

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)

Jafarinejadvazifehkhorani · Accepted Answer · 2014-06-19T11:15:00

in theas two methods you are filling the same Dataset, which means after filling the second one, it's gonna overwrite what you had in the first data population.

C#

showdatabase();
           showchannelingdatabase();

Basically you need to update your code with the following :

namespace MediAlert.Patient
   {
       public partial class Patient_Details : Form
       {

           //database connection {
           private MySqlConnection con;
           private dbconnection dbcon = new dbconnection();
           private MySqlDataAdapter da;
           private DataSet ds = new DataSet();
           private MySqlDataReader dr;
           //}

           public Patient_Details()
           {
               InitializeComponent();
           }

           private void Patient_Details_Load(object sender, EventArgs e)
           {


               con = dbcon.openconnection();
               showdatabase();
               showchannelingdatabase();

           }

           public void showdatabase()
           {
               con.Open();
               da = new MySqlDataAdapter("select * from patientinformation", con);
              // ds = new DataSet();
               da.Fill(ds,"table0");
               dtvupdate.DataSource = ds.Tables["table0"];
               con.Close();

           }

           public void showchannelingdatabase()
           {

               con.Open();
               da = new MySqlDataAdapter("select * from channeling", con);
              // ds = new DataSet();
               da.Fill(ds, "table1");
               dgvchannelingupdate.DataSource = ds.Tables["table1"];
               con.Close();


           }

           public void searchbasedidadddetailsupdate()
           {
               try
               {
                   con.Open();

                   DataView view = new DataView();
                   view.Table = ds.Tables["table0"];
                   view.RowFilter = "Patient_ID = '" + txtupdatesearch.Text.Trim() + "'";
                   dtvupdate.DataSource = view;

                   if (dtvupdate.RowCount < 1)
                   {
                       MessageBox.Show(
                           "Invalide ID! Please select Patient ID from the following combobox or try again",
                           "Medi Alert Patien Care System", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                   }
               }
               catch (MySqlException ms)
               {
                   MessageBox.Show(ms.Message);
               }


               con.Close();
           }

           public void searchbasedidupdate()
           {

               try
               {
                   con.Open();

                   DataView view = new DataView();
                   view.Table = ds.Tables["table1"];
                   view.RowFilter = "Channeling_ID = '" + cmbchannelingidupdate.Text.Trim() + "'";
                   dgvchannelingupdate.DataSource = view;

                   if (dgvchannelingupdate.RowCount < 1)
                   {
                       MessageBox.Show(
                           "Invalide ID! Please select Channeling ID from the following combobox or try again",
                           "Medi Alert Patien Care System", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                   }
               }
               catch (MySqlException ms)
               {
                   MessageBox.Show(ms.Message);
               }


               con.Close();
           }
       }
   }