combofill error
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 SafeerPosted Aug 22, 2013, 7:49 AM
Iftikar HussainPosted Aug 22, 2013, 7:31 AM
right click on Reference->Click on Add Reference->select the project
Safeer SafeerPosted Aug 22, 2013, 7:30 AM
Safeer SafeerPosted Aug 22, 2013, 7:29 AM
Iftikar HussainPosted Aug 22, 2013, 7:28 AM
public class divisioninfo
{
public decimal divisionId { get; set; }
public string divisionName { get; set; }
public decimal classId { get; set; } }
Regards,
Iftikar
Safeer SafeerPosted Aug 22, 2013, 7:24 AM
Iftikar HussainPosted Aug 22, 2013, 7:22 AM
Safeer SafeerPosted Aug 22, 2013, 7:13 AM
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 HussainPosted Aug 22, 2013, 7:02 AM
Regards,
Iftikar
Safeer SafeerPosted Aug 22, 2013, 6:59 AM
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 HussainPosted Aug 22, 2013, 6:55 AM
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 LenkaPosted Aug 22, 2013, 6:55 AM
public void cmbsfill()
{
classsp spclass=new classsp();
ddlsclass.DataSource=spclass.ClassViewall();
ddlsclass.DataValueField="classId";
ddlsclass.DataTextField="className";
ddlsclass.DataBind();
ddlsclass.Items.Insert(0,"--Select--");
}