stored procedure have no results

[chessitguy]

my stored procedure:

create procedure ps_title @Title nchar(15)
AS
SELECT
,Title
FROM books
Where Title = @Title

this is my code. i'm passing variable to sp and getting no results.

protected void Button1_Click(object sender, EventArgs e)
{
SqlDataReader rdr = null;
SqlConnection con = null;
SqlCommand cmd = null;

try
{

string conn =
@"server=local;uid=;pwd=;trusted_connection=true;database=library";
con = new SqlConnection(conn);
con.Open();

cmd = new SqlCommand("ps_title", con);
cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("@Book",
System.Data.SqlDbType.NVarChar).Value = drpdbooks.Text;


// Execute the query
rdr = cmd.ExecuteReader();
}
}

 

[Mark Rae]

SELECT
,Title
FROM books
Where Title = @Title

Does that not generate an error...? It certainly should do, because of the
apostrophe...

 

[chessitguy]

I re-wrote the statement and made an error. If anyone has any
suggestions.
Thanx

 

[Mark Rae]

I re-wrote the statement and made an error.

Sigh...

What was the error...?

 

[chessitguy]

From the listed stored procedure and C#.Net script I'm receiving no
error messages, but I'm also receiving blank records (no records at
all).

 

[RobinS]

I think what Mark meant was "Re-post your (corrected) code."

Robin S.
--------------------------

 

[chessitguy]

sorry i am. im new with c.net coming from cold fusion. so locating
stacktrace and hasrows property are really new to me. when working in
the query analyzer and using
ps_title 'Computers', returns records.

thanks for everyone


create procedure ps_title @Title nchar(15)
AS
SELECT Title FROM books
Where Title = @Title


this is my code. i'm passing variable to sp and getting no results.


protected void Button1_Click(object sender, EventArgs e)
{
SqlDataReader rdr = null;
SqlConnection con = null;
SqlCommand cmd = null;


try
{


string conn =
@"server=local;uid=;pwd=;trusted_connection=true;database=library";
con = new SqlConnection(conn);
con.Open();


cmd = new SqlCommand("ps_title", con);
cmd.CommandType = CommandType.StoredProcedure;


cmd.Parameters.Add("@Book",
System.Data.SqlDbType.NVarChar).Value = drpdbooks.Text;


// Execute the query
rdr = cmd.ExecuteReader();
}
}
lbFound.Items.Clear();
while (rdr.Read())
{
titles.Items.Add(rdr["Title"].ToString();
}
}
catch (SqlException ex)
{
}
finally
{
// Close data reader object and database connection
if (rdr != null)
rdr.Close();

if (con.State == ConnectionState.Open)
con.Close();
}
}