class file and code behind file

Question

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

Rafnas T P · 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 }

Amit Kumar · Answer

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

Rafnas T P · Answer

ok.

sam samuel · Answer

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 P · Answer

have you got the solution?

sam samuel · Answer

ThanksRafnas and Amit for your help.

sam samuel · Answer

yes

Rafnas T P · Answer

Is your class in the same project

Rafnas T P · Answer

for me its working here. try adding new class and copy all this into that and try again.

sam samuel · Answer

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 P · Answer

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 samuel · Answer

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 P · Answer

not that after those lines like below namespace ---------- {

sam samuel · Answer

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 P · Answer

do one thing open your class then see what is the name space is there inside class that is above public class ..

sam samuel · Answer

now my project name is website folder name is AccessClass inside the folder classname is Connectionprocedure

sam samuel · Answer

now i get error in using Website .DataAccess;

Rafnas T P · Answer

can you change the folder name and class name  becouse it confuces with System.web.dataaccess and your file dataaccess

Rafnas T P · Answer

then give using projectname dot foldername in the namespace

sam samuel · Answer

Website is my solution name DataAccess is my folder name inside the dataaccess folder i have the class name called DataAccess.cs

sam samuel · Answer

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 P · Answer

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 P · Answer

when you click ctrl+. what all option you got

sam samuel · Answer

System.Web.DataAccess obj = new DataAccess(); still the red line is there

Rafnas T P · Answer

select DataAccess and click ctrl + dotyou will get some popup select first one

sam samuel · Answer

Do i have to add any namespace in it because it shows errror an error in DataAccess

sam samuel · Answer

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 }