class file and code behind file

sam samuel

9y1k

how to call the class file method to code behind file and how to add namespace in code behind file

27 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
Accepted answer
public void BindData()
{
DataAccess obj = new DataAccess();
DataTable Dt_LessonDetails= obj.GetLessonDetailsByInstructor(2)//Here you will be getting DataTable
//use Dt_LessonDetails to bind data
}
Rafnas T P9y ago
ok.
sam samuel9y ago
using App_Code folder i dint face any problem but adding new folder i face problem.
Still it shows error.Do i have to add Website.DataAccess anywhere in project?
Rafnas T P9y ago
have you got the solution?
sam samuel9y ago
Thanks,Rafnas and Amit for your help.
sam samuel9y ago
yes
Rafnas T P9y ago
Is your class in the same project
Rafnas T P9y ago
for me its working here.
try adding new class and copy all this into that and try again.
sam samuel9y ago
but still i have error in project name(Website) and error in Connectionprocedure()

var x = new global::Connectionprocedure();// error line in this line
The type or namespace name 'Connectionprocedure' could not be found in the global namespace (are you missing an assembly reference?) J:\Student\Website\Trainer.aspx.cs 56 29 J:\Student\Website\
Rafnas T P9y ago
ok no namespace then

try like this

public void BindData()
{
var x = new global::Connectionprocedure();

DataTable Dt_LessonDetails= x .GetLessonDetailsByInstructor(2)//Here you will be getting DataTable
//use Dt_LessonDetails to bind data
}

DataTable Dt_addpodetails = x.GetLessonDetailsByInstructor(1);
sam samuel9y ago
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Configuration;
using System.Data.SqlClient;
using System.Data;
public class Connectionprocedure
{
string connectionString;
public Connectionprocedure()
{
connectionString = WebConfigurationManager.ConnectionStrings["studentConnectionString"].ConnectionString;
}
public DataTable GetLessonDetailsByInstructor(int InstructorId)
{
SqlConnection connection = new SqlConnection(connectionString);
DataSet dsLessonDetails = new DataSet();
connection.Open();
SqlCommand selectcommand = new SqlCommand("GetLessonDetailsByInstructor", connection);
selectcommand.CommandType = CommandType.StoredProcedure;
selectcommand.Parameters.AddWithValue("@InstructorId", InstructorId);
SqlDataAdapter sdaLessonDetails = new SqlDataAdapter(selectcommand);
sdaLessonDetails.Fill(dsLessonDetails);
connection.Close();
return dsLessonDetails.Tables[0];
}
}

//my whole code in class file
Rafnas T P9y ago
not that, after those lines like below

namespace ----------
{
sam samuel9y ago
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Configuration;
using System.Data.SqlClient;
using System.Data;

these are included in class file
Rafnas T P9y ago
do one thing open your class then see what is the name space is there inside class that is above public class ..
sam samuel9y ago
now my project name is website
folder name is AccessClass
inside the folder classname is Connectionprocedure
sam samuel9y ago
now i get error in
using Website.DataAccess;
Rafnas T P9y ago
can you change the folder name and class name , becouse it confuces with
System.web.dataaccess and your file dataaccess
Rafnas T P9y ago
then give using projectname dot foldername in the namespace
sam samuel9y ago
Website is my solution name
DataAccess is my folder name
inside the dataaccess folder i have the class name called DataAccess.cs
sam samuel9y ago
1)System.web.dataaccess
2)generate class for 'DataAccess '
3)generate new type
these are the three things i got when i use crtl+.
Rafnas T P9y ago
from the list options select using yoursolutionname.classcontainingfoldername.
or mannually write
using yoursolutionname.classcontainingfoldername.

example
proj is your solution Name
classes is your foldernmae where your class contains then
using proj.classes

if your class is outside folder that is inside your solution
then using proj
Rafnas T P9y ago
when you click ctrl+. what all option you got
sam samuel9y ago
System.Web.DataAccess obj = new DataAccess();
still the red line is there
Rafnas T P9y ago
select DataAccess and click ctrl + dotyou will get some popup select first one
sam samuel9y ago
Do i have to add any namespace in it because it shows errror an error in DataAccess
sam samuel9y ago
class File(DataAccess)
public class DataAccess
{
string connectionString;
public DataAccess()
{
connectionString = WebConfigurationManager.ConnectionStrings["studentConnectionString"].ConnectionString;
}
public DataTable GetLessonDetailsByInstructor(int InstructorId)
{
SqlConnection connection = new SqlConnection(connectionString);
DataSet dsLessonDetails = new DataSet();
connection.Open();
SqlCommand selectcommand = new SqlCommand("GetLessonDetailsByInstructor", connection);
selectcommand.CommandType = CommandType.StoredProcedure;
selectcommand.Parameters.AddWithValue("@InstructorId", InstructorId);
SqlDataAdapter sdaLessonDetails = new SqlDataAdapter(selectcommand);
sdaLessonDetails.Fill(dsLessonDetails);
connection.Close();
return dsLessonDetails.Tables[0];
}
}
code behind (trainer.aspx.cs)

public void BindData()
{
//want to bind the data here from class file how to do it
}
Amit Kumar9y ago
Hi,
It is simple create an object of that class which contains the method then call the using object like.
//your class is Math
//create object of Math class
Math objMath=new Math();
objMath.FunctionName();