Receving this error when trying to display specific data from database to datagridview

-3

It works fine when i select all the data from the database and display it. But when i want to specifically display certain data from the database, that error would show up. (System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.' )

  private void button1_Click(object sender, EventArgs e)

  {

   string selectoledb = "Select * from items where Categories=Fitems";

   command = new OleDbCommand(selectoledb, connection);

   da = new OleDbDataAdapter(command);



    DataTable table = new DataTable();

    itemstxt.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;

    itemstxt.RowTemplate.Height = 120;

    itemstxt.AllowUserToAddRows = false;



    da.Fill(table);



    itemstxt.DataSource = table;



    DataGridViewImageColumn imageColumn = new DataGridViewImageColumn();

    imageColumn = (DataGridViewImageColumn)itemstxt.Columns[3];

    imageColumn.ImageLayout = DataGridViewImageCellLayout.Stretch;



     DataGridViewButtonColumn button = new DataGridViewButtonColumn();

     button.HeaderText = "Buttons";

     button.Name = "button";

     button.Text = "Add to cart";

     button.UseColumnTextForButtonValue = true;

     itemstxt.Columns.Add(button);





     da.Dispose();



    }

edited Jan 17 at 15:11

asked Jan 1 at 16:28

Newbie

1

If Fitems is a string, you need quotes around that (i.e. Categories='Fitems')

– steve16351
Jan 1 at 16:32

oops oh yea that quotes are needed. wow thanks man, i just edited it and it works like a charm.

– Newbie
Jan 1 at 16:36

add a comment |

-3

  private void button1_Click(object sender, EventArgs e)

  {

   string selectoledb = "Select * from items where Categories=Fitems";

   command = new OleDbCommand(selectoledb, connection);

   da = new OleDbDataAdapter(command);



    DataTable table = new DataTable();

    itemstxt.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;

    itemstxt.RowTemplate.Height = 120;

    itemstxt.AllowUserToAddRows = false;



    da.Fill(table);



    itemstxt.DataSource = table;



    DataGridViewImageColumn imageColumn = new DataGridViewImageColumn();

    imageColumn = (DataGridViewImageColumn)itemstxt.Columns[3];

    imageColumn.ImageLayout = DataGridViewImageCellLayout.Stretch;



     DataGridViewButtonColumn button = new DataGridViewButtonColumn();

     button.HeaderText = "Buttons";

     button.Name = "button";

     button.Text = "Add to cart";

     button.UseColumnTextForButtonValue = true;

     itemstxt.Columns.Add(button);





     da.Dispose();



    }

edited Jan 17 at 15:11

asked Jan 1 at 16:28

Newbie

1

If Fitems is a string, you need quotes around that (i.e. Categories='Fitems')

– steve16351
Jan 1 at 16:32

oops oh yea that quotes are needed. wow thanks man, i just edited it and it works like a charm.

– Newbie
Jan 1 at 16:36

add a comment |

-3

  private void button1_Click(object sender, EventArgs e)

  {

   string selectoledb = "Select * from items where Categories=Fitems";

   command = new OleDbCommand(selectoledb, connection);

   da = new OleDbDataAdapter(command);



    DataTable table = new DataTable();

    itemstxt.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;

    itemstxt.RowTemplate.Height = 120;

    itemstxt.AllowUserToAddRows = false;



    da.Fill(table);



    itemstxt.DataSource = table;



    DataGridViewImageColumn imageColumn = new DataGridViewImageColumn();

    imageColumn = (DataGridViewImageColumn)itemstxt.Columns[3];

    imageColumn.ImageLayout = DataGridViewImageCellLayout.Stretch;



     DataGridViewButtonColumn button = new DataGridViewButtonColumn();

     button.HeaderText = "Buttons";

     button.Name = "button";

     button.Text = "Add to cart";

     button.UseColumnTextForButtonValue = true;

     itemstxt.Columns.Add(button);





     da.Dispose();



    }

edited Jan 17 at 15:11

asked Jan 1 at 16:28

Newbie

  private void button1_Click(object sender, EventArgs e)

  {

   string selectoledb = "Select * from items where Categories=Fitems";

   command = new OleDbCommand(selectoledb, connection);

   da = new OleDbDataAdapter(command);



    DataTable table = new DataTable();

    itemstxt.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;

    itemstxt.RowTemplate.Height = 120;

    itemstxt.AllowUserToAddRows = false;



    da.Fill(table);



    itemstxt.DataSource = table;



    DataGridViewImageColumn imageColumn = new DataGridViewImageColumn();

    imageColumn = (DataGridViewImageColumn)itemstxt.Columns[3];

    imageColumn.ImageLayout = DataGridViewImageCellLayout.Stretch;



     DataGridViewButtonColumn button = new DataGridViewButtonColumn();

     button.HeaderText = "Buttons";

     button.Name = "button";

     button.Text = "Add to cart";

     button.UseColumnTextForButtonValue = true;

     itemstxt.Columns.Add(button);





     da.Dispose();



    }

edited Jan 17 at 15:11

asked Jan 1 at 16:28

Newbie

edited Jan 17 at 15:11

asked Jan 1 at 16:28

Newbie

edited Jan 17 at 15:11

asked Jan 1 at 16:28

Newbie

asked Jan 1 at 16:28

Newbie

asked Jan 1 at 16:28

Newbie

1

If Fitems is a string, you need quotes around that (i.e. Categories='Fitems')

– steve16351
Jan 1 at 16:32

oops oh yea that quotes are needed. wow thanks man, i just edited it and it works like a charm.

– Newbie
Jan 1 at 16:36

add a comment |

1

If Fitems is a string, you need quotes around that (i.e. Categories='Fitems')

– steve16351
Jan 1 at 16:32

oops oh yea that quotes are needed. wow thanks man, i just edited it and it works like a charm.

– Newbie
Jan 1 at 16:36

If Fitems is a string, you need quotes around that (i.e. Categories='Fitems')

– steve16351
Jan 1 at 16:32

oops oh yea that quotes are needed. wow thanks man, i just edited it and it works like a charm.

– Newbie
Jan 1 at 16:36

add a comment |

1 Answer
1

active

oldest

votes

you need to add parameter to your select

string selectoledb = "Select * from items where Categories=@Fitems";

command.Parameters.Add("@Fitems", SqlDbType.Varchar).Value = Fitems.Text; //or value you want to filter

answered Jan 1 at 16:36

Fedri Qrueger

573317

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53997067%2freceving-this-error-when-trying-to-display-specific-data-from-database-to-datagr%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

you need to add parameter to your select

string selectoledb = "Select * from items where Categories=@Fitems";

command.Parameters.Add("@Fitems", SqlDbType.Varchar).Value = Fitems.Text; //or value you want to filter

answered Jan 1 at 16:36

Fedri Qrueger

573317

add a comment |

you need to add parameter to your select

string selectoledb = "Select * from items where Categories=@Fitems";

command.Parameters.Add("@Fitems", SqlDbType.Varchar).Value = Fitems.Text; //or value you want to filter

answered Jan 1 at 16:36

Fedri Qrueger

573317

add a comment |

you need to add parameter to your select

string selectoledb = "Select * from items where Categories=@Fitems";

command.Parameters.Add("@Fitems", SqlDbType.Varchar).Value = Fitems.Text; //or value you want to filter

answered Jan 1 at 16:36

Fedri Qrueger

573317

you need to add parameter to your select

string selectoledb = "Select * from items where Categories=@Fitems";

command.Parameters.Add("@Fitems", SqlDbType.Varchar).Value = Fitems.Text; //or value you want to filter

answered Jan 1 at 16:36

Fedri Qrueger

573317

answered Jan 1 at 16:36

Fedri Qrueger

573317

answered Jan 1 at 16:36

Fedri Qrueger

573317

answered Jan 1 at 16:36

Fedri Qrueger

573317

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

Search This Blog

Ufyukyu