Error:Expected class, delegate, enum, interface, or struct

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

using mymvc2.Models;

using System.IO;

using System.Drawing;

using System.Web.Mvc;

using System.Web.Caching;

using System.Management;

using System.Web.UI;

using System.Data.Objects;

using mymvc2.Controllers;

using mymvc2.DataAccessLayer;

namespace mymvc2.DataAccessLayer

{

public class DBdata

{

}

public string InsertData(Mobiledata MD)

{

SqlConnection con = null;

string result = "";

try

{

con = new SqlConnection(ConfigurationManager.ConnectionStrings["Data Source=ANIRUDDHA-PC;Initial Catalog=sark;Integrated Security=True",con].ToString());

SqlCommand cmd = new SqlCommand("Usp_InsertUpdateDelete", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@MobileID", 0);

// i will pass zero to MobileID beacause its Primary .

cmd.Parameters.AddWithValue("@MobileName", MD.MobileName);

cmd.Parameters.AddWithValue("@MobileIMEno", MD.MobileIMEno);

cmd.Parameters.AddWithValue("@mobileprice", MD.mobileprice);

cmd.Parameters.AddWithValue("@mobileManufacured", MD.mobileManufacured);

cmd.Parameters.AddWithValue("@Query", 1);

con.Open();

result = cmd.ExecuteScalar().ToString();

return result;

}

catch

{

return result = "";

}

finally

{

con.Close();

}

public string UpdateData(Mobiledata MD)

{

SqlConnection con = null;

string result = "";

try

{

con = new SqlConnection(ConfigurationManager.ConnectionStrings["Data Source=ANIRUDDHA-PC;Initial Catalog=sark;Integrated Security=True"].ToString());

SqlCommand cmd = new SqlCommand("Usp_InsertUpdateDelete", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@MobileID", MD.MobileID);

cmd.Parameters.AddWithValue("@MobileName", MD.MobileName);

cmd.Parameters.AddWithValue("@MobileIMEno", MD.MobileIMEno);

cmd.Parameters.AddWithValue("@mobileprice", MD.mobileprice);

cmd.Parameters.AddWithValue("@mobileManufacured", MD.mobileManufacured);

cmd.Parameters.AddWithValue("@Query", 2);

con.Open();

result = cmd.ExecuteScalar().ToString();

return result;

}

catch

{

return result = "";

}

finally

{

con.Close();

}

public string DeleteData(Mobiledata MD)

{

SqlConnection con = null;

string result = "";

try

{

con = new SqlConnection(ConfigurationManager.ConnectionStrings["Data Source=ANIRUDDHA-PC;Initial Catalog=sark;Integrated Security=True"].ToString());

SqlCommand cmd = new SqlCommand("Usp_InsertUpdateDelete", con);

cmd.CommandType = CommandType.StoredProcedure;

Cmd.Parameters.AddWithValue("@MobileID", MD.MobileID);

cmd.Parameters.AddWithValue("@MobileName", null);

cmd.Parameters.AddWithValue("@MobileIMEno", null);

cmd.Parameters.AddWithValue("@mobileprice", 0);

cmd.Parameters.AddWithValue("@mobileManufacured", null);

cmd.Parameters.AddWithValue("@Query", 3);

con.Open();

result = cmd.ExecuteScalar().ToString();

return result;

}

catch

{

return result = "";

}

finally

{

con.Close();

}

SelectAllData

public DataSet SelectAllData()

{

SqlConnection con = null;

string result = "";

DataSet ds = null;

try

{

con = new SqlConnection(ConfigurationManager.ConnectionStrings["Data Source=ANIRUDDHA-PC;Initial Catalog=sark;Integrated Security=True"].ToString());

SqlCommand cmd = new SqlCommand("Usp_InsertUpdateDelete", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@MobileID",0);

cmd.Parameters.AddWithValue("@MobileName", null);

cmd.Parameters.AddWithValue("@MobileIMEno", null);

cmd.Parameters.AddWithValue("@mobileprice", 0);

cmd.Parameters.AddWithValue("@mobileManufacured", null);

cmd.Parameters.AddWithValue("@Query", 4);

con.Open();

SqlDataAdapter da = new SqlDataAdapter();

da.SelectCommand = cmd;

ds = new DataSet(); da.Fill(ds);

return ds;

}

catch

{

return ds;

}

finally

{

con.Close();

}

SelectAllDatabyID

public DataSet SelectAllDatabyID(string MobileID)

{

SqlConnection con = null;

string result = "";

DataSet ds = null;

try

{

con = new SqlConnection(ConfigurationManager.ConnectionStrings["Data Source=ANIRUDDHA-PC;Initial Catalog=sark;Integrated Security=True"].ToString());

SqlCommand cmd = new SqlCommand("Usp_InsertUpdateDelete", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@MobileID", MobileID); // i will pass zero to MobileID beacause its Primary .

cmd.Parameters.AddWithValue("@MobileName", null);

cmd.Parameters.AddWithValue("@MobileIMEno", null);

cmd.Parameters.AddWithValue("@mobileprice", 0);

cmd.Parameters.AddWithValue("@mobileManufacured", null);

cmd.Parameters.AddWithValue("@Query", 4);

con.Open();

SqlDataAdapter da = new SqlDataAdapter();

da.SelectCommand = cmd;

ds = new DataSet();

da.Fill(ds);

return ds;

}

catch

{

return ds;

}

finally

{

con.Close();

}

5 Replies

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

Bhushan Bhasme11y ago
Accepted answer
this error mostly occur due to missing reference,extra or less "}".
so
public class DBdata
{
}
.you need to close it at the bottom of code not there itself.(i.e:

after closing ofbelow method
public DataSet SelectAllDatabyID(string MobileID)
{
}

)
something like this..
namespace xyz
{
   public class DBdata
   {
         public DataSet SelectAllDatabyID(string MobileID)
      {
            //Your Code
         }

   }//end of class
} //end of namespace
like this
hope this will help You
Bhushan Bhasme11y ago
Please mark as "Accepted Answer" if your issue has got solved
11y ago
yes now it's fine

thanks Bhushan Bhasme sir
11y ago
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using mymvc2.Models;
using System.IO;
using System.Drawing;
using System.Web.Mvc;
using System.Web.Caching;
using System.Management;
using System.Web.UI;
using System.Data.Objects;
using mymvc2.Controllers;
using mymvc2.DataAccessLayer;
namespace mymvc2.DataAccessLayer
{
public class DBdata
{
}
public string InsertData(Mobiledata MD)

{
SqlConnection con = null;
string result = "";
try
{

con = new SqlConnection(ConfigurationManager.ConnectionStrings["Data Source=ANIRUDDHA-PC;Initial Catalog=sark;Integrated Security=True",con].ToString());
SqlCommand cmd = new SqlCommand("Usp_InsertUpdateDelete", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MobileID", 0);
// i will pass zero to MobileID beacause its Primary .
cmd.Parameters.AddWithValue("@MobileName", MD.MobileName);
cmd.Parameters.AddWithValue("@MobileIMEno", MD.MobileIMEno);
cmd.Parameters.AddWithValue("@mobileprice", MD.mobileprice);
cmd.Parameters.AddWithValue("@mobileManufacured", MD.mobileManufacured);
cmd.Parameters.AddWithValue("@Query", 1);
con.Open();
result = cmd.ExecuteScalar().ToString();
return result;
}
catch
{
return result = "";
}
finally
{
con.Close();
}
}
public string UpdateData(Mobiledata MD)
{
SqlConnection con = null;
string result = "";
try
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["Data Source=ANIRUDDHA-PC;Initial Catalog=sark;Integrated Security=True"].ToString());
SqlCommand cmd = new SqlCommand("Usp_InsertUpdateDelete", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MobileID", MD.MobileID);
cmd.Parameters.AddWithValue("@MobileName", MD.MobileName);
cmd.Parameters.AddWithValue("@MobileIMEno", MD.MobileIMEno);
cmd.Parameters.AddWithValue("@mobileprice", MD.mobileprice);
cmd.Parameters.AddWithValue("@mobileManufacured", MD.mobileManufacured);
cmd.Parameters.AddWithValue("@Query", 2);
con.Open();
result = cmd.ExecuteScalar().ToString();
return result;
}
catch
{
return result = "";
}
finally
{
con.Close();
}
}
public string DeleteData(Mobiledata MD)
{
SqlConnection con = null;
string result = "";
try
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["Data Source=ANIRUDDHA-PC;Initial Catalog=sark;Integrated Security=True"].ToString());
SqlCommand cmd = new SqlCommand("Usp_InsertUpdateDelete", con);
cmd.CommandType = CommandType.StoredProcedure;
Cmd.Parameters.AddWithValue("@MobileID", MD.MobileID);
cmd.Parameters.AddWithValue("@MobileName", null);
cmd.Parameters.AddWithValue("@MobileIMEno", null);
cmd.Parameters.AddWithValue("@mobileprice", 0);
cmd.Parameters.AddWithValue("@mobileManufacured", null);
cmd.Parameters.AddWithValue("@Query", 3);
con.Open();
result = cmd.ExecuteScalar().ToString();
return result;
}
catch
{
return result = "";
}
finally
{
con.Close();
}
}
SelectAllData
public DataSet SelectAllData()
{
SqlConnection con = null;
string result = "";
DataSet ds = null;
try
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["Data Source=ANIRUDDHA-PC;Initial Catalog=sark;Integrated Security=True"].ToString());
SqlCommand cmd = new SqlCommand("Usp_InsertUpdateDelete", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MobileID",0);
cmd.Parameters.AddWithValue("@MobileName", null);
cmd.Parameters.AddWithValue("@MobileIMEno", null);
cmd.Parameters.AddWithValue("@mobileprice", 0);
cmd.Parameters.AddWithValue("@mobileManufacured", null);
cmd.Parameters.AddWithValue("@Query", 4);
con.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
ds = new DataSet(); da.Fill(ds);
return ds;
}
catch
{
return ds;
}
finally
{
con.Close();
}
}
SelectAllDatabyID
public DataSet SelectAllDatabyID(string MobileID)
{
SqlConnection con = null;
string result = "";
DataSet ds = null;
try
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["Data Source=ANIRUDDHA-PC;Initial Catalog=sark;Integrated Security=True"].ToString());
SqlCommand cmd = new SqlCommand("Usp_InsertUpdateDelete", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MobileID", MobileID); // i will pass zero to MobileID beacause its Primary .
cmd.Parameters.AddWithValue("@MobileName", null);
cmd.Parameters.AddWithValue("@MobileIMEno", null);
cmd.Parameters.AddWithValue("@mobileprice", 0);
cmd.Parameters.AddWithValue("@mobileManufacured", null);
cmd.Parameters.AddWithValue("@Query", 4);
con.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
ds = new DataSet();
da.Fill(ds);
return ds;
}
catch
{
return ds;
}
finally
{
con.Close();
}
}
Bhushan Bhasme11y ago
Please Paste the line of code here