Mixing
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();
}
c#
asked Jan 1 at 16:28
NewbieNewbie
11
add a comment |
-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();
}
c#
asked Jan 1 at 16:28
NewbieNewbie
11
1
IfFitemsis 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
-3
-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();
}
c#
asked Jan 1 at 16:28
NewbieNewbie
11
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();
}
c#
c#
asked Jan 1 at 16:28
NewbieNewbie
11
asked Jan 1 at 16:28
NewbieNewbie
11
edited Jan 17 at 15:11
Newbie
asked Jan 1 at 16:28
NewbieNewbie
11
asked Jan 1 at 16:28
NewbieNewbie
11
asked Jan 1 at 16:28
NewbieNewbie
11
11
1
IfFitemsis 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
IfFitemsis 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
1
1
If
Fitems is a string, you need quotes around that (i.e. Categories='Fitems')– steve16351
Jan 1 at 16:32
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
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
0
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 QruegerFedri 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');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
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
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
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 QruegerFedri Qrueger
573317
add a comment |
0
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 QruegerFedri Qrueger
573317
add a comment |
0
0
0
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 QruegerFedri 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 QruegerFedri Qrueger
573317
answered Jan 1 at 16:36
Fedri QruegerFedri Qrueger
573317
answered Jan 1 at 16:36
Fedri QruegerFedri Qrueger
573317
answered Jan 1 at 16:36
Fedri QruegerFedri Qrueger
573317
573317
add a comment |
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');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
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
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
If
Fitemsis 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