Write DataGridView to TextFile Duplicate Lines based on Grid Cell QTY
0
I have a routine that produces a text file based on the contents of a DataGridView.
the scenario is this.
Sales Order line [Item Name[ [Quantity]
the solution is to produce a text file for each quantity. currently my routine only produces a line for each order line, not each quantity.
If for example its current row, column 6.
Try
Dim StrExport As String = ""
For Each C As DataGridViewColumn In DataGridView1.Columns
StrExport &= "" & C.HeaderText & ","
Next
StrExport = StrExport.Substring(0, StrExport.Length - 1)
StrExport &= Environment.NewLine
For Each R As DataGridViewRow In DataGridView1.Rows
For Each C As DataGridViewCell In R.Cells
If Not C.Value Is Nothing Then
StrExport &= "" & C.Value.ToString & ","
Else
StrExport &= "" & "" & ","
End If
Next
StrExport = StrExport.Substring(0, StrExport.Length - 1)
StrExport &= Environment.NewLine
Next
Dim tw As IO.TextWriter = New IO.StreamWriter(SaveFileDialog1.FileName)
tw.Write(StrExport)
tw.Close()
My.Computer.FileSystem.RenameFile(SaveFileDialog1.FileName, "FRLSTicket.txt")
Catch ex As Exception
MsgBox(ex.Message)
End Try
Try
DataGridView1.Refresh()
Catch ex As Exception
End Try
a sample row might be
SalesID,QTY,CustomerName,ItemID,Name,LegColour
SO1234567,3,John Smith ,Chair,Comfortable Blue Chair,Walnut
vb.net
asked Nov 28 '18 at 10:22
JustAnAverageSQLuserJustAnAverageSQLuser
59110
add a comment |
0
I have a routine that produces a text file based on the contents of a DataGridView.
the scenario is this.
Sales Order line [Item Name[ [Quantity]
the solution is to produce a text file for each quantity. currently my routine only produces a line for each order line, not each quantity.
If for example its current row, column 6.
Try
Dim StrExport As String = ""
For Each C As DataGridViewColumn In DataGridView1.Columns
StrExport &= "" & C.HeaderText & ","
Next
StrExport = StrExport.Substring(0, StrExport.Length - 1)
StrExport &= Environment.NewLine
For Each R As DataGridViewRow In DataGridView1.Rows
For Each C As DataGridViewCell In R.Cells
If Not C.Value Is Nothing Then
StrExport &= "" & C.Value.ToString & ","
Else
StrExport &= "" & "" & ","
End If
Next
StrExport = StrExport.Substring(0, StrExport.Length - 1)
StrExport &= Environment.NewLine
Next
Dim tw As IO.TextWriter = New IO.StreamWriter(SaveFileDialog1.FileName)
tw.Write(StrExport)
tw.Close()
My.Computer.FileSystem.RenameFile(SaveFileDialog1.FileName, "FRLSTicket.txt")
Catch ex As Exception
MsgBox(ex.Message)
End Try
Try
DataGridView1.Refresh()
Catch ex As Exception
End Try
a sample row might be
SalesID,QTY,CustomerName,ItemID,Name,LegColour
SO1234567,3,John Smith ,Chair,Comfortable Blue Chair,Walnut
vb.net
asked Nov 28 '18 at 10:22
JustAnAverageSQLuserJustAnAverageSQLuser
59110
2
This code loops on every row of your grid and for each row extracts the value of every cell concatenating and separating them with a comma. It seems correct albeit I strongly suggest you to use a StringBuilder and not all those &= . Can you post an example of what you have on a row of this grid?
– Steve
Nov 28 '18 at 10:28
Thanks, Sample added at the bottom.
– JustAnAverageSQLuser
Nov 28 '18 at 10:35
Sorry but I still cannot see any kind of error in processing that grid row. What is the output in the file for that row?
– Steve
Nov 28 '18 at 11:06
Hi Steve, the output would be 1 line. as above. the desired results would be 3 lines because there is a qty of 3. ive just overcome it now by changing the SQL Query that produces the data in the grid, so although I appreciate your comments, I'm kind of ok now. whats the norm here, delete the Question or leave it for an answer for someone else? I dont want to break etiquette here, I know some people can be quite precious about it.
– JustAnAverageSQLuser
Nov 28 '18 at 11:50
add a comment |
0
0
0
I have a routine that produces a text file based on the contents of a DataGridView.
the scenario is this.
Sales Order line [Item Name[ [Quantity]
the solution is to produce a text file for each quantity. currently my routine only produces a line for each order line, not each quantity.
If for example its current row, column 6.
Try
Dim StrExport As String = ""
For Each C As DataGridViewColumn In DataGridView1.Columns
StrExport &= "" & C.HeaderText & ","
Next
StrExport = StrExport.Substring(0, StrExport.Length - 1)
StrExport &= Environment.NewLine
For Each R As DataGridViewRow In DataGridView1.Rows
For Each C As DataGridViewCell In R.Cells
If Not C.Value Is Nothing Then
StrExport &= "" & C.Value.ToString & ","
Else
StrExport &= "" & "" & ","
End If
Next
StrExport = StrExport.Substring(0, StrExport.Length - 1)
StrExport &= Environment.NewLine
Next
Dim tw As IO.TextWriter = New IO.StreamWriter(SaveFileDialog1.FileName)
tw.Write(StrExport)
tw.Close()
My.Computer.FileSystem.RenameFile(SaveFileDialog1.FileName, "FRLSTicket.txt")
Catch ex As Exception
MsgBox(ex.Message)
End Try
Try
DataGridView1.Refresh()
Catch ex As Exception
End Try
a sample row might be
SalesID,QTY,CustomerName,ItemID,Name,LegColour
SO1234567,3,John Smith ,Chair,Comfortable Blue Chair,Walnut
vb.net
asked Nov 28 '18 at 10:22
JustAnAverageSQLuserJustAnAverageSQLuser
59110
I have a routine that produces a text file based on the contents of a DataGridView.
the scenario is this.
Sales Order line [Item Name[ [Quantity]
the solution is to produce a text file for each quantity. currently my routine only produces a line for each order line, not each quantity.
If for example its current row, column 6.
Try
Dim StrExport As String = ""
For Each C As DataGridViewColumn In DataGridView1.Columns
StrExport &= "" & C.HeaderText & ","
Next
StrExport = StrExport.Substring(0, StrExport.Length - 1)
StrExport &= Environment.NewLine
For Each R As DataGridViewRow In DataGridView1.Rows
For Each C As DataGridViewCell In R.Cells
If Not C.Value Is Nothing Then
StrExport &= "" & C.Value.ToString & ","
Else
StrExport &= "" & "" & ","
End If
Next
StrExport = StrExport.Substring(0, StrExport.Length - 1)
StrExport &= Environment.NewLine
Next
Dim tw As IO.TextWriter = New IO.StreamWriter(SaveFileDialog1.FileName)
tw.Write(StrExport)
tw.Close()
My.Computer.FileSystem.RenameFile(SaveFileDialog1.FileName, "FRLSTicket.txt")
Catch ex As Exception
MsgBox(ex.Message)
End Try
Try
DataGridView1.Refresh()
Catch ex As Exception
End Try
a sample row might be
SalesID,QTY,CustomerName,ItemID,Name,LegColour
SO1234567,3,John Smith ,Chair,Comfortable Blue Chair,Walnut
vb.net
vb.net
asked Nov 28 '18 at 10:22
JustAnAverageSQLuserJustAnAverageSQLuser
59110
asked Nov 28 '18 at 10:22
JustAnAverageSQLuserJustAnAverageSQLuser
59110
edited Nov 28 '18 at 10:34
JustAnAverageSQLuser
asked Nov 28 '18 at 10:22
JustAnAverageSQLuserJustAnAverageSQLuser
59110
asked Nov 28 '18 at 10:22
JustAnAverageSQLuserJustAnAverageSQLuser
59110
asked Nov 28 '18 at 10:22
JustAnAverageSQLuserJustAnAverageSQLuser
59110
59110
2
This code loops on every row of your grid and for each row extracts the value of every cell concatenating and separating them with a comma. It seems correct albeit I strongly suggest you to use a StringBuilder and not all those &= . Can you post an example of what you have on a row of this grid?
– Steve
Nov 28 '18 at 10:28
Thanks, Sample added at the bottom.
– JustAnAverageSQLuser
Nov 28 '18 at 10:35
Sorry but I still cannot see any kind of error in processing that grid row. What is the output in the file for that row?
– Steve
Nov 28 '18 at 11:06
Hi Steve, the output would be 1 line. as above. the desired results would be 3 lines because there is a qty of 3. ive just overcome it now by changing the SQL Query that produces the data in the grid, so although I appreciate your comments, I'm kind of ok now. whats the norm here, delete the Question or leave it for an answer for someone else? I dont want to break etiquette here, I know some people can be quite precious about it.
– JustAnAverageSQLuser
Nov 28 '18 at 11:50
add a comment |
2
This code loops on every row of your grid and for each row extracts the value of every cell concatenating and separating them with a comma. It seems correct albeit I strongly suggest you to use a StringBuilder and not all those &= . Can you post an example of what you have on a row of this grid?
– Steve
Nov 28 '18 at 10:28
Thanks, Sample added at the bottom.
– JustAnAverageSQLuser
Nov 28 '18 at 10:35
Sorry but I still cannot see any kind of error in processing that grid row. What is the output in the file for that row?
– Steve
Nov 28 '18 at 11:06
Hi Steve, the output would be 1 line. as above. the desired results would be 3 lines because there is a qty of 3. ive just overcome it now by changing the SQL Query that produces the data in the grid, so although I appreciate your comments, I'm kind of ok now. whats the norm here, delete the Question or leave it for an answer for someone else? I dont want to break etiquette here, I know some people can be quite precious about it.
– JustAnAverageSQLuser
Nov 28 '18 at 11:50
2
2
This code loops on every row of your grid and for each row extracts the value of every cell concatenating and separating them with a comma. It seems correct albeit I strongly suggest you to use a StringBuilder and not all those &= . Can you post an example of what you have on a row of this grid?
– Steve
Nov 28 '18 at 10:28
This code loops on every row of your grid and for each row extracts the value of every cell concatenating and separating them with a comma. It seems correct albeit I strongly suggest you to use a StringBuilder and not all those &= . Can you post an example of what you have on a row of this grid?
– Steve
Nov 28 '18 at 10:28
Thanks, Sample added at the bottom.
– JustAnAverageSQLuser
Nov 28 '18 at 10:35
Thanks, Sample added at the bottom.
– JustAnAverageSQLuser
Nov 28 '18 at 10:35
Sorry but I still cannot see any kind of error in processing that grid row. What is the output in the file for that row?
– Steve
Nov 28 '18 at 11:06
Sorry but I still cannot see any kind of error in processing that grid row. What is the output in the file for that row?
– Steve
Nov 28 '18 at 11:06
Hi Steve, the output would be 1 line. as above. the desired results would be 3 lines because there is a qty of 3. ive just overcome it now by changing the SQL Query that produces the data in the grid, so although I appreciate your comments, I'm kind of ok now. whats the norm here, delete the Question or leave it for an answer for someone else? I dont want to break etiquette here, I know some people can be quite precious about it.
– JustAnAverageSQLuser
Nov 28 '18 at 11:50
Hi Steve, the output would be 1 line. as above. the desired results would be 3 lines because there is a qty of 3. ive just overcome it now by changing the SQL Query that produces the data in the grid, so although I appreciate your comments, I'm kind of ok now. whats the norm here, delete the Question or leave it for an answer for someone else? I dont want to break etiquette here, I know some people can be quite precious about it.
– JustAnAverageSQLuser
Nov 28 '18 at 11:50
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%2f53517161%2fwrite-datagridview-to-textfile-duplicate-lines-based-on-grid-cell-qty%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%2f53517161%2fwrite-datagridview-to-textfile-duplicate-lines-based-on-grid-cell-qty%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
2
This code loops on every row of your grid and for each row extracts the value of every cell concatenating and separating them with a comma. It seems correct albeit I strongly suggest you to use a StringBuilder and not all those &= . Can you post an example of what you have on a row of this grid?
– Steve
Nov 28 '18 at 10:28
Thanks, Sample added at the bottom.
– JustAnAverageSQLuser
Nov 28 '18 at 10:35
Sorry but I still cannot see any kind of error in processing that grid row. What is the output in the file for that row?
– Steve
Nov 28 '18 at 11:06
Hi Steve, the output would be 1 line. as above. the desired results would be 3 lines because there is a qty of 3. ive just overcome it now by changing the SQL Query that produces the data in the grid, so although I appreciate your comments, I'm kind of ok now. whats the norm here, delete the Question or leave it for an answer for someone else? I dont want to break etiquette here, I know some people can be quite precious about it.
– JustAnAverageSQLuser
Nov 28 '18 at 11:50