how to write a method in asp.net

Question

0.00/5 (No votes)

See more:

ASP.NET

Oracle

i want to write a method in dal

i am new...

plz guide me

Posted 23-Sep-11 1:52am

himanshu034

Add a Solution

6 solutions

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)

member60 · Answer 1 · 2011-09-23T02:00:00

Sure ur DAL is a Class library ,if it is then add a class in it wiht some specifc name and u can create there any methods u want.

C#

public DataTable GetEntity(string sqlQuery)
        {
            DataTable dt = new DataTable();
            dt.Rows.Clear();
            sqlAdapter = new SqlDataAdapter(sqlQuery, sqlConn);
            sqlAdapter.Fill(dt);
            sqlAdapter.Dispose();
            return dt;
        }

the thing is that build the DAl after completing coding in created class and the whole application then u can access those methods with object.mehodname anywhere

uspatel · Answer 2 · 2011-09-23T02:31:00

Solution 2

A very good example of class library
MSDN

Posted 23-Sep-11 2:31am

uspatel

Comments

Jaydev Deva 8-Jun-22 0:38am

simple interface

RaisKazi · Answer 3 · 2011-09-23T03:13:00

Solution 3

Have a look at below link.

http://www.15seconds.com/issue/030317.htm

Posted 23-Sep-11 3:13am

RaisKazi

sasolanki007 · Answer 4 · 2011-09-23T03:30:00

Solution 4

you can define method as follows :

C#

public string GetName()
{
    return "Name";
}

you can call this method as follows :

C#

string a = GetName();

-Sagar Solanki

Posted 23-Sep-11 3:30am

sasolanki007

Anele Ngqandu · Answer 5 · 2011-09-23T12:20:00

"procAvailableStuff" will be your stored procedure...you can google wt a stored procedure is...

C#

public DataTable grid(string date)
        {
            using (SqlConnection con = new SqlConnection(ConnString))
            {
                SqlCommand cmd = new SqlCommand("procAvailableStuff", con);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add(new SqlParameter("@Date", SqlDbType.NVarChar));
                cmd.Parameters["@Date"].Value = date;
                DataTable dTable = new DataTable("EmployeeName");
                SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                adapter.Fill(dTable);
                return dTable;

            }

        }

anvas kuttan · Answer 6 · 2011-09-23T21:17:00

//this function wont return a value will do the task
public void MyFirstMethod()
{
   int a=10;
   int b=10;
   int c= a+b;
}

//this function return a  string value will do the task
public string MyFirstMethod()
{
   return "napster"   ;
}

//this function return a  string value will do the task
public string MyFirstMethod()
{
   return "napster"   ;
}

//this function accepts 2  parameters string will use do the task
public void MyFirstMethod(string a, string b)
{
  string s= a + " " + b;
}


Actually it is example of function overloading too :) happy learning