C#

foreach (EcashProductCatModel ecash in model)
{
 using (var cmdinsert = new SqlCommand("sp_AddProductCategory", con))
 {
  cmdinsert.CommandType = CommandType.StoredProcedure;

  cmdinsert.Parameters.Add("@CATEGORY_ID", SqlDbType.Int).Value = ecash.CATEGORY_ID;
  cmdinsert.Parameters.Add("@CATEGORY_DESCRIPTION", SqlDbType.VarChar).Value =
   ecash.CATEGORY_DESCRIPTION;
  cmdinsert.Parameters.Add("@SCHOOLID", SqlDbType.Int).Value = ecash.SCHOOLID;
  cmdinsert.ExecuteNonQuery();
 }

}

Create Command
Create and add parameters

Loop
{
    Set parameter values
    Execute Command
}

aeman wrote:

I am trying to read the data in C and is giving zero ouput. What does this mean?? Is the power suply not properly given??

public class Classname
{
    public Classname()
    {
        this.Name = Guid.NewGuid().ToString();
    }
}

public static class ClassNames{
   private static int _count = 0;

   public static string GetNextName(){
      return "Class" + (_count++);
   }
}

public abstract NamedClass{
   public string Name {get;set;}
   
   public NamedClass(){
      this.Name = ClassNames.GetNextName();
   }
}

public class Classname : NamedClass{
   public Classname(){
      
   }
}