LiveWire Peer Support Network

Printable Version of Topic "SQL Express connection string ASP.NET v2.0"

- LiveWire Teen Forums & College Forums (http://www.golivewire.com)
-- (http://www.golivewire.com/forums/support-technical.html)
--- Programming & Application Development (http://www.golivewire.com/forums/forum-211-s-0.html)
---- SQL Express connection string ASP.NET v2.0 (http://www.golivewire.com/forums/peer-nypbey-support-a.html)

-- Posted by ArkiTecT101 at 9:13 am on April 20, 2007

Hi guys,

This is quite a difficult topic so I appreciate it if no one knows the answer, but I welcome all comments.

OK so I am messing around with web applications and databases. I have the knowledge to create a connection string to the access database but do not know how to access SQL Express database which is now part of Visual Web Developer (the development software I am using).

I have quickly drafted up an aspx page with its counterpart C# page as follows:

[ASPX PAGE]

<%@ Page Language="C#" AutoEventWireup="true" Inherits="addContractor" CodeFile="Default.aspx.cs" %>


   Untitled Page


   


   

       Select a Category:
       
           
       

       

       

       

       

       Contractor Description:
       

       Contractor Add1:        
       

       Contractor Add1:        
       

       Contractor Add1:        
       

       Contractor Add1:        
       

       Contractor Contact:    
       

       

       

   


[C# PAGE]

using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;


public partial class addContractor : System.Web.UI.Page
{
   protected void Page_Load(object sender, EventArgs e)
   {

       if (IsPostBack)
       {
           Label2.Text = "Category ID: " + list1.SelectedItem.Value;
       }
       else
       {

           Label2.Text = "Category ID: ";

           rtvContractorID();

           DateTime d = DateTime.Now;
           Label1.Text = d.ToString("d");

           OleDbConnection conn = new OleDbConnection();
           string connStr;
           connStr = "Provider=Microsoft.Jet.OLEDB.4.0;";
           connStr += "Data Source= " + Server.MapPath("App_Data/test.mdb");
           conn.ConnectionString = connStr;

           string queryString;
           queryString = "SELECT CategoryID, CategoryDesc FROM Category";
           OleDbCommand dbCommand = new OleDbCommand();
           dbCommand.CommandText = queryString;
           dbCommand.Connection = conn;

           conn.Open();

           OleDbDataReader dataReader = dbCommand.ExecuteReader();

           list1.DataSource = dataReader;
           list1.DataValueField = "CategoryID";
           list1.DataTextField = "CategoryDesc";
           list1.DataBind();


       }
   }

   public void ContractorList (object sender, EventArgs e)
         {
             Label2.Text = "Category ID: " + list1.SelectedItem.Value;

         }

   protected void rtvContractorID()
   {

       Guid ContractorID = Guid.NewGuid();
       Session["sContractorID"] = ContractorID;

   }

 
   protected void submitContractor(object sender, EventArgs e)
   {


       OleDbConnection conn;
       conn = new OleDbConnection();
       string connStr;
       connStr = "Provider=Microsoft.Jet.OLEDB.4.0;";
       connStr += "Data Source= " + Server.MapPath("App_Data/test.mdb");
       conn.ConnectionString = connStr;

       string queryString4;
       queryString4 = "insert into Contractor (ContractorID, CategoryID, ContDateAdded, ContDesc, Add1, Add2, Add3, Add4, ContactTel) values (";
       queryString4 += "'" + Convert.ToString(Session["sContractorID"]) + "', '";
       queryString4 += Convert.ToString(list1.SelectedItem.Value) + "', '";
       queryString4 += Label1.Text;
       queryString4 += "', '";
       queryString4 += TextBox1.Text;
       queryString4 += "', '";
       queryString4 += TextBox2.Text;
       queryString4 += "', '";
       queryString4 += TextBox3.Text;
       queryString4 += "', '";
       queryString4 += TextBox4.Text;
       queryString4 += "', '";
       queryString4 += TextBox5.Text;
       queryString4 += "', '";
       queryString4 += TextBox6.Text;
       queryString4 += "')";

       OleDbCommand dbCommand4 = new OleDbCommand();
       dbCommand4.CommandText = queryString4;
       dbCommand4.Connection = conn;
       conn.Open();
       dbCommand4.ExecuteNonQuery();

       conn.Close();
       Server.Transfer("default.aspx");

   }
}

So basically what I am asking is instead of connecting to an access database, I want to connect to an SQL express database. This requires modifcation in the connection string. If you know then please explain.

Thanks.

www.golivewire.com