Asp.net Datagrid : delete one line at a time even if the same info is in the next line c#
1
I am trying to create a webpage that allow users to unsubscribe from receiving the report.
So far I have created the page. users are able to see all the reports that they are receiving
I have also written an "update replace" statement that, unfortunately this updates everything.
My question is how do I modify my code to only delete one line at a time even if the same info is in the next line
Please see my code below
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
System.Web.UI.WebControls.Label rollno = GridView1.Rows[e.RowIndex].FindControl("Label1") as System.Web.UI.WebControls.Label;
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString;
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE Subscriptions SET Subscriptions.ExtensionSettings = REPLACE('Subscriptions.ExtensionSettings', @ReportSearch, '') WHERE Subscriptions.ExtensionSettings like '@ReportSearch'" ;
cmd.Parameters.AddWithValue("ReportSearch", TxtSearch.Text);
cmd.Connection = con;
cmd.ExecuteNonQuery();
GridView1.EditIndex = -1;
GridView1.DataSource = SqlDataSource1;
GridView1.DataBind();
}
c# asp.net .net datagridview webforms
edited Nov 28 '18 at 12:01
S.Akbari
30.5k93774
asked Nov 28 '18 at 11:58
OlaOla
61
add a comment |
1
I am trying to create a webpage that allow users to unsubscribe from receiving the report.
So far I have created the page. users are able to see all the reports that they are receiving
I have also written an "update replace" statement that, unfortunately this updates everything.
My question is how do I modify my code to only delete one line at a time even if the same info is in the next line
Please see my code below
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
System.Web.UI.WebControls.Label rollno = GridView1.Rows[e.RowIndex].FindControl("Label1") as System.Web.UI.WebControls.Label;
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString;
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE Subscriptions SET Subscriptions.ExtensionSettings = REPLACE('Subscriptions.ExtensionSettings', @ReportSearch, '') WHERE Subscriptions.ExtensionSettings like '@ReportSearch'" ;
cmd.Parameters.AddWithValue("ReportSearch", TxtSearch.Text);
cmd.Connection = con;
cmd.ExecuteNonQuery();
GridView1.EditIndex = -1;
GridView1.DataSource = SqlDataSource1;
GridView1.DataBind();
}
c# asp.net .net datagridview webforms
edited Nov 28 '18 at 12:01
S.Akbari
30.5k93774
asked Nov 28 '18 at 11:58
OlaOla
61
'@ReportSearch'should be@ReportSearch. It shouldn't have quotes around it.
– mjwills
Nov 28 '18 at 12:03
Possible duplicate of How to update top 1 row in SQL Server
– mjwills
Nov 28 '18 at 12:06
@mjwills thanks for your reply it's not quite the same, my issue is with the c# code not the sql
– Ola
Nov 28 '18 at 14:18
@s.akbari can you please have a look at this for me please I am new to asp.net and c#
– Ola
Nov 28 '18 at 15:53
First what is your SqlDataSource1, it is not updated anywhere in this code. Also share some data and what you type in the search text. To update just one row you must use one unique identifier in your update statement. You started that with 'rollno' but never used it. Probably that is your issue.
– SehaxX
Nov 29 '18 at 8:00
add a comment |
1
1
1
I am trying to create a webpage that allow users to unsubscribe from receiving the report.
So far I have created the page. users are able to see all the reports that they are receiving
I have also written an "update replace" statement that, unfortunately this updates everything.
My question is how do I modify my code to only delete one line at a time even if the same info is in the next line
Please see my code below
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
System.Web.UI.WebControls.Label rollno = GridView1.Rows[e.RowIndex].FindControl("Label1") as System.Web.UI.WebControls.Label;
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString;
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE Subscriptions SET Subscriptions.ExtensionSettings = REPLACE('Subscriptions.ExtensionSettings', @ReportSearch, '') WHERE Subscriptions.ExtensionSettings like '@ReportSearch'" ;
cmd.Parameters.AddWithValue("ReportSearch", TxtSearch.Text);
cmd.Connection = con;
cmd.ExecuteNonQuery();
GridView1.EditIndex = -1;
GridView1.DataSource = SqlDataSource1;
GridView1.DataBind();
}
c# asp.net .net datagridview webforms
edited Nov 28 '18 at 12:01
S.Akbari
30.5k93774
asked Nov 28 '18 at 11:58
OlaOla
61
I am trying to create a webpage that allow users to unsubscribe from receiving the report.
So far I have created the page. users are able to see all the reports that they are receiving
I have also written an "update replace" statement that, unfortunately this updates everything.
My question is how do I modify my code to only delete one line at a time even if the same info is in the next line
Please see my code below
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
System.Web.UI.WebControls.Label rollno = GridView1.Rows[e.RowIndex].FindControl("Label1") as System.Web.UI.WebControls.Label;
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString;
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "UPDATE Subscriptions SET Subscriptions.ExtensionSettings = REPLACE('Subscriptions.ExtensionSettings', @ReportSearch, '') WHERE Subscriptions.ExtensionSettings like '@ReportSearch'" ;
cmd.Parameters.AddWithValue("ReportSearch", TxtSearch.Text);
cmd.Connection = con;
cmd.ExecuteNonQuery();
GridView1.EditIndex = -1;
GridView1.DataSource = SqlDataSource1;
GridView1.DataBind();
}
c# asp.net .net datagridview webforms
c# asp.net .net datagridview webforms
edited Nov 28 '18 at 12:01
S.Akbari
30.5k93774
asked Nov 28 '18 at 11:58
OlaOla
61
edited Nov 28 '18 at 12:01
S.Akbari
30.5k93774
asked Nov 28 '18 at 11:58
OlaOla
61
edited Nov 28 '18 at 12:01
S.Akbari
30.5k93774
edited Nov 28 '18 at 12:01
S.Akbari
30.5k93774
edited Nov 28 '18 at 12:01
S.Akbari
30.5k93774
30.5k93774
asked Nov 28 '18 at 11:58
OlaOla
61
asked Nov 28 '18 at 11:58
OlaOla
61
asked Nov 28 '18 at 11:58
OlaOla
61
61
'@ReportSearch'should be@ReportSearch. It shouldn't have quotes around it.
– mjwills
Nov 28 '18 at 12:03
Possible duplicate of How to update top 1 row in SQL Server
– mjwills
Nov 28 '18 at 12:06
@mjwills thanks for your reply it's not quite the same, my issue is with the c# code not the sql
– Ola
Nov 28 '18 at 14:18
@s.akbari can you please have a look at this for me please I am new to asp.net and c#
– Ola
Nov 28 '18 at 15:53
First what is your SqlDataSource1, it is not updated anywhere in this code. Also share some data and what you type in the search text. To update just one row you must use one unique identifier in your update statement. You started that with 'rollno' but never used it. Probably that is your issue.
– SehaxX
Nov 29 '18 at 8:00
add a comment |
'@ReportSearch'should be@ReportSearch. It shouldn't have quotes around it.
– mjwills
Nov 28 '18 at 12:03
Possible duplicate of How to update top 1 row in SQL Server
– mjwills
Nov 28 '18 at 12:06
@mjwills thanks for your reply it's not quite the same, my issue is with the c# code not the sql
– Ola
Nov 28 '18 at 14:18
@s.akbari can you please have a look at this for me please I am new to asp.net and c#
– Ola
Nov 28 '18 at 15:53
First what is your SqlDataSource1, it is not updated anywhere in this code. Also share some data and what you type in the search text. To update just one row you must use one unique identifier in your update statement. You started that with 'rollno' but never used it. Probably that is your issue.
– SehaxX
Nov 29 '18 at 8:00
'@ReportSearch' should be @ReportSearch. It shouldn't have quotes around it.– mjwills
Nov 28 '18 at 12:03
'@ReportSearch' should be @ReportSearch. It shouldn't have quotes around it.– mjwills
Nov 28 '18 at 12:03
Possible duplicate of How to update top 1 row in SQL Server
– mjwills
Nov 28 '18 at 12:06
Possible duplicate of How to update top 1 row in SQL Server
– mjwills
Nov 28 '18 at 12:06
@mjwills thanks for your reply it's not quite the same, my issue is with the c# code not the sql
– Ola
Nov 28 '18 at 14:18
@mjwills thanks for your reply it's not quite the same, my issue is with the c# code not the sql
– Ola
Nov 28 '18 at 14:18
@s.akbari can you please have a look at this for me please I am new to asp.net and c#
– Ola
Nov 28 '18 at 15:53
@s.akbari can you please have a look at this for me please I am new to asp.net and c#
– Ola
Nov 28 '18 at 15:53
First what is your SqlDataSource1, it is not updated anywhere in this code. Also share some data and what you type in the search text. To update just one row you must use one unique identifier in your update statement. You started that with 'rollno' but never used it. Probably that is your issue.
– SehaxX
Nov 29 '18 at 8:00
First what is your SqlDataSource1, it is not updated anywhere in this code. Also share some data and what you type in the search text. To update just one row you must use one unique identifier in your update statement. You started that with 'rollno' but never used it. Probably that is your issue.
– SehaxX
Nov 29 '18 at 8:00
add a comment |
0
active
oldest
votes
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%2f53518971%2fasp-net-datagrid-delete-one-line-at-a-time-even-if-the-same-info-is-in-the-nex%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f53518971%2fasp-net-datagrid-delete-one-line-at-a-time-even-if-the-same-info-is-in-the-nex%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
'@ReportSearch'should be@ReportSearch. It shouldn't have quotes around it.– mjwills
Nov 28 '18 at 12:03
Possible duplicate of How to update top 1 row in SQL Server
– mjwills
Nov 28 '18 at 12:06
@mjwills thanks for your reply it's not quite the same, my issue is with the c# code not the sql
– Ola
Nov 28 '18 at 14:18
@s.akbari can you please have a look at this for me please I am new to asp.net and c#
– Ola
Nov 28 '18 at 15:53
First what is your SqlDataSource1, it is not updated anywhere in this code. Also share some data and what you type in the search text. To update just one row you must use one unique identifier in your update statement. You started that with 'rollno' but never used it. Probably that is your issue.
– SehaxX
Nov 29 '18 at 8:00