Mixing
Trying to append row wise data in a variable in sequential order
While reading data it is coming in below mentioned order what i want first read first row of data of grid then append it to table then read second row and then append.i mean first value read 1sizMin,2sizeMax,3tolMin,4tolMax of rownum=1 then 2nd,3rd but not getting idea how to do.
+----------+----------+--------+--+
| prop_name | property | rownum | |
+----------+----------+--------+--+
| 1NDia | 1 | 1 | |
| 1sizMin | 1 | 1 | |
| 3tolMin | 3 | 1 | |
| 4tolMax | 4 | 1 | |
| 2sizeMax | 2 | 1 | |
| 1NDia | 2 | 2 | |
| 1sizMin | 5 | 2 | |
| 3tolMin | 7 | 2 | |
| 4tolMax | 8 | 2 | |
| 2sizeMax | 6 | 2 | |
| 1NDia | 3 | 3 | |
| 1sizMin | 9 | 3 | |
| 3tolMin | 11 | 3 | |
| 4tolMax | 12 | 3 | |
| 2sizeMax | 10 | 3 | |
+----------+----------+--------+--+
c# code
var sizMinStringFrst = "";
var sizMinStringSnd = "";
var sizMinStringThrd = "";
var sizMinStringFr = "";
int StdSize = 0;
var lblStdSize_Tolerm =htmltable
while (ReadData.Read())
{
if (prop_name == "1sizMin")
{
sizMinStringFrst = tdc_property;
StdSize = StdSize+1;
}
if (prop_name == "2sizeMax")
{
sizMinStringSnd = tdc_property;
StdSize = StdSize + 1;
}
if (prop_name == "3tolMin")
{
sizMinStringThrd = tdc_property;
StdSize = StdSize + 1;
}
if (prop_name == "4tolMax")
{
sizMinStringFr = tdc_property;
StdSize = StdSize + 1;
}
if (StdSize % 4 == 0)
{
var newTable = "<tr><td class='td-First-col-value'><center>" + sizMinStringFrst + "</center></td>" +
"<td class='td-First-col-value'><center>" + sizMinStringSnd + "</center></td>" +
"<td class='td-First-col-value'><center>" + sizMinStringThrd + "</center></td>" +
"<td class='td-First-col-value'><center>" + sizMinStringFr + "</center></td></tr>";
lblStdSize_Tolerm = lblStdSize_Tolerm + newTable;
}
}
lblStdSize_Toler.Text = lblStdSize_Tolerm+ "</table>";
I have defined four varible at top to store property value
and StdSize variable as a counter and divide it with 4 so that when first row column data found then it will append to table similarly second but logic is some wrong .after exit the loop this table will bind to a label any idea how to implement this will be appreciated.
c# asp.net
asked Nov 21 '18 at 6:43
MohanMohan
608
add a comment |
While reading data it is coming in below mentioned order what i want first read first row of data of grid then append it to table then read second row and then append.i mean first value read 1sizMin,2sizeMax,3tolMin,4tolMax of rownum=1 then 2nd,3rd but not getting idea how to do.
+----------+----------+--------+--+
| prop_name | property | rownum | |
+----------+----------+--------+--+
| 1NDia | 1 | 1 | |
| 1sizMin | 1 | 1 | |
| 3tolMin | 3 | 1 | |
| 4tolMax | 4 | 1 | |
| 2sizeMax | 2 | 1 | |
| 1NDia | 2 | 2 | |
| 1sizMin | 5 | 2 | |
| 3tolMin | 7 | 2 | |
| 4tolMax | 8 | 2 | |
| 2sizeMax | 6 | 2 | |
| 1NDia | 3 | 3 | |
| 1sizMin | 9 | 3 | |
| 3tolMin | 11 | 3 | |
| 4tolMax | 12 | 3 | |
| 2sizeMax | 10 | 3 | |
+----------+----------+--------+--+
c# code
var sizMinStringFrst = "";
var sizMinStringSnd = "";
var sizMinStringThrd = "";
var sizMinStringFr = "";
int StdSize = 0;
var lblStdSize_Tolerm =htmltable
while (ReadData.Read())
{
if (prop_name == "1sizMin")
{
sizMinStringFrst = tdc_property;
StdSize = StdSize+1;
}
if (prop_name == "2sizeMax")
{
sizMinStringSnd = tdc_property;
StdSize = StdSize + 1;
}
if (prop_name == "3tolMin")
{
sizMinStringThrd = tdc_property;
StdSize = StdSize + 1;
}
if (prop_name == "4tolMax")
{
sizMinStringFr = tdc_property;
StdSize = StdSize + 1;
}
if (StdSize % 4 == 0)
{
var newTable = "<tr><td class='td-First-col-value'><center>" + sizMinStringFrst + "</center></td>" +
"<td class='td-First-col-value'><center>" + sizMinStringSnd + "</center></td>" +
"<td class='td-First-col-value'><center>" + sizMinStringThrd + "</center></td>" +
"<td class='td-First-col-value'><center>" + sizMinStringFr + "</center></td></tr>";
lblStdSize_Tolerm = lblStdSize_Tolerm + newTable;
}
}
lblStdSize_Toler.Text = lblStdSize_Tolerm+ "</table>";
I have defined four varible at top to store property value
and StdSize variable as a counter and divide it with 4 so that when first row column data found then it will append to table similarly second but logic is some wrong .after exit the loop this table will bind to a label any idea how to implement this will be appreciated.
c# asp.net
asked Nov 21 '18 at 6:43
MohanMohan
608
What result do you get with this code? Did you try to debug the code and check the variable values at each step to understand what is the logic issue?
– Chetan Ranpariya
Nov 21 '18 at 7:37
add a comment |
While reading data it is coming in below mentioned order what i want first read first row of data of grid then append it to table then read second row and then append.i mean first value read 1sizMin,2sizeMax,3tolMin,4tolMax of rownum=1 then 2nd,3rd but not getting idea how to do.
+----------+----------+--------+--+
| prop_name | property | rownum | |
+----------+----------+--------+--+
| 1NDia | 1 | 1 | |
| 1sizMin | 1 | 1 | |
| 3tolMin | 3 | 1 | |
| 4tolMax | 4 | 1 | |
| 2sizeMax | 2 | 1 | |
| 1NDia | 2 | 2 | |
| 1sizMin | 5 | 2 | |
| 3tolMin | 7 | 2 | |
| 4tolMax | 8 | 2 | |
| 2sizeMax | 6 | 2 | |
| 1NDia | 3 | 3 | |
| 1sizMin | 9 | 3 | |
| 3tolMin | 11 | 3 | |
| 4tolMax | 12 | 3 | |
| 2sizeMax | 10 | 3 | |
+----------+----------+--------+--+
c# code
var sizMinStringFrst = "";
var sizMinStringSnd = "";
var sizMinStringThrd = "";
var sizMinStringFr = "";
int StdSize = 0;
var lblStdSize_Tolerm =htmltable
while (ReadData.Read())
{
if (prop_name == "1sizMin")
{
sizMinStringFrst = tdc_property;
StdSize = StdSize+1;
}
if (prop_name == "2sizeMax")
{
sizMinStringSnd = tdc_property;
StdSize = StdSize + 1;
}
if (prop_name == "3tolMin")
{
sizMinStringThrd = tdc_property;
StdSize = StdSize + 1;
}
if (prop_name == "4tolMax")
{
sizMinStringFr = tdc_property;
StdSize = StdSize + 1;
}
if (StdSize % 4 == 0)
{
var newTable = "<tr><td class='td-First-col-value'><center>" + sizMinStringFrst + "</center></td>" +
"<td class='td-First-col-value'><center>" + sizMinStringSnd + "</center></td>" +
"<td class='td-First-col-value'><center>" + sizMinStringThrd + "</center></td>" +
"<td class='td-First-col-value'><center>" + sizMinStringFr + "</center></td></tr>";
lblStdSize_Tolerm = lblStdSize_Tolerm + newTable;
}
}
lblStdSize_Toler.Text = lblStdSize_Tolerm+ "</table>";
I have defined four varible at top to store property value
and StdSize variable as a counter and divide it with 4 so that when first row column data found then it will append to table similarly second but logic is some wrong .after exit the loop this table will bind to a label any idea how to implement this will be appreciated.
c# asp.net
asked Nov 21 '18 at 6:43
MohanMohan
608
While reading data it is coming in below mentioned order what i want first read first row of data of grid then append it to table then read second row and then append.i mean first value read 1sizMin,2sizeMax,3tolMin,4tolMax of rownum=1 then 2nd,3rd but not getting idea how to do.
+----------+----------+--------+--+
| prop_name | property | rownum | |
+----------+----------+--------+--+
| 1NDia | 1 | 1 | |
| 1sizMin | 1 | 1 | |
| 3tolMin | 3 | 1 | |
| 4tolMax | 4 | 1 | |
| 2sizeMax | 2 | 1 | |
| 1NDia | 2 | 2 | |
| 1sizMin | 5 | 2 | |
| 3tolMin | 7 | 2 | |
| 4tolMax | 8 | 2 | |
| 2sizeMax | 6 | 2 | |
| 1NDia | 3 | 3 | |
| 1sizMin | 9 | 3 | |
| 3tolMin | 11 | 3 | |
| 4tolMax | 12 | 3 | |
| 2sizeMax | 10 | 3 | |
+----------+----------+--------+--+
c# code
var sizMinStringFrst = "";
var sizMinStringSnd = "";
var sizMinStringThrd = "";
var sizMinStringFr = "";
int StdSize = 0;
var lblStdSize_Tolerm =htmltable
while (ReadData.Read())
{
if (prop_name == "1sizMin")
{
sizMinStringFrst = tdc_property;
StdSize = StdSize+1;
}
if (prop_name == "2sizeMax")
{
sizMinStringSnd = tdc_property;
StdSize = StdSize + 1;
}
if (prop_name == "3tolMin")
{
sizMinStringThrd = tdc_property;
StdSize = StdSize + 1;
}
if (prop_name == "4tolMax")
{
sizMinStringFr = tdc_property;
StdSize = StdSize + 1;
}
if (StdSize % 4 == 0)
{
var newTable = "<tr><td class='td-First-col-value'><center>" + sizMinStringFrst + "</center></td>" +
"<td class='td-First-col-value'><center>" + sizMinStringSnd + "</center></td>" +
"<td class='td-First-col-value'><center>" + sizMinStringThrd + "</center></td>" +
"<td class='td-First-col-value'><center>" + sizMinStringFr + "</center></td></tr>";
lblStdSize_Tolerm = lblStdSize_Tolerm + newTable;
}
}
lblStdSize_Toler.Text = lblStdSize_Tolerm+ "</table>";
I have defined four varible at top to store property value
and StdSize variable as a counter and divide it with 4 so that when first row column data found then it will append to table similarly second but logic is some wrong .after exit the loop this table will bind to a label any idea how to implement this will be appreciated.
c# asp.net
c# asp.net
asked Nov 21 '18 at 6:43
MohanMohan
608
asked Nov 21 '18 at 6:43
MohanMohan
608
asked Nov 21 '18 at 6:43
MohanMohan
608
asked Nov 21 '18 at 6:43
MohanMohan
608
asked Nov 21 '18 at 6:43
MohanMohan
608
608
What result do you get with this code? Did you try to debug the code and check the variable values at each step to understand what is the logic issue?
– Chetan Ranpariya
Nov 21 '18 at 7:37
add a comment |
What result do you get with this code? Did you try to debug the code and check the variable values at each step to understand what is the logic issue?
– Chetan Ranpariya
Nov 21 '18 at 7:37
What result do you get with this code? Did you try to debug the code and check the variable values at each step to understand what is the logic issue?
– Chetan Ranpariya
Nov 21 '18 at 7:37
What result do you get with this code? Did you try to debug the code and check the variable values at each step to understand what is the logic issue?
– Chetan Ranpariya
Nov 21 '18 at 7:37
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
});
}
});
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%2f53406544%2ftrying-to-append-row-wise-data-in-a-variable-in-sequential-order%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
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.
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%2f53406544%2ftrying-to-append-row-wise-data-in-a-variable-in-sequential-order%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
What result do you get with this code? Did you try to debug the code and check the variable values at each step to understand what is the logic issue?
– Chetan Ranpariya
Nov 21 '18 at 7:37