If you look on the web you will eventually find an example that refers to the Northwind sample database in one of the their examples. What they fell to tell you is where to find this sample database and how to add to your database. Follow these steps to add the Northwind sample database to your SQL Server: 1. Go the URL http://www.microsoft.com/en-us/download/details.aspx?id=23654 and download the Northwind and pubs sample database from Microsoft. 2. Double click on the SQL2000SampleDb.msi file, then click "Run" 3. After you finished with the installer you will have the sample databases in the "SQL Server 2000 Sample Databases" folder in the C drive 4. Log onto SQL Server using SQL Server Management Studio 5. Right-click on the "Databases" node inside the "Object Explorer" window, then select "Attach" 6. Click on the "Add" button, in the "Attach Database" window 7. Select the "NORTHWND.MDF" file inside t...
In our previous blog posts we ran containers with the Fedora and CentOS images. In this blog we are going to run a command to see which containers are running in our host system. To get a list of all the containers running on our host Ubuntu system we type in the command docker ps -a command.
In this blog we will go over how to query an Oracle database in ASP.NET using the System.Data.OracleClient data provider in C#. Namespaces: using System.Web.Configuration; using System.Data.OracleClient; using System.Data; string cs = WebConfigurationManager.ConnectionStrings["SomeConnectionString"].ConnectionString; using (OracleConnection oc = new OracleConnection(cs)) { oc.Open(); DataTable dt = new DataTable(); OracleCommand ocmd = new OracleCommand("SELECT * FROM SOMETABLE", oc); OracleDataAdapter oda = new OracleDataAdapter(ocmd); oda.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); }
Comments
Post a Comment