0
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 ?

Votes + Comments
N.A
4
Contributors
5
Replies
6
Views
8 Years
Discussion Span
Last Post by plazmo
0

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

Edited by Ramesh S: n/a

1

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();

        }
    }
}
0
 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: Fixed formatting

1
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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.