am not able to find what is the error

Question

1.00/5 (1 vote)

See more:

please suggest me what i need to do by seeing the below.please kindly help me out am a fresher.
this is my class which contains some properties

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace proinsert
{
    public class insert
    {
        private int mode;

        public int Mode
        {
            get { return mode; }
            set { mode = value; }
        }
        private int stid;

        public int Stid
        {
            get { return stid; }
            set { stid = value; }
        }
        private string stname;

        public string Stname
        {
            get { return stname; }
            set { stname = value; }
        }
        private string staddress;

        public string Staddress
        {
            get { return staddress; }
            set { staddress = value; }
        }
    }
}

this is my dal

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using proinsert;
using System.Data.SqlClient;


namespace studentdal
{
    public class stude
    {
        public SqlConnection con;
        public stude()
        {
            con = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog=g;Integrated Security=True");
            con.Open();
        }
        public DataView fetch(int stids)
        {

            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = "h";
            cmd.Parameters.Add(new SqlParameter("@sid", SqlDbType.Int)).Value = stids;
            SqlDataReader dr = cmd.ExecuteReader();
            DataTable dt = new DataTable();
            dt.Load(dr);
            return dt.DefaultView;

        }
        public int isy(proinsert.insert ayo, out string stadre)
        {
            SqlCommand cm = new SqlCommand();
            cm.Connection = con;
            cm.CommandText = "oi";
            cm.Parameters.Add(new SqlParameter("@mode", SqlDbType.Int)).Value = ayo.Mode;
            cm.Parameters.Add(new SqlParameter("@sid", SqlDbType.Int)).Value = ayo.Stid;
            cm.Parameters.Add(new SqlParameter("@sname", SqlDbType.VarChar)).Value = ayo.Stname;
            cm.Parameters.Add(new SqlParameter("@sad", SqlDbType.VarChar)).Direction=ParameterDirection.Output;
            cm.ExecuteNonQuery();
            stadre = Convert.ToString(cm.Parameters["@sad"].Value);
            return Convert.ToInt32(cm.Parameters["@sad"].Value);
            


        }
    }
}

and am trying to pass value from the asp.net page.kindly please how can pass the value from front end.and my database is

SQL

create database g
use g
create table student(stid int primary key,stname varchar(50),staddress varchar(50))
alter procedure h
(@sid int)
as
begin
if @sid=null
begin
select * from student
end
else
begin
select * from student where stid=@sid
end
end
create procedure oi
(@mode int, @sid int,@sname varchar(80),@sad varchar(30) out)
as
begin transaction
if @mode=1
begin
insert into student values(@sid,@sname,@sad)
end
else
begin
if @mode=2
begin
update student set stname=@sname where stid=@sid
end
end

Posted 1-Sep-14 7:39am

karthikeyan9966

Updated 1-Sep-14 8:03am

OriginalGriff

v2

Add a Solution

Comments

Dave Kreskowiak 1-Sep-14 13:51pm

You haven't said anything about what the problem is other than "it doesn't work". That doesn't help at all.

What error? What's the exception message? What do you expect this code to do? What is it doing?

karthikeyan9966 1-Sep-14 13:58pm

protected void Button2_Click(object sender, EventArgs e)
{
int a = int.Parse(mode.Text);
int b = int.Parse(id.Text);
stude oki = new stude();
oki.isy(a,b,name.Text,address.Text);
}when am trying to write this code in my asp.net page it is showing Error 4 No overload for method 'isy' takes 4 arguments c:\users\aswin\documents\visual studio 2010\Projects\WebApplication4\WebApplication4\WebForm1.aspx.cs 32 13 WebApplication4

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)

OriginalGriff · Accepted Answer · 2014-09-01T08:06:00

Error	4	No overload for method 'isy' takes 4 arguments

Look at the error message.
Then look at your class:

C#

namespace studentdal
{
    public class stude
    {
        public SqlConnection con;
        public stude()
        {
        ...
        }
        public DataView fetch(int stids)
        {
        ...
        }
        public int isy(proinsert.insert ayo, out string stadre)
        {
        ...
        }
    }
}

You have one method called isy - it takes two parameters, one of them an out parameter.
Now look at how you are calling it:

C#

stude oki = new stude();
oki.isy(a,b,name.Text,address.Text);

Four parameters, none of them out parameters.

You need to either call the method with just the required two parameters, or write a new method which takes the four you want to give it...