public int Insert_Title_mst(Title_mst Objtitle)
 {
     return (int)ExecuteNonQuery(Sp_Title_Insert, new object[] { Objtitle.Categoryid, Objtitle.Subacetgoryid, Objtitle.Title });
 }
    public CollectionBase GenerateTitle_mstCollection(ref IDataReader returnData)
    {
        BLLCollection<Title_mst> col = new BLLCollection<Title_mst>();
        while (returnData.Read())
        {

            Title_mst obj = new Title_mst();
            obj.Id = (int)returnData["Id"];
            obj.Categoryid = (int)returnData["Categoryid"];
            obj.Title = (string)returnData["Title"];
            obj.Subacetgoryid = (int)returnData["subcategoryid"];

            col.Add(obj);
        }
        returnData.Close();
        returnData.Dispose();
        return col;
    }