Input string was not in a correct format while updating row in gridview?
0
I am having problem when update my OrderStatus 'P' TO 'A'. Datatype in
SQL server is varchar(50).
protected void grdNewOrder_RowUpdating(object sender, GridViewUpdateEventArgs e)
using (SqlConnection sqlCon = new SqlConnection(constring))
sqlCon.Open();
string query = "UPDATE tblPurchase SET OrderStatus ='A' WHERE PurchaseID= @id";
SqlCommand sqlCmd = new SqlCommand(query, sqlCon);
sqlCmd.Parameters.AddWithValue("@id", Convert.ToInt32(grdNewOrder.DataKeys[e.RowIndex].Value.ToString()));
sqlCmd.ExecuteNonQuery();
LoadNewOrders();
lblsucessmsg.Text = "Selected Record Updated";
lblerror.Text = "";
catch (Exception ex)
lblsucessmsg.Text = "";
lblerror.Text = ex.Message;
asp.net
sql-server edited Nov 14 '18 at 17:20
Larnu
21.1k51733
asked Nov 14 '18 at 17:15
Arslan jappaArslan jappa
46
add a comment |
0
I am having problem when update my OrderStatus 'P' TO 'A'. Datatype in
SQL server is varchar(50).
protected void grdNewOrder_RowUpdating(object sender, GridViewUpdateEventArgs e)
using (SqlConnection sqlCon = new SqlConnection(constring))
sqlCon.Open();
string query = "UPDATE tblPurchase SET OrderStatus ='A' WHERE PurchaseID= @id";
SqlCommand sqlCmd = new SqlCommand(query, sqlCon);
sqlCmd.Parameters.AddWithValue("@id", Convert.ToInt32(grdNewOrder.DataKeys[e.RowIndex].Value.ToString()));
sqlCmd.ExecuteNonQuery();
LoadNewOrders();
lblsucessmsg.Text = "Selected Record Updated";
lblerror.Text = "";
catch (Exception ex)
lblsucessmsg.Text = "";
lblerror.Text = ex.Message;
asp.net
sql-server edited Nov 14 '18 at 17:20
Larnu
21.1k51733
asked Nov 14 '18 at 17:15
Arslan jappaArslan jappa
46
And what was that error?
– Larnu
Nov 14 '18 at 17:20
Assign this sectiongrdNewOrder.DataKeys[e.RowIndex].Value.ToString()to a variable before converting it to an Int and check if it is a number. You cannot useConvert.ToInt32on a non-numeric string
– Dumisani
Nov 14 '18 at 17:20
@Dumisani thanks, I have been trying to solve this problem for last three hours but thank you very much for saving my time by solving my problem.
– Arslan jappa
Nov 14 '18 at 17:29
@Arslanjappa glad I could help
– Dumisani
Nov 14 '18 at 18:27
add a comment |
0
0
0
I am having problem when update my OrderStatus 'P' TO 'A'. Datatype in
SQL server is varchar(50).
protected void grdNewOrder_RowUpdating(object sender, GridViewUpdateEventArgs e)
using (SqlConnection sqlCon = new SqlConnection(constring))
sqlCon.Open();
string query = "UPDATE tblPurchase SET OrderStatus ='A' WHERE PurchaseID= @id";
SqlCommand sqlCmd = new SqlCommand(query, sqlCon);
sqlCmd.Parameters.AddWithValue("@id", Convert.ToInt32(grdNewOrder.DataKeys[e.RowIndex].Value.ToString()));
sqlCmd.ExecuteNonQuery();
LoadNewOrders();
lblsucessmsg.Text = "Selected Record Updated";
lblerror.Text = "";
catch (Exception ex)
lblsucessmsg.Text = "";
lblerror.Text = ex.Message;
asp.net
sql-server edited Nov 14 '18 at 17:20
Larnu
21.1k51733
asked Nov 14 '18 at 17:15
Arslan jappaArslan jappa
46
I am having problem when update my OrderStatus 'P' TO 'A'. Datatype in
SQL server is varchar(50).
protected void grdNewOrder_RowUpdating(object sender, GridViewUpdateEventArgs e)
using (SqlConnection sqlCon = new SqlConnection(constring))
sqlCon.Open();
string query = "UPDATE tblPurchase SET OrderStatus ='A' WHERE PurchaseID= @id";
SqlCommand sqlCmd = new SqlCommand(query, sqlCon);
sqlCmd.Parameters.AddWithValue("@id", Convert.ToInt32(grdNewOrder.DataKeys[e.RowIndex].Value.ToString()));
sqlCmd.ExecuteNonQuery();
LoadNewOrders();
lblsucessmsg.Text = "Selected Record Updated";
lblerror.Text = "";
catch (Exception ex)
lblsucessmsg.Text = "";
lblerror.Text = ex.Message;
asp.net
sql-server asp.net
sql-server edited Nov 14 '18 at 17:20
Larnu
21.1k51733
asked Nov 14 '18 at 17:15
Arslan jappaArslan jappa
46
edited Nov 14 '18 at 17:20
Larnu
21.1k51733
asked Nov 14 '18 at 17:15
Arslan jappaArslan jappa
46
edited Nov 14 '18 at 17:20
Larnu
21.1k51733
edited Nov 14 '18 at 17:20
Larnu
21.1k51733
edited Nov 14 '18 at 17:20
Larnu
21.1k51733
21.1k51733
asked Nov 14 '18 at 17:15
Arslan jappaArslan jappa
46
asked Nov 14 '18 at 17:15
Arslan jappaArslan jappa
46
asked Nov 14 '18 at 17:15
Arslan jappaArslan jappa
46
46
And what was that error?
– Larnu
Nov 14 '18 at 17:20
Assign this sectiongrdNewOrder.DataKeys[e.RowIndex].Value.ToString()to a variable before converting it to an Int and check if it is a number. You cannot useConvert.ToInt32on a non-numeric string
– Dumisani
Nov 14 '18 at 17:20
@Dumisani thanks, I have been trying to solve this problem for last three hours but thank you very much for saving my time by solving my problem.
– Arslan jappa
Nov 14 '18 at 17:29
@Arslanjappa glad I could help
– Dumisani
Nov 14 '18 at 18:27
add a comment |
And what was that error?
– Larnu
Nov 14 '18 at 17:20
Assign this sectiongrdNewOrder.DataKeys[e.RowIndex].Value.ToString()to a variable before converting it to an Int and check if it is a number. You cannot useConvert.ToInt32on a non-numeric string
– Dumisani
Nov 14 '18 at 17:20
@Dumisani thanks, I have been trying to solve this problem for last three hours but thank you very much for saving my time by solving my problem.
– Arslan jappa
Nov 14 '18 at 17:29
@Arslanjappa glad I could help
– Dumisani
Nov 14 '18 at 18:27
And what was that error?
– Larnu
Nov 14 '18 at 17:20
And what was that error?
– Larnu
Nov 14 '18 at 17:20
Assign this section
grdNewOrder.DataKeys[e.RowIndex].Value.ToString() to a variable before converting it to an Int and check if it is a number. You cannot use Convert.ToInt32 on a non-numeric string– Dumisani
Nov 14 '18 at 17:20
Assign this section
grdNewOrder.DataKeys[e.RowIndex].Value.ToString() to a variable before converting it to an Int and check if it is a number. You cannot use Convert.ToInt32 on a non-numeric string– Dumisani
Nov 14 '18 at 17:20
@Dumisani thanks, I have been trying to solve this problem for last three hours but thank you very much for saving my time by solving my problem.
– Arslan jappa
Nov 14 '18 at 17:29
@Dumisani thanks, I have been trying to solve this problem for last three hours but thank you very much for saving my time by solving my problem.
– Arslan jappa
Nov 14 '18 at 17:29
@Arslanjappa glad I could help
– Dumisani
Nov 14 '18 at 18:27
@Arslanjappa glad I could help
– Dumisani
Nov 14 '18 at 18:27
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%2f53305547%2finput-string-was-not-in-a-correct-format-while-updating-row-in-gridview%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%2f53305547%2finput-string-was-not-in-a-correct-format-while-updating-row-in-gridview%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
And what was that error?
– Larnu
Nov 14 '18 at 17:20
Assign this section
grdNewOrder.DataKeys[e.RowIndex].Value.ToString()to a variable before converting it to an Int and check if it is a number. You cannot useConvert.ToInt32on a non-numeric string– Dumisani
Nov 14 '18 at 17:20
@Dumisani thanks, I have been trying to solve this problem for last three hours but thank you very much for saving my time by solving my problem.
– Arslan jappa
Nov 14 '18 at 17:29
@Arslanjappa glad I could help
– Dumisani
Nov 14 '18 at 18:27