combofill error

Question

Error : 1 Method must have a return type public cmbsfill() { classsp spclass=new classsp(); ddlsclass.DataSource=spclass.ClassViewall(); ddlsclass.DataValueField='classId'; ddlsclass.DataTextField='className'; ddlsclass.DataBind(); ddlsclass.Items.Insert(0,'--Select--'); }

Safeer Safeer · Answer

thnx.., i got

Iftikar Hussain · Answer

then add the reference of that project in your current project. right click on Reference->Click on Add Reference->select the project

Safeer Safeer · Answer

className already defined in classInfo

Safeer Safeer · Answer

yeah!!!

Iftikar Hussain · Answer

where you have defined the below class? is it in separate project? public class divisioninfo { public decimal divisionId { get; set; } public string divisionName { get; set; } public decimal classId { get; set; } } Regards, Iftikar

Safeer Safeer · Answer

no public class divisioninfo { public decimal divisionId { get; set; } public string divisionName { get; set; } public decimal classId { get; set; } }

Iftikar Hussain · Answer

please check weather is there any class name by divisionInfo

Safeer Safeer · Answer

Error 1 Inconsistent accessibility: base class 'ERP.dbconnection' is less accessible than class 'ERP.divisionsp' H:\20.8.13\ERP\ERP\classes\sp\divisionsp.cs 17 18 ERP Error 2 The type or namespace name 'divisionInfo' could not be found (are you missing a using directive or an assembly reference?) H:\20.8.13\ERP\ERP\classes\sp\divisionsp.cs 19 34 ERP Error 3 The type or namespace name 'divisionInfo' could not be found (are you missing a using directive or an assembly reference?) H:\20.8.13\ERP\ERP\classes\sp\divisionsp.cs 50 16 ERP Error 4 The type or namespace name 'divisionInfo' could not be found (are you missing a using directive or an assembly reference?) H:\20.8.13\ERP\ERP\classes\sp\divisionsp.cs 98 33 ERP

Iftikar Hussain · Answer

which line you are getting the issue? Regards, Iftikar

Safeer Safeer · Answer

here it is sp public class divisionsp : dbconnection { public int DivisionAdd(divisionInfo infodivision) { try { if (sqlcon.State == ConnectionState.Closed) sqlcon.Open(); SqlCommand sqlcmd = new SqlCommand("DivisionAdd", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("divisionName", SqlDbType.VarChar).Value = infodivision.divisionName; sqlcmd.Parameters.Add("classId", SqlDbType.Decimal).Value = infodivision.classId; int a = sqlcmd.ExecuteNonQuery(); return a; } catch (Exception) { throw; } finally { sqlcon.Close(); } } public DataTable DivisionViewallGrid() { DataTable dt1 = new DataTable(); SqlDataAdapter sqlda = new SqlDataAdapter("DivisionViewallGrid", sqlcon); sqlda.SelectCommand.CommandType = CommandType.StoredProcedure; sqlda.Fill(dt1); return dt1; } public divisionInfo DivisionViewFill(decimal divId) { divisionInfo infoDivision = new divisionInfo(); try { if (sqlcon.State == ConnectionState.Closed) sqlcon.Open(); SqlCommand sqlcmd = new SqlCommand("DivisionViewFill", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("@divisionId", SqlDbType.Decimal).Value = divId; SqlDataReader sqldr = sqlcmd.ExecuteReader(); while (sqldr.Read()) { infoDivision.divisionName = sqldr["divisionName"].ToString(); infoDivision.classId = decimal.Parse(sqldr["classId"].ToString()); } return infoDivision; } catch (Exception) { throw; } finally { sqlcon.Close(); } } public DataTable DivisionViewallclass(decimal decClassId) { DataTable dt1 = new DataTable(); SqlDataAdapter sqlda = new SqlDataAdapter("DivisionViewallclass", sqlcon); sqlda.SelectCommand.CommandType = CommandType.StoredProcedure; sqlda.SelectCommand.Parameters.Add("@classId", SqlDbType.Decimal).Value = decClassId; sqlda.Fill(dt1); return dt1; } public DataTable DivisionViewallclassSearch(decimal decClassId, string txtDivision) { DataTable dt1 = new DataTable(); SqlDataAdapter sqlda = new SqlDataAdapter("DivisionViewallclassSearch", sqlcon); sqlda.SelectCommand.CommandType = CommandType.StoredProcedure; sqlda.SelectCommand.Parameters.Add("@classId", SqlDbType.Decimal).Value = decClassId; sqlda.SelectCommand.Parameters.Add("@divisionName", SqlDbType.VarChar).Value = txtDivision; sqlda.Fill(dt1); return dt1; } public int DivisionEdit(divisionInfo infodivision) { try { if (sqlcon.State == ConnectionState.Closed) sqlcon.Open(); SqlCommand sqlcmd = new SqlCommand("DivisionEdit", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("divisionId", SqlDbType.Decimal).Value = infodivision.divisionId; sqlcmd.Parameters.Add("divisionName", SqlDbType.VarChar).Value = infodivision.divisionName; sqlcmd.Parameters.Add("classId", SqlDbType.VarChar).Value = infodivision.classId; int a = sqlcmd.ExecuteNonQuery(); return a; } catch (Exception) { throw; } finally { sqlcon.Close(); } } public int DivisionDelete(decimal divId) { try { if (sqlcon.State == ConnectionState.Closed) sqlcon.Open(); SqlCommand sqlcmd = new SqlCommand("DivisionDelete", sqlcon); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("divisionId", SqlDbType.Decimal).Value = divId; int a = sqlcmd.ExecuteNonQuery(); return a; } catch (Exception) { throw; } finally { sqlcon.Close(); } } }

Iftikar Hussain · Answer

Hi, Modify your method public void cmbsfill() { classsp spclass=new classsp(); ddlsclass.DataSource=spclass.ClassViewall(); ddlsclass.DataValueField="classId"; ddlsclass.DataTextField="className"; ddlsclass.DataBind(); ddlsclass.Items.Insert(0,"--Select--"); } Regards, Iftikar

Sanjeeb Lenka · Answer

try this: public void cmbsfill() { classsp spclass=new classsp(); ddlsclass.DataSource=spclass.ClassViewall(); ddlsclass.DataValueField="classId"; ddlsclass.DataTextField="className"; ddlsclass.DataBind(); ddlsclass.Items.Insert(0,"--Select--"); }

combofill error

Answers (12)