Member Avatar for Se7Olutionyg 
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

namespace WebApplication5
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection(
                " Server =localhost\\SqlExpress; Database= Dorknozzle; " + 
                "Integrated Secutiry = True" ) ;

            SqlCommand comm = new SqlCommand(
                "SELECT EmployeeID, Name FROM Employees", conn);
            conn.Open();
            SqlDataReader reader = comm.ExecuteReader();
            reader.Close();
            conn.Close();
            while (reader.Read())
            {
                employeesLabel.Text += reader["Name"] + "<br/>";
            }
            reader.Close();
            conn.Close();

        }
    }
}
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication5._Default" %>
<%@ Import Namespace = "System.Data.SqlClient" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">

how come it does not recgonized the SQL command while I have already imported ?

  • 4 Contributors
  • 5 Replies
  • 107 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by plazmo
kvprajapati commented: N.A -4
Member Avatar for Ramesh S

You need to import System.Data.SqlClient namespace in order to recognize the SqlConnection, SqlCommand and SqlDataReader etc objects.

Edited by Ramesh S because: n/a
Member Avatar for Se7Olutionyg

i did it dude, you didn't see that ?

Member Avatar for sknake

You need to do it in your code behind file:

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

namespace WebApplication5
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection(
                " Server =localhost\\SqlExpress; Database= Dorknozzle; " + 
                "Integrated Secutiry = True" ) ;

            SqlCommand comm = new SqlCommand(
                "SELECT EmployeeID, Name FROM Employees", conn);
            conn.Open();
            SqlDataReader reader = comm.ExecuteReader();
            reader.Close();
            conn.Close();
            while (reader.Read())
            {
                employeesLabel.Text += reader["Name"] + "<br/>";
            }
            reader.Close();
            conn.Close();

        }
    }
}
Member Avatar for Se7Olutionyg 
 public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection(
                " Server =se7olutionyg-PC\\SqlExpress; Database= database1.mdf; " + 
                "Integrated Secutiry = True" ) ;

the program said that this part

 SqlConnection conn = new SqlConnection(
                " Server =se7olutionyg-PC\\SqlExpress; Database= database1.mdf; " + 
                "Integrated Secutiry = True" ) ;

the server should be local host or my server name ?
how about the name of database, Do i have to declare the directory to the database or it already included in the project ?
Why the integrated security is not available for my page ?

Edited by mike_2000_17 because: Fixed formatting
Member Avatar for plazmo 
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

namespace WebApplication5
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection(
                " Server =localhost\\SqlExpress; Database= Dorknozzle; " + 
                "Integrated Secutiry = True" ) ;

            SqlCommand comm = new SqlCommand(
                "SELECT EmployeeID, Name FROM Employees", conn);
            conn.Open();
            SqlDataReader reader = comm.ExecuteReader();
[B]            reader.Close();
            conn.Close();[/B]
            while (reader.Read())
            {
                employeesLabel.Text += reader["Name"] + "<br/>";
            }
            reader.Close();
            conn.Close();

        }
    }
}
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication5._Default" %>
<%@ Import Namespace = "System.Data.SqlClient" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">

how come it does not recgonized the SQL command while I have already imported ?

You are closing your reader before you have read the data.
I put in bold what you should delete

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.