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

Question

how to solved Error 1 Expected class, delegate, enum, interface, or struct this error in mvc project in asp.net

Bhushan Bhasme · 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 Bhasme · Answer

Please Paste the line of code here

Bhushan Bhasme · Answer

Please mark as "Accepted Answer" if your issue has got solved

saroj bhattacharya · Answer

yes now it's fine thanks Bhushan Bhasme sir

saroj bhattacharya · Answer

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