Search:

@PlausiblyDamp, thank you for taking the time to make sure I am doing this correctly!
So tell me, am I misunderstanding the article I cited in post #9?
In his first screenshot, he sets his...

So I see that in the root folder, parallel to \Application Files, I have setup.exe. It is timestamped 3/1/2021 9:10 AM which is the date of my last publish.
The folder \Application Files also has...

Is there more to it than just this? https://tahoeninjas.blog/2018/11/17/change-default-project-folder-in-visual-studio-2017-to-a-onedrive-folder/
Meaning, if I have my source/repos folder on the...

My application is a click-once app, and I have the sequentially numbered versions on a network drive in the Application Files folder. I would like to run a previous version. The most current...

I was given the info I need which is our permanent solution as long as the mail is sent from a PC in our building. For this particular function in the application, that is fine.
The SMTP Server is...

Ok, thanks, but I went with using gmail directly in my code. I realized I could make a new gmail account specifically for this and not have to use my own personal one. It's all working great. ...

@kfcSmitty, I don't understand exactly what I am supposed to do with the github code. Build and install it? I had errors when I tried to open the solution file I downloaded.

I went to the...

Thanks @kfc, I will give that a try.

Sorry I did not see this; I didn't refresh the page. Yes this might be a good idea. I can also change my gmail password when I'm done testing. Thanks.

I am getting stuck on what provide in this line: MailClient.Credentials = new System.Net.NetworkCredential("account2@gmail.com", "password");
Would I use my own personal gmail id and pw?

... other than you guys here?

I'm working on a new function in my WinForms C# application to send an email. I send emails in this app all the time but how it works is we have a table called...

LOL, actually in the second one I am going to exception!
So this is kind of what I mean. Maybe I should not rewrite this because I rewrote it wrong and if I hadn't asked and wasn't testing it...

No, we don't differ in approaches at all. I just may not have been thinking about it enough but you're absolutely right.

Yes, I agree with your first three sentences but what are you saying is the problem that doesn't exist? Here is the whole routine. It runs when you click a command button on a form called...

Is this what VS wants me to do here?



//ckOTNew.Checked = drTrips.IsOTNull() ? false : drTrips.OT;
ckOTNew.Checked = drTrips.IsOTNull() && drTrips.OT;


I feel like I had to think about...

I am not calling both properties Width; Microsoft is. Form A has a Width property and Form B has a Width property; they are both forms.
I like your idea of having VS remove "this" warnings. Like...

Okay, so I have a question. I am launching forms from other forms quite often. So let's say the user has form A positioned nicely on his screen where he wants it and he launches form B. The...

I see...thank you. It's been a long day; I will digest this in the morning!

So are you ever developing code and you want to know if your call to TableAdapter.Update() worked so you throw int rc = ta.Update() in front of it to check it when you run and then you leave it there...

@si_the_geek, So if you were my successor here you would want me to take the time and address the 207 occurrences where my code *could* be simplified?
My point in asking is while I can certainly...

So a lot of them have to do with form instantiation...


frmCustomerService frmCustomerService = new frmCustomerService(txtCustNo.Text, tab, sdc);

frmCustomerService.StartPosition =...

OK, thank you both!

Maybe I should've paid closer attention 5 years ago when I started coding our application, LOL. But now that I have some free time, I'm looking at Messages and Warnings.
I have 207 places in my...

Please excuse this post when I see that all I needed to do was google "c# tryparse ide0059" and the answer is there!



static int Check_input(string input)
{
bool is_valid =...

So I am getting a message when I do the following instruction:


if (txtUnitPrice.Text != "" && !decimal.TryParse(txtUnitPrice.Text, out decimal dec))
{
MessageBox.Show("Please enter a numeric...

Thank you; worked beautifully!

Probably it can, but I am not sure how, for reason stated in my comment!
Is there a better way to write this?



int rc = taCustomerSystemData.Update(txtCustNo.Text,
// 01/12/21...

Also, @FunkyDexter, thanks for the tips on how to approach it. I've done only a few of these. If I am lucky enough to find an example of what I want to do, I then find it pretty straightforward to...

select pri.[customer_id], pri.[EmpID] as PrimaryRep, sec.EmpID as SecondaryRep
into #tmpTest
from EmpSalesReps pri
left join EmpSalesReps sec on sec.customer_id = pri.customer_id and sec.bPrimary...

Sorry @FunkyDexter, I didn't refresh!

I've got it, thank you.
This is my model: https://stackoverflow.com/questions/41465261/sql-server-combine-multiple-rows-to-one-row-with-multiple-columns
I will post my exact solution when I am done...

It's kind of like this and this is actually what I did yesterday until my boss further explained what she wanted. ...

Here are my query and results:


select pri.[customer_id], pri.[EmpID] as PrimaryRep, sec.EmpID as SecondaryRep
from EmpSalesReps pri
left join EmpSalesReps sec on sec.customer_id =...

I found a clever way to deal with this. I am concatenating a string made up of SONO and line. SO my criterion goes like this: SONO + '|' + CONVERT(nvarchar(4), SLINE), and that works. (I am...

I have my original problem solved and now I am onto something a bit more complex.

I need to run my crystal report based on two parameters (same as described above): order number (SONO) and line...

Yes, tg. One thing I was considering was something I've done in the past that I thought was very cool based on this stackoverflow post. I can do the same thing here. I wasn't sure if there was a...

Hello. I need to design a Crystal report that can branch one way or another with its selection criteria. I have a database table containing a column called lines and those lines are grouped...

@Delaney, thanks for the help. I ended up going with the DevExpress XtraSpreadsheet.SpreadsheetControl. We use DX controls throughout the application so I had this control readily available and it...

OH, thanks to Zvoni too who snuck in there with the same answer while I was testing and posting back. :)

I could just do that! Thanks so much!!!

P.S. DB is SQL Server, if that helps anyone in the future.