Search:

Type: Posts; User: MMock

Page 1 of 13 1 2 3 4

Search: Search took 1.12 seconds.

  1. Re: [RESOLVED] Constraint within primary key - sql server database

    @fd, you have made my day. That is hilarious!
  2. Re: Constraint within primary key - sql server database

    My table's natural compound key is beautiful!
    My code is working!
    I am releasing my applicatin and maybe it will get tested (we test things live around here) this afternoon if we get a shipment of...
  3. Re: Constraint within primary key - sql server database

    Love those old muscle cars! Must've been nice.
  4. Re: Constraint within primary key - sql server database

    Off by a decade, and a bit more! Graduated in 1980 (and while I did attend public schools in South Windsor up through 9th grade, I went to H.S. at East Catholic in Manchester).
  5. Re: Constraint within primary key - sql server database

    So this was a worthwhile conversation for me simply because (please don't roll your eyes at me), I never even considered surrogate vs natural keys unless it screamed out at me that it should be a...
  6. Re: Constraint within primary key - sql server database

    I'm sorry! I don't know what's wrong with me today!

    Columns I have in the table right now are:

    xtblMROrderItems.Control

    xtblMROrderItems.MROrderMasterControl

    xtblMROrderItems.BoxNumber
  7. Re: Constraint within primary key - sql server database

    Yes, I was considering that too. Thanks for the update; I have not done anything further with this yet.
  8. Re: Constraint within primary key - sql server database

    @GaryMazzone, thanks I will try that!
  9. [RESOLVED] Constraint within primary key - sql server database

    Sorry to bother you guys with what I thought would be an easy question but googling isn't returning a solution to me.
    I have a table with a primary key and one of the other columns in the table is a...
  10. Replies
    0
    Views
    311

    It's a Visual Studio editing question

    I know I'm in the wrong forum but I couldn't find a good match.

    I type fast and I transpose characters a lot. You used to be able to hit ctrl-T in Visual Studio to transpose characters. I loved...
  11. Re: It's a separate and more important source control question

    Thank you.
    So I will revise the question I asked at the end of #11.
    What I could do is set my Projects location to my local drive (formerly I said OneDrive) and the git repository to our network...
  12. Re: It's a separate and more important source control question

    @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...
  13. Re: Can I run a previous version of a click-once app?

    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...
  14. Re: It's a separate and more important source control question

    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...
  15. Can I run a previous version of a click-once app?

    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...
  16. Re: Want to send an email - can I just figure it out without anyone helping me...

    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...
  17. Re: Want to send an email - can I just figure it out without anyone helping me...

    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. ...
  18. Re: Want to send an email - can I just figure it out without anyone helping me...

    @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...
  19. Re: Want to send an email - can I just figure it out without anyone helping me...

    Thanks @kfc, I will give that a try.
  20. Re: Want to send an email - can I just figure it out without anyone helping me...

    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.
  21. Re: Want to send an email - can I just figure it out without anyone helping me...

    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?
  22. [RESOLVED] Want to send an email - can I just figure it out without anyone helping me...

    ... 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...
  23. Re: IDE0075 How do I simplify this condition expression?

    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...
  24. Replies
    16
    Views
    734

    Re: IDE0017 - Should I simplify all these?

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

    Re: IDE0017 - Should I simplify all these?

    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...
  26. IDE0075 How do I simplify this condition expression?

    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...
  27. Replies
    16
    Views
    734

    Re: IDE0017 - Should I simplify all these?

    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...
  28. Replies
    16
    Views
    734

    Re: IDE0017 - Should I simplify all these?

    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...
  29. Re: IDE0059 Unnecessary assignment of a value...

    I see...thank you. It's been a long day; I will digest this in the morning!
  30. IDE0059 Unnecessary assignment of a value...

    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...
  31. Replies
    16
    Views
    734

    Re: IDE0017 - Should I simplify all these?

    @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...
  32. Replies
    16
    Views
    734

    Re: IDE0017 - Should I simplify all these?

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


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

    frmCustomerService.StartPosition =...
  33. Replies
    16
    Views
    734

    Re: IDE0017 - Should I simplify all these?

    OK, thank you both!
  34. Replies
    16
    Views
    734

    IDE0017 - Should I simplify all these?

    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...
  35. Replies
    1
    Views
    257

    Re: Ide0059

    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 =...
  36. Replies
    1
    Views
    257

    [RESOLVED] Ide0059

    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...
  37. Re: IDE0031 "Null check can be simplified", but can it?

    Thank you; worked beautifully!
  38. [RESOLVED] IDE0031 "Null check can be simplified", but can it?

    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...
  39. Re: [RESOLVED] SQL Server - would this be a pivot or something else?

    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...
  40. Re: SQL Server - would this be a pivot or something else?

    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...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width