How to get a row from sqldatareader in 3-tier?

Question

0.00/5 (No votes)

See more:

Hi everyone
I've had a problem. I want to know how to get a row from sqldatareader in 3-tier?
My code don't run. Could you tell me Why it isn't correct ?
this is my code:
DAL:

C#

public static SqlDataReader Clerk_Search(string name, string family, string melliCode)
        {
            SqlDataReader sqlDataReader;
            SqlCommand comm = new SqlCommand("Clerk_Search", Data_Access.conn);
            comm.CommandType = CommandType.StoredProcedure;
            comm.Parameters.AddWithValue("@clk_Name", name);
            comm.Parameters.AddWithValue("@clk_Family", family);
            comm.Parameters.AddWithValue("@clk_MeliCod", melliCode);
            conn.Open();
            sqlDataReader = comm.ExecuteReader();
            conn.Close();
            return sqlDataReader;


        }

BL:

C#

static public System.Data.SqlClient.SqlDataReader   Clerk_Search(string name, string family, string meliCode)
       {
           System.Data.SqlClient.SqlDataReader sqlDataReader;
         sqlDataReader = Data_Access.Clerk_Search(name, family, meliCode);
         return sqlDataReader;


       }

UI

C#

private void Clerk_Search_Click(object sender, EventArgs e)
        {
            //System.Data.SqlClient.SqlDataReader sqlDataReader;
           
           
                System.Data.SqlClient.SqlDataReader red;
                red = Business.Clerk_Search(txtNameClerk.Text.Trim(), txtFamilyClerk.Text.Trim(), txtShomarehyeMeliClerk.Text.Trim());
                txtClerkId.Text = red["clk_Id"].ToString();
          
        }

Posted 30-Jul-13 23:31pm

Elham.Deljooei

Updated 31-Jul-13 0:08am

Code-Hunt

v2

Add a Solution

Comments

[no name] 31-Jul-13 5:58am

If your "code don't run" then you need to debug it and figure out the problem. Or, at the very least, tell us was "code don't run" actually means.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

MuhammadUSman1 · Answer 1 · 2013-07-30T23:56:00

C#

BL:
static public string Clerk_Search(string name, string family, string meliCode)
{
System.Data.SqlClient.SqlDataReader sqlDataReader;
sqlDataReader = Data_Access.Clerk_Search(name, family, meliCode);

//you shoud read data here using 
//this will read one line 
sqlDataReader.Read();

//know assing data to string for example

string str=sqlDataReader["name"].ToString();
str+=":"+sqlDataReader["family"].ToString();
str+=":"+sqlDataReader["meliCode"].ToString();

//and recieve str at UI and split string with : and get required data

return str;
}

or in

C#

UI
private void Clerk_Search_Click(object sender, EventArgs e)
{
//System.Data.SqlClient.SqlDataReader sqlDataReader;


System.Data.SqlClient.SqlDataReader red;
red = Business.Clerk_Search(txtNameClerk.Text.Trim(), txtFamilyClerk.Text.Trim(), txtShomarehyeMeliClerk.Text.Trim());

red.Read();

if(red.HasRow)
{

   txtClerkId.Text = red["clk_Id"].ToString(); 
}