|
Sorry... here I will paste the entire coding.. what I ended up doing was just leaving it blank and it seems to work....
foreach (DataGridViewRow r in theTableDataGridView.Rows)
{
richTextBox1.Text += string.Format("{0} {1}\n", r.Cells[1].Value.ToString(), r.Cells[2].Value.ToString());
if (DBNull.Value == r.Cells[3].Value);
else richTextBox1.Text += string.Format("{0}\n", r.Cells[3].Value.ToString());
if (DBNull.Value == r.Cells[4].Value && DBNull.Value == r.Cells[5].Value && DBNull.Value == r.Cells[6].Value);
else if (DBNull.Value == r.Cells[4].Value && DBNull.Value != r.Cells[5].Value && DBNull.Value != r.Cells[6].Value) richTextBox1.Text += string.Format("{0}, {1}\n", r.Cells[5].Value.ToString(), r.Cells[6].Value.ToString());
else if (DBNull.Value != r.Cells[4].Value && DBNull.Value == r.Cells[5].Value && DBNull.Value != r.Cells[6].Value) richTextBox1.Text += string.Format("{0}, {1}\n", r.Cells[4].Value.ToString(), r.Cells[6].Value.ToString());
else if (DBNull.Value != r.Cells[4].Value && DBNull.Value == r.Cells[5].Value && DBNull.Value == r.Cells[6].Value) richTextBox1.Text += string.Format("{0}\n", r.Cells[4].Value.ToString());
else if (DBNull.Value == r.Cells[4].Value && DBNull.Value != r.Cells[5].Value && DBNull.Value == r.Cells[6].Value) richTextBox1.Text += string.Format("{0}\n", r.Cells[5].Value.ToString());
else if (DBNull.Value == r.Cells[4].Value && DBNull.Value == r.Cells[5].Value && DBNull.Value != r.Cells[6].Value) richTextBox1.Text += string.Format("{0}\n", r.Cells[6].Value.ToString());
else richTextBox1.Text += string.Format("{0}, {1} {2}\n", r.Cells[4].Value.ToString(), r.Cells[5].Value.ToString(), r.Cells[6].Value.ToString());
if (DBNull.Value == r.Cells[7].Value);
else richTextBox1.Text += string.Format("Home Phone: {0}\n", r.Cells[7].Value.ToString());
if (DBNull.Value == r.Cells[8].Value);
else richTextBox1.Text += string.Format("Cell Phone: {0}\n", r.Cells[8].Value.ToString());
if (DBNull.Value == r.Cells[9].Value);
else richTextBox1.Text += string.Format("Fax Number: {0}\n", r.Cells[9].Value.ToString());
if (DBNull.Value == r.Cells[10].Value);
else richTextBox1.Text += string.Format("Email Address: {0}\n", r.Cells[10].Value.ToString());
if (DBNull.Value == r.Cells[12].Value);
else richTextBox1.Text += string.Format("Notes: {0}\n", r.Cells[12].Value.ToString());
richTextBox1.Text += "\n\n";
}
It appears to be work.. See I just left the IF statements without the RETURN. It seems to be working, I haven't ran into any problems yet..
Basically I just wanted to have it take the VALUE from the CELLS in a datagridview and display them in a certain format in a RichTextBox. Now If the cells were NULL then I did not want it to do anything.
Sorry to be so confusing, I'm trying to explain what I am trying to do.. Like I said it appears to be working and I thank you for trying to help me out.
-- Jacob Dixon
|
|
|
|
|
|
Yes! Thanks! As long as it skips the Else statement that is right after the IF statement!
|
|
|
|
|
Jacob Dixon wrote: Yes! Thanks! As long as it skips the Else statement that is right after the IF statement!
Umm... You do know how if statements work. Don't you?
if (some expression is true)
{
}
else
{
}
So, if you landed in the first block in the if statement, the code in the second block (after the else) will not run.
Remember that if you have multiple statements you must enclose them in the braces. You can get away without the braces if you only have one statement.
|
|
|
|
|
Jacob Dixon wrote: As long as it skips the Else statement that is right after the IF statement!
I just re-read that if statement and it looks confusing
if (DBNull.Value == r.Cells[3].Value);
else richTextBox1.Text += string.Format("{0}\n", r.Cells[3].Value.ToString());
The reason it is confusing is that you have a do nothing semi-colon after the if. This is not normal practice (and if you are doing that as a matter of course then I suggest you stop)
The normal practice would be to reverse the if statement. So that the if has a != (not equal) instead of an == (equals) operator.
i.e.
if (DBNull.Value != r.Cells[3].Value)
richTextBox1.Text += string.Format("{0}\n", r.Cells[3].Value.ToString());
You might also want to consider using a StringBuilder to build your string then finally assign it to the RichTextBox. It will be faster, especially for larger sets of data.
|
|
|
|
|
Yes I understand how the If statement works and I think you are correct about reversing them. I tried using the continue statement that someone mentioned before... like:
if (DBNull.Value == r.Cells[12].Value) continue;
else richTextBox1.Text += string.Format("Notes: {0}\n", r.Cells[12].Value.ToString());
richTextBox1.Text += "\n\n";
the problem with this is if Cells[12] was actually DBNull, then for some reason it would skip the richTextBox1.Text += "\n\n"; ... now when I left continue out, it would work correctly. The program actually works like I wanted it to. I do think that you are correct and there are better ways of doing what I wanted it to do (which I'm sure you know). I'm still learning how things work exactly, and still learning how to make them more code friendly. Thanks
|
|
|
|
|
Jacob Dixon wrote: the problem with this is if Cells[12] was actually DBNull, then for some reason it would skip the richTextBox1.Text += "\n\n";
That is because continue moves to the start of the next iteration skipping any remaining statements in the current iteration.
|
|
|
|
|
Jacob Dixon wrote: When I enter like: 123-4567 it doesn't because of the dash.
You need to loop through the string and when you encounter a numeric character, add it to a temporary string, and ignore the none numeric characters. When done with the loop, you should be able to convert the temporary string to int32 with no problem.
---modified
Int32 is not always going to work if you include area codes. You might want to consider Int64 if you have store the phone numbers as integers.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
hi all
i work with database and i connetion to it
when aplay to connet to it the application send to me this message
Error [IM002][Microsoft][ODBC Driver Manager] DataSource name not found and no default driver specifies
thanks for any body help me ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
Thaer
|
|
|
|
|
There's something wrong with your connection string.
You need to provide details of this if you want help.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Thaer Hamael wrote: DataSource name not found
Check to make sure that the data source you're connecting to has been setup properly. In WinXP go to [Start -> Settings -> Control Panel -> Administrative Tools -> Data Sources (ODBC)] to View/Modify your systems ODBC connections.
|
|
|
|
|
ODBC is soooo '80s... get with ADO.net, there's likely a provider for your database.
|
|
|
|
|
Hello All:
How can I add an icon for any element inside list view,
thanks
|
|
|
|
|
Step1 :
use one ImageList and load all required images !!!
Step 2:
Use ListViewItem Class object ListItemobj
Step3:
ListItemObj.ImageIndex= set image index from ImageList
Hope this will help you 
|
|
|
|
|
i have created a report using crystal report and i want to open it in reportViwer in C# 2005 how can i do that ?
|
|
|
|
|
The ReportViewer is for SSRS reports, not Crystal Reports.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
so how can i display the crystal report 
|
|
|
|
|
Did you try searching[^] for an answer to your question yourself?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
sure, so how to use reportviwer ?
|
|
|
|
|
shabonaa wrote: sure, so how to use reportviwer ?
I already told you, you can't use the Report Viewer control for Crystal Reports 
The Report Viewer control is for displaying SSRS reports.
Which part of 'you can't use it' didn't you understand?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
how to set the report source. i was using it in VS 2003
|
|
|
|
|
you can you Crystal Reports viewer to view the reports .
give the Crystal Report Source !!!
|
|
|
|
|
As Paul has stated, Crystal Reports and ReportViewer are two different products.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
yes i tried it and it works, thats guys
|
|
|
|
|
Hi there,
I am trying to save an Image from a database to a file but it only save the following to the file
"System.Byte[]".
fileWriter.Write(dsExportDataTypes.Tables[0].Rows[i]["ATTACHMENT"]);
fileWriter is an object of StreamWriter Class.
Mujtaba
"If both of us are having one apple each and we exchange it, at the end we both will have one apple each. BUT if both of us are having one idea each and we exchange it, at the end both of us will be having two ideas each."
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
