Results 1 to 9 of 9
  1. #1
    Join Date
    Oct 2011
    Posts
    3

    Red face Unanswered: Help required! SQL server

    New in SQL server/ASP.net/c# in this environment need help after creation of tables what should I do next? working on a project but can't figure out what to do next, I created logical structure of DB...then Physical structure..then datatypes and relationships by defining PK and FK etc. what I suppose to do next?
    writing SQL queries? or what ?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    next step: load some data

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2011
    Posts
    3

    Question Next step to develp a complete System using SQL server/ASP.NET/C#

    Thanks for advice,

    I want my client to insert data in database, what I suppose to do for that? have to write sql queries of insert with getdata(example)? or have to develop front end for user to insert data in database?
    Can you please tell me to create complete System (Database + Software) steps to develop that I could start research and deploy what I need to do and where I need to focus.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    sorry, i cannot do that

    some of the steps are secret

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    601
    romanceb2nus,

    I think your question is so broad as to not be answerable.

    It's like saying I want to manufacture a car. What are the steps I should take?

    If you ask a question in that manner, it is likely something that you are not really qualified to accomplish.

    Perhaps you want to narrow the scope of your question?
    Ken

    Maverick Software Design

    (847) 864-3600 x2

  6. #6
    Join Date
    Oct 2011
    Posts
    3

    Next step to develp a complete System using SQL server/ASP.NET/C#

    Just need instruction tools name

    Like I was zero 1 month ago... start getting instruction to build database

    So created logical structure using MS-Visio, then created Physical structure using MS-SQL server, do have good hands on SQL queries, But tell what tools I should use to get input from end user and display his requested output?
    what should my next step after created tables,entities and relationships? I am sure to write queries, But I am confused about what type of queries it should be? I have to write all queries as a script? and call these queries? or what I suppose to do in SQL domain ? not in ASP.NET domain or C# domain

  7. #7
    Join Date
    Oct 2011
    Posts
    29
    Your question is still not clear!

    If your front-end application is written in .NET/C# or any programming language, You will have to connect to the SQL Server (you use a connection string) and then query the database. The resultset returned from SQL Server can be displayed on the front-end that you have developed.

    One of the ways to connect to SQL Server is by ADO.

  8. #8
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    romanceb2nus,

    What is the name of the company you are working for and their location?
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  9. #9
    Join Date
    Mar 2009
    Location
    Australia
    Posts
    113
    Quote Originally Posted by Wim View Post
    What is the name of the company you are working for and their location?
    Microsoft support in India?


Tags for this Thread

Posting Permissions

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