Results 1 to 7 of 7

Thread: Any C# .NET + msSQL programmers out there?

  1. #1
    Senior Member mattblan's Avatar
    Join Date
    Oct 2001
    Location
    N. California
    Posts
    1,151

    Lightbulb Any C# .NET + msSQL programmers out there?

    We are automating event planning for the Women's Center at school and my group chose C# .NET 2.0 and msSQL. I am having a hell of a time with relationships and foreign keys. Does anyone have experience with database searching?

    Happy Sunday,

    Matt

  2. #2
    Senior Member lynnifer's Avatar
    Join Date
    Aug 2002
    Location
    Windsor ON Canada
    Posts
    19,320
    Matt, just popping in to say you still look great. /ego boost. lol
    Roses are red. Tacos are enjoyable. Don't blame immigrants, because you're unemployable.

    T-11 Flaccid Paraplegic due to TM July 1985 @ age 12

  3. #3
    Senior Member mattblan's Avatar
    Join Date
    Oct 2001
    Location
    N. California
    Posts
    1,151
    Thanks Jen, compliments from hot chicks are always appreciated.

  4. #4
    Senior Member mr_coffee's Avatar
    Join Date
    Mar 2005
    Location
    San Francisco, CA
    Posts
    6,030
    I don't know c# but I do know Java, but it sounds like your having problems understanidng relational databases.

    What type of application is this? Is it going to be a webbased application, like someoen goes to a website or is it going to be on distrubed boxes like Windows and its going to have a GUI front end and its storing everything in a mSSQL server?

    If you want it to be free, you could do it in Java/mySQL but if its not your money who cares.

    What are you having issues with when you say forgien keys? Are you creating everything from scratch or your having a hard time understanding some elses database design? Or your not sure when you should use a foriegn key/primary key?
    Last edited by mr_coffee; 12-11-2007 at 10:32 PM.
    Injured:10-16-04
    C7/C8, T1 incomplete;


    For stalkers convenience:
    Blog:
    http://www.ordealsonwheels.com/
    Facebook:
    http://www.facebook.com/#!/coryssanchez
    Progress:
    http://photobucket.com/albums/b290/swooty/
    My drawings:
    http://kanvases.com/sites/corysanchez/home

  5. #5
    Senior Member mattblan's Avatar
    Join Date
    Oct 2001
    Location
    N. California
    Posts
    1,151
    Hey Sanchez, How are finals going?

    If it were up to me we would have used Java and MySQL, but they wanted .NET so we are doing a standalone GUI database frontend that connects to their msSQL serverr.

    It's coming down to the wire so I just fixed my issue by doing tons of SELECT queries.

    I'm not into database stuff because my major is CpE.

    C# is pretty cool. The IDE is awesome. There is so much that it can do for you with a few button clicks. The only problem is that it takes time to learn all the tricks so I am stuck doing things manually.

    I think I'm up over 10k lines of code just with my part lol. I will show it to you when we are done if you are interested.

    Matt

  6. #6
    I know some Java, but am still learning database and SQL. Sounds like you have an interesting project.
    C2/3 quad since February 20, 1985.

  7. #7
    Senior Member mr_coffee's Avatar
    Join Date
    Mar 2005
    Location
    San Francisco, CA
    Posts
    6,030
    Sounds like a sweet project. Glad you figured it out.
    Yah its mainly just connecting forieng keys like select * from <tableName(s),...> where <tableName1>.customer_id = <tableName2>.email_id; if you have a customer id as a foriegn key in another table.

    I always wanted to get into the .net technologies but IBM hates microsoft it would be fun to work at Microsoft though.

    goodluck bro

    ps: I'm still working on my co-op at IBM I don't have to go back to school until jan 7th woo!
    Injured:10-16-04
    C7/C8, T1 incomplete;


    For stalkers convenience:
    Blog:
    http://www.ordealsonwheels.com/
    Facebook:
    http://www.facebook.com/#!/coryssanchez
    Progress:
    http://photobucket.com/albums/b290/swooty/
    My drawings:
    http://kanvases.com/sites/corysanchez/home

Similar Threads

  1. Good books on .NET???
    By garvey in forum Computers
    Replies: 6
    Last Post: 11-26-2005, 08:09 PM
  2. MKIV programmers
    By HeathQuad in forum Equipment
    Replies: 2
    Last Post: 07-05-2005, 03:58 PM
  3. Programmers
    By Steven Edwards in forum Computers
    Replies: 15
    Last Post: 06-13-2004, 02:03 PM
  4. Question for Steve or other programmers
    By Raven in forum Computers
    Replies: 10
    Last Post: 09-02-2003, 06:14 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •