Mixing
How to enter SELECTED checkbox values in database using C#, SQL Server?
-2
I have set of 10 checkbox on my form. Each checkbox has its own column in the database table.
When the user clicks on some checkbox, the selected checkbox value must be inserted into its column in the database table. Any idea how I can do that?
I have tried this code, but it doesn't work. Only first checkbox value is inserted into its own column, other columns are unaffected.
protected void Button2_Click(object sender, EventArgs e)
{
SqlConnection cnm = new SqlConnection(connStr);
cnm.Open();
if (CheckBox1.Checked)
{
SqlCommand cmd = new SqlCommand("INSERT INTO services(artist) VALUES (@artist)", cnm);
cmd.Parameters.AddWithValue("@artist", CheckBox1.Checked);
cmd.ExecuteReader();
}
else if (CheckBox2.Checked)
{
SqlCommand cmd1 = new SqlCommand("INSERT INTO services(apprepair) VALUES (@apprepair)", cnm);
cmd1.Parameters.AddWithValue("@apprepair", CheckBox2.Checked);
cmd1.ExecuteReader();
}
}
Here's the asp.net markup:
<tr>
<td style="font-family:Muli, sans-serif;">
<div class="form-check">
<asp:CheckBox ID="CheckBox1" runat="server"/>
<label class="form-check-label" style="color:rgb(255,15,15);font-size:20px;" formmethod="post">Artist and Fine Arts </label>
</div>
</td>
<td>
<div class="form-check">
<asp:CheckBox ID="CheckBox2" runat="server"/>
<label class="form-check-label" style="color:rgb(36,0,255);font-family:Muli, sans-serif;font-size:20px;">Appliance Repair</label>
</div>
</td>
</tr>
<tr>
<td>
<div class="form-check">
<asp:CheckBox ID="CheckBox3" runat="server"/>
<label class="form-check-label" runat="server" style="color:rgb(255,0,0);font-family:Muli, sans-serif;font-size:20px;"> Service and Repairs</label>
</div>
</td>
<td>
<div class="form-check">
<asp:CheckBox ID="CheckBox4" runat="server"/>
<label class="form-check-label" runat="server" style="color:rgb(20,0,255);font-family:Muli, sans-serif;font-size:20px;">Carpenter </label>
</div>
</td>
</tr>
<tr>
<td>
<div class="form-check">
<asp:CheckBox ID="CheckBox5" runat="server"/>
<label class="form-check-label" style="color:rgb(255,0,0);font-family:Muli, sans-serif;font-size:20px;">Electrical and Electronics </label>
</div>
</td>
<td>
<div class="form-check">
<asp:CheckBox ID="CheckBox6" runat="server"/>
<label class="form-check-label" style="color:rgb(51,0,255);font-family:Muli, sans-serif;font-size:20px;">I.T Solutions </label>
</div>
</td>
</tr>
.... and so on and so forth ........
c# sql
sql-server database visual-studio edited Jan 1 at 9:12
marc_s
580k13011191266
asked Jan 1 at 5:46
Tanvesh PatilTanvesh Patil
123
add a comment |
-2
I have set of 10 checkbox on my form. Each checkbox has its own column in the database table.
When the user clicks on some checkbox, the selected checkbox value must be inserted into its column in the database table. Any idea how I can do that?
I have tried this code, but it doesn't work. Only first checkbox value is inserted into its own column, other columns are unaffected.
protected void Button2_Click(object sender, EventArgs e)
{
SqlConnection cnm = new SqlConnection(connStr);
cnm.Open();
if (CheckBox1.Checked)
{
SqlCommand cmd = new SqlCommand("INSERT INTO services(artist) VALUES (@artist)", cnm);
cmd.Parameters.AddWithValue("@artist", CheckBox1.Checked);
cmd.ExecuteReader();
}
else if (CheckBox2.Checked)
{
SqlCommand cmd1 = new SqlCommand("INSERT INTO services(apprepair) VALUES (@apprepair)", cnm);
cmd1.Parameters.AddWithValue("@apprepair", CheckBox2.Checked);
cmd1.ExecuteReader();
}
}
Here's the asp.net markup:
<tr>
<td style="font-family:Muli, sans-serif;">
<div class="form-check">
<asp:CheckBox ID="CheckBox1" runat="server"/>
<label class="form-check-label" style="color:rgb(255,15,15);font-size:20px;" formmethod="post">Artist and Fine Arts </label>
</div>
</td>
<td>
<div class="form-check">
<asp:CheckBox ID="CheckBox2" runat="server"/>
<label class="form-check-label" style="color:rgb(36,0,255);font-family:Muli, sans-serif;font-size:20px;">Appliance Repair</label>
</div>
</td>
</tr>
<tr>
<td>
<div class="form-check">
<asp:CheckBox ID="CheckBox3" runat="server"/>
<label class="form-check-label" runat="server" style="color:rgb(255,0,0);font-family:Muli, sans-serif;font-size:20px;"> Service and Repairs</label>
</div>
</td>
<td>
<div class="form-check">
<asp:CheckBox ID="CheckBox4" runat="server"/>
<label class="form-check-label" runat="server" style="color:rgb(20,0,255);font-family:Muli, sans-serif;font-size:20px;">Carpenter </label>
</div>
</td>
</tr>
<tr>
<td>
<div class="form-check">
<asp:CheckBox ID="CheckBox5" runat="server"/>
<label class="form-check-label" style="color:rgb(255,0,0);font-family:Muli, sans-serif;font-size:20px;">Electrical and Electronics </label>
</div>
</td>
<td>
<div class="form-check">
<asp:CheckBox ID="CheckBox6" runat="server"/>
<label class="form-check-label" style="color:rgb(51,0,255);font-family:Muli, sans-serif;font-size:20px;">I.T Solutions </label>
</div>
</td>
</tr>
.... and so on and so forth ........
c# sql
sql-server database visual-studio edited Jan 1 at 9:12
marc_s
580k13011191266
asked Jan 1 at 5:46
Tanvesh PatilTanvesh Patil
123
add a comment |
-2
-2
-2
I have set of 10 checkbox on my form. Each checkbox has its own column in the database table.
When the user clicks on some checkbox, the selected checkbox value must be inserted into its column in the database table. Any idea how I can do that?
I have tried this code, but it doesn't work. Only first checkbox value is inserted into its own column, other columns are unaffected.
protected void Button2_Click(object sender, EventArgs e)
{
SqlConnection cnm = new SqlConnection(connStr);
cnm.Open();
if (CheckBox1.Checked)
{
SqlCommand cmd = new SqlCommand("INSERT INTO services(artist) VALUES (@artist)", cnm);
cmd.Parameters.AddWithValue("@artist", CheckBox1.Checked);
cmd.ExecuteReader();
}
else if (CheckBox2.Checked)
{
SqlCommand cmd1 = new SqlCommand("INSERT INTO services(apprepair) VALUES (@apprepair)", cnm);
cmd1.Parameters.AddWithValue("@apprepair", CheckBox2.Checked);
cmd1.ExecuteReader();
}
}
Here's the asp.net markup:
<tr>
<td style="font-family:Muli, sans-serif;">
<div class="form-check">
<asp:CheckBox ID="CheckBox1" runat="server"/>
<label class="form-check-label" style="color:rgb(255,15,15);font-size:20px;" formmethod="post">Artist and Fine Arts </label>
</div>
</td>
<td>
<div class="form-check">
<asp:CheckBox ID="CheckBox2" runat="server"/>
<label class="form-check-label" style="color:rgb(36,0,255);font-family:Muli, sans-serif;font-size:20px;">Appliance Repair</label>
</div>
</td>
</tr>
<tr>
<td>
<div class="form-check">
<asp:CheckBox ID="CheckBox3" runat="server"/>
<label class="form-check-label" runat="server" style="color:rgb(255,0,0);font-family:Muli, sans-serif;font-size:20px;"> Service and Repairs</label>
</div>
</td>
<td>
<div class="form-check">
<asp:CheckBox ID="CheckBox4" runat="server"/>
<label class="form-check-label" runat="server" style="color:rgb(20,0,255);font-family:Muli, sans-serif;font-size:20px;">Carpenter </label>
</div>
</td>
</tr>
<tr>
<td>
<div class="form-check">
<asp:CheckBox ID="CheckBox5" runat="server"/>
<label class="form-check-label" style="color:rgb(255,0,0);font-family:Muli, sans-serif;font-size:20px;">Electrical and Electronics </label>
</div>
</td>
<td>
<div class="form-check">
<asp:CheckBox ID="CheckBox6" runat="server"/>
<label class="form-check-label" style="color:rgb(51,0,255);font-family:Muli, sans-serif;font-size:20px;">I.T Solutions </label>
</div>
</td>
</tr>
.... and so on and so forth ........
c# sql
sql-server database visual-studio edited Jan 1 at 9:12
marc_s
580k13011191266
asked Jan 1 at 5:46
Tanvesh PatilTanvesh Patil
123
I have set of 10 checkbox on my form. Each checkbox has its own column in the database table.
When the user clicks on some checkbox, the selected checkbox value must be inserted into its column in the database table. Any idea how I can do that?
I have tried this code, but it doesn't work. Only first checkbox value is inserted into its own column, other columns are unaffected.
protected void Button2_Click(object sender, EventArgs e)
{
SqlConnection cnm = new SqlConnection(connStr);
cnm.Open();
if (CheckBox1.Checked)
{
SqlCommand cmd = new SqlCommand("INSERT INTO services(artist) VALUES (@artist)", cnm);
cmd.Parameters.AddWithValue("@artist", CheckBox1.Checked);
cmd.ExecuteReader();
}
else if (CheckBox2.Checked)
{
SqlCommand cmd1 = new SqlCommand("INSERT INTO services(apprepair) VALUES (@apprepair)", cnm);
cmd1.Parameters.AddWithValue("@apprepair", CheckBox2.Checked);
cmd1.ExecuteReader();
}
}
Here's the asp.net markup:
<tr>
<td style="font-family:Muli, sans-serif;">
<div class="form-check">
<asp:CheckBox ID="CheckBox1" runat="server"/>
<label class="form-check-label" style="color:rgb(255,15,15);font-size:20px;" formmethod="post">Artist and Fine Arts </label>
</div>
</td>
<td>
<div class="form-check">
<asp:CheckBox ID="CheckBox2" runat="server"/>
<label class="form-check-label" style="color:rgb(36,0,255);font-family:Muli, sans-serif;font-size:20px;">Appliance Repair</label>
</div>
</td>
</tr>
<tr>
<td>
<div class="form-check">
<asp:CheckBox ID="CheckBox3" runat="server"/>
<label class="form-check-label" runat="server" style="color:rgb(255,0,0);font-family:Muli, sans-serif;font-size:20px;"> Service and Repairs</label>
</div>
</td>
<td>
<div class="form-check">
<asp:CheckBox ID="CheckBox4" runat="server"/>
<label class="form-check-label" runat="server" style="color:rgb(20,0,255);font-family:Muli, sans-serif;font-size:20px;">Carpenter </label>
</div>
</td>
</tr>
<tr>
<td>
<div class="form-check">
<asp:CheckBox ID="CheckBox5" runat="server"/>
<label class="form-check-label" style="color:rgb(255,0,0);font-family:Muli, sans-serif;font-size:20px;">Electrical and Electronics </label>
</div>
</td>
<td>
<div class="form-check">
<asp:CheckBox ID="CheckBox6" runat="server"/>
<label class="form-check-label" style="color:rgb(51,0,255);font-family:Muli, sans-serif;font-size:20px;">I.T Solutions </label>
</div>
</td>
</tr>
.... and so on and so forth ........
c# sql
sql-server database visual-studio c# sql
sql-server database visual-studio edited Jan 1 at 9:12
marc_s
580k13011191266
asked Jan 1 at 5:46
Tanvesh PatilTanvesh Patil
123
edited Jan 1 at 9:12
marc_s
580k13011191266
asked Jan 1 at 5:46
Tanvesh PatilTanvesh Patil
123
edited Jan 1 at 9:12
marc_s
580k13011191266
edited Jan 1 at 9:12
marc_s
580k13011191266
edited Jan 1 at 9:12
marc_s
580k13011191266
580k13011191266
asked Jan 1 at 5:46
Tanvesh PatilTanvesh Patil
123
asked Jan 1 at 5:46
Tanvesh PatilTanvesh Patil
123
asked Jan 1 at 5:46
Tanvesh PatilTanvesh Patil
123
123
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
1
Set field names into Tag of your checkboxes, for example set "artist" into Tag of CheckBox1 then write to your button click:
foreach (Control control in Controls)
if (control is CheckBox)
{
SqlCommand cmd = new SqlCommand($"INSERT INTO services({(control as CheckBox).Tag.ToString()}) VALUES (@a)", cnm);
cmd.Parameters.AddWithValue("@a", (control as CheckBox).Checked);
cmd.ExecuteReader();
}
answered Jan 1 at 6:08
CodeManCodeMan
557311
$ used in VS2017.
– CodeMan
Jan 1 at 6:12
can you please justify the code more , like how to use it for 4 or more checkbox ?
– Tanvesh Patil
Jan 3 at 19:26
add a comment |
0
the issue is not with the SQL But with your C# Code.
if (CheckBox1.Checked)
{
SqlCommand cmd = new SqlCommand("INSERT INTO services(artist) VALUES (@artist)", cnm);
cmd.Parameters.AddWithValue("@artist", CheckBox1.Checked);
cmd.ExecuteReader();
}
**else if (CheckBox2.Checked)-- Issue is Here**
{
SqlCommand cmd1 = new SqlCommand("INSERT INTO services(apprepair) VALUES (@apprepair)", cnm);
cmd1.Parameters.AddWithValue("@apprepair", CheckBox2.Checked);
cmd1.ExecuteReader();
}
In the 2nd If, you are using Else if so If the 1st Checkbox is checked then the remaining conditions won't be executed. Instead, you may use only IF instead of ELSE IF
OR
You Can Directly use the following Approach.
SqlCommand cmd = new SqlCommand("INSERT INTO services(artist) VALUES (@artist)", cnm);
cmd.Parameters.AddWithValue("@artist", CheckBox1.Checked);
cmd.ExecuteNonQuery(); -- Since Insert Statement Wont have any Retun values, Use ExecuteNonQuery
SqlCommand cmd1 = new SqlCommand("INSERT INTO services(apprepair) VALUES (@apprepair)", cnm);
cmd1.Parameters.AddWithValue("@apprepair", CheckBox2.Checked);
cmd.ExecuteNonQuery();
answered Jan 1 at 6:11
Jayasurya SatheeshJayasurya Satheesh
6,00331028
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%2f53993273%2fhow-to-enter-selected-checkbox-values-in-database-using-c-sql-server%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
Set field names into Tag of your checkboxes, for example set "artist" into Tag of CheckBox1 then write to your button click:
foreach (Control control in Controls)
if (control is CheckBox)
{
SqlCommand cmd = new SqlCommand($"INSERT INTO services({(control as CheckBox).Tag.ToString()}) VALUES (@a)", cnm);
cmd.Parameters.AddWithValue("@a", (control as CheckBox).Checked);
cmd.ExecuteReader();
}
answered Jan 1 at 6:08
CodeManCodeMan
557311
$ used in VS2017.
– CodeMan
Jan 1 at 6:12
can you please justify the code more , like how to use it for 4 or more checkbox ?
– Tanvesh Patil
Jan 3 at 19:26
add a comment |
1
Set field names into Tag of your checkboxes, for example set "artist" into Tag of CheckBox1 then write to your button click:
foreach (Control control in Controls)
if (control is CheckBox)
{
SqlCommand cmd = new SqlCommand($"INSERT INTO services({(control as CheckBox).Tag.ToString()}) VALUES (@a)", cnm);
cmd.Parameters.AddWithValue("@a", (control as CheckBox).Checked);
cmd.ExecuteReader();
}
answered Jan 1 at 6:08
CodeManCodeMan
557311
$ used in VS2017.
– CodeMan
Jan 1 at 6:12
can you please justify the code more , like how to use it for 4 or more checkbox ?
– Tanvesh Patil
Jan 3 at 19:26
add a comment |
1
1
1
Set field names into Tag of your checkboxes, for example set "artist" into Tag of CheckBox1 then write to your button click:
foreach (Control control in Controls)
if (control is CheckBox)
{
SqlCommand cmd = new SqlCommand($"INSERT INTO services({(control as CheckBox).Tag.ToString()}) VALUES (@a)", cnm);
cmd.Parameters.AddWithValue("@a", (control as CheckBox).Checked);
cmd.ExecuteReader();
}
answered Jan 1 at 6:08
CodeManCodeMan
557311
Set field names into Tag of your checkboxes, for example set "artist" into Tag of CheckBox1 then write to your button click:
foreach (Control control in Controls)
if (control is CheckBox)
{
SqlCommand cmd = new SqlCommand($"INSERT INTO services({(control as CheckBox).Tag.ToString()}) VALUES (@a)", cnm);
cmd.Parameters.AddWithValue("@a", (control as CheckBox).Checked);
cmd.ExecuteReader();
}
answered Jan 1 at 6:08
CodeManCodeMan
557311
edited Jan 1 at 6:13
answered Jan 1 at 6:08
CodeManCodeMan
557311
answered Jan 1 at 6:08
CodeManCodeMan
557311
answered Jan 1 at 6:08
CodeManCodeMan
557311
557311
$ used in VS2017.
– CodeMan
Jan 1 at 6:12
can you please justify the code more , like how to use it for 4 or more checkbox ?
– Tanvesh Patil
Jan 3 at 19:26
add a comment |
$ used in VS2017.
– CodeMan
Jan 1 at 6:12
can you please justify the code more , like how to use it for 4 or more checkbox ?
– Tanvesh Patil
Jan 3 at 19:26
$ used in VS2017.
– CodeMan
Jan 1 at 6:12
$ used in VS2017.
– CodeMan
Jan 1 at 6:12
can you please justify the code more , like how to use it for 4 or more checkbox ?
– Tanvesh Patil
Jan 3 at 19:26
can you please justify the code more , like how to use it for 4 or more checkbox ?
– Tanvesh Patil
Jan 3 at 19:26
add a comment |
0
the issue is not with the SQL But with your C# Code.
if (CheckBox1.Checked)
{
SqlCommand cmd = new SqlCommand("INSERT INTO services(artist) VALUES (@artist)", cnm);
cmd.Parameters.AddWithValue("@artist", CheckBox1.Checked);
cmd.ExecuteReader();
}
**else if (CheckBox2.Checked)-- Issue is Here**
{
SqlCommand cmd1 = new SqlCommand("INSERT INTO services(apprepair) VALUES (@apprepair)", cnm);
cmd1.Parameters.AddWithValue("@apprepair", CheckBox2.Checked);
cmd1.ExecuteReader();
}
In the 2nd If, you are using Else if so If the 1st Checkbox is checked then the remaining conditions won't be executed. Instead, you may use only IF instead of ELSE IF
OR
You Can Directly use the following Approach.
SqlCommand cmd = new SqlCommand("INSERT INTO services(artist) VALUES (@artist)", cnm);
cmd.Parameters.AddWithValue("@artist", CheckBox1.Checked);
cmd.ExecuteNonQuery(); -- Since Insert Statement Wont have any Retun values, Use ExecuteNonQuery
SqlCommand cmd1 = new SqlCommand("INSERT INTO services(apprepair) VALUES (@apprepair)", cnm);
cmd1.Parameters.AddWithValue("@apprepair", CheckBox2.Checked);
cmd.ExecuteNonQuery();
answered Jan 1 at 6:11
Jayasurya SatheeshJayasurya Satheesh
6,00331028
add a comment |
0
the issue is not with the SQL But with your C# Code.
if (CheckBox1.Checked)
{
SqlCommand cmd = new SqlCommand("INSERT INTO services(artist) VALUES (@artist)", cnm);
cmd.Parameters.AddWithValue("@artist", CheckBox1.Checked);
cmd.ExecuteReader();
}
**else if (CheckBox2.Checked)-- Issue is Here**
{
SqlCommand cmd1 = new SqlCommand("INSERT INTO services(apprepair) VALUES (@apprepair)", cnm);
cmd1.Parameters.AddWithValue("@apprepair", CheckBox2.Checked);
cmd1.ExecuteReader();
}
In the 2nd If, you are using Else if so If the 1st Checkbox is checked then the remaining conditions won't be executed. Instead, you may use only IF instead of ELSE IF
OR
You Can Directly use the following Approach.
SqlCommand cmd = new SqlCommand("INSERT INTO services(artist) VALUES (@artist)", cnm);
cmd.Parameters.AddWithValue("@artist", CheckBox1.Checked);
cmd.ExecuteNonQuery(); -- Since Insert Statement Wont have any Retun values, Use ExecuteNonQuery
SqlCommand cmd1 = new SqlCommand("INSERT INTO services(apprepair) VALUES (@apprepair)", cnm);
cmd1.Parameters.AddWithValue("@apprepair", CheckBox2.Checked);
cmd.ExecuteNonQuery();
answered Jan 1 at 6:11
Jayasurya SatheeshJayasurya Satheesh
6,00331028
add a comment |
0
0
0
the issue is not with the SQL But with your C# Code.
if (CheckBox1.Checked)
{
SqlCommand cmd = new SqlCommand("INSERT INTO services(artist) VALUES (@artist)", cnm);
cmd.Parameters.AddWithValue("@artist", CheckBox1.Checked);
cmd.ExecuteReader();
}
**else if (CheckBox2.Checked)-- Issue is Here**
{
SqlCommand cmd1 = new SqlCommand("INSERT INTO services(apprepair) VALUES (@apprepair)", cnm);
cmd1.Parameters.AddWithValue("@apprepair", CheckBox2.Checked);
cmd1.ExecuteReader();
}
In the 2nd If, you are using Else if so If the 1st Checkbox is checked then the remaining conditions won't be executed. Instead, you may use only IF instead of ELSE IF
OR
You Can Directly use the following Approach.
SqlCommand cmd = new SqlCommand("INSERT INTO services(artist) VALUES (@artist)", cnm);
cmd.Parameters.AddWithValue("@artist", CheckBox1.Checked);
cmd.ExecuteNonQuery(); -- Since Insert Statement Wont have any Retun values, Use ExecuteNonQuery
SqlCommand cmd1 = new SqlCommand("INSERT INTO services(apprepair) VALUES (@apprepair)", cnm);
cmd1.Parameters.AddWithValue("@apprepair", CheckBox2.Checked);
cmd.ExecuteNonQuery();
answered Jan 1 at 6:11
Jayasurya SatheeshJayasurya Satheesh
6,00331028
the issue is not with the SQL But with your C# Code.
if (CheckBox1.Checked)
{
SqlCommand cmd = new SqlCommand("INSERT INTO services(artist) VALUES (@artist)", cnm);
cmd.Parameters.AddWithValue("@artist", CheckBox1.Checked);
cmd.ExecuteReader();
}
**else if (CheckBox2.Checked)-- Issue is Here**
{
SqlCommand cmd1 = new SqlCommand("INSERT INTO services(apprepair) VALUES (@apprepair)", cnm);
cmd1.Parameters.AddWithValue("@apprepair", CheckBox2.Checked);
cmd1.ExecuteReader();
}
In the 2nd If, you are using Else if so If the 1st Checkbox is checked then the remaining conditions won't be executed. Instead, you may use only IF instead of ELSE IF
OR
You Can Directly use the following Approach.
SqlCommand cmd = new SqlCommand("INSERT INTO services(artist) VALUES (@artist)", cnm);
cmd.Parameters.AddWithValue("@artist", CheckBox1.Checked);
cmd.ExecuteNonQuery(); -- Since Insert Statement Wont have any Retun values, Use ExecuteNonQuery
SqlCommand cmd1 = new SqlCommand("INSERT INTO services(apprepair) VALUES (@apprepair)", cnm);
cmd1.Parameters.AddWithValue("@apprepair", CheckBox2.Checked);
cmd.ExecuteNonQuery();
answered Jan 1 at 6:11
Jayasurya SatheeshJayasurya Satheesh
6,00331028
answered Jan 1 at 6:11
Jayasurya SatheeshJayasurya Satheesh
6,00331028
answered Jan 1 at 6:11
Jayasurya SatheeshJayasurya Satheesh
6,00331028
answered Jan 1 at 6:11
Jayasurya SatheeshJayasurya Satheesh
6,00331028
6,00331028
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%2f53993273%2fhow-to-enter-selected-checkbox-values-in-database-using-c-sql-server%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
