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