errors while retrieving records from database using 3-tier architecture?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

How to get record based on it's Rollnumber suppose if i enter the Rollnumber in textbox the details of the Record should display on Respective textboxes
i have tried ito and written the following code but not working how to get it?
Make some changes to my code where i did wrong.

In data access layer

public DataSet FindRecord(int RollNumber)
{
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("spfindtblstudent", con);
cmd.Parameters.AddWithValue("@RollNumber", RollNumber);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter("cmd", con);
con.Open();
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
return ds;

}
}

in BusinessLogicLayer

C#

public void findRec(int RollNumber)
      {
          Dal objdal = new Dal();
          objdal.FindRecord(RollNumber);
      }

In Code behind File

C#

protected void btnfind_Click(object sender, EventArgs e)
        {

            Bo objbo = new Bo();
            objbo.Name = txtname.Text.ToString();
            objbo.Address = txtaddress.Text.ToString();
            objbo.Phone = txtphone.Text.ToString();



        }

Regards

Posted 31-Oct-14 22:50pm

raxhemanth

Updated 31-Oct-14 23:01pm

v3

Add a Solution

Comments

Laiju k 1-Nov-14 5:04am

where are you calling findRec(int RollNumber)

raxhemanth 1-Nov-14 5:07am

yes in businesslogiclayer

raxhemanth 1-Nov-14 5:12am

protected void btnfind_Click(object sender, EventArgs e)
{

Bo objbo = new Bo();
objbo.Name = txtname.Text.ToString();
objbo.Address = txtaddress.Text.ToString();
objbo.Phone = txtphone.Text.ToString();
Bll objbll = new Bll();
objbll.findRec(RollNumber);

}

Do u want me to write like this is this write but
objbll.findRec(RollNumber);
Here the method is saying that RollNumber Doesnot exist in the correct Context.
What does it mean

Laiju k 1-Nov-14 5:15am

use reply option when repling

raxhemanth 1-Nov-14 5:14am

Try to help me iam new to 3-Tier
Thanks in advance

Laiju k 1-Nov-14 5:17am

try the solution below it will the problem

Laiju k 1-Nov-14 5:18am

And don't use void if you are trying to return something

2 solutions

Solution 2

C#

public DataSet FindRecord(int RollNumber)
{
using (SqlConnection con = new SqlConnection(cs))
{
SqlCommand cmd = new SqlCommand("spfindtblstudent", con);
cmd.Parameters.AddWithValue("@RollNumber", SqlDbType.BigInt).Value = RollNumber;
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
}

Posted 31-Oct-14 23:15pm

kskumaran

Comments

raxhemanth 1-Nov-14 5:45am

oh Thankyou Somuch kskumaran

raxhemanth 1-Nov-14 6:04am

what code i need to write in code behind please tell me

kskumaran 1-Nov-14 6:37am

what code means?

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)

DamithSL · Accepted Answer · 2014-10-31T23:07:00

Solution 1

method public DataSet FindRecord(int RollNumber) is return data set, so you can get the result after you call that method in your BusinessLogicLayer

C#

public void findRec(int RollNumber)
      {
          Dal objdal = new Dal();
          DataSet ds = objdal.FindRecord(RollNumber);
          // ds.Tables[0] will have  the data you need 
      }

you can return this data set by changing signature of the method as below

C#

public DataSet findRec(int RollNumber)
      {
          Dal objdal = new Dal();
          DataSet ds = objdal.FindRecord(RollNumber);
          return ds; 
      }

then

C#

protected void btnfind_Click(object sender, EventArgs e)
        {
            int rollnumber = int.Parse(txtrollnumber.Text);
            Bo objbo = new Bo();
            DataSet ds =objbo.findRec(rollnumber);
            if(ds !=null && ds.Tables.Count >0 && ds.Tables[0].Rows.Count >0)
            {
                txtName.Text = ds.Tables[0].Rows[0]["Name"].ToString();
                txtAddress.Text = ds.Tables[0].Rows[0]["Address"].ToString();
                txtPhone.Text = ds.Tables[0].Rows[0]["Phone"].ToString();
            }
        }

Posted 31-Oct-14 23:07pm

DamithSL

v2

Comments

raxhemanth 1-Nov-14 5:16am

Great Tankyou very much DamithSL

Laiju k 1-Nov-14 5:21am

raxhemanth
Accept the Solution as Answer if it solved your problem

Laiju k 1-Nov-14 5:20am

DamithSL,
1)can you tell me why you are using this condition

if(ds !=null && ds.Tables.Count >0 && ds.Tables[0].Rows.Count >0)

and

2)if we know it returns only one cant we use DataTable instead of DataSet

DamithSL 1-Nov-14 5:24am

1. if there is no records, you will get exception when you assign values for the text boxes, that's why I have added few validations
2. yes, you can return Datatable, or even object like Student, create class with few properties like name, address etc. and you can return object of that class after setting properties with help of returned values from database

hope this helps

Laiju k 1-Nov-14 5:25am

Thanks

raxhemanth 1-Nov-14 5:43am

DataSet ds =objbo.findRec(rollnumber);
in this line getting BO.Bo does not contain a definition for findrec and no extension mehtod accepting firstargument of type BO.Bo Could Be Found (are u missing an assembly reference) even i add all the references like BLL,DAL,BO . How to solve it?

DamithSL 1-Nov-14 5:49am

what is the value you given as rollnumber? it should be int value

raxhemanth 1-Nov-14 5:51am

yes that is an integer but iam getting a completime error even before i build soluitons its occuring with red curly lines

raxhemanth 1-Nov-14 5:55am

when i creating object to the Bo the method is not coming in the intellisense but i have added all the references DAL,BLL,BO. why its having that

DamithSL 1-Nov-14 5:58am

do you have method public DataSet findRec(int RollNumber) in your BLL?

raxhemanth 1-Nov-14 6:06am

Yes i have that method
public DataSet findrec(int RollNumber)
{
Dal objdal = new Dal();
DataSet ds = objdal.FindRecord(RollNumber);
return ds;
}

raxhemanth 1-Nov-14 6:39am

my bll is like
public DataSet findrec(int RollNumber)
{
Dal objdal = new Dal();
DataSet ds = objdal.FindRecord(RollNumber);
return ds;
}