Results 1 to 5 of 5

Thread: How to make Database connection in ASP.NET

  1. #1
    Join Date
    Feb 2009
    Posts
    62

    How to make Database connection in ASP.NET

    Hello Friends,

    Can anyone suggest me the procedure about how to make Database connection in ASP.Net, I wanted to apply it into my project so please help.


    Thanks for your help

  2. #2
    Join Date
    Dec 2008
    Posts
    202

    Re: How to make Database connection in ASP.NET

    Hi,
    please add the follwoing code in you aspx.cs page.

    Step 1 : Add Namspace "using System.Data.SqlClient;"

    Step 2 : Make Sql connection.

    Write this code to create Sql connection.
    SqlConnection con = new SqlConnection("Server=You server name or comp name;Database=Yourdatabasename;Trusted_Connectopn=True");
    SqlCommand cmd = new SqlCommand("Write your sql query here eg. select * from Table name");
    con.Open();
    DataSet ds = new DataSet(cmd,con);
    SqlDataAdapter da = new SqlDataAdapter();
    da.Fill(ds);
    con.Close();

    i hope this should work

  3. #3
    Join Date
    Dec 2008
    Posts
    161

    Re: How to make Database connection in ASP.NET

    1: Open visual studio 2005 and from FILE select NEW-> WebSite, then from pop-menu select asp.net
    website (Note: Language must be C#) , then press OK.

    2: Now create three textboxes from the toolbox , to remove ambiguity I am using default name for that textboxes and that should be textbox1,textbox2 & textbox3. And also drag & drop the button to the asp.net application.

    3: Meanwhile, Open SQL SERVER Management studio 2005 and open adventureworks(or you can create your own database by the Sql command CREATE DATABASE database_name), but here I am using AdventureWorks database.

    4: Then create table by clicking right mouse button and form three column, Name them according to your requirement , for your information only I used EID,name,Address. And click save button, then you’ll get a pop up menu where you have to enter the Table Name, for this example I used students.

    5: Now Come Back to Visual studio Application and write the following code in the button_click event.

    Code:
    protected void Button1_Click(object sender, EventArgs e)
    {
    SqlConnection myConn = new SqlConnection();
    myConn.ConnectionString = “Connection string(See Below for this — )COPY PASTE  HERE“;
    
    myConn.Open();
    string strqry = “Insert into students values (” + TextBox1.Text +
    “,’” + TextBox2.Text + “‘,’” + TextBox3.Text + “‘)”;
    
    SqlCommand myCom = new SqlCommand(strqry, myConn);
    int numrow = myCom.ExecuteNonQuery();
    myConn.Close();
    
    }

  4. #4
    Join Date
    Sep 2011
    Posts
    1

    Re: How to make Database connection in ASP.NET

    A simple database program in VB.NET and C# , hope this will help you.

  5. #5
    Join Date
    Nov 2011
    Posts
    1

    Re: How to make Database connection in ASP.NET and where we have to choose that path

    how to connect microsoft access database to asp.net and where we have to choose that path

Similar Threads

  1. Replies: 9
    Last Post: 14-05-2012, 06:05 PM
  2. How to make database for xcode
    By Farren in forum Software Development
    Replies: 4
    Last Post: 27-03-2012, 11:17 AM
  3. CAR MAKE & MODEL database
    By karv in forum Software Development
    Replies: 2
    Last Post: 07-10-2011, 02:19 PM
  4. Make PAYPAL payment and save data on database
    By Eshita The Techie in forum Software Development
    Replies: 4
    Last Post: 18-01-2011, 02:52 PM
  5. How to make the Database connection in PHP
    By AK_Chopra in forum Software Development
    Replies: 3
    Last Post: 05-09-2009, 09:35 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
  •